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)
2485 59880 1 123 2139 Filbert St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/20/1981 12:00:00 AM 10   Permit Number 19345 6002701.87127 2118840.74506 37.7980849079605 -122.434729923369 (37.7980849079605, -122.434729923369) 13 9 1 57 17
6340 33134 1 123 3107 Pierce St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/05/1996 12:00:00 AM 10   Permit Number 37364 6001390.00916 2119109.09622 37.7987471650933 -122.439288583214 (37.7987471650933, -122.439288583214) 13 9 1 57 17
20202 136176 1 123 2134 Green St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6002833.9768 2118210.69092 37.7963624418193 -122.434227733841 (37.7963624418193, -122.434227733841) 13 9 1 57 17
32482 65937 1 123 2826 Union St 1 Sidewalk: Curb side : Cutout Tree 2   06/08/1990 12:00:00 AM 7   Permit Number 28956 5999433.3119 2118083.73409 37.7958202522453 -122.445985572784 (37.7958202522453, -122.445985572784) 13 9 1 57 17
55713 136180 1 123 3134 Baker St 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   5999407.16472 2119635.33058 37.8000790286731 -122.446187711617 (37.8000790286731, -122.446187711617) 13 9 1 57 17
56230 136182 1 123 3140 Baker St 2 Sidewalk: Curb side : Cutout Tree 2     4 Width 2ft   5999403.04173 2119664.02877 37.8001575907471 -122.446204044176 (37.8001575907471, -122.446204044176) 13 9 1 57 17
94223 136177 1 123 2028 Filbert St 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   6003216.31619 2118958.46656 37.7984373333682 -122.432958210354 (37.7984373333682, -122.432958210354) 13 9 1 57 17
106021 136178 1 123 2400 Greenwich St 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 4ft   6001367.93231 2119047.53981 37.798576891075 -122.439360561339 (37.798576891075, -122.439360561339) 13 9 1 57 17
106256 65755 1 123 3036 Octavia St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/20/1990 12:00:00 AM 14   Permit Number 28718 6004280.73363 2119630.96227 37.8003441497153 -122.429322978897 (37.8003441497153, -122.429322978897) 13 9 1 57 17
116025 30565 1 123 2245 Union St 2 Sidewalk: Curb side : Cutout Tree 2   01/25/1995 12:00:00 AM 7   Permit Number 34543 6002240.34549 2118428.38115 37.7969264516424 -122.436297407498 (37.7969264516424, -122.436297407498) 13 9 1 57 17
146439 136181 1 123 3140 Baker St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 2ft   5999405.90686 2119644.67772 37.8001046215781 -122.446192737013 (37.8001046215781, -122.446192737013) 13 9 1 57 17
148213 136179 1 123 2400 Greenwich St 2 Sidewalk: Curb side : Cutout Tree 2     9 Width 4ft   6001333.81043 2119043.17386 37.7985629614603 -122.439478320365 (37.7985629614603, -122.439478320365) 13 9 1 57 17
155023 80092 1 123 1800-1804 Filbert St 2 Sidewalk: Curb side : Cutout Tree 2   07/01/2009 12:00:00 AM 4 3x3 Permit Number 52336 6004273.51915 2119103.69822 37.7988960100912 -122.429310324527 (37.7988960100912, -122.429310324527) 13 9 1 57 17
169587 83336 1 123 1800-1804 Filbert St 1 Sidewalk: Curb side : Cutout Tree 2   07/01/2009 12:00:00 AM 4 3x3 Permit Number 52336 6004282.92403 2119104.69719 37.7988992854406 -122.429277851819 (37.7988992854406, -122.429277851819) 13 9 1 57 17
180939 136175 1 123 3103 Pierce St 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6001391.85411 2119087.81282 37.7986888314695 -122.439280672761 (37.7986888314695, -122.439280672761) 13 9 1 57 17