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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 119491 | 119491 | 234348 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 550x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6004955.107340001 | 2105017.7620200003 | 37.760258058393205 | -122.425948567888 | (37.7602580583932, -122.425948567888) | ||||
| 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) | ||||
| 120022 | 120022 | 27940 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
| 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) | ||||
| 121752 | 121752 | 27776 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.39634576874799 | (37.797431381421, -122.396345768748) | |||
| 123736 | 123736 | 234368 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6005333.75186 | 2098133.92444 | 37.7413780222889 | -122.42414944174 | (37.7413780222889, -122.42414944174) | ||||
| 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) | ||||
| 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) | ||||
| 125860 | 125860 | 27766 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 24 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
| 126077 | 126077 | 51202 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 567 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47573 | 6003673.55383836 | 2104968.22861825 | 37.760049541377796 | -122.43037732338999 | (37.7600495413778, -122.43037732339) | ||||
| 127099 | 127099 | 27943 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
| 127400 | 127400 | 119700 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 6x Octavia St Frontage West | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||
| 130698 | 130698 | 234352 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 45 | 6004969.77736 | 2104678.02917 | 37.7593260612613 | -122.425873648056 | (37.7593260612613, -122.425873648056) | ||||
| 131012 | 131012 | 234358 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6004991.05597 | 2104342.31446 | 37.7584054702508 | -122.425776160656 | (37.7584054702508, -122.425776160656) | ||||
| 132648 | 132648 | 210911 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 443 Gennessee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 5997433.82925 | 2094957.55837 | 37.7322072729454 | -122.451235463261 | (37.7322072729454, -122.451235463261) | ||||
| 132937 | 132937 | 234364 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6005148.136969999 | 2101464.62312 | 37.7505128760752 | -122.425028157637 | (37.7505128760752, -122.425028157637) | ||||
| 133649 | 133649 | 234347 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 550x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6004944.62757 | 2105117.25917 | 37.760530661773 | -122.425991895418 | (37.760530661773, -122.425991895418) | ||||
| 133800 | 133800 | 234346 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350x Dolores St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6005214.83803 | 2100265.33674 | 37.74722367943539 | -122.424712194312 | (37.7472236794354, -122.424712194312) | ||||
| 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) | ||||
| 138316 | 138316 | 119699 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 6x Octavia St Frontage West | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 139415 | 139415 | 27774 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/10/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.39634576874799 | (37.797431381421, -122.396345768748) | |||
| 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) | ||||
| 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) | |||
| 140893 | 140893 | 27783 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 24 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
| 144544 | 144544 | 27779 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 24 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
| 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) | ||||
| 147563 | 147563 | 96683 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 375@32nd Ave 32nd Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 28 | Permit Number 768040 | 5985881.4573800005 | 2113426.06761 | 37.782248491261605 | -122.49253366172199 | (37.7822484912616, -122.492533661722) | ||
| 148964 | 148964 | 234370 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6005335.592730001 | 2098044.06455 | 37.7411313913144 | -122.42413668757 | (37.7411313913144, -122.42413668757) | ||||
| 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) | ||||
| 150698 | 150698 | 234330 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900x Dolores St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6005083.062580001 | 2102603.58555 | 37.7536365264144 | -122.42533423108699 | (37.7536365264144, -122.425334231087) | ||||
| 151204 | 151204 | 234363 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6005145.85028 | 2101496.26634 | 37.7505996318694 | -122.425038316369 | (37.7505996318694, -122.425038316369) | ||||
| 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) | ||||
| 151971 | 151971 | 194274 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Tennessee St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6015578.255919999 | 2103421.32087 | 37.756469211897 | -122.389096301947 | (37.756469211897, -122.389096301947) | ||||
| 154721 | 154721 | 234361 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6005142.97819 | 2101556.59196 | 37.75076510982829 | -122.42505254004699 | (37.7507651098283, -122.425052540047) | ||||
| 155084 | 155084 | 234329 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900x Dolores St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6005081.6594 | 2102660.65252 | 37.7537931397475 | -122.425343144298 | (37.7537931397475, -122.425343144298) | ||||
| 156553 | 156553 | 233943 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 450x Dolores St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 6004924.09393 | 2105519.3056799998 | 37.7616334257704 | -122.426091534022 | (37.7616334257704, -122.426091534022) | ||||
| 156879 | 156879 | 233941 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 370x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 6004887.91201 | 2106172.4684599997 | 37.7634248105293 | -122.426263176805 | (37.7634248105293, -122.426263176805) | ||||
| 157237 | 157237 | 234355 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6004978.4588 | 2104465.76881 | 37.7587437349524 | -122.425828514675 | (37.7587437349524, -122.425828514675) | ||||
| 158301 | 158301 | 234365 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6005150.81264 | 2101423.31762 | 37.7503996118641 | -122.425015966416 | (37.7503996118641, -122.425015966416) | ||||
| 161645 | 161645 | 194297 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2198 Revere Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6011968.87844 | 2096761.7845599998 | 37.737982818059294 | -122.40111095580299 | (37.7379828180593, -122.401110955803) | ||||
| 161954 | 161954 | 234349 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 6004962.28051 | 2104795.65924 | 37.7596486220069 | -122.42590794909599 | (37.7596486220069, -122.425907949096) | ||||
| 162443 | 162443 | 194387 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 6013093.20116 | 2089924.2998099998 | 37.7192711404238 | -122.39674438396099 | (37.7192711404238, -122.396744383961) | ||||
| 163407 | 163407 | 187499 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005135.10052 | 2086491.02363 | 37.7093979531098 | -122.42400854947999 | (37.7093979531098, -122.42400854948) | ||||
| 164116 | 164116 | 194276 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2347 19th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 46 | 6010780.52383 | 2105047.83738 | 37.7606681393399 | -122.405803207256 | (37.7606681393399, -122.405803207256) | ||||
| 164381 | 164381 | 218156 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1396 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5993216.16649 | 2097685.94396 | 37.7394563464375 | -122.46601493705799 | (37.7394563464375, -122.466014937058) | ||||
| 164800 | 164800 | 233942 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 450x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6004917.83694 | 2105642.84744 | 37.7619722884988 | -122.426121969753 | (37.7619722884988, -122.426121969753) | ||||
| 164848 | 164848 | 234326 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6005043.60607 | 2103360.12702 | 37.755711583428294 | -122.425524518639 | (37.7557115834283, -122.425524518639) | ||||
| 165757 | 165757 | 234350 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6004963.57632 | 2104757.16703 | 37.759543004714 | -122.425900727537 | (37.759543004714, -122.425900727537) | ||||
| 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) | ||||
| 167096 | 167096 | 234328 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6005051.1738 | 2103243.46642 | 37.7553916882954 | -122.425490044948 | (37.7553916882954, -122.425490044948) | ||||
| 170250 | 170250 | 233938 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 230x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 6004845.02149 | 2106914.0966 | 37.7654587199743 | -122.426464330874 | (37.7654587199743, -122.426464330874) | ||||
| 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) | ||||
| 171992 | 171992 | 218157 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1396 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 44 | 5993196.82548 | 2097677.0995099996 | 37.7394309459859 | -122.46608116671001 | (37.7394309459859, -122.46608116671) | ||||
| 173622 | 173622 | 234381 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Eugenia Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6006554.5281 | 2098105.53483 | 37.74136892295 | -122.41992640079599 | (37.74136892295, -122.419926400796) | ||||
| 174328 | 174328 | 234327 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 6005045.03345 | 2103276.5066400003 | 37.755482062073604 | -122.425513631455 | (37.7554820620736, -122.425513631455) | ||||
| 176009 | 176009 | 234379 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 246 Bemis St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 6003018.34772 | 2096316.7253 | 37.736257406663704 | -122.432025563025 | (37.7362574066637, -122.432025563025) | ||||
| 177827 | 177827 | 234351 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6004966.99113 | 2104720.1905900002 | 37.759441669116796 | -122.425886285347 | (37.7594416691168, -122.425886285347) | ||||
| 179308 | 179308 | 124647 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Arguello Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5995536.8608800005 | 2115835.19472 | 37.789423108579996 | -122.459305014392 | (37.78942310858, -122.459305014392) | ||||
| 179789 | 179789 | 234357 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004986.096919999 | 2104380.3629099997 | 37.758509662101204 | -122.425796019476 | (37.7585096621012, -122.425796019476) | ||||
| 181517 | 181517 | 194279 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6016113.78589 | 2100276.91255 | 37.7478649967659 | -122.387024931273 | (37.7478649967659, -122.387024931273) | ||||
| 181927 | 181927 | 201684 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 401 08th St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6010233.57215 | 2109769.89905 | 37.773603237626 | -122.408027891695 | (37.773603237626, -122.408027891695) | ||||
| 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) | ||||
| 182038 | 182038 | 234353 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004972.999969999 | 2104631.70012 | 37.7591990347337 | -122.425859204936 | (37.7591990347337, -122.425859204936) | ||||
| 182456 | 182456 | 234394 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350 Noe St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 6003187.2989 | 2100371.4904099996 | 37.7474004312881 | -122.431730842629 | (37.7474004312881, -122.431730842629) | ||||
| 182641 | 182641 | 233932 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004814.58298 | 2107439.6885599997 | 37.7669001488458 | -122.426607040704 | (37.7669001488458, -122.426607040704) | ||||
| 184903 | 184903 | 201683 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 401 08th St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010259.3376400005 | 2109773.81073 | 37.7736154207404 | -122.407939040461 | (37.7736154207404, -122.407939040461) | ||||
| 186098 | 186098 | 96686 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 375@32nd Ave 32nd Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 25 | Permit Number 768040 | 5985884.08947 | 2113350.81045 | 37.7820420106561 | -122.49251901199499 | (37.7820420106561, -122.492519011995) | ||
| 186407 | 186407 | 194386 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 6013080.03152 | 2089934.31035 | 37.7192978943535 | -122.396790608192 | (37.7192978943535, -122.396790608192) | ||||
| 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) | ||
| 4067 | 4067 | 25799 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012220.09673 | 2120843.1378 | 37.8041187644177 | -122.401934728525 | (37.8041187644177, -122.401934728525) | ||
| 5785 | 5785 | 25798 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012871.9305 | 2119823.23547 | 37.801354716114 | -122.39960734420201 | (37.801354716114, -122.399607344202) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 8987 | 8987 | 25784 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013869.26975 | 2118339.24702 | 37.797335579338004 | -122.396052026484 | (37.797335579338, -122.396052026484) | ||
| 17397 | 17397 | 25527 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002730.2479 | 2106324.2376 | 37.7637193356407 | -122.433736680672 | (37.7637193356407, -122.433736680672) | ||
| 17411 | 17411 | 25526 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002746.7355 | 2106338.4868 | 37.7637593960329 | -122.43368067367201 | (37.7637593960329, -122.433680673672) | ||
| 17621 | 17621 | 25516 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2190X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003679.0354 | 2107225.3342 | 37.7662473210814 | -122.430519419203 | (37.7662473210814, -122.430519419203) | ||
| 18199 | 18199 | 25532 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002592.5231 | 2106186.5128 | 37.7633333608706 | -122.43420318116999 | (37.7633333608706, -122.43420318117) | ||
| 18227 | 18227 | 25534 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002560.5766 | 2106158.8258 | 37.763255525853296 | -122.43431169398701 | (37.7632555258533, -122.434311693987) | ||
| 18754 | 18754 | 25528 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002714.6296 | 2106302.2301 | 37.7636580221412 | -122.433789126424 | (37.7636580221412, -122.433789126424) | ||
| 19415 | 19415 | 25531 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002640.0878 | 2106231.2379 | 37.763458864653295 | -122.434041867896 | (37.7634588646533, -122.434041867896) | ||
| 19785 | 19785 | 25785 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 19946 | 19946 | 25514 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6004037.0875 | 2107573.3112 | 37.7672230586461 | -122.429305801661 | (37.7672230586461, -122.429305801661) | ||
| 20343 | 20343 | 25533 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002574.775 | 2106170.8945 | 37.7632894694666 | -122.43426344933201 | (37.7632894694666, -122.434263449332) | ||
| 20414 | 20414 | 25529 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002679.8435 | 2106267.4439 | 37.7635605336875 | -122.43390695394699 | (37.7635605336875, -122.433906953947) | ||
| 20599 | 20599 | 25518 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003909.9867 | 2107446.2105 | 37.7668668744555 | -122.429736358347 | (37.7668668744555, -122.429736358347) | ||
| 21187 | 21187 | 25519 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003894.4866 | 2107428.3854 | 37.7668170533219 | -122.42978869913401 | (37.7668170533219, -122.429788699134) | ||
| 21387 | 21387 | 25517 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2190X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003660.4353 | 2107205.9591 | 37.7661930680529 | -122.43058237071199 | (37.7661930680529, -122.430582370712) |
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");