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)
92382 47550 7 47 1681 Noe St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45414 6003392.60348895 2098449.5926945 37.7421349817765 -122.430883775787 (37.7421349817765, -122.430883775787) 2 7 5 63 22
40263 227676 1 47 427 Valley St 1 Sidewalk: Curb side : Yard Tree 2     10     6003106.32375 2099187.31259 37.7441443647786 -122.431926305762 (37.7441443647786, -122.431926305762) 2 7 5 63 22
176307 227678 1 47 300 Valley St 2 Sidewalk: Curb side : Cutout Tree 2     4 Width 2ft   6003889.89165 2099268.52237 37.7444117377113 -122.429222690078 (37.7444117377113, -122.429222690078) 2 7 5 63 22
123108 227677 1 47 300 Valley St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 2ft   6003907.02908 2099270.15617 37.7444171939021 -122.429163548878 (37.7444171939021, -122.429163548878) 2 7 5 63 22
22890 50289 7 47 300 Valley St 6 Sidewalk: Curb side : Cutout Tree 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
84280 50293 7 47 300 Valley St 4 Sidewalk: Curb side : Cutout Tree 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
89527 50288 7 47 300 Valley St 5 Sidewalk: Curb side : Cutout Tree 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
112832 50290 7 47 300 Valley St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 08/28/2003 12:00:00 AM   3x3 Permit Number 47005 6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
113972 50292 7 47 300 Valley St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/28/2003 12:00:00 AM   3x3 Permit Number 47005 6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
193338 50291 7 47 300 Valley St 3 Sidewalk: Curb side : Cutout Tree 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
56832 227680 1 47 1541 Sanchez St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 2ft   6003988.60954 2099295.31119 37.7444908816604 -122.428883253577 (37.7444908816604, -122.428883253577) 2 7 5 63 22
192707 49012 7 47 361 28th St 1 Sidewalk: Curb side : Cutout Tree 2   12/31/2002 12:00:00 AM     Permit Number 46198 6003561.60300767 2099494.42119752 37.7450134133041 -122.430373957908 (37.7450134133041, -122.430373957908) 2 7 5 63 22
134621 227679 1 47 361 28th St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 2ft   6003556.92712 2099495.03666 37.7450148383554 -122.430390170187 (37.7450148383554, -122.430390170187) 2 7 5 63 22
137505 34621 7 47 370 28th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/05/2016 12:00:00 AM 3   Permit Number 778228 6003497.10528776 2099542.95496323 37.7451430220882 -122.430600441889 (37.7451430220882, -122.430600441889) 2 7 5 63 22
142493 227693 1 47 337 Clipper St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   6002979.94012 2100929.17253 37.7489199393117 -122.432487701248 (37.7489199393117, -122.432487701248) 2 4 5 28862 22