sf-trees

Data source: data.sfgov.org

Custom SQL query returning 34 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
22918 191269 2 30 538 Delancey St 6 9 1 1     8     6015147.69888 2113724.07494 37.7847344271845 -122.391305511737 (37.7847344271845, -122.391305511737)
28130 191253 2 30 654 Minnesota St 12 9 1 1     3 Width 10ft   6015148.44265 2105367.15882 37.7617882296504 -122.39071873558599 (37.7617882296504, -122.390718735586)
35185 129454 2 30 855 Chestnut St 3 9 1 1     5 Width 6ft   6007720.06236 2120575.53372 37.8031318169374 -122.41748848713002 (37.8031318169374, -122.41748848713)
36009 186909 2 30 2700 Sunset Blvd 58 9 1 1     2 Width 0ft   5985192.0104 2096702.7177 37.7362904860675 -122.49368611859501 (37.7362904860675, -122.493686118595)
36838 191250 2 30 654 Minnesota St 8 9 1 1     5 Width 10ft   6015147.38841 2105382.23529 37.7618295678896 -122.390723435432 (37.7618295678896, -122.390723435432)
43531 191264 2 30 801 Arkansas St 30 9 1 1     19     6013055.03201 2103799.19748 37.7573665842245 -122.39784906707399 (37.7573665842245, -122.397849067074)
46474 129453 2 30 855 Chestnut St 2 9 1 1     4 Width 6ft   6007720.64474 2120576.4205400003 37.8031342846895 -122.417486534671 (37.8031342846895, -122.417486534671)
49285 129456 2 30 855 Chestnut St 5 9 1 1     3 Width 6ft   6007719.74229 2120576.43903 37.803134284681 -122.41748965894199 (37.803134284681, -122.417489658942)
51023 185052 2 30 2715 41st Ave 2 9 1 1     3 Width 0ft   5983668.1125 2096649.8142 37.7360559577629 -122.498950875232 (37.7360559577629, -122.498950875232)
56239 191252 2 30 654 Minnesota St 10 9 1 1     3 Width 10ft   6015147.22099 2105373.94992 37.761806808764796 -122.390723435452 (37.7618068087648, -122.390723435452)
57630 191251 2 30 654 Minnesota St 9 9 1 1     5 Width 10ft   6015148.84129 2105378.48456 37.7618193498029 -122.39071814833599 (37.7618193498029, -122.390718148336)
61708 227660 2 30 195 Beacon St 1 9 1 1     8 Width 2ft   6003113.10037 2097586.0775 37.73974812787179 -122.43178856828101 (37.7397481278718, -122.431788568281)
62772 185051 2 30 2715 41st Ave 1 9 1 1     3 Width 0ft   5983667.0512 2096660.9577 37.736086492552 -122.49895536756901 (37.736086492552, -122.498955367569)
62886 227610 2 30 400 Prospect Ave 6 9 1 1     25     6006250.04952 2097648.9456700003 37.7400980729811 -122.420946773391 (37.7400980729811, -122.420946773391)
65391 129455 2 30 855 Chestnut St 4 9 1 1     5 Width 6ft   6007721.09596 2120576.41129 37.8031342846798 -122.41748497255199 (37.8031342846798, -122.417484972552)
66851 191268 2 30 538 Delancey St 5 9 1 1     4     6015150.51675 2113731.33336 37.7847545135408 -122.391296270324 (37.7847545135408, -122.391296270324)
71134 187130 2 30 2600 Sunset Blvd 66 9 1 1     1 Width 0ft   5985156.874 2097417.7557 37.73825173359629 -122.49386027578899 (37.7382517335963, -122.493860275789)
74356 186817 2 30 1200 Sunset Blvd 110 9 1 1     2 Width 0ft   5984826.8059 2106810.865 37.7640233139964 -122.49569412937599 (37.7640233139964, -122.495694129376)
76720 129452 2 30 855 Chestnut St 1 9 1 1     5 Width 6ft   6007720.96455 2120575.51523 37.803131816931206 -122.41748536375799 (37.8031318169312, -122.417485363758)
105637 96626 1 30 145 Sutro Heights Ave 1 9 1 1   06/10/2011 12:00:00 AM     Permit Number 767986 5981103.1 2111247.3 37.775985700966395 -122.50890252539 (37.7759857009664, -122.50890252539)
144733 96627 1 30 145 Sutro Heights Ave 2 9 1 1   06/10/2011 12:00:00 AM     Permit Number 767986 5981103.1 2111247.3 37.775985700966395 -122.50890252539 (37.7759857009664, -122.50890252539)
154095 248214 2 30 67 Fair Ave 4 9 1 1     18 Width 6ft   6006956.2223 2099478.83098 37.7451623091856 -122.41863484214 (37.7451623091856, -122.41863484214)
155770 191267 2 30 538 Delancey St 3 9 1 1     7     6015157.461180001 2113744.4936599997 37.7847910341296 -122.391273164948 (37.7847910341296, -122.391273164948)
155958 227621 2 30 1335 Douglass St 5 9 1 1     5 Width 4ft   6001398.3282 2099807.1524799997 37.7457493236871 -122.43787655407499 (37.7457493236871, -122.437876554075)
157008 187077 2 30 2600 Sunset Blvd 13 9 1 1     2 Width 0ft   5985155.4633 2096938.6014 37.736936021545 -122.493829852855 (37.736936021545, -122.493829852855)
159621 186908 2 30 2700 Sunset Blvd 57 9 1 1     2 Width 0ft   5985188.8014 2096694.9245 37.736268900285 -122.493696639188 (37.736268900285, -122.493696639188)
160010 176926 2 30 200 Morse St 5 9 1 1     23 Width 10ft   6000586.22066 2087873.8924099999 37.712937131606395 -122.439829268227 (37.7129371316064, -122.439829268227)
161451 227601 2 30 1100 San Jose Ave 48 9 1 1     13     6004769.19859 2096667.0685 37.7373184762576 -122.425997076417 (37.7373184762576, -122.425997076417)
162520 227662 2 30 32 Harry St 10 9 1 1     4 Width 10ft   6003182.99622 2097643.55659 37.7399099141156 -122.43155100069099 (37.7399099141156, -122.431551000691)
166791 191265 2 30 2100 Thomas Ave 2 9 1 1     10     6012134.75084 2095927.2478099999 37.735700607590296 -122.400478845738 (37.7357006075903, -122.400478845738)
168581 227609 2 30 400 Prospect Ave 5 9 1 1     33     6006260.1728300005 2097644.39448 37.740086147061 -122.420911448013 (37.740086147061, -122.420911448013)
168888 176927 2 30 200 Morse St 6 9 1 1     30 Width 10ft   6000575.21017 2087869.90013 37.7129255429455 -122.43986703794201 (37.7129255429455, -122.439867037942)
182154 207098 2 30 144 Mangels Ave 4 9 1 1     9     6000468.8354 2095254.59465 37.733196173744105 -122.440764091915 (37.7331961737441, -122.440764091915)
187273 176963 2 30 83 Badger St 7 9 1 1     15 Width 2ft   6002428.97482 2094295.2581 37.7306734890866 -122.43391881851299 (37.7306734890866, -122.433918818513)
Powered by Datasette · Query took 20.547ms · Data source: data.sfgov.org