trees
614 rows where qSpecies_id = 29 sorted by Zip Codes
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▼ | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2794 | 254529 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 421 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769845 | ||||||||||
4016 | 52794 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
5667 | 52792 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
11431 | 35742 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 39016 | ||||||||||||||
13707 | 35743 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 39016 | ||||||||||||||
13860 | 52793 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
22588 | 44207 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 701 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2000 12:00:00 AM | Permit Number 43655 | 6009221.06713893 | 2115299.96241651 | 37.7887307349007 | -122.411921176175 | (37.7887307349007, -122.411921176175) | 5 | 1 | 10 | 28852 | 21 | ||
70554 | 240383 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004954.4402 | 2108809.15318 | 37.7706682749432 | -122.426220805247 | (37.7706682749432, -122.426220805247) | 7 | 9 | 5 | 28852 | 10 | |||
81719 | 8100 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 765 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/1998 12:00:00 AM | 6 | 3X3 | 6004193.95704 | 2111472.64562 | 37.7779385589247 | -122.429041260431 | (37.7779385589247, -122.429041260431) | 7 | 9 | 11 | 28852 | 10 | ||
100804 | 8103 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 775 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/1998 12:00:00 AM | 8 | 3X3 | 6004110.63243 | 2111457.69852 | 37.7778928009026 | -122.429328443516 | (37.7778928009026, -122.429328443516) | 7 | 9 | 11 | 28852 | 10 | ||
157935 | 240384 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779910 | 6004983.76918 | 2108813.08838 | 37.7706807377627 | -122.426119636009 | (37.7706807377627, -122.426119636009) | 7 | 9 | 5 | 28852 | 10 | |
187305 | 42777 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47615 | 6004966.00219495 | 2108807.30598956 | 37.7706638565131 | -122.426180680587 | (37.7706638565131, -122.426180680587) | 7 | 9 | 5 | 28852 | 10 | ||
7825 | 197345 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008901.33871 | 2110395.02653 | 37.7752450102959 | -122.412680506426 | (37.7752450102959, -122.412680506426) | 8 | 2 | 9 | 28853 | 34 | |||
14362 | 197348 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009001.8467 | 2110254.60923 | 37.7748650979682 | -122.412322898178 | (37.7748650979682, -122.412322898178) | 8 | 2 | 9 | 28853 | 34 | |||
21604 | 48459 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 2 | Permit Number 45824 | 6011943.63031 | 2110470.08202 | 37.7756213756527 | -122.40216174349 | (37.7756213756527, -122.40216174349) | 14 | 2 | 9 | 28853 | 34 | ||
45022 | 240381 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 98 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008070.80857 | 2107998.41684 | 37.7686178359612 | -122.415383805538 | (37.7686178359612, -122.415383805538) | 8 | 4 | 7 | 28853 | 19 | |||
46975 | 82884 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 398 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52426 | 6008893.02169344 | 2108709.50255899 | 37.7706164898271 | -122.412590100264 | (37.7706164898271, -122.412590100264) | 8 | 2 | 9 | 28853 | 19 | ||
49609 | 48458 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 3 | Permit Number 45824 | 6011932.18219 | 2110480.19141 | 37.7756484947135 | -122.402202056493 | (37.7756484947135, -122.402202056493) | 14 | 2 | 9 | 28853 | 34 | ||
72275 | 48457 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 6 | Permit Number 45824 | 6011919.3472 | 2110495.26684 | 37.7756891719521 | -122.402247516312 | (37.7756891719521, -122.402247516312) | 14 | 2 | 9 | 28853 | 34 | ||
75249 | 240426 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 60 Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006672.38997 | 2109529.27096 | 37.7727425000967 | -122.420329500315 | (37.7727425000967, -122.420329500315) | 8 | 2 | 9 | 28853 | 19 | |||
80217 | 42941 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 90 14TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | 10 | Permit Number 42835 | 6008035 | 2107992 | 37.768598204142 | -122.415507210488 | (37.768598204142, -122.415507210488) | 8 | 4 | 7 | 28853 | 19 | ||
80398 | 82767 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 398 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52426 | 6008893.02169344 | 2108709.50255899 | 37.7706164898271 | -122.412590100264 | (37.7706164898271, -122.412590100264) | 8 | 2 | 9 | 28853 | 19 | ||
87519 | 112589 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 TEHAMA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009004 | 2110266 | 37.7748964951756 | -122.41231625471 | (37.7748964951756, -122.41231625471) | 8 | 2 | 9 | 28853 | 34 | |||||
94034 | 240379 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 87 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008087.13667 | 2107952.681 | 37.7684931737476 | -122.41532408966 | (37.7684931737476, -122.41532408966) | 8 | 4 | 7 | 28853 | 19 | |||
97314 | 197347 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1245 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009016.84079 | 2110503.78617 | 37.7755501205886 | -122.41228864573 | (37.7755501205886, -122.41228864573) | 8 | 2 | 9 | 28853 | 34 | |||
103746 | 240377 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 87 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008059.81094 | 2107952.18864 | 37.768490286015 | -122.415418572409 | (37.768490286015, -122.415418572409) | 8 | 4 | 7 | 28853 | 19 | |||
104787 | 41729 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 99X 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | 8 | 4 | 7 | 28853 | 19 | ||
106241 | 42939 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 90 14TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42835 | 6008035 | 2107992 | 37.768598204142 | -122.415507210488 | (37.768598204142, -122.415507210488) | 8 | 4 | 7 | 28853 | 19 | |||
110728 | 197350 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 719 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009290.40599 | 2110497.98819 | 37.7755495477154 | -122.411341904202 | (37.7755495477154, -122.411341904202) | 8 | 2 | 9 | 28853 | 34 | |||
112150 | 40175 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1779 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1999 12:00:00 AM | Permit Number 41366 | 6008032.61088554 | 2108096.47604813 | 37.7688849366199 | -122.415522872015 | (37.7688849366199, -122.415522872015) | 8 | 4 | 7 | 28853 | 19 | ||
119382 | 112588 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 TEHAMA ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009004 | 2110266 | 37.7748964951756 | -122.41231625471 | (37.7748964951756, -122.41231625471) | 8 | 2 | 9 | 28853 | 34 | |||||
132392 | 30659 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 54 Lafayette St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 34592 | 6007591.74325 | 2109572.72569 | 37.7729135790239 | -122.41715242667 | (37.7729135790239, -122.41715242667) | 8 | 2 | 9 | 28853 | 19 |
141338 | 240378 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 87 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008072.76469 | 2107952.79864 | 37.768492689 | -122.415373809569 | (37.768492689, -122.415373809569) | 8 | 4 | 7 | 28853 | 19 | |||
148211 | 240375 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 99 Ramona Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005227.26292 | 2107315.18034 | 37.7665816008793 | -122.425170785627 | (37.7665816008793, -122.425170785627) | 8 | 4 | 5 | 28853 | 19 | |||
149660 | 39381 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1367 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2001 12:00:00 AM | Permit Number 43822 | 6007199.57850018 | 2107537.80288531 | 37.7673040926749 | -122.418364663242 | (37.7673040926749, -122.418364663242) | 8 | 4 | 7 | 28853 | 19 | ||
157180 | 41736 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1675 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42175 | 6007516.69169836 | 2108778.794217 | 37.7707294087229 | -122.417355765748 | (37.7707294087229, -122.417355765748) | 8 | 2 | 9 | 28853 | 19 | ||
157735 | 197346 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1245 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008998.58265 | 2110487.32292 | 37.7755038918289 | -122.412350641372 | (37.7755038918289, -122.412350641372) | 8 | 2 | 9 | 28853 | 34 | |||
158119 | 240374 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 99 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005228.2825 | 2107285.15785 | 37.7664992238917 | -122.425165122599 | (37.7664992238917, -122.425165122599) | 8 | 4 | 5 | 28853 | 19 | |||
163835 | 41727 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1803 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | 8 | 4 | 7 | 28853 | 19 | ||
165949 | 48456 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 7 | Permit Number 45824 | 6011955.48397 | 2110455.52014 | 37.7755820536976 | -122.402119714552 | (37.7755820536976, -122.402119714552) | 14 | 2 | 9 | 28853 | 34 | ||
166802 | 240380 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 87 14th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008113.4152 | 2107953.3802 | 37.7684965704858 | -122.415233243732 | (37.7684965704858, -122.415233243732) | 8 | 4 | 7 | 28853 | 19 | |||
177127 | 240392 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1803 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008038.16649 | 2107910.13922 | 37.7683736115782 | -122.415490461517 | (37.7683736115782, -122.415490461517) | 8 | 4 | 7 | 28853 | 19 | |||
178499 | 197349 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008993.79561 | 2110246.5783 | 37.7748425951336 | -122.412350180929 | (37.7748425951336, -122.412350180929) | 8 | 2 | 9 | 28853 | 34 | |||
181210 | 41725 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 99X 14th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | 8 | 4 | 7 | 28853 | 19 | ||
185234 | 41728 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 99X 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | 8 | 4 | 7 | 28853 | 19 | ||
191449 | 240376 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1367 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007185.77161 | 2107529.73267 | 37.7672811565308 | -122.418411847135 | (37.7672811565308, -122.418411847135) | 8 | 4 | 7 | 28853 | 19 | |||
191578 | 41726 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 99X 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | 8 | 4 | 7 | 28853 | 19 | ||
194297 | 252847 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1500 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 3x3 | 6008908 | 2108725 | 37.7706598827985 | -122.412539385599 | (37.7706598827985, -122.412539385599) | 8 | 2 | 9 | 28853 | 19 | ||
194319 | 252846 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1500 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 3x3 | 6008908 | 2108725 | 37.7706598827985 | -122.412539385599 | (37.7706598827985, -122.412539385599) | 8 | 2 | 9 | 28853 | 19 | ||
13087 | 103083 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012579.2635 | 2114003.58062 | 37.785359006363 | -122.400211142746 | (37.785359006363, -122.400211142746) | 12 | 2 | 9 | 28855 | 6 | |||
27362 | 197344 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012519.57167 | 2113947.09446 | 37.7852005799736 | -122.400413690752 | (37.7852005799736, -122.400413690752) | 12 | 2 | 9 | 28855 | 6 | |||
58885 | 197342 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012547.87891 | 2113973.86639 | 37.785275667977 | -122.400317636871 | (37.785275667977, -122.400317636871) | 12 | 2 | 9 | 28855 | 6 | |||
132076 | 197343 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012532.19574 | 2113959.45979 | 37.7852352362655 | -122.400370883928 | (37.7852352362655, -122.400370883928) | 12 | 2 | 9 | 28855 | 6 | |||
5097 | 37962 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52636 | 6013967.39431 | 2106347.66255 | 37.7644148813545 | -122.394872214003 | (37.7644148813545, -122.394872214003) | 14 | 3 | 8 | 28856 | 29 | |
12760 | 32019 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 900 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | Permit Number 35412 | 6012513.40810989 | 2108571.960758 | 37.7704413522571 | -122.400057399946 | (37.7704413522571, -122.400057399946) | 14 | 2 | 8 | 28856 | 20 | |||
27524 | 37977 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
33110 | 197353 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 22nd St | 13 | Side Yard : Yard | Tree | Private 2 | 4 | 6012786.799 | 2103803.61301 | 37.7573637666391 | -122.398777038841 | (37.7573637666391, -122.398777038841) | 10 | 3 | 8 | 28856 | 29 | ||||
40275 | 95802 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1512 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767546 | 6014097.5 | 2102025.1 | 37.7525532940671 | -122.394119575027 | (37.7525532940671, -122.394119575027) | 10 | 3 | 8 | 28856 | 29 | |
79828 | 37976 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
95948 | 197335 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1512 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014078.36763 | 2102008.61135 | 37.7525069563416 | -122.394184584264 | (37.7525069563416, -122.394184584264) | 10 | 3 | 8 | 28856 | 29 | |||
98374 | 101956 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 510X Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6x6 | 6012441.7 | 2108540.8 | 37.7703517934984 | -122.400303251175 | (37.7703517934984, -122.400303251175) | 14 | 2 | 8 | 28856 | 20 | |||
103820 | 37979 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
113452 | 197332 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1501 25th St | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6014163.86905 | 2101969.79141 | 37.7524051171259 | -122.393886186499 | (37.7524051171259, -122.393886186499) | 10 | 3 | 8 | 28856 | 1 | ||||
129710 | 37980 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
131587 | 106045 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2201X 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2014 12:00:00 AM | 14 | 4x14 | Permit Number 772230 | 6011471.49227 | 2104620.16703 | 37.7595324691706 | -122.403383358282 | (37.7595324691706, -122.403383358282) | 10 | 3 | 8 | 28856 | 29 | |
131937 | 197336 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 651 Missouri St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6013643.57223 | 2103811.49396 | 37.757433106182 | -122.395814509232 | (37.757433106182, -122.395814509232) | 10 | 3 | 8 | 28856 | 29 | ||||
147911 | 197331 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1501 25th St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6014124.12337 | 2101967.77095 | 37.752397360459 | -122.394023493212 | (37.752397360459, -122.394023493212) | 10 | 3 | 8 | 28856 | 1 | ||||
164027 | 35432 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1506 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | 7 | Permit Number 38878 | 6014141.49848 | 2102013.02263 | 37.7525225775725 | -122.393966574215 | (37.7525225775725, -122.393966574215) | 10 | 3 | 8 | 28856 | 29 | |
176192 | 197334 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1098 Mississippi St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 5ft | 6014199.99182 | 2102083.09836 | 37.7527182412529 | -122.393769197285 | (37.7527182412529, -122.393769197285) | 10 | 3 | 8 | 28856 | 29 | |||
178307 | 37981 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
182459 | 37978 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
187632 | 197333 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1501 25th St | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6014202.14844 | 2101967.42619 | 37.7524007500093 | -122.393753643523 | (37.7524007500093, -122.393753643523) | 10 | 3 | 8 | 28856 | 1 | ||||
9509 | 136313 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008832.97743 | 2116650.20878 | 37.7924164019518 | -122.413359441492 | (37.7924164019518, -122.413359441492) | 5 | 1 | 10 | 28857 | 21 | |||
13641 | 136307 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008614.23308 | 2116420.22843 | 37.7917726483359 | -122.41410002782 | (37.7917726483359, -122.41410002782) | 5 | 1 | 10 | 28857 | 21 | |||
38756 | 41743 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
58873 | 41744 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
59349 | 136311 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008756.30767 | 2116638.98455 | 37.7923812780273 | -122.413623927626 | (37.7923812780273, -122.413623927626) | 5 | 1 | 10 | 28857 | 21 | |||
68647 | 41746 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
70236 | 136304 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008621.36418 | 2116364.4323 | 37.791619846337 | -122.414071405095 | (37.791619846337, -122.414071405095) | 5 | 1 | 10 | 28857 | 21 | |||
78187 | 136309 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008608.17525 | 2116456.59832 | 37.7918721709048 | -122.41412356217 | (37.7918721709048, -122.41412356217) | 5 | 1 | 10 | 28857 | 21 | |||
89184 | 136306 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008615.34001 | 2116402.44898 | 37.7917238924876 | -122.414094939449 | (37.7917238924876, -122.414094939449) | 5 | 1 | 10 | 28857 | 21 | |||
91621 | 136312 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008787.57627 | 2116642.7504 | 37.7923933739042 | -122.413516003555 | (37.7923933739042, -122.413516003555) | 5 | 1 | 10 | 28857 | 21 | |||
91849 | 136305 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008618.49447 | 2116385.90895 | 37.7916786547855 | -122.414082854345 | (37.7916786547855, -122.414082854345) | 5 | 1 | 10 | 28857 | 21 | |||
96947 | 106210 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 585X Bush St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774310 | 6010773.37918 | 2115862.19303 | 37.7903614528559 | -122.406590009715 | (37.7903614528559, -122.406590009715) | 5 | 1 | 10 | 28857 | 6 | |
100225 | 41749 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
124867 | 41751 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
127392 | 136303 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008623.1195 | 2116351.39928 | 37.7915841594399 | -122.414064409258 | (37.7915841594399, -122.414064409258) | 5 | 1 | 10 | 28857 | 21 | |||
134101 | 41747 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
138587 | 41752 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
145308 | 41748 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
147857 | 41750 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
168528 | 136308 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008610.17492 | 2116437.51898 | 37.7918198960214 | -122.414115292883 | (37.7918198960214, -122.414115292883) | 5 | 1 | 10 | 28857 | 21 | |||
173586 | 136310 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008741.78085 | 2116636.60472 | 37.7923739278622 | -122.413674022565 | (37.7923739278622, -122.413674022565) | 5 | 1 | 10 | 28857 | 21 | |||
189923 | 41745 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
20270 | 41769 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
26389 | 87804 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1953 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50568 | 6004841 | 2117073 | 37.7933523405685 | -122.427201927622 | (37.7933523405685, -122.427201927622) | 13 | 9 | 1 | 28858 | 27 | ||
42698 | 41761 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
51701 | 98673 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
52593 | 98672 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
55018 | 41767 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );