sf-trees

Data source: data.sfgov.org

Custom SQL query returning 18 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
10092 173852 1 54 450 Toland St 7 1 2 1   01/27/2017 12:00:00 AM 3 8.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
22811 185829 2 54 2061 34th Ave 7 1 1 1     0 Width 0ft   5985695.3610000005 2101217.9835 37.7487176270346 -122.49227823369301 (37.7487176270346, -122.492278233693)
28402 137551 2 54 1526 Steiner St 7 1 1 1     0 Width 0ft   6002668.0924 2113464.7267 37.7833218226195 -122.434462226416 (37.7833218226195, -122.434462226416)
30940 185841 2 54 2000 35th Ave 7 2 1 1     0 Width 0ft   5985424.0767 2101308.9631 37.748951568943205 -122.493223020907 (37.7489515689432, -122.493223020907)
40764 186526 2 54 1501 Sunset Blvd 7 2 1 1     0 Width 0ft   5984782.9201 2104548.9278 37.7578100967767 -122.495679060793 (37.7578100967767, -122.495679060793)
61664 245454 2 54 2700 16th St 7 1 1 1     0 Width 0ft   6008487.3357 2106844.226 37.765472098116796 -122.41386141193001 (37.7654720981168, -122.41386141193)
73809 139018 2 54 2569 SUTTER ST 7 1 1 1     0 Width 0ft   6000314.1665 2114058.3378 37.784817825136706 -122.44264848882601 (37.7848178251367, -122.442648488826)
74459 137586 2 54 1150 PIERCE ST 7 1 1 1     0 Width 0ft   6002357.4789 2112504.0318 37.7806663604621 -122.435468077701 (37.7806663604621, -122.435468077701)
97624 114622 2 54 2400X Post St 7 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
113187 115067 3 54 70 Coral Rd 7 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
113454 108799 2 54 501-599 University St 7 1 1 1           6008503.45306 2091469.8325200002 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961)
118898 116327 2 54 1400X Potrero Ave 7 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
120796 105087 6 54 344 Fulton St 7 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
125482 116947 2 54 3676 23RD ST 7 1 1 1       3x3   6005238.0 2102584.0 37.753591501312705 -122.424797029407 (37.7535915013127, -122.424797029407)
140188 116280 2 54 700X Greenwich St 7 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
168746 142538 2 54 2100 POWELL ST 7 1 1 1     0 Width 0ft   6009433.1509 2121013.8406 37.8044315384071 -122.41159126219999 (37.8044315384071, -122.4115912622)
172874 139933 2 54 800 GOUGH ST 7 1 1 1     0 Width 0ft   6005708.0541 2112525.3709 37.7809146750444 -122.42387833426001 (37.7809146750444, -122.42387833426)
179050 186412 2 54 1601 Sunset Blvd 7 2 1 1     0 Width 0ft   5984810.0324 2103749.2702 37.7556160465723 -122.49552631838101 (37.7556160465723, -122.495526318381)
Powered by Datasette · Query took 14.138ms · Data source: data.sfgov.org