Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
81864 | 81864 | 28226 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
85028 | 85028 | 18558 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
86395 | 86395 | 18554 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
87635 | 87635 | 28186 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X King St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6 | 6014324.7762427 | 2110655.2584450003 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | |||
89467 | 89467 | 28227 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
92311 | 92311 | 28184 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X King St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6 | 6014324.7762427 | 2110655.2584450003 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | |||
93618 | 93618 | 28237 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
96175 | 96175 | 28191 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X King St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6 | 6014324.7762427 | 2110655.2584450003 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | |||
102777 | 102777 | 28189 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6 | 6014324.7762427 | 2110655.2584450003 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | |||
103796 | 103796 | 28225 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
104151 | 104151 | 28188 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X King St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6 | 6014324.7762427 | 2110655.2584450003 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | |||
107571 | 107571 | 28235 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
107778 | 107778 | 28192 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X King St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6 | 6014324.7762427 | 2110655.2584450003 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | |||
108524 | 108524 | 28230 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
109189 | 109189 | 27850 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015895.51701 | 2112292.73501 | 37.7808457639334 | -122.38861833648701 | (37.7808457639334, -122.388618336487) | ||
111408 | 111408 | 28223 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
111889 | 111889 | 28228 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
115023 | 115023 | 28238 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
116814 | 116814 | 28222 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
117445 | 117445 | 27852 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015817.39201 | 2112182.05801 | 37.780537539741395 | -122.388880882265 | (37.7805375397414, -122.388880882265) | ||
117955 | 117955 | 28218 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
119895 | 119895 | 28234 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
120266 | 120266 | 27849 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015921.55801 | 2112354.58401 | 37.7810170305764 | -122.388532565578 | (37.7810170305764, -122.388532565578) | ||
122472 | 122472 | 28187 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X King St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6 | 6014324.7762427 | 2110655.2584450003 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | |||
124299 | 124299 | 28233 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
124386 | 124386 | 28193 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X King St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6 | 6014324.7762427 | 2110655.2584450003 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | |||
124429 | 124429 | 28219 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
125243 | 125243 | 28183 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X King St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6 | 6014324.7762427 | 2110655.2584450003 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | |||
126124 | 126124 | 25683 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 3X3 | 6015960.62101 | 2112553.15201 | 37.781564418481004 | -122.388411289639 | (37.781564418481, -122.388411289639) | ||
138450 | 138450 | 28224 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
138478 | 138478 | 24290 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 386 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X17 | 6000963.19469 | 2086697.3561200001 | 37.709728074949204 | -122.43844208303699 | (37.7097280749492, -122.438442083037) | |||
139057 | 139057 | 28221 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
139779 | 139779 | 27853 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015772.90401 | 2112134.31501 | 37.780403982219205 | -122.389031454309 | (37.7804039822192, -122.389031454309) | ||
139983 | 139983 | 27851 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015857.5390099995 | 2112236.31101 | 37.7806887314792 | -122.388745782008 | (37.7806887314792, -122.388745782008) | ||
159189 | 159189 | 234375 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 9ft | 6004995.06327 | 2105009.72546 | 37.760238249920604 | -122.425809806971 | (37.7602382499206, -122.425809806971) | |||
187874 | 187874 | 194313 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 7ft | 6015116.8381 | 2116756.98357 | 37.793060384871 | -122.391624402345 | (37.793060384871, -122.391624402345) | |||
130104 | 130104 | 210913 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1800 18th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5990641.4505900005 | 2103071.06132 | 37.754093605056795 | -122.47531013997101 | (37.7540936050568, -122.475310139971) | |||
101242 | 101242 | 27788 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 14 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
140643 | 140643 | 27786 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 14 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
145407 | 145407 | 27787 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 14 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
29021 | 29021 | 234332 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6004849.34041 | 2105800.52772 | 37.7624013694379 | -122.42637009990601 | (37.7624013694379, -122.426370099906) | |||
39479 | 39479 | 234374 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 9ft | 6004996.87402 | 2105008.5457599997 | 37.760235113069896 | -122.425803460464 | (37.7602351130699, -122.425803460464) | |||
58910 | 58910 | 234395 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 217 Ogden Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 6008499.5527 | 2096078.48845 | 37.735912484272205 | -122.413057867339 | (37.7359124842722, -122.413057867339) | |||
151716 | 151716 | 194282 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6016226.55416 | 2100307.94064 | 37.7479564371431 | -122.386637143603 | (37.7479564371431, -122.386637143603) | ||||
171516 | 171516 | 194323 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 7ft | 6014746.37404 | 2117187.8708099998 | 37.7942229303951 | -122.39293639989201 | (37.7942229303951, -122.392936399892) | |||
181931 | 181931 | 247638 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 360 Bradford St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6009465.98098 | 2096572.55437 | 37.7373232876386 | -122.40975139021499 | (37.7373232876386, -122.409751390215) | ||||
724 | 724 | 25734 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013899.49111 | 2118360.1858599996 | 37.7973947538281 | -122.395948920127 | (37.7973947538281, -122.395948920127) | ||
1312 | 1312 | 25735 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013816.07307 | 2118422.78251 | 37.7975619881486 | -122.396241959692 | (37.7975619881486, -122.396241959692) | ||
73625 | 73625 | 178085 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 210 Tocoloma Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012726.322790001 | 2087488.8573099999 | 37.712563474091894 | -122.397841808652 | (37.7125634740919, -122.397841808652) | |||
78576 | 78576 | 25731 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 501X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013387.7643744005 | 2119020.8269614 | 37.799180234142106 | -122.39776600258999 | (37.7991802341421, -122.39776600259) | ||
112637 | 112637 | 25732 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 501X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013387.7643744005 | 2119020.8269614 | 37.799180234142106 | -122.39776600258999 | (37.7991802341421, -122.39776600259) | ||
124202 | 124202 | 25733 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 501X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013387.7643744005 | 2119020.8269614 | 37.799180234142106 | -122.39776600258999 | (37.7991802341421, -122.39776600259) | ||
163255 | 163255 | 132126 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6014272.27117 | 2117547.1339 | 37.7951830367225 | -122.394602030674 | (37.7951830367225, -122.394602030674) | |||
30035 | 30035 | 194392 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 860x Jamestown Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 6014755.052209999 | 2089115.5775900001 | 37.7171429037943 | -122.39094345187799 | (37.7171429037943, -122.390943451878) | |||
47529 | 47529 | 132102 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 10ft | 6012409.883230001 | 2120572.1173400003 | 37.8033851982182 | -122.401258897879 | (37.8033851982182, -122.401258897879) | |||
137882 | 137882 | 132117 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 10ft | 6013132.776319999 | 2119506.7755299998 | 37.800500329583 | -122.398682475136 | (37.800500329583, -122.398682475136) | |||
9337 | 9337 | 113319 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 VALENCIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005986.0 | 2109035.0 | 37.7713466487942 | -122.42266867187 | (37.7713466487942, -122.42266867187) | |||
15304 | 15304 | 19794 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 STAIRWAY19 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
25048 | 25048 | 132103 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 10ft | 6012095.78368 | 2120981.89347 | 37.8044928149639 | -122.402374687645 | (37.8044928149639, -122.402374687645) | |||
32517 | 32517 | 234386 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6004984.24145 | 2103652.12046 | 37.7565099745835 | -122.42575060280899 | (37.7565099745835, -122.425750602809) | |||
41054 | 41054 | 194324 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 7ft | 6014719.872819999 | 2117222.0655900002 | 37.7943153492131 | -122.39303049145701 | (37.7943153492131, -122.393030491457) | |||
44784 | 44784 | 132123 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6014232.87879 | 2117626.20085 | 37.795397945911205 | -122.394743875326 | (37.7953979459112, -122.394743875326) | |||
48105 | 48105 | 118707 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4201 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 5982546.62842 | 2110970.49419 | 37.775310661099795 | -122.503888560039 | (37.7753106610998, -122.503888560039) | |||
54210 | 54210 | 132125 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6014258.525909999 | 2117571.02815 | 37.79524788055 | -122.39465126585199 | (37.79524788055, -122.394651265852) | |||
54710 | 54710 | 132121 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6014209.141 | 2117675.2625 | 37.7955313378499 | -122.39482945031999 | (37.7955313378499, -122.39482945032) | |||
56654 | 56654 | 132101 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 10ft | 6012520.61539 | 2120407.16114 | 37.802938445615 | -122.40086410632 | (37.802938445615, -122.40086410632) | |||
68375 | 68375 | 234369 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6005339.90624 | 2098058.76544 | 37.7411720001789 | -122.42412281821899 | (37.7411720001789, -122.424122818219) | ||||
77513 | 77513 | 27958 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | |||
79708 | 79708 | 27959 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | |||
91142 | 91142 | 28372 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 18 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
93856 | 93856 | 27960 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | |||
101121 | 101121 | 27717 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 09/11/2000 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | |||
118074 | 118074 | 27961 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | |||
120310 | 120310 | 27785 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 18 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
138553 | 138553 | 116529 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 745X SANCHEZ ST | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
140710 | 140710 | 27962 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | |||
151174 | 151174 | 194393 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 860x Jamestown Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 5ft | 6014647.11529 | 2089218.63866 | 37.7174198994758 | -122.391323741894 | (37.7174198994758, -122.391323741894) | |||
160623 | 160623 | 234336 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 420 Dolores St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6004864.2449199995 | 2105581.16954 | 37.7617999064621 | -122.42630293226101 | (37.7617999064621, -122.426302932261) | |||
163388 | 163388 | 233927 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 389 Webster St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6004115.83529 | 2109995.53754 | 37.7738783609231 | -122.429206159632 | (37.7738783609231, -122.429206159632) | |||
186247 | 186247 | 118708 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4201 Balboa St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 5982482.88801 | 2110969.6299 | 37.7753045397791 | -122.504108985066 | (37.7753045397791, -122.504108985066) | |||
32439 | 32439 | 194391 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 828x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 5ft | 6014866.8225 | 2088973.5540099998 | 37.7167591360948 | -122.39054719349899 | (37.7167591360948, -122.390547193499) | |||
41784 | 41784 | 194394 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 920x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 5ft | 6014490.42947 | 2089308.0420799998 | 37.717656686497506 | -122.39187158462799 | (37.7176566864975, -122.391871584628) | |||
131575 | 131575 | 132122 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6014219.48603 | 2117650.76237 | 37.7954646414426 | -122.39479193780599 | (37.7954646414426, -122.394791937806) | |||
170253 | 170253 | 178084 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 210 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6012735.74773 | 2087515.03594 | 37.7126358803078 | -122.39781106804199 | (37.7126358803078, -122.397811068042) | |||
174052 | 174052 | 194319 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 7ft | 6014937.91263 | 2116957.6212 | 37.793601355862705 | -122.392257538577 | (37.7936013558627, -122.392257538577) | |||
177459 | 177459 | 132104 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 10ft | 6012041.8343 | 2121038.82925 | 37.8046461349625 | -122.402565391602 | (37.8046461349625, -122.402565391602) | |||
17598 | 17598 | 9369 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 276 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2x2 | 6001136.50681 | 2098095.27018 | 37.7410340073111 | -122.438659251142 | (37.7410340073111, -122.438659251142) | |||
30823 | 30823 | 132092 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011191.46105 | 2121714.3637599996 | 37.806453474602 | -122.405555813649 | (37.806453474602, -122.405555813649) | |||
66065 | 66065 | 132114 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6013298.81612 | 2119255.09608 | 37.799818527453105 | -122.39809024008001 | (37.7998185274531, -122.39809024008) | |||
69507 | 69507 | 132112 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011208.1934400005 | 2121737.88602 | 37.8065189965151 | -122.40549956557501 | (37.8065189965151, -122.405499565575) | |||
70221 | 70221 | 132087 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011581.4658 | 2121414.5973099996 | 37.8056521894584 | -122.40418501304501 | (37.8056521894584, -122.404185013045) | |||
111571 | 111571 | 27784 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 20 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
121202 | 121202 | 27482 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 990X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/20/1999 12:00:00 AM | 20 | 20 | 6005038.29077 | 2102581.9809991 | 37.7535746757806 | -122.425487524624 | (37.7535746757806, -122.425487524624) | ||
131771 | 131771 | 132074 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6013098.86351 | 2119482.52775 | 37.800431861502396 | -122.39879812525601 | (37.8004318615024, -122.398798125256) | |||
133391 | 133391 | 194310 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 7ft | 6015149.43028 | 2116672.0498900004 | 37.7928289857212 | -122.39150569005301 | (37.7928289857212, -122.391505690053) | |||
135157 | 135157 | 132081 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6012501.69351 | 2120366.8481099997 | 37.802826700352995 | -122.400926752172 | (37.802826700353, -122.400926752172) | |||
136050 | 136050 | 132086 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011972.21269 | 2121045.33445 | 37.8046601095467 | -122.402806783124 | (37.8046601095467, -122.402806783124) | |||
136668 | 136668 | 194314 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 7ft | 6015030.092180001 | 2116803.1524 | 37.793182338337296 | -122.39192778056601 | (37.7931823383373, -122.391927780566) | |||
152917 | 152917 | 194273 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Tennessee St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 8ft | 6015573.17514 | 2103426.7647700002 | 37.7564838780418 | -122.38911425333 | (37.7564838780418, -122.38911425333) | |||
160227 | 160227 | 194315 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 7ft | 6015053.743430001 | 2116822.79374 | 37.793237581902105 | -122.391847319118 | (37.7932375819021, -122.391847319118) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");