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)
4820 253072 2 36 1350 46th Ave 1 Sidewalk: Property side : Yard Tree 2   12/18/2019 12:00:00 AM 3 6x10 Permit Number 780489 5981849.66657 2105897.22193 37.7613399178539 -122.50592325662 (37.7613399178539, -122.50592325662) 1 8 3 56 35
18618 170106 2 13 527 Mangels Ave 1 Sidewalk: Property side : Yard Tree 2   08/18/2020 12:00:00 AM 3 6x10 Permit Number 783167 5997920.28587 2095246.22061 37.7330277118397 -122.449574473879 (37.7330277118397, -122.449574473879) 9 7 4 59 40
20157 121528 2 12 333 Beale St 4 Sidewalk: Curb side : Cutout Tree 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
25972 121523 2 12 280 Beale St 2 Sidewalk: Curb side : Cutout Tree 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
40138 121526 2 12 333 Beale St 2 Sidewalk: Curb side : Cutout Tree 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
52894 121531 2 12 333 Beale St 7 Sidewalk: Curb side : Cutout Tree 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
67232 256000 2 1 8 Springfield Dr 1 Sidewalk: Property side : Yard Tree 2   08/21/2018 12:00:00 AM 3 6x10 Permit Number 780036 5986792.13129 2095812.03329 37.733938381975 -122.488088482457 (37.733938381975, -122.488088482457) 1 8 4 64 35
80358 121522 2 12 280 Beale St 1 Sidewalk: Curb side : Cutout Tree 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
100470 121527 2 12 333 Beale St 3 Sidewalk: Curb side : Cutout Tree 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
103030 121533 2 12 333 Beale St 9 Sidewalk: Curb side : Cutout Tree 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
103456 121525 2 12 333 Beale St 1 Sidewalk: Curb side : Cutout Tree 2     5 6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
152599 121532 2 12 333 Beale St 8 Sidewalk: Curb side : Cutout Tree 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
170258 121530 2 12 333 Beale St 6 Sidewalk: Curb side : Cutout Tree 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
184275 121529 2 12 333 Beale St 5 Sidewalk: Curb side : Cutout Tree 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
194150 121524 2 12 280 Beale St 3 Sidewalk: Curb side : Cutout Tree 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6