sf-trees

This data as json, CSV

rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	PlantDate	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location
109	9895	3	40	1800X Pine St	1	1	1	2		18	3X3	6005051.0377	2115464.4068	37.7889474242075	-122.426360597873	(37.7889474242075, -122.426360597873)
1707	19767	3	40	100 STAIRWAY16	6	1	1	2		12	30ST
1811	19991	3	40	100 STAIRWAY46	11	1	1	2		12	40
1842	19990	3	40	100 STAIRWAY46	10	1	1	2		6	40
2751	19916	3	40	100 STAIRWAY35	12	1	1	2		6	120ST
5450	19643	3	40	100 STAIRWAY5	42	1	1	2		12	30
5580	19952	3	40	100 STAIRWAY39	9	1	1	2		12	25ST
5629	19629	3	40	100 STAIRWAY5	28	1	1	2		6	30
5638	19734	3	40	100 STAIRWAY14	12	1	1	2		12	40ST
6130	19637	3	40	100 STAIRWAY5	36	1	1	2		12	30
6465	20050	3	40	100 STAIRWAY52	6	1	1	2		12	10
6552	19622	3	40	100 STAIRWAY5	21	1	1	2		12	30
6727	20046	3	40	100 STAIRWAY52	2	1	1	2		3	10
6840	19703	3	40	100 STAIRWAY13	1	1	1	2		12	40ST
6859	19881	3	40	100 STAIRWAY33	13	1	1	2		12	25ST
7127	19877	3	40	100 STAIRWAY33	9	1	1	2		24	25ST
8000	19575	3	40	100 STAIRWAY1	10	1	1	2		36	100ST
8376	17629	3	40	150 Phelps St	2	1	1	2		12	10M
8874	19879	3	40	100 STAIRWAY33	11	1	1	2		12	25ST
8891	19873	3	40	100 STAIRWAY33	5	1	1	2		30	25ST
9101	19626	3	40	100 STAIRWAY5	25	1	1	2		12	30
9670	19824	3	40	100 STAIRWAY25	8	1	1	2		6	10ST
10110	17260	3	40	29 Osceola Ln	1	1	1	2	01/27/2017 12:00:00 AM	18	3X3	6017247.640204701	2094279.3298336002	37.73145956022589	-122.382686794637	(37.7314595602259, -122.382686794637)
10584	19572	3	40	100 STAIRWAY1	6	1	1	2		24	100ST
10624	19574	3	40	100 STAIRWAY1	8	1	1	2		12	100ST
10757	19823	3	40	100 STAIRWAY25	7	1	1	2		6	10ST
10946	19995	3	40	100 STAIRWAY46	15	1	1	2		12	40
11109	19996	3	40	100 STAIRWAY46	16	1	1	2		12	40
11188	19822	3	40	100 STAIRWAY25	6	1	1	2		6	10ST
11496	19573	3	40	100 STAIRWAY1	7	1	1	2		12	100ST
11523	19635	3	40	100 STAIRWAY5	34	1	1	2		12	30
11623	19765	3	40	100 STAIRWAY16	4	1	1	2		12	30ST
12152	19571	3	40	100 STAIRWAY1	5	1	1	2		24	100ST
12720	19640	3	40	100 STAIRWAY5	39	1	1	2		6	30
12830	19619	3	40	100 STAIRWAY5	18	1	1	2		12	30
12952	19628	3	40	100 STAIRWAY5	27	1	1	2		6	30
13122	19636	3	40	100 STAIRWAY5	35	1	1	2		12	30
13156	20391	3	40	262X Sunset Blvd	37	1	1	2		12	60
13560	20028	3	40	100 STAIRWAY49	1	1	1	2		12	10
13632	19618	3	40	100 STAIRWAY5	17	1	1	2		6	30
13773	19987	3	40	100 STAIRWAY46	7	1	1	2		6	40
13854	11422	3	40	803X Mendell St	1	1	1	2		24	3X3	6016040.90005	2096755.8649799998	37.738192886184	-122.38703142706001	(37.738192886184, -122.38703142706)
13883	19639	3	40	100 STAIRWAY5	38	1	1	2		6	30
14157	17628	3	40	150 Phelps St	1	1	1	2		12	10M
14188	19617	3	40	100 STAIRWAY5	16	1	1	2		6	30
14354	17473	3	40	2050X Palou Ave	8	1	1	2	11/17/1992 12:00:00 AM	12	3X3	6012341.587169999	2097177.38743	37.73914476102	-122.39985148498	(37.73914476102, -122.39985148498)
14387	22148	3	40	3800 03rd St	3	1	1	2		6	3x3	6015737.9632	2098284.4406	37.7423732631069	-122.388185488874	(37.7423732631069, -122.388185488874)
14502	17475	3	40	2050X Palou Ave	10	1	1	2		12	3X3	6012301.79777	2097206.74854	37.7392231621197	-122.399991120917	(37.7392231621197, -122.399991120917)
14653	19921	3	40	100 STAIRWAY37	1	1	1	2		12	3X3
15242	22432	3	40	6000 03rd St	1	1	1	2		18	3X3	6013579.8961	2091555.5712	37.7237773618259	-122.39517625529	(37.7237773618259, -122.39517625529)
15445	19918	3	40	100 STAIRWAY35	14	1	1	2		6	120ST
15768	19884	3	40	100 STAIRWAY33	16	1	1	2		18	25ST
15852	19567	3	40	100 STAIRWAY1	1	1	1	2		24	100ST
15947	19630	3	40	100 STAIRWAY5	29	1	1	2		12	30
16203	19623	3	40	100 STAIRWAY5	22	1	1	2		12	30
16222	19870	3	40	100 STAIRWAY33	2	1	1	2		36	25ST
16278	19770	3	40	100 STAIRWAY16	9	1	1	2		6	30ST
16313	19876	3	40	100 STAIRWAY33	8	1	1	2		12	25ST
16376	19641	3	40	100 STAIRWAY5	40	1	1	2		12	30
16486	19701	3	40	100 STAIRWAY12	1	1	1	2		12	60
16953	19917	3	40	100 STAIRWAY35	13	1	1	2		6	120ST
23642	176313	3	40	500x Mansell St	18	11	1	2		38	Width 0ft	6010259.13784	2090270.57035	37.7200637812891	-122.40656510840799	(37.7200637812891, -122.406565108408)
24910	113499	3	40	200x Mansell St	5	11	1	2		19	3x3	6011193.56936	2090563.5306400002	37.7209204242214	-122.403355677147	(37.7209204242214, -122.403355677147)
28478	176327	3	40	700x Mansell St	31	11	1	2		46	Width 0ft	6009212.31958	2089948.46975	37.7191207387124	-122.41016088932699	(37.7191207387124, -122.410160889327)
28724	199407	3	40	301x Cashmere St	7	3	1	2		18		6016184.136419999	2096191.07332	37.736650012889	-122.386496812495	(37.736650012889, -122.386496812495)
30294	176308	3	40	300x Mansell St	12	11	1	2		23	Width 0ft	6010842.734619999	2090461.59096	37.7206209176161	-122.404561241708	(37.7206209176161, -122.404561241708)
30521	17266	3	40	40 Osceola Dr	1	1	1	2		18	3X3	6017197.543092299	2094354.669125	37.7316636592684	-122.382865232677	(37.7316636592684, -122.382865232677)
36490	176307	3	40	300x Mansell St	7	11	1	2		14	Width 0ft	6010889.97096	2090468.7148799999	37.7206431182563	-122.404398460825	(37.7206431182563, -122.404398460825)
36977	186970	3	40	1650x Sloat Blvd	1	11	1	2		10	Width 0ft	5986025.4295	2095869.2083	37.734050611594604	-122.49074337328301	(37.7340506115946, -122.490743373283)
37371	176317	3	40	600x Mansell St	5	11	1	2		20	Width 0ft	6009952.88344	2090194.2340000002	37.7198370388417	-122.40761835123199	(37.7198370388417, -122.407618351232)
40506	176323	3	40	700x Mansell St	23	11	1	2		31	Width 0ft	6009342.20287	2090002.90208	37.719277477945	-122.40971577078399	(37.719277477945, -122.409715770784)
42868	176330	3	40	700x Mansell St	35	11	1	2		7	Width 0ft	6009184.10476	2089961.98667	37.7191562718235	-122.41025937136801	(37.7191562718235, -122.410259371368)
44683	176302	3	40	100x Mansell St	2	11	1	2		18	Width 0ft	6011513.54745	2090660.92357	37.721205711656204	-122.40225644658301	(37.7212057116562, -122.402256446583)
46745	176303	3	40	200x Mansell St	16	11	1	2		23	Width 0ft	6011115.33526	2090539.9745900002	37.7208513742667	-122.40362445389799	(37.7208513742667, -122.403624453898)
49638	25447	3	40	1261X La Salle Ave	15	1	1	2		18	3X3	6017141.6501925	2094501.7221284	37.732064349457005	-122.383068698568	(37.732064349457, -122.383068698568)
50131	199404	3	40	299x Cashmere St	24	3	1	2		31		6016629.65755	2096008.94769	37.7361745853726	-122.38494375437	(37.7361745853726, -122.38494375437)
53330	186974	3	40	1600x Sloat Blvd	1	11	1	2		9	Width 0ft	5986249.0864	2095869.2083	37.7340636742344	-122.489970132524	(37.7340636742344, -122.489970132524)
55441	199405	3	40	301x Cashmere St	4	3	1	2		25		6016273.90453	2096214.7321400002	37.736719944173004	-122.386188091409	(37.736719944173, -122.386188091409)
56266	9287	3	40	13X George Ct	4	1	1	2		18	3X3	6017208.549763201	2094048.0250586998	37.7308222832509	-122.38280584856301	(37.7308222832509, -122.382805848563)
58856	185127	3	40	700x Sloat Blvd	2	11	1	2		10	Width 0ft	5989015.4133	2095969.6432	37.734500589899504	-122.480413539116	(37.7345005898995, -122.480413539116)
62350	176309	3	40	300x Mansell St	21	11	1	2		24	Width 0ft	6010760.4946	2090426.07331	37.720518796898	-122.404843021812	(37.720518796898, -122.404843021812)
62801	176326	3	40	700x Mansell St	26	11	1	2		11	Width 0ft	6009300.414580001	2090007.1642099998	37.719286839006706	-122.40986051846701	(37.7192868390067, -122.409860518467)
64522	176312	3	40	500x Mansell St	15	11	1	2		13	Width 0ft	6010340.9019	2090322.69069	37.720211467072296	-122.406286146812	(37.7202114670723, -122.406286146812)
64735	176318	3	40	600x Mansell St	6	11	1	2		24	Width 0ft	6009900.75619	2090162.07565	37.71974582058	-122.40779627129	(37.71974582058, -122.40779627129)
66989	176322	3	40	700x Mansell St	11	11	1	2		11	Width 0ft	6009482.932019999	2090051.6391099999	37.7194191850237	-122.40923275838699	(37.7194191850237, -122.409232758387)
70430	176306	3	40	300x Mansell St	5	11	1	2		17	Width 0ft	6010916.0273400005	2090472.38873	37.7206546619672	-122.40430865004299	(37.7206546619672, -122.404308650043)
71073	199399	3	40	299x Cashmere St	14	3	1	2		22		6016725.29246	2095937.31293	37.7359831799735	-122.38460811386999	(37.7359831799735, -122.38460811387)
72173	176321	3	40	700x Mansell St	10	11	1	2		20	Width 0ft	6009491.13352	2090035.22052	37.7193745624679	-122.409203250746	(37.7193745624679, -122.409203250746)
73572	176297	3	40	10x Mansell St	5	11	1	2		22	Width 0ft	6011769.33402	2090739.1089	37.7214346673524	-122.401377752274	(37.7214346673524, -122.401377752274)
73620	176316	3	40	600x Mansell St	4	11	1	2		20	Width 0ft	6009975.17316	2090196.6271099998	37.7198448575227	-122.40754147176001	(37.7198448575227, -122.40754147176)
75997	176325	3	40	700x Mansell St	25	11	1	2		7	Width 0ft	6009306.38792	2090008.2878700001	37.7192902591068	-122.40983995006701	(37.7192902591068, -122.409839950067)
76398	17253	3	40	15 Osceola Ln	1	1	1	2		24	3X3	6017345.102761	2094248.0837328997	37.7313791485056	-122.382347671583	(37.7313791485056, -122.382347671583)
77295	113498	3	40	200x Mansell St	4	11	1	2		23	3x3	6011210.15679	2090562.2005	37.7209176983622	-122.403298245537	(37.7209176983622, -122.403298245537)
77566	106463	3	40	3500X MISSION ST	3	11	1	2		28		6005565.6	2097823.9	37.7405398531137	-122.42332575716001	(37.7405398531137, -122.42332575716)
77748	11361	3	40	1350X Ingalls St	5	1	1	2		80	3X3	6017253.696644001	2093959.2156363998	37.7305809242894	-122.382643589629	(37.7305809242894, -122.382643589629)
78038	11356	3	40	1339 Ingalls St	5	1	1	2		90	3X3	6017292.9099838	2093920.0801467	37.7304756321775	-122.382505299944	(37.7304756321775, -122.382505299944)
79746	23414	3	40	1800X VAN NESS AVE	2	11	1	2		30	9	6006192.0	2116736.0	37.7925033310543	-122.422503407712	(37.7925033310543, -122.422503407712)
80454	12087	3	40	1261X La Salle Ave	9	1	1	2		12	3X3	6017141.6501925	2094501.7221284	37.732064349457005	-122.383068698568	(37.732064349457, -122.383068698568)
80713	12013	3	40	1230X La Salle Ave	14	1	1	2		45	3X3	6017323.1168478	2094452.6646717	37.7319396729967	-122.382437910438	(37.7319396729967, -122.382437910438)
81197	11295	3	40	1199X Ingalls St	7	1	1	2		60	3X3	6017612.0195749	2093925.7037957	37.730508696225705	-122.38140247160801	(37.7305086962257, -122.381402471608)
81240	9288	3	40	13X George Ct	5	1	1	2		18	3X3	6017208.549763201	2094048.0250586998	37.7308222832509	-122.38280584856301	(37.7308222832509, -122.382805848563)

sf-trees

Custom SQL query returning 101 rows (hide)

Query parameters