trees

Custom SQL query returning 15 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
2915 223666 4 8 1511 Castro St 6 Sidewalk: Curb side : Cutout Tree 4   02/16/2016 05:50:00 AM 2 Width 3ft   6002610.0457 2101075.27233 37.7493001124297 -122.433777236447 (37.7493001124297, -122.433777236447) 2 4 5 28862 22
16772 113034 1 25 251 06th Ave 5 Sidewalk: Curb side : Cutout Tree 4     2 3x3   5993975.1139 2113804.1265 37.7837564355183 -122.464560902617 (37.7837564355183, -122.464560902617) 11 6 2 54 11
23915 96577 1 14 401x Otsego Ave 1 Sidewalk: Curb side : Cutout Tree 4   05/14/2011 12:00:00 AM 2 3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
44433 94516 1 8 1106X Wisconsin St 1 Sidewalk: Curb side : Cutout Tree 4   08/27/2010 12:00:00 AM 2   Permit Number 53703 6012787.7377 2102360.94736 37.7534025731789 -122.398672553793 (37.7534025731789, -122.398672553793) 10 3 8 28856 29
104120 131002 4 13 937 Lombard St 3 Sidewalk: Curb side : Cutout Tree 4   05/09/2014 12:00:00 AM 2 Width 3ft   6007919.06293 2120264.13988 37.8022880028424 -122.416777764577 (37.8022880028424, -122.416777764577) 5 1 10 308 32
124230 107423 1 110 251 06th Ave 1 Sidewalk: Curb side : Cutout Tree 4     2 3x3   5993968.46376 2113916.3836 37.7840642796834 -122.464592063385 (37.7840642796834, -122.464592063385) 11 6 2 54 11
134492 228663 1 11 4235 19th St 6 Sidewalk: Curb side : Cutout Tree 4   06/23/2015 07:36:00 AM 2 Width 3ft   6001958.87793 2104675.64602 37.7591489038263 -122.436286615639 (37.7591489038263, -122.436286615639) 2 4 5 28862 3
178792 115969 1 9 1599x 30th Ave 6 Sidewalk: Curb side : Cutout Tree 4     2 3x3   5986813.3885 2104627.15 37.7581435700771 -122.488662699732 (37.7581435700771, -122.488662699732) 1 8 3 56 35
5633 76756 1 95 1501X 42nd Ave 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   2 3x12   5983095.0741 2104639.3384 37.757959352781 -122.501522927406 (37.757959352781, -122.501522927406) 1 8 3 56 35
31112 96772 1 36 1300X Lane St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   2 3x3   6015407.2 2095381.5 37.7343840488548 -122.389126529878 (37.7343840488548, -122.389126529878) 10 3 8 58 1
79109 116057 1 22 2100x 19th St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   2 3x3   6011480.97635 2105135.37266 37.760947638753 -122.40338680266 (37.760947638753, -122.40338680266) 10 3 8 28856 29
112770 116059 1 22 2100x 19th St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   2 3x3   6011431.5308 2105131.75607 37.7609349466036 -122.403557559651 (37.7609349466036, -122.403557559651) 10 3 8 28856 29
121110 98804 1 22 950x Clay St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010297.35863 2117215.00262 37.7940492982967 -122.408332474088 (37.7940492982967, -122.408332474088) 3 1 10 28857 4
130969 116857 1 22 950x Clay St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   2 3x3   6010080.35093 2117187.65635 37.793962057763 -122.409081415981 (37.793962057763, -122.409081415981) 3 1 10 28857 4
164578 116058 1 22 2100x 19th St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   2 3x3   6011458.59484 2105134.56728 37.760944177262 -122.403464154268 (37.760944177262, -122.403464154268) 10 3 8 28856 29