sf-trees

Data source: data.sfgov.org

Custom SQL query returning 26 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
37 226924 2 19 1 Newburg St 1 6 1 1     11 Width 4ft   6002558.65829 2099967.6575700003 37.7462559468486 -122.433875776072 (37.7462559468486, -122.433875776072)
44 226925 2 19 1 Newburg St 2 6 1 1     19 Width 4ft   6002565.841680001 2099976.66752 37.746281093695 -122.433851580699 (37.746281093695, -122.433851580699)
61 226596 2 27 1 Newburg St 4 6 1 1     4 Width 4ft   6002583.45295 2099992.19698 37.746324733318 -122.433791792881 (37.746324733318, -122.433791792881)
65 226926 2 19 1 Newburg St 3 6 1 1     15 Width 4ft   6002574.76935 2099983.89995 37.7463014588644 -122.433821226777 (37.7463014588644, -122.433821226777)
1580 239668 2 149 180 Dolores St 3 6 1 1     23 Width 4ft   6004776.3298 2107329.36682 37.766595069134105 -122.426731495165 (37.7665950691341, -122.426731495165)
79776 94218 1 43 246 01st St 3 6 1 1   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636)
80534 96292 1 17 1294 Union St   6 2 1   03/21/2011 12:00:00 AM       6006773.0 2119090.0 37.7989995844362 -122.420660308797 (37.7989995844362, -122.420660308797)
83162 91494 1 106 1980 Union St 3 6 1 1   12/12/2006 12:00:00 AM     Permit Number 49113 6003507.0 2118649.0 37.797604101528 -122.431930246212 (37.797604101528, -122.431930246212)
86057 94469 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
88424 107748 1 17 475 Florida St 3 6 1 1   10/22/2014 12:00:00 AM 3   Permit Number 774008 6009222.84948 2106151.80329 37.7636121434561 -122.41126850895901 (37.7636121434561, -122.411268508959)
90460 94216 1 43 1X Tehama St 1 6 1 1   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6013910.7 2114841.3 37.7877333404996 -122.395663455814 (37.7877333404996, -122.395663455814)
93021 107747 1 17 475 Florida St 2 6 1 1   10/22/2014 12:00:00 AM 3   Permit Number 774008 6009222.84948 2106151.80329 37.7636121434561 -122.41126850895901 (37.7636121434561, -122.411268508959)
98453 93908 1 17 1238 Sutter St   6 1 1   04/26/2010 12:00:00 AM     Permit Number 53382 6006657.0 2114990.0 37.787735469045295 -122.420770480664 (37.7877354690453, -122.420770480664)
100186 107746 1 17 475 Florida St 1 6 1 1   10/22/2014 12:00:00 AM 3   Permit Number 774008 6009222.84948 2106151.80329 37.7636121434561 -122.41126850895901 (37.7636121434561, -122.411268508959)
100656 94229 1 17 45 Stonecrest Dr 1 6 1 1   06/28/2010 12:00:00 AM 60   Permit Number 53610 5991334.0 2093833.0 37.728768372571295 -122.47224179475 (37.7287683725713, -122.47224179475)
100936 96291 1 17 1294 Union St   6 2 1   03/21/2011 12:00:00 AM       6006773.0 2119090.0 37.7989995844362 -122.420660308797 (37.7989995844362, -122.420660308797)
101398 91493 1 106 1980 Union St 2 6 1 1   12/12/2006 12:00:00 AM     Permit Number 49113 6003507.0 2118649.0 37.797604101528 -122.431930246212 (37.797604101528, -122.431930246212)
103566 94487 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
105416 94220 1 43 1X Tehama St 5 6 1 1         Permit Number 53568 6013910.7 2114841.3 37.7877333404996 -122.395663455814 (37.7877333404996, -122.395663455814)
117229 94219 1 43 246 01st St 4 6 1 1   06/25/2010 12:00:00 AM     Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636)
121379 91495 1 106 1980 Union St 4 6 1 1   12/12/2006 12:00:00 AM     Permit Number 49113 6003507.0 2118649.0 37.797604101528 -122.431930246212 (37.797604101528, -122.431930246212)
126549 94468 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
139298 92611 1 98 3856 23rd St   6 2 1   08/31/2009 12:00:00 AM     Permit Number 52924 6004067.0 2102488.0 37.753261698893496 -122.428839761175 (37.7532616988935, -122.428839761175)
139599 110312 1 17 899x Stanyan St 6 6 1 5   04/03/2015 12:00:00 AM 3 3x3 Permit Number 774992 5997166.64381 2107575.86009 37.7668387037649 -122.45306972128999 (37.7668387037649, -122.45306972129)
140810 93909 1 17 1238 Sutter St 2 6 1 1   04/26/2010 12:00:00 AM     Permit Number 53382 6006657.0 2114990.0 37.787735469045295 -122.420770480664 (37.7877354690453, -122.420770480664)
143783 94217 1 43 246 01st St 2 6 1 1   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636)
Powered by Datasette · Query took 1.557ms · Data source: data.sfgov.org