sf-trees

Data source: data.sfgov.org

Custom SQL query returning 17 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
7597 98002 2 72 1904 Filbert St 1 1 1 1     8 4x12   6003787.47736 2119037.49851 37.7986867144679 -122.430987461215 (37.7986867144679, -122.430987461215)
28940 237901 2 72 185 Graystone Ter 1 1 1 1     8 Width 3ft   5999340.2051099995 2104037.6986700003 37.7572481219159 -122.44529733780399 (37.7572481219159, -122.445297337804)
32055 116119 2 72 1649x Newhall St 1 1 1 1     8 2x2   6014063.167280001 2095217.05774 37.7338579263887 -122.393761818374 (37.7338579263887, -122.393761818374)
58805 237927 2 72 4780 19th St 2 1 1 1     8 Width 3ft   5999842.984730001 2104684.3807599996 37.75905243893521 -122.44360498998999 (37.7590524389352, -122.44360498999)
155130 237898 2 72 1087 Florida St 1 1 1 1     8 Width 4ft   6009471.98593 2102823.41576 37.754487114207 -122.41017181789101 (37.754487114207, -122.410171817891)
155167 214341 2 72 144 Montana St 1 1 1 1     8 Width 3ft   5995498.01894 2089341.3443900002 37.7166754640834 -122.457521759431 (37.7166754640834, -122.457521759431)
159793 58839 1 72 2385 Broadway 1 1 1 1   11/27/1979 12:00:00 AM 8   Permit Number 18096 6002233.54572 2117374.3754 37.7940320393926 -122.43624546807699 (37.7940320393926, -122.436245468077)
180799 135866 2 72 200 Presidio Ave 1 1 1 1     8 Width 3ft   5999037.7073 2115878.6146 37.7897429809958 -122.447195652882 (37.7897429809958, -122.447195652882)
186903 214342 2 72 331 Lakeview Ave 1 4 1 1     8 Width 3ft   5996752.352000001 2089647.99235 37.7175894189894 -122.45320830242599 (37.7175894189894, -122.453208302426)
38247 237913 2 72 256 Bemis St 2 7 1 1     8     6003021.95871 2096302.8591099998 37.736219537998 -122.432012088491 (37.736219537998, -122.432012088491)
62421 214311 2 72 1616 09th Ave 1 7 1 1     8 Width 6ft   5993417.73262 2104465.9003 37.7580840030825 -122.46581049954901 (37.7580840030825, -122.465810499549)
135434 214312 2 72 1616 09th Ave 2 7 1 1     8 Width 6ft   5993417.09067 2104452.78428 37.758047952866605 -122.465811766705 (37.7580479528666, -122.465811766705)
174855 196321 2 72 1018 Pennsylvania Ave 1 7 1 1     8 Width 6ft   6014465.23121 2102394.5848 37.753588252598796 -122.392873735151 (37.7535882525988, -122.392873735151)
28361 214344 2 72 498 Vernon St 2 9 1 1     8 Width 10ft   5992505.71978 2091140.82125 37.7214440535804 -122.467995374584 (37.7214440535804, -122.467995374584)
59899 237911 2 72 414 Collingwood St 4 9 1 1     8     6002101.71196 2103425.3535700003 37.7557240165608 -122.435703175975 (37.7557240165608, -122.435703175975)
171890 196322 2 72 320 Pennsylvania Ave 2 9 1 1     8 Width 6ft   6014284.29861 2105571.05325 37.7623000976946 -122.393721759867 (37.7623000976946, -122.393721759867)
37189 196334 2 72 185 Hampshire St 2 10 1 1     8 Width 5ft   6010020.7902 2107448.7072099997 37.767217864928206 -122.408600163592 (37.7672178649282, -122.408600163592)
Powered by Datasette · Query took 3.98ms · Data source: data.sfgov.org