614 rows where qSpecies_id = 29 sorted by Zip Codes

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);