sf-trees

This data as json, CSV

rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
1099	250070	3	70	399 Austin St	1	4	1	2			2	Width 3ft		6005393.47416	2115303.0126799997	37.788523627097	-122.425164323999	(37.788523627097, -122.425164323999)
19541	31130	1	70	127 Foerster St	1	1	1	1	1	03/21/1995 12:00:00 AM	2	3x3	Permit Number 34845	5998083.60465	2093967.1558599998	37.729525044927705	-122.448917737661	(37.7295250449277, -122.448917737661)
26824	125535	2	70	11 Miller Pl	7	1	1	1			2	Width 2ft		6010079.40223	2116881.04203	37.7931201160419	-122.409063053629	(37.7931201160419, -122.409063053629)
30740	221771	2	70	155 Conrad St	3	1	1	1			2	Width 2ft		6001803.9521	2096539.96195	37.7368014398277	-122.436240194438	(37.7368014398277, -122.436240194438)
33829	189162	2	70	109 Kissling St	5	4	1	1			2	Width 3ft		6008137.74771	2109383.99653	37.7724260745213	-122.41525036411998	(37.7724260745213, -122.41525036412)
35263	249989	2	70	228 Filbert St	5	7	1	1			2	Width 0ft		6011581.894069999	2120103.40396	37.802051997370896	-122.404091195777	(37.8020519973709, -122.404091195777)
38916	125482	2	70	1 Nob Hill Pl	4	1	1	1			2	Width 1ft		6009469.59091	2116291.78471	37.7914679787239	-122.41113140348499	(37.7914679787239, -122.411131403485)
43952	221766	2	70	712 Waller St	1	1	1	1			2	Width 3ft		6002158.80169	2108813.78872	37.770522589268204	-122.43589127638799	(37.7705225892682, -122.435891276388)
44557	119343	2	70	462 32nd Ave	1	1	1	1			2	Width 3ft		5985960.41468	2112779.42827	37.7804776215792	-122.49221287963199	(37.7804776215792, -122.492212879632)
46216	189159	2	70	109 Kissling St	2	4	1	1			2	Width 3ft		6008170.01676	2109410.076	37.7724994960939	-122.415140588393	(37.7724994960939, -122.415140588393)
47631	221761	2	70	4441 20th St	2	1	1	1			2	Width 3ft		6001542.762080001	2104063.39418	37.75744415704379	-122.437681892224	(37.7574441570438, -122.437681892224)
47885	125511	2	70	900 Green St	15	9	1	1			2	Width 5ft		6008625.76186	2119029.2242099997	37.7989369553212	-122.41424481055799	(37.7989369553212, -122.414244810558)
48850	246960	2	70	2177 15th St	1	4	1	1			2	Width 3ft		6003038.46952	2107086.92585	37.7658309772437	-122.432725124067	(37.7658309772437, -122.432725124067)
49294	221759	2	70	4515 20th St	2	1	1	1			2	Width 3ft		6001360.92884	2104054.05926	37.7574081850601	-122.438310074049	(37.7574081850601, -122.438310074049)
49806	221764	2	70	3809 16th St	1	9	1	1			2	Width 2ft		6001727.44948	2106346.3994299998	37.7637232334694	-122.437206631108	(37.7637232334694, -122.437206631108)
54829	221760	2	70	4515 20th St	3	1	1	1			2	Width 3ft		6001372.8328	2104055.08022	37.7574116654297	-122.43826897865101	(37.7574116654297, -122.438268978651)
55188	203461	2	70	409 Hearst Ave	2	1	1	1			2	Width 2ft		5998653.32929	2094365.51359	37.7306514071182	-122.446976805539	(37.7306514071182, -122.446976805539)
60116	248097	2	70	8 Brewster St	6	1	1	1			2	Width 2ft		6010442.71302	2099823.47595	37.7463043033989	-122.406603382656	(37.7463043033989, -122.406603382656)
61770	249991	2	70	228 Filbert St	7	7	1	1			2	Width 0ft		6011578.47013	2120102.62532	37.802049668108396	-122.404102989475	(37.8020496681084, -122.404102989475)
63403	221758	2	70	4515 20th St	1	1	1	1			2	Width 3ft		6001348.5727699995	2104052.2530799997	37.757402522937	-122.438352676761	(37.757402522937, -122.438352676761)
70634	189160	2	70	109 Kissling St	3	4	1	1			2	Width 3ft		6008158.83722	2109400.5814099996	37.772472797918	-122.415178587445	(37.772472797918, -122.415178587445)
71399	125537	2	70	11 Miller Pl	9	1	1	1			2	Width 2ft		6010079.43392	2116876.79887	37.7931084671277	-122.409062644443	(37.7931084671277, -122.409062644443)
74953	125514	2	70	900 Green St	24	9	1	1			2	Width 5ft		6008590.31929	2119027.3925900003	37.7989299352366	-122.414367324317	(37.7989299352366, -122.414367324317)
77178	220638	2	70	222 Parnassus Ave	2	1	1	1			2	Width 7ft		5997115.15152	2106725.56313	37.7645010544003	-122.453186433611	(37.7645010544003, -122.453186433611)
132055	189161	2	70	109 Kissling St	4	4	1	1			2	Width 3ft		6008149.50016	2109391.65635	37.7724477670719	-122.41521025345699	(37.7724477670719, -122.415210253457)
132179	220641	2	70	859 Moultrie St	1	1	1	1			2	Width 3ft		6007571.590369999	2095340.9683400001	37.7338352787826	-122.416213992189	(37.7338352787826, -122.416213992189)
134395	125517	2	70	900 Green St	29	9	1	1			2	Width 5ft		6008575.41519	2119026.3782099998	37.7989263127569	-122.414418825785	(37.7989263127569, -122.414418825785)
149721	125500	2	70	12 Hastings Ter	6	9	1	1			2			6007269.76384	2119273.06582	37.7995302219096	-122.41895432719299	(37.7995302219096, -122.418954327193)
150359	125533	2	70	11 Miller Pl	5	1	1	1			2	Width 2ft		6010078.6629	2116885.41787	37.7931320896218	-122.40906592066901	(37.7931320896218, -122.409065920669)
150893	189163	2	70	2324 19th St	1	1	1	1			2	Width 4ft		6010839.472159999	2105097.2568200002	37.7608071304715	-122.405602811334	(37.7608071304715, -122.405602811334)
155489	125460	2	70	2416 Webster St	1	1	1	1			2	Width 4ft		6003175.77984	2117097.00502	37.7933239410913	-122.432965418428	(37.7933239410913, -122.432965418428)
159071	125499	2	70	10 Hastings Ter	1	9	1	1			2			6007355.47144	2119286.0885099997	37.799570804701396	-122.418658671469	(37.7995708047014, -122.418658671469)
161599	125530	2	70	11 Miller Pl	2	1	1	1			2	Width 2ft		6010077.8438099995	2116891.68093	37.7931492405824	-122.40906919691002	(37.7931492405824, -122.40906919691)
161762	220642	2	70	565 Banks St	1	1	1	1			2	Width 3ft		6008547.4442300005	2096175.62445	37.7361818869891	-122.41289915230101	(37.7361818869891, -122.412899152301)
163457	189152	2	70	1665 Hudson Ave	1	4	1	1			2	Width 3ft		6015368.44602	2097645.0372099997	37.7405971121722	-122.389418536259	(37.7405971121722, -122.389418536259)
164035	203455	2	70	5 Madrone Ave	2	1	1	1			2	Width 3ft		5993020.02718	2099098.31016	37.7433230301343	-122.466795738355	(37.7433230301343, -122.466795738355)
164200	189164	2	70	900 Pennsylvania Ave	12	9	1	1			2			6014453.294530001	2102557.3777799997	37.754034584334605	-122.392926403935	(37.7540345843346, -122.392926403935)
167745	220613	2	70	919 South Van Ness Ave	1	1	1	1			2	Width 3ft		6007605.87187	2104275.7103	37.7583700063988	-122.416728224545	(37.7583700063988, -122.416728224545)
172712	125518	2	70	900 Green St	30	9	1	1			2	Width 5ft		6008573.08581	2119026.43144	37.7989263280573	-122.414426890005	(37.7989263280573, -122.414426890005)
184003	125521	2	70	900 Green St	33	9	1	1			2	Width 5ft		6008568.41134	2119026.0619799998	37.7989250510158	-122.414443039112	(37.7989250510158, -122.414443039112)
184956	249990	2	70	228 Filbert St	6	7	1	1			2	Width 0ft		6011580.18498	2120103.15607	37.802051221233	-122.404097092619	(37.802051221233, -122.404097092619)
186515	189172	2	70	1947 Quesada Ave	1	4	1	1			2	Width 2ft		6013391.6303	2095988.7563900002	37.735939510689605	-122.396137605077	(37.7359395106896, -122.396137605077)
186745	189158	2	70	109 Kissling St	1	4	1	1			2	Width 3ft		6008181.208740001	2109420.17856	37.7725278642987	-122.41510258932301	(37.7725278642987, -122.415102589323)

sf-trees

Custom SQL query returning 43 rows (hide)

Query parameters