sf-trees

Data source: data.sfgov.org

Custom SQL query returning 14 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
92324 96987 1 84 2201 North Point St   9 1 1   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.44357930017799 (37.8026268776405, -122.443579300178)
36648 136020 2 84 1477 Green St 1 9 1 1     4 Width 2ft   6006004.56438 2118595.56069 37.7975986409201 -122.423284189634 (37.7975986409201, -122.423284189634)
137017 212859 2 84 1850 17th Ave 1 9 1 1     5 Width 6ft   5990965.567480001 2102825.03354 37.753436858936205 -122.474171325764 (37.7534368589362, -122.474171325764)
158246 136025 2 84 80 MacOndray Ln 1 9 1 1     11     6008316.37067 2119137.06676 37.79921568041429 -122.415323048225 (37.7992156804143, -122.415323048225)
168491 213704 2 84 635 Mangels Ave 1 9 1 1     15     5997206.92035 2095245.84356 37.7329858403205 -122.45204072612499 (37.7329858403205, -122.452040726125)
184295 136024 2 84 66 MacOndray Ln 1 9 1 1     9     6008379.74874 2119143.46885 37.7992368207748 -122.415104191024 (37.7992368207748, -122.415104191024)
165336 213703 2 84 27 Melrose Ave 2 9 1 1     16 Width 10ft   5999907.55727 2095471.26814 37.733759127772394 -122.442720129024 (37.7337591277724, -122.442720129024)
165975 136022 2 84 60 MacOndray Ln 2 9 1 1     6     6008402.81482 2119144.69077 37.7992414720639 -122.415024460715 (37.7992414720639, -122.415024460715)
166130 238535 2 84 118 Saint Marys Ave 2 9 1 1     10 Width 3ft   6003941.15849 2095961.17353 37.735333416189206 -122.42880968543899 (37.7353334161892, -122.428809685439)
182122 185047 2 84 2767 34th Ave 2 9 1 1     4 Width 0ft   5985832.2143 2096586.5348 37.7360089113847 -122.491464150215 (37.7360089113847, -122.491464150215)
183108 213705 2 84 175 Staples Ave 2 9 1 1     2     5998918.04752 2093764.63915 37.7290166671659 -122.4460184358 (37.7290166671659, -122.4460184358)
152816 136023 2 84 60 MacOndray Ln 3 9 1 1     3     6008389.23117 2119145.89275 37.7992440090735 -122.415071550105 (37.7992440090735, -122.415071550105)
181165 185048 2 84 2767 34th Ave 3 9 1 1     2 Width 0ft   5985831.6836 2096605.638 37.7360613326903 -122.49146739069799 (37.7360613326903, -122.491467390698)
147664 237972 2 84 400 Prospect Ave 14 9 1 1     11     6006214.1673 2097605.70169 37.7399773120135 -122.42106776996201 (37.7399773120135, -122.421067769962)
Powered by Datasette · Query took 20.403ms · Data source: data.sfgov.org