sf-trees

This data as json, CSV

rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
129	20398	3	47	262X Sunset Blvd	43	1	1	2	24	60
272	251264	6	47	3630x 19th Ave	3	9	1	1			Permit Number 779147
277	251265	6	47	3630x 19th Ave	4	9	1	1			Permit Number 779147
293	251262	6	47	3630x 19th Ave	1	9	1	1			Permit Number 779147
300	251263	6	47	3630x 19th Ave	2	9	1	1			Permit Number 779147
549	251321	2	47	100X Monument Way	1	14	1	1
618	20377	3	47	262X Sunset Blvd	25	1	1	2	48	60
682	251365	5	47	138x Gladeview Way	2	9	1	1
712	251366	5	47	138x Gladeview Way	3	9	1	1
713	251364	5	47	138x Gladeview Way	1	9	1	1
886	19568	3	47	100 STAIRWAY1	2	1	1	2	48	100ST
1098	251438	3	47	2501X Santiago St	1	3	1	2
1898	20392	3	47	262X Sunset Blvd	38	1	1	2	12	60
5557	20407	3	47	262X Sunset Blvd	52	1	1	2	36	60
5855	19776	3	47	100 STAIRWAY18	2	1	1	2	18	50ST
6006	20312	3	47	101X Sunset Blvd	1	1	1	2	24	60
6023	19905	3	47	100 STAIRWAY35	1	1	1	2	12	120ST
6115	20296	3	47	20X Sunset Blvd	17	1	1	2	42	60
6147	19906	3	47	100 STAIRWAY35	2	1	1	2	6	120ST
6357	20291	3	47	20X Sunset Blvd	12	1	1	2	18	60
6360	20424	3	47	453X Sunset Blvd	13	1	1	2	42	60
6399	20412	3	47	453X Sunset Blvd	1	1	1	2	42	60
6517	19907	3	47	100 STAIRWAY35	3	1	1	2	12	120ST
6533	19565	3	47	100 STAIRWAY1	-11	1	1	2	36	100ST
6834	19955	3	47	100 STAIRWAY39	12	1	1	2	12	2ST
6952	19935	3	47	100 STAIRWAY38	4	1	1	2	12	10ST
7006	20417	3	47	453X Sunset Blvd	6	1	1	2	42	60
7548	20317	3	47	101X Sunset Blvd	6	1	1	2	18	60
7732	19948	3	47	100 STAIRWAY39	5	1	1	2	18	25ST
7834	119605	6	47	299x Avalon Ave	1	7	1	1
7886	19945	3	47	100 STAIRWAY39	2	1	1	2	6	25ST
7938	19700	3	47	100 STAIRWAY11	2	1	1	2	36	40ST
8196	20297	3	47	20X Sunset Blvd	18	1	1	2	36	60
8406	20373	3	47	262X Sunset Blvd	21	1	1	2	18	60
8739	20365	3	47	262X Sunset Blvd	15	1	1	2	48	60
8750	20413	3	47	453X Sunset Blvd	2	1	1	2	42	60
8903	19566	3	47	100 STAIRWAY1	-9	1	1	2	36	100ST
9072	19804	3	47	100 STAIRWAY22	3	1	1	2	6	20
9473	20455	3	47	495X Sunset Blvd	20	1	1	2	42	60
9584	20422	3	47	453X Sunset Blvd	11	1	1	2	36	60
10571	19570	3	47	100 STAIRWAY1	4	1	1	2	48	100ST
10674	19936	3	47	100 STAIRWAY38	5	1	1	2	12	10ST
10701	20452	3	47	495X Sunset Blvd	17	1	1	2	36	60
10705	19569	3	47	100 STAIRWAY1	3	1	1	2	48	100ST
10816	19910	3	47	100 STAIRWAY35	6	1	1	2	12	120ST
10949	19933	3	47	100 STAIRWAY38	2	1	1	2	12	10ST
11220	19950	3	47	100 STAIRWAY39	7	1	1	2	12	25ST
11591	20428	3	47	485X Sunset Blvd	1	1	1	2	42	40
11826	20419	3	47	453X Sunset Blvd	8	1	1	2	12	60
12151	19869	3	47	100 STAIRWAY33	1	1	1	2	24	25ST
12480	20434	3	47	485X Sunset Blvd	7	1	1	2	12	30
12812	19953	3	47	100 STAIRWAY39	10	1	1	2	12	25ST
13158	19753	3	47	100 STAIRWAY15	11	1	1	2	12	10ST
13184	20013	3	47	100 STAIRWAY47	1	1	1	2	6	100ST
14158	20429	3	47	485X Sunset Blvd	2	1	1	2	42	30
14206	19813	3	47	100 STAIRWAY24	4	1	1	2	12	100ST
14400	19934	3	47	100 STAIRWAY38	3	1	1	2	12	10ST
14425	19694	3	47	100 STAIRWAY7	1	1	1	2	24	12ST
14506	20366	3	47	262X Sunset Blvd	16	1	1	2	48	60
14521	20280	3	47	20X Sunset Blvd	1	1	1	2	18	60
14597	20303	3	47	50X Sunset Blvd	5	1	1	2	12	60
14923	20430	3	47	485X Sunset Blvd	3	1	1	2	42	30
14992	19932	3	47	100 STAIRWAY38	1	1	1	2	12	10ST
15767	19699	3	47	100 STAIRWAY11	1	1	1	2	24	40ST
15771	19908	3	47	100 STAIRWAY35	4	1	1	2	6	120ST
15978	19943	3	47	100 STAIRWAY38	12	1	1	2	12	10ST
16086	20423	3	47	453X Sunset Blvd	12	1	1	2	42	60
16424	19949	3	47	100 STAIRWAY39	6	1	1	2	24	25ST
16454	20294	3	47	20X Sunset Blvd	15	1	1	2	24	60
16608	19951	3	47	100 STAIRWAY39	8	1	1	2	12	25ST
16721	19947	3	47	100 STAIRWAY39	4	1	1	2	18	25ST
16878	19909	3	47	100 STAIRWAY35	5	1	1	2	12	120ST
17092	19978	3	47	100 STAIRWAY45	5	1	1	2	36	30ST
27191	186631	2	47	1300 Lower Great Hwy	7	19	1	1	2	Width 0ft		5980860.0426	2105683.7293	37.7606954284135	-122.50933003298901	(37.7606954284135, -122.509330032989)
73687	186630	2	47	1300 Lower Great Hwy	6	19	1	1	2	Width 0ft		5980860.7453	2105672.8381	37.7606655657469	-122.50932679385099	(37.7606655657469, -122.509326793851)
155462	186632	2	47	1300 Lower Great Hwy	8	19	1	1	5	Width 0ft		5980861.0966	2105687.2426	37.7607051370684	-122.509326648666	(37.7607051370684, -122.509326648666)
174389	186633	2	47	1300 Lower Great Hwy	9	19	1	1	3	Width 0ft		5980876.555	2105686.5399	37.760704119089	-122.509273133786	(37.760704119089, -122.509273133786)
153024	186626	2	47	1300 Lower Great Hwy	2	19	1	1	7	Width 0ft		5980879.19	2105650.5288	37.7606053983358	-122.509261346313	(37.7606053983358, -122.509261346313)
166154	186488	2	47	1400 Lower Great Hwy	34	19	1	1	15	Width 0ft		5980888.4423	2105382.2174	37.7598692379346	-122.50920942183998	(37.7598692379346, -122.50920942184)
137510	118414	2	47	641 48th Ave	1	9	1	1	26			5980997.21538	2111360.64896	37.7762906814163	-122.509277221064	(37.7762906814163, -122.509277221064)
185035	183344	2	47	1210 48th Ave	2	1	1	1	15	Width 0ft		5981199.4113	2106812.2909	37.763814137238896	-122.50824009998999	(37.7638141372389, -122.50824009999)
133209	183349	2	47	1210 48th Ave	1	1	1	1	16	Width 0ft		5981200.6659	2106791.7999	37.763757948803	-122.508234239743	(37.763757948803, -122.508234239743)
127792	99864	1	47	681 47th Ave	2	1	1	1			Permit Number 768887	5981306.2	2111092.9	37.775573734396204	-122.508188499048	(37.7755737343962, -122.508188499048)
72965	99863	1	47	681 47th Ave	1	1	1	1	28			5981324.99313	2111098.19167	37.7755893711796	-122.508123883044	(37.7755893711796, -122.508123883044)
168002	118630	2	47	349 Point Lobos Ave	9	9	1	1	16			5981637.79887	2112651.0038099997	37.7798713628306	-122.507157052361	(37.7798713628306, -122.507157052361)
24438	118836	2	47	600 46th Ave	5	2	1	1	30	Width 3ft		5981651.25866	2111619.12831	37.77703893001029	-122.50703392298401	(37.7770389300103, -122.507033922984)
173594	118511	2	47	8131 Geary Blvd	1	1	1	1	13	Width 6ft		5981763.277969999	2112328.08269	37.7789921064061	-122.506699014872	(37.7789921064061, -122.506699014872)
27465	118640	2	47	495 45th Ave	2	2	1	1	17	Width 3ft		5981891.5492	2112442.21245	37.7793130253265	-122.50626374607401	(37.7793130253265, -122.506263746074)
36295	176117	2	47	3500 Great Hwy	1	4	1	1	27	Width 0ft		5982122.73417	2092919.02565	37.725721454959896	-122.50401753028099	(37.7257214549599, -122.504017530281)
175790	176118	2	47	3500 Great Hwy	2	4	1	1	9	Width 0ft		5982159.440219999	2092886.81947	37.7256351838922	-122.50388825816201	(37.7256351838922, -122.503888258162)
67613	176119	2	47	3500 Great Hwy	3	4	1	1	6	Width 0ft		5982177.8802	2092874.78727	37.7256032309891	-122.503823622987	(37.7256032309891, -122.503823622987)
155726	185138	2	47	2690 Wawona St	3	1	1	1	28	Width 0ft		5982184.8279	2096764.5685	37.736283925183294	-122.504087599723	(37.7362839251833, -122.504087599723)
140427	185137	2	47	2690 Wawona St	2	1	1	1	31	Width 0ft		5982222.13	2096764.5685	37.7362861187615	-122.503958633083	(37.7362861187615, -122.503958633083)
60682	176120	2	47	3500 Great Hwy	5	4	1	1	7	Width 0ft		5982240.010290001	2092829.2357299998	37.725481811732294	-122.503605476233	(37.7254818117323, -122.503605476233)
130304	185136	2	47	2690 Wawona St	1	1	1	1	33	Width 0ft		5982268.7576	2096762.1144	37.7362821222461	-122.503797243162	(37.7362821222461, -122.503797243162)
43979	176121	2	47	3500 Great Hwy	8	4	1	1	6	Width 0ft		5982310.611330001	2092790.70938	37.7253801793381	-122.503358567347	(37.7253801793381, -122.503358567347)
128242	176122	2	47	3500 Great Hwy	9	4	1	1	3	Width 0ft		5982330.17471	2092783.08412	37.7253603924579	-122.50329037535101	(37.7253603924579, -122.503290375351)
40949	176127	2	47	3500 Great Hwy	14	4	1	1	2	Width 0ft		5982331.987919999	2092758.60697	37.7252932913503	-122.503282295839	(37.7252932913503, -122.503282295839)
181416	176125	2	47	3500 Great Hwy	12	4	1	1	2	Width 0ft		5982332.21205	2092769.0757400002	37.7253220489632	-122.50328229583499	(37.7253220489632, -122.503282295835)
56038	176126	2	47	3500 Great Hwy	13	4	1	1	1	Width 0ft		5982340.21435	2092760.75831	37.725299681933706	-122.503254017558	(37.7252996819337, -122.503254017558)
71232	176123	2	47	3500 Great Hwy	10	4	1	1	3	Width 0ft		5982341.65637	2092773.52846	37.725334830110995	-122.50324997780199	(37.725334830111, -122.503249977802)

sf-trees

Custom SQL query returning 101 rows (hide)

Query parameters