trees

Custom SQL query returning 40 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
18444 259521 9 45 190 Parker Ave 4 Sidewalk: Curb side : Cutout Tree 2   07/23/2019 12:00:00 AM 3     5996965.93026 2113053.17261 37.7818664738231 -122.454159603161 (37.7818664738231, -122.454159603161) 11 6 1 54 31
18936 260399 9 1 190 Parker Ave 3 Sidewalk: Curb side : Cutout Tree 2   08/21/2019 12:00:00 AM 3     5996965.93026 2113053.17261 37.7818664738231 -122.454159603161 (37.7818664738231, -122.454159603161) 11 6 1 54 31
19591 264707 9 67 4345 Clement St 3 Sidewalk: Property side : Cutout Tree 2   09/17/2020 12:00:00 AM 3     5982064.28374 2113052.50483 37.7809988756405 -122.505711450059 (37.7809988756405, -122.505711450059) 11 6 2 55 26
20327 109501 9 74 1400X on Filbert Montgomery St 1 Unaccepted Street : Yard Tree 2         see 279 Filbert St. Same tree; shared responsibility 6011485.9 2120124.8 37.8021053817179 -122.404424889694 (37.8021053817179, -122.404424889694) 3 1 10 308 23
33729 109829 9 149 629 TAYLOR ST 1 Sidewalk: Curb side : Cutout Tree 2   12/01/2015 12:00:00 AM     Permit Number 775362 6009246.3 2115118.4 37.7882336239769 -122.41182103906 (37.7882336239769, -122.41182103906) 5 1 10 28852 21
33896 104968 9 330 495 COLLINGWOOD ST 1 Front Yard : Yard Tree 2     15   Permit Number 770776 6002186.6 2103026 37.7546323087418 -122.435381040855 (37.7546323087418, -122.435381040855) 2 4 5 28862 22
44862 114642 9 102 30 MacEdonia St 1 Sidewalk: Curb side : Cutout Tree 2   11/30/2015 12:00:00 AM     Permit Number 773527 6010319.9 2099707.2 37.745978163197 -122.407019863158 (37.745978163197, -122.407019863158) 2 7 7 28859 2
53506 108816 9 15 348 Gold Mine Dr 1 Back Yard : Yard Tree 2     30     6001084 2097744 37.740066514789 -122.438815634293 (37.740066514789, -122.438815634293) 2 7 5 63 7
60173 80520 9 281 2499X Mendell St 1 Sidewalk: Curb side : Cutout Tree 2   09/07/2002 12:00:00 AM 2     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
64184 80593 9 327 1780 Bancroft Ave 5 Sidewalk: Curb side : Cutout Tree 2   09/07/2002 12:00:00 AM 7     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
69100 104567 9 17 8 JOY ST 2 Front Yard : Yard Tree 2     40     6010448 2098932 37.7438568002142 -122.406522292508 (37.7438568002142, -122.406522292508) 2 7 7 28859 2
70534 104510 9 155 254 ALLISON ST 1 Back Yard : Yard Tree 2     40     6000052 2087408 37.7116274717654 -122.441642291463 (37.7116274717654, -122.441642291463) 9 7 6 28861 5
74288 105439 9 17 790 LAKEVIEW AVE 1 Front Yard : Yard Tree 2           5994224.8 2089960.8 37.7183031233486 -122.461967505828 (37.7183031233486, -122.461967505828) 9 8 6 28861 24
80106 114666 9 51 382 Richland Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/30/2015 12:00:00 AM     Permit Number 774512 6007233.6 2095963.6 37.7355258779344 -122.417426639907 (37.7355258779344, -122.417426639907) 2 7 7 28859 2
85850 114258 9 15 70x CHUMASERO DR 1 Front Yard : Yard Tree 2     40     5990913 2088468 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941) 1 8 4 64 14
86075 100243 9 17 1326-1332 Shotwell St   unknown : Yard Tree 2           6008043 2100485 37.7479861507453 -122.414948142067 (37.7479861507453, -122.414948142067) 2 7 7 28859 2
88394 39627 9 27 199X Carmel St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/29/1998 12:00:00 AM 6   Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.450318782133 (37.7607233191374, -122.450318782133) 15 5 11 29492 12
92274 80514 9 281 1769X Armstrong Ave 9 Sidewalk: Curb side : Cutout Tree 2   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
96093 39626 9 27 1550 Shrader St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/29/1998 12:00:00 AM     Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.450318782133 (37.7607233191374, -122.450318782133) 15 5 11 29492 12
100633 104881 9 212 101 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree 2         missing? 5990474.7 2090014.4 37.7182336817112 -122.474933796522 (37.7182336817112, -122.474933796522) 1 8 4 64 14
102300 113801 9 31 806 SHOTWELL ST 3 Front Yard : Yard Tree 2           6007931 2103220 37.755489548438 -122.415529041662 (37.755489548438, -122.415529041662) 2 4 7 28859 19
108336 80517 9 281 1769X Armstrong Ave 5 Sidewalk: Curb side : Cutout Tree 2   09/07/2002 12:00:00 AM 3     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
108521 110587 9 201 151 EDGEWOOD AVE 1 Front Yard : Yard Tree 2           5996558 2106132 37.7628393335165 -122.45507056335 (37.7628393335165, -122.45507056335) 15 5 11 29492 12
109240 115128 9 25 499X MAIN ST 6 Sidewalk: Curb side : Cutout Tree 2     7     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
112528 104689 9 15 657 PALMETTO AVE 1 Back Yard : Yard Tree 2     30     5991786 2087190.1 37.7105547448876 -122.470195680575 (37.7105547448876, -122.470195680575) 9 8 4 64 24
119017 105441 9 56 425 WAWONA ST   unknown : Yard Tree 2           5991587.6 2097036.5 37.7375790508831 -122.471598439568 (37.7375790508831, -122.471598439568) 1 8 4 29491 40
119423 114977 9 36 183 Lee Ave 1 Sidewalk: Curb side : Cutout Tree 2   12/28/2015 12:00:00 AM     Permit Number 774982 5996484.3 2091092.2 37.7215395068839 -122.454239087603 (37.7215395068839, -122.454239087603) 9 8 6 28861 24
126097 39629 9 27 199X Carmel St 3 Sidewalk: Curb side : Cutout Tree 2 FUF 12/29/1998 12:00:00 AM 6   Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.450318782133 (37.7607233191374, -122.450318782133) 15 5 11 29492 12
128761 115129 9 25 499X MAIN ST 7 Sidewalk: Curb side : Cutout Tree 2     6     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
133648 80515 9 281 1769X Armstrong Ave 8 Sidewalk: Curb side : Cutout Tree 2   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
141416 118356 9 41 100 RACCOON DR 2 Back Yard : Cutout Tree 2     48     5998776 2103987 37.7570766935068 -122.447244922317 (37.7570766935068, -122.447244922317) 15 5 5 63 3
141800 80510 9 327 1740 Bancroft Ave 5 Sidewalk: Curb side : Cutout Tree 2   08/20/2007 12:00:00 AM 9   Permit Number 49651 6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
143868 80518 9 281 1769X Armstrong Ave 4 Sidewalk: Curb side : Cutout Tree 2   09/07/2002 12:00:00 AM 5     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
160381 256862 9 200 133 Majestic Ave 1 Back Yard : Yard Tree 2           5997017.00624 2089223.65081 37.7164394409514 -122.452262915882 (37.7164394409514, -122.452262915882) 9 8 6 28861 24
160937 102060 9 41 115 Kensington Way 1 Back Yard : Yard Tree 2           5994908.3 2098325.8 37.7413107073974 -122.460210667073 (37.7413107073974, -122.460210667073) 1 8 4 59 40
164704 80516 9 281 1769X Armstrong Ave 7 Sidewalk: Curb side : Cutout Tree 2   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
165045 114647 9 8 331 Prentiss St 1 Sidewalk: Curb side : Cutout Tree 2   11/30/2015 12:00:00 AM     Permit Number 774946 6008851.6 2097283.6 37.7392412152063 -122.41192582952 (37.7392412152063, -122.41192582952) 10 7 7 28859 2
166399 39628 9 27 199X Carmel St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 12/29/1998 12:00:00 AM 5   Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.450318782133 (37.7607233191374, -122.450318782133) 15 5 11 29492 12
167961 104436 9 28 2 SAN FERNANDO WAY 1 Front Yard : Yard Tree 2     13     5992040 2096369 37.7357724272627 -122.469985704629 (37.7357724272627, -122.469985704629) 1 8 4 59 40
169586 80512 9 327 1740 Bancroft Ave 3 Sidewalk: Curb side : Cutout Tree 2   09/07/2002 12:00:00 AM 9     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1