trees

Custom SQL query returning 23 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
6293 97158 5 91 1079 Le Conte Ave 5 Sidewalk: Curb side : Cutout Tree 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012744.23117 2089823.98249 37.7189762599209 -122.397943616401 (37.7189762599209, -122.397943616401) 10 3 8 58 1
6990 97154 5 91 1079 Le Conte Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/25/2011 12:00:00 AM 4   Permit Number 768080 6012676.26956 2089874.1029 37.7191100952408 -122.398182049174 (37.7191100952408, -122.398182049174) 10 3 8 58 1
12625 97159 5 91 1079 Le Conte Ave 6 Sidewalk: Curb side : Cutout Tree 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012757.60574 2089814.3813 37.7189506418481 -122.397896712286 (37.7189506418481, -122.397896712286) 10 3 8 58 1
12626 97156 5 91 1079 Le Conte Ave 3 Sidewalk: Curb side : Cutout Tree 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012721.62132 2089840.20593 37.7190195469812 -122.398022907844 (37.7190195469812, -122.398022907844) 10 3 8 58 1
18330 97157 5 91 1079 Le Conte Ave 4 Sidewalk: Curb side : Cutout Tree 2   08/25/2011 12:00:00 AM 2   Permit Number 768080 6012734.70575 2089832.2191 37.7189983454895 -122.397977119771 (37.7189983454895, -122.397977119771) 10 3 8 58 1
18353 97155 5 91 1079 Le Conte Ave 2 Sidewalk: Curb side : Cutout Tree 2   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012703.24235 2089857.95173 37.7190672497343 -122.398087681509 (37.7190672497343, -122.398087681509) 10 3 8 58 1
2103 262299 5 6 209 Prentiss St 1 Sidewalk: Curb side : Cutout Tree 2   06/29/2020 12:00:00 AM 3 3x3 Permit Number 773443 6008837.63968 2097618.9316 37.7401611793174 -122.411997789374 (37.7401611793174, -122.411997789374) 10 7 7 28859 2
2107 113082 5 215 414 Somerset St 1 Sidewalk: Curb side : Cutout Tree 2   09/08/2015 12:00:00 AM 3 3x3   6010030.65327 2092539.3572 37.7262806120542 -122.407514778095 (37.7262806120542, -122.407514778095) 10 3 7 309 28
5719 108450 5 140 696 Pennsylvania Ave 2 Sidewalk: Curb side : Cutout Tree 2     6 3x3   6014379.30863 2103997.39375 37.7579844490278 -122.393283028308 (37.7579844490278, -122.393283028308) 10 3 8 28856 29
7842 108451 5 140 696 Pennsylvania Ave 3 Sidewalk: Curb side : Cutout Tree 2     7 3x3   6014380.97285 2103975.72487 37.7579250434155 -122.393275756387 (37.7579250434155, -122.393275756387) 10 3 8 28856 29
8512 117149 5 8 928 Toland St 4 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011929.15518 2097982.19203 37.7413315821976 -122.401334038935 (37.7413315821976, -122.401334038935) 10 3 8 58 1
8525 117146 5 8 928 Toland St 1 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011982.52405 2098055.99364 37.741537203178 -122.401154691646 (37.741537203178, -122.401154691646) 10 3 8 58 1
8951 108447 5 140 696 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree 2     12 3x3   6014378.0974 2104018.35584 37.7580419391129 -122.393288684138 (37.7580419391129, -122.393288684138) 10 3 8 28856 29
10248 108452 5 140 696 Pennsylvania Ave 4 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6014381.40925 2103952.18314 37.757860427147 -122.393272599772 (37.757860427147, -122.393272599772) 10 3 8 28856 29
10674 117147 5 8 928 Toland St 2 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011972.25416 2098042.58697 37.7414998183769 -122.40118925978 (37.7414998183769, -122.40118925978) 10 3 8 58 1
14750 108453 5 140 696 Pennsylvania Ave 5 Sidewalk: Curb side : Cutout Tree 2     11 3x3   6014383.1993 2103935.66602 37.7578151741454 -122.393265253191 (37.7578151741454, -122.393265253191) 10 3 8 28856 29
15368 262300 5 6 209 Prentiss St 2 Sidewalk: Curb side : Cutout Tree 2   06/29/2020 12:00:00 AM 3 3x3 Permit Number 773443 6008837.63968 2097618.9316 37.7401611793174 -122.411997789374 (37.7401611793174, -122.411997789374) 10 7 7 28859 2
18014 117148 5 8 928 Toland St 3 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011961.8463 2098027.63913 37.7414581941431 -122.401224196662 (37.7414581941431, -122.401224196662) 10 3 8 58 1
18648 108454 5 276 696 Pennsylvania Ave 6 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6014383.50929 2103916.35065 37.757762155526 -122.393262829511 (37.757762155526, -122.393262829511) 10 3 8 28856 29
194328 258403 5 8 1052 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree 2   05/10/2019 12:00:00 AM 3 3x5   6011869 2103486 37.7564404909426 -122.401928842587 (37.7564404909426, -122.401928842587) 10 3 8 28856 29
4387 264910 5 19 1615 Wallace Ave 1 Front Yard : Cutout Tree 2   11/04/2020 12:00:00 AM 3 4x4 Permit Number 775989 6014687.7877 2092924.6213 37.7275980500808 -122.391442091837 (37.7275980500808, -122.391442091837) 10 3 8 58 1
6880 24222 5 78 54 Whitney Young Cir 1 Sidewalk: Curb side : Cutout Tree 2   05/07/2010 12:00:00 AM 3 4x4 this is original dpw basin record. 6017205.2608 2094992.48681 37.7334154068844 -122.382882921904 (37.7334154068844, -122.382882921904) 10 3 8 58 1
33 261067 5 19 1832 Egbert Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/13/2020 12:00:00 AM 3 4x6 Permit Number 782484 6011934 2092960 37.727541965346 -122.400964507068 (37.727541965346, -122.400964507068) 10 3 8 58 1