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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 131405 | 131405 | 194320 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 7ft | 6014831.89764 | 2117081.36813 | 37.7939352489635 | -122.392633022622 | (37.7939352489635, -122.392633022622) | |||
| 72003 | 72003 | 194321 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 7ft | 6014800.62587 | 2117118.44333 | 37.794035312034104 | -122.392743821769 | (37.7940353120341, -122.392743821769) | |||
| 80229 | 80229 | 18563 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
| 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) | |||
| 94802 | 94802 | 18548 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
| 182110 | 182110 | 194322 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 7ft | 6014773.3420400005 | 2117151.64182 | 37.7941249519603 | -122.392840551058 | (37.7941249519603, -122.392840551058) | |||
| 129396 | 129396 | 93074 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 301 Executive Park Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2007 12:00:00 AM | 3x3 | Permit Number 49938 | 6014761.5 | 2086930.3 | 37.711142914018296 | -122.390768534473 | (37.7111429140183, -122.390768534473) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 16811 | 16811 | 18551 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014649.71614 | 2095074.3239900002 | 37.733498586072294 | -122.391723949223 | (37.7334985860723, -122.391723949223) | |||
| 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) | |||
| 16768 | 16768 | 18555 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014626.04256 | 2095092.9200799998 | 37.733548332979105 | -122.39180709603201 | (37.7335483329791, -122.391807096032) | |||
| 13621 | 13621 | 18556 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014603.96741 | 2095108.67042 | 37.7335903547148 | -122.391884517749 | (37.7335903547148, -122.391884517749) | |||
| 28249 | 28249 | 194306 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 500 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6014568.03404 | 2117229.07965 | 37.7943261725661 | -122.393556366426 | (37.7943261725661, -122.393556366426) | |||
| 16559 | 16559 | 18559 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014565.4208 | 2095135.4289 | 37.733661688034104 | -122.392019656183 | (37.7336616880341, -122.392019656183) | |||
| 14049 | 14049 | 18560 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014546.06488 | 2095149.2171099999 | 37.7336984729967 | -122.392087539714 | (37.7336984729967, -122.392087539714) | |||
| 162909 | 162909 | 194305 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 500 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 5ft | 6014543.5989 | 2117243.74376 | 37.7943650790379 | -122.393641942341 | (37.7943650790379, -122.393641942341) | |||
| 24075 | 24075 | 194304 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 500 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6014519.25252 | 2117262.79206 | 37.7944160283404 | -122.393727518235 | (37.7944160283404, -122.393727518235) | |||
| 35928 | 35928 | 194284 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6014504.15008 | 2095180.2076400002 | 37.733781239407 | -122.392234619349 | (37.733781239407, -122.392234619349) | ||||
| 130546 | 130546 | 194303 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 500 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6014498.26565 | 2117280.42263 | 37.794463271518296 | -122.39380137055599 | (37.7944632715183, -122.393801370556) | |||
| 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) | |||
| 173668 | 173668 | 194302 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 550 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 5ft | 6014474.29881 | 2117301.48742 | 37.7945197786065 | -122.393885774627 | (37.7945197786065, -122.393885774627) | |||
| 166815 | 166815 | 194285 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6014471.94536 | 2095201.4069599998 | 37.7338376601657 | -122.39234744377701 | (37.7338376601657, -122.392347443777) | ||||
| 131945 | 131945 | 194301 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 550 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6014450.94814 | 2117319.50323 | 37.794567948092606 | -122.393967833244 | (37.7945679480926, -122.393967833244) | |||
| 150397 | 150397 | 194286 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 6014450.16973 | 2095221.3993900002 | 37.7338913460907 | -122.392424127176 | (37.7338913460907, -122.392424127176) | ||||
| 39870 | 39870 | 194287 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6014435.322380001 | 2095233.3766599998 | 37.733923408722795 | -122.392476296866 | (37.7339234087228, -122.392476296866) | ||||
| 43567 | 43567 | 194300 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 550 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 6014431.69544 | 2117339.12323 | 37.7946207500099 | -122.39403582470699 | (37.7946207500099, -122.394035824707) | |||
| 183995 | 183995 | 194395 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 920x Jamestown Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 5ft | 6014427.53162 | 2089348.9061599998 | 37.7177653992236 | -122.392091851971 | (37.7177653992236, -122.392091851971) | |||
| 35608 | 35608 | 194288 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6014411.93404 | 2095259.01392 | 37.733992504551296 | -122.392558950849 | (37.7339925045513, -122.392558950849) | ||||
| 48294 | 48294 | 194299 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 550 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6014410.76303 | 2117359.45162 | 37.794675403602 | -122.39410967794599 | (37.794675403602, -122.394109677946) | |||
| 58702 | 58702 | 194289 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 6014396.14271 | 2095264.76436 | 37.734007417094 | -122.39261394888901 | (37.734007417094, -122.392613948889) | ||||
| 71126 | 71126 | 194298 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 550 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6014390.53553 | 2117381.11551 | 37.794733763298105 | -122.394181185735 | (37.7947337632981, -122.394181185735) | |||
| 70141 | 70141 | 194290 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 40 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6014381.3022300005 | 2095272.57767 | 37.7340280466394 | -122.39266580380101 | (37.7340280466394, -122.392665803801) | ||||
| 134605 | 134605 | 194275 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 01st St | 34 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014376.659969999 | 2105881.88915 | 37.76315871732 | -122.39342406806101 | (37.76315871732, -122.393424068061) | ||||
| 54354 | 54354 | 194291 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6014364.32912 | 2095287.3135099998 | 37.7340675655682 | -122.39272551607701 | (37.7340675655682, -122.392725516077) | ||||
| 27134 | 27134 | 194292 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 43 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6014354.24031 | 2095291.86255 | 37.734079495961396 | -122.392760714642 | (37.7340794959614, -122.392760714642) | ||||
| 94898 | 94898 | 28032 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 12 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014349.29301 | 2117643.21201 | 37.7954511263865 | -122.394342251353 | (37.7954511263865, -122.394342251353) | ||
| 104388 | 104388 | 28031 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 11 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014334.10201 | 2117669.25401 | 37.7955217871698 | -122.394396639485 | (37.7955217871698, -122.394396639485) | ||
| 69369 | 69369 | 28185 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X King St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6 | 6014324.7762427 | 2110655.2584450003 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | |||
| 72577 | 72577 | 28190 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X King St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6 | 6014324.7762427 | 2110655.2584450003 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | |||
| 80653 | 80653 | 28194 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X King St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6 | 6014324.7762427 | 2110655.2584450003 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 78636 | 78636 | 28030 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 10 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014322.16601 | 2117689.8700099997 | 37.795577730351205 | -122.39443938464899 | (37.7955777303512, -122.394439384649) | ||
| 27594 | 27594 | 194293 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 46 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6014318.796490001 | 2095319.19207 | 37.7341525685742 | -122.392885167337 | (37.7341525685742, -122.392885167337) | ||||
| 142211 | 142211 | 28029 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 9 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014304.80501 | 2117713.7420099997 | 37.7956423121436 | -122.394501129585 | (37.7956423121436, -122.394501129585) | ||
| 35095 | 35095 | 132128 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6014303.114130001 | 2117497.5911 | 37.7950487184753 | -122.39449183764299 | (37.7950487184753, -122.394491837643) | |||
| 54350 | 54350 | 194294 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 49 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6014297.19865 | 2095334.47415 | 37.7341933303645 | -122.392960907318 | (37.7341933303645, -122.392960907318) | ||||
| 144979 | 144979 | 28028 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014289.61401 | 2117737.61301 | 37.7957070117951 | -122.394555365911 | (37.7957070117951, -122.394555365911) | ||
| 163649 | 163649 | 132127 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6014286.02329 | 2117523.57721 | 37.79511912011571 | -122.39455279549401 | (37.7951191201157, -122.394552795494) | |||
| 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) | |||
| 102648 | 102648 | 28027 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014263.57201 | 2117754.9750099997 | 37.795753235969 | -122.394646693031 | (37.795753235969, -122.394646693031) | ||
| 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) | |||
| 123608 | 123608 | 28026 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014253.80701 | 2117776.67601 | 37.795812278914 | -122.39468200241699 | (37.795812278914, -122.394682002417) | ||
| 62627 | 62627 | 132124 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6014245.1809 | 2117597.9501799997 | 37.7953210601821 | -122.39469932831301 | (37.7953210601821, -122.394699328313) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 54517 | 54517 | 132120 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 5ft | 6014198.1938 | 2117703.48543 | 37.795608222695996 | -122.394869307388 | (37.795608222696, -122.394869307388) | |||
| 45951 | 45951 | 132119 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6014187.59198 | 2117732.03905 | 37.795686034729 | -122.39490799262501 | (37.795686034729, -122.394907992625) | |||
| 1379 | 1379 | 25668 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6014174.0749699995 | 2117868.41683 | 37.796059744425996 | -122.394964320767 | (37.796059744426, -122.394964320767) | ||
| 183774 | 183774 | 132118 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 6014172.89911 | 2117759.32578 | 37.795760140682894 | -122.394960745056 | (37.7957601406829, -122.394960745056) | |||
| 77877 | 77877 | 28025 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014170.25601 | 2117873.24701 | 37.796072794607895 | -122.39497787369301 | (37.7960727946079, -122.394977873693) | ||
| 6748 | 6748 | 26030 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 10 | 6014150.34723 | 2117905.1373099997 | 37.796159250800294 | -122.395048997307 | (37.7961592508003, -122.395048997307) | ||
| 81297 | 81297 | 28024 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014145.300009999 | 2117911.2250099997 | 37.7961756855245 | -122.39506688844999 | (37.7961756855245, -122.39506688845) | ||
| 6093 | 6093 | 26031 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 10 | 6014122.12078 | 2117941.0950599997 | 37.7962564126589 | -122.39514918719999 | (37.7962564126589, -122.3951491872) | ||
| 92971 | 92971 | 28023 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014119.25801 | 2117944.86201 | 37.7962665966149 | -122.395159357042 | (37.7962665966149, -122.395159357042) | ||
| 115397 | 115397 | 28022 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014106.23701 | 2117977.41401 | 37.796355252616294 | -122.39520669408002 | (37.7963552526163, -122.39520669408) | ||
| 6610 | 6610 | 25631 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014105.621619999 | 2117876.68788 | 37.7960786481665 | -122.395201764263 | (37.7960786481665, -122.395201764263) | ||
| 5331 | 5331 | 25671 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6014100.8579 | 2117974.29057 | 37.7963463772386 | -122.395225088169 | (37.7963463772386, -122.395225088169) | ||
| 8404 | 8404 | 25630 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014084.49775 | 2117912.38554 | 37.7961754907607 | -122.395277359473 | (37.7961754907607, -122.395277359473) | ||
| 82580 | 82580 | 28021 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014080.19501 | 2118017.56101 | 37.796464038519396 | -122.39529961933201 | (37.7964640385194, -122.395299619332) | ||
| 5927 | 5927 | 25672 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6014076.201780001 | 2118013.23421 | 37.796451936061295 | -122.39531313361799 | (37.7964519360613, -122.395313133618) | ||
| 8064 | 8064 | 25629 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014059.75449 | 2117949.14567 | 37.79627504929729 | -122.39536555327801 | (37.7962750492973, -122.395365553278) | ||
| 170613 | 170613 | 194296 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1799 Revere Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | 6014052.02799 | 2095141.7859200002 | 37.733650626363 | -122.393795063609 | (37.733650626363, -122.393795063609) | ||||
| 2027 | 2027 | 25628 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014034.02503 | 2117986.25531 | 37.796375512586 | -122.39545718430401 | (37.796375512586, -122.395457184304) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 7340 | 7340 | 25782 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 36 | 10 | 6013997.3565 | 2118221.08563 | 37.7970182616509 | -122.395600527244 | (37.7970182616509, -122.395600527244) | ||
| 7108 | 7108 | 25783 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013938.98446 | 2118296.9177 | 37.7972232315271 | -122.39580782638599 | (37.7972232315271, -122.395807826386) | ||
| 90111 | 90111 | 27847 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 99547 | 99547 | 27845 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 100729 | 100729 | 27843 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 105556 | 105556 | 27842 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 105677 | 105677 | 27827 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 110061 | 110061 | 27844 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 115875 | 115875 | 27841 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 118319 | 118319 | 27846 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) |
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");