trees

Custom SQL query returning 16 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
20460 100528 1 86 1728 Jones St 2 Sidewalk: Curb side : Cutout Tree 2     5 4.5x6   6008351.1313 2118382.01094 37.7971444383282 -122.415149288427 (37.7971444383282, -122.415149288427) 5 1 10 308 21
49688 136713 1 86 290 Green St 2 Sidewalk: Property side : Yard Tree 2     7 Width 3ft   6011569.99478 2119432.50864 37.8002092172264 -122.404085130728 (37.8002092172264, -122.404085130728) 3 1 10 308 23
59813 136702 1 86 1728 Jones St 5 Sidewalk: Property side : Yard Tree 2     5 Width 2ft   6008349.70738 2118393.07464 37.7971747364841 -122.415154999108 (37.7971747364841, -122.415154999108) 5 1 10 308 21
65762 136699 1 86 1955 Jones St 1 Sidewalk: Property side : Yard Tree 2     10 Width 2ft   6008168.57169 2119227.42502 37.7994554738439 -122.415840886849 (37.7994554738439, -122.415840886849) 5 1 10 308 32
83289 64384 1 86 290 Green St 1 Sidewalk: Curb side : Cutout Tree 2   03/11/2010 12:00:00 AM 6 3x3 Permit Number 53175 6011583.39503 2119434.85196 37.8002164001168 -122.404038925378 (37.8002164001168, -122.404038925378) 3 1 10 308 23
84545 136709 1 86 801 Chestnut St 3 Sidewalk: Property side : Yard Tree 2     8 Width 3ft   6007914.92474 2120604.50253 37.8032223202271 -122.416816212417 (37.8032223202271, -122.416816212417) 5 1 1 308 32
90245 136682 1 86 874 Green St 1 Sidewalk: Property side : Yard Tree 2     7 Width 3ft   6008846.30156 2119059.10202 37.7990313778645 -122.413483781748 (37.7990313778645, -122.413483781748) 3 1 10 308 32
100575 136700 1 86 1955 Jones St 3 Sidewalk: Property side : Yard Tree 2     10 Width 2ft   6008170.72961 2119215.54579 37.7994229777558 -122.415832578026 (37.7994229777558, -122.415832578026) 5 1 10 308 32
115962 136711 1 86 801 Chestnut St 5 Sidewalk: Property side : Yard Tree 2     10 Width 3ft   6007948.87662 2120608.06628 37.8032340150017 -122.416698973183 (37.8032340150017, -122.416698973183) 5 1 1 308 32
140172 136708 1 86 801 Chestnut St 2 Sidewalk: Property side : Yard Tree 2     8 Width 3ft   6007910.30742 2120604.37308 37.803221705081 -122.416832181661 (37.803221705081, -122.416832181661) 5 1 1 308 32
147511 136710 1 86 801 Chestnut St 4 Sidewalk: Property side : Yard Tree 2     9 Width 3ft   6007938.82451 2120606.36693 37.8032287836485 -122.41673363846 (37.8032287836485, -122.41673363846) 5 1 1 308 32
152644 136704 1 86 1728 Jones St 7 Sidewalk: Property side : Yard Tree 2     6 Width 2ft   6008348.41822 2118399.20524 37.7971914971435 -122.415159894117 (37.7971914971435, -122.415159894117) 5 1 10 308 21
173768 136712 1 86 84 MacOndray Ln 1 Sidewalk: Property side : Yard Tree 2     14     6008291.17542 2119130.0368 37.7991949618221 -122.415409734769 (37.7991949618221, -122.415409734769) 5 1 10 308 32
183336 136701 1 86 1728 Jones St 4 Sidewalk: Property side : Yard Tree 2     5 Width 2ft   6008350.35689 2118390.24391 37.7971670005024 -122.415152551158 (37.7971670005024, -122.415152551158) 5 1 10 308 21
186499 136703 1 86 1728 Jones St 6 Sidewalk: Property side : Yard Tree 2     4 Width 2ft   6008348.84171 2118396.84882 37.7971850507978 -122.415158261846 (37.7971850507978, -122.415158261846) 5 1 10 308 21
190798 136683 1 86 874 Green St 2 Sidewalk: Property side : Yard Tree 2     5 Width 3ft   6008833.05028 2119058.08121 37.7990278309217 -122.413529563544 (37.7990278309217, -122.413529563544) 3 1 10 308 32