sf-trees

Data source: data.sfgov.org

Custom SQL query returning 16 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9985 120925 6 3 3995X Alemany Blvd 8 5 1 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
128194 114232 6 140 99x FONT BLVD 8 2 1 1     15     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
9647 114149 6 3 1200X JUNIPERO SERRA BLVD 8 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
91870 122411 6 55 499x Ocean Ave 8 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
111177 110952 6 3 220 Newhall St 8 9 1 1   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.38450453105301 (37.7426065069695, -122.384504531053)
80352 121187 6 1 1000x Duncan St 8 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
145011 113731 6 26 1580 Valencia St 8 7 1 1           6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
1957 252829 6 161 3852 17th St 8 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
88130 98104 6 3 1@Carl Irving St 8 9 1 1     15     5995817.2 2106753.3 37.7645027364821 -122.45767767256001 (37.7645027364821, -122.45767767256)
87470 102106 6 116 50X Noe St 8 7 1 1   12/19/2012 12:00:00 AM 25   Permit Number 769282 6002816.1 2107996.5 37.7683158318555 -122.433559261751 (37.7683158318555, -122.433559261751)
110151 107080 6 92 401X TOWNSEND ST 8 5 1 1     14 2x30   6013045.0 2110022.0 37.774452457479 -122.398320364295 (37.774452457479, -122.398320364295)
89800 98948 6 108 401 Grove St 8 7 1 1           6005778.2 2111279.0 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313)
141862 105088 6 54 344 Fulton St 8 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
100107 100701 6 85 200X 01st St 8 7 1 1   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954.0 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137)
9752 173678 6 75 299x Beale St 8 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
122658 112488 6 40 1275 Columbus Ave 8 7 1 1           6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209)
Powered by Datasette · Query took 7.297ms · Data source: data.sfgov.org