sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
37652 141525 2 54 200 STANYAN ST 11 1 1 1     0 Width 0ft   5996673.9338 2111292.1171 37.7770143310958 -122.455042477562 (37.7770143310958, -122.455042477562)
51927 141418 2 54 530 IVY ST 11 1 1 1     0 Width 0ft   6004607.07 2111051.7308 37.776806205978 -122.42758216085 (37.776806205978, -122.42758216085)
52002 182469 2 54 1599 30th Ave 11 1 1 1     0 Width 0ft   5986816.8873 2104483.4967 37.757749341610705 -122.488640040992 (37.7577493416107, -122.488640040992)
72583 114625 2 54 2400X Post St 11 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
80868 116284 2 54 700X Greenwich St 11 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
97038 105091 6 54 344 Fulton St 11 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
121543 116331 2 54 1400X Potrero Ave 11 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
151138 183895 2 54 1390 Quintara St 11 1 1 1     4 Width 0ft   5989106.2065 2101019.8038 37.74837228939921 -122.480469185732 (37.7483722893992, -122.480469185732)
156661 137740 2 54 101 Saint Joseph's Ave 11 1 1 1     0 Width 0ft   6000679.5664 2112493.295 37.7805414418009 -122.441271996241 (37.7805414418009, -122.441271996241)
181306 185833 2 54 2091 34th Ave 11 1 1 1     0 Width 0ft   5985698.6694 2101072.9677 37.748319646443 -122.49225611672199 (37.748319646443, -122.492256116722)
Powered by Datasette · Query took 7.947ms · Data source: data.sfgov.org