Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80037 | 80037 | 86731 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Pico Ave | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 49705 | 5994102.9 | 2092171.9 | 37.724367252780496 | -122.462549157922 | (37.7243672527805, -122.462549157922) | |||||
| 608 | 608 | 233928 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 8 Octavia St Frontage East | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 8ft | 6005775.18179 | 2109348.30824 | 37.77219502161479 | -122.423420179704 | (37.7721950216148, -122.423420179704) | |||
| 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) | |||
| 9471 | 9471 | 18535 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 270 PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6006489.0 | 2098160.0 | 37.74151478014 | -122.420156839009 | (37.74151478014, -122.420156839009) | |||
| 9735 | 9735 | 173670 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 251x Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012236.0 | 2086860.0 | 37.7108094381203 | -122.399492405366 | (37.7108094381203, -122.399492405366) | ||||
| 14133 | 14133 | 29536 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2600X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6015127.6919 | 2091149.846 | 37.7227492757118 | -122.38979741293699 | (37.7227492757118, -122.389797412937) | |||
| 14829 | 14829 | 95065 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 4801 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014916.5089 | 2095299.5463 | 37.7341318071091 | -122.390817297505 | (37.7341318071091, -122.390817297505) | |||
| 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) | |||
| 20932 | 20932 | 5679 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1470 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | 6 | 3x3 | 6005190.57812 | 2099817.1721900003 | 37.7459917521253 | -122.424764205708 | (37.7459917521253, -122.424764205708) | ||
| 23525 | 23525 | 187316 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5985075.4607 | 2099608.8478 | 37.744263118481705 | -122.494303219592 | (37.7442631184817, -122.494303219592) | |||
| 25123 | 25123 | 210904 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1539 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5990882.40967 | 2107206.58351 | 37.7654626131273 | -122.47477868020201 | (37.7654626131273, -122.474778680202) | |||
| 25380 | 25380 | 124656 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 Presidio Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 7ft | 5995441.43994 | 2115441.36584 | 37.7883362746058 | -122.45960662195401 | (37.7883362746058, -122.459606621954) | |||
| 26354 | 26354 | 234378 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 Bird St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 5ft | 6005998.07456 | 2105729.78745 | 37.7622720010628 | -122.42239202167299 | (37.7622720010628, -122.422392021673) | |||
| 28217 | 28217 | 210914 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 317 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 3ft | 5993048.097569999 | 2099658.5212 | 37.744862847537206 | -122.46673939310301 | (37.7448628475372, -122.466739393103) | |||
| 29139 | 29139 | 194295 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1942 Quesada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | Width 10ft | 6013443.13195 | 2096013.71128 | 37.7360108970885 | -122.395961290278 | (37.7360108970885, -122.395961290278) | |||
| 30108 | 30108 | 210927 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 234 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6000492.41263 | 2094973.31916 | 37.732425199355 | -122.44066241093701 | (37.732425199355, -122.440662410937) | ||||
| 31219 | 31219 | 194283 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 44 | 6016255.79944 | 2100318.37917 | 37.747986718206604 | -122.386536741486 | (37.7479867182066, -122.386536741486) | ||||
| 34765 | 34765 | 143058 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 426 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6010776.1378 | 2120354.2833 | 37.8026957973236 | -122.406897202115 | (37.8026957973236, -122.406897202115) | |||
| 34789 | 34789 | 119450 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 33rd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 5985749.05602 | 2110390.9661 | 37.7739072286205 | -122.49276808877701 | (37.7739072286205, -122.492768088777) | ||||
| 34895 | 34895 | 67033 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 174 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1992 12:00:00 AM | 30 | 5x5 | Permit Number 30405 | 5992451.37715 | 2114312.24159 | 37.7850636224737 | -122.469869417746 | (37.7850636224737, -122.469869417746) | |
| 42292 | 42292 | 234344 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 751 Dolores St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6005051.924 | 2103931.9938 | 37.757282265587 | -122.42553644996299 | (37.757282265587, -122.425536449963) | |||
| 45534 | 45534 | 124659 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 199 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 8ft | 5995478.86593 | 2115238.56038 | 37.7877815776324 | -122.45946244145901 | (37.7877815776324, -122.459462441459) | |||
| 46040 | 46040 | 187495 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005184.36761 | 2086469.76682 | 37.709342367834395 | -122.423836763664 | (37.7093423678344, -122.423836763664) | ||||
| 47083 | 47083 | 186006 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985010.9219 | 2101633.2915 | 37.7498179124605 | -122.494675598244 | (37.7498179124605, -122.494675598244) | |||
| 48676 | 48676 | 210905 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1545 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5990857.32948 | 2107205.82169 | 37.76545906800929 | -122.47486537036501 | (37.7654590680093, -122.474865370365) | |||
| 56280 | 56280 | 194309 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 The Embarcadero | 1 | : 4 | Tree 1 | Private 1 | 24 | Width 7ft | 6015233.93882 | 2116624.33128 | 37.79270265166021 | -122.39120994708 | (37.7927026516602, -122.39120994708) | |||
| 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) | |||
| 59740 | 59740 | 182872 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1845 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 5987505.5699 | 2102718.6655 | 37.7529437568716 | -122.48612877158999 | (37.7529437568716, -122.48612877159) | |||
| 62437 | 62437 | 182268 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1466 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 0ft | 5985290.7143 | 2105238.2671 | 37.759732554956 | -122.493973725026 | (37.759732554956, -122.493973725026) | |||
| 62633 | 62633 | 185382 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2615 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 0ft | 5985803.8248 | 2097379.5833 | 37.7381847526444 | -122.491620661903 | (37.7381847526444, -122.491620661903) | |||
| 63387 | 63387 | 210922 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 Kingston St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | Width 4ft | 5994038.377230001 | 2099205.2198900003 | 37.7436752972852 | -122.463282329909 | (37.7436752972852, -122.463282329909) | |||
| 66140 | 66140 | 118759 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 544 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | Width 5ft | 5981951.74748 | 2112030.16523 | 37.7781852088244 | -122.50602493975501 | (37.7781852088244, -122.506024939755) | |||
| 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) | |||
| 72198 | 72198 | 245079 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 154 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | Width 0ft | 6000824.0394 | 2109520.8819 | 37.7723881764486 | -122.440558941181 | (37.7723881764486, -122.440558941181) | |||
| 76183 | 76183 | 118547 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 8140 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 5981731.05099 | 2112390.85514 | 37.7791625633163 | -122.50681515625901 | (37.7791625633163, -122.506815156259) | |||
| 76588 | 76588 | 247039 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 574 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 6ft | 6002246.4280199995 | 2099186.76685 | 37.7440940809725 | -122.43489959305 | (37.7440940809725, -122.43489959305) | |||
| 78635 | 78635 | 60467 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 152 MAJESTIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1982 12:00:00 AM | Permit Number 20060 | 5996883.0 | 2089135.0 | 37.716188348676894 | -122.45271971026699 | (37.7161883486769, -122.452719710267) | |||
| 100781 | 100781 | 109174 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 63 KEYSTONE WAY | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775282 | 5994095.9 | 2093146.9 | 37.7270439629203 | -122.46264404963699 | (37.7270439629203, -122.462644049637) | |
| 110630 | 110630 | 92744 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 627 Dartmouth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52968 | 6009200.0 | 2091312.0 | 37.722864017361395 | -122.41029969523998 | (37.7228640173614, -122.41029969524) | |||
| 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) | |||
| 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) | ||||
| 136703 | 136703 | 178086 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 364 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 43 | Width 3ft | 6001063.00753 | 2092653.5980599998 | 37.7260882551546 | -122.438523588412 | (37.7260882551546, -122.438523588412) | |||
| 139986 | 139986 | 1443 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 151X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | |||
| 142373 | 142373 | 87850 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 94 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50753 | 5997405.9 | 2099153.7 | 37.7437272652603 | -122.45163459365601 | (37.7437272652603, -122.451634593656) | |||
| 150774 | 150774 | 118706 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4201 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 5982550.59501 | 2110970.7524 | 37.7753116033094 | -122.50387485804899 | (37.7753116033094, -122.503874858049) | |||
| 156465 | 156465 | 187520 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Lauren Ct | 1 | : 4 | Tree 1 | Private 1 | 24 | Width 5ft | 6012373.80363 | 2088075.5295400003 | 37.7141547210285 | -122.399101386534 | (37.7141547210285, -122.399101386534) | |||
| 157407 | 157407 | 210926 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 39 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 10ft | 5999833.49072 | 2095475.12852 | 37.7337655048678 | -122.44297647541 | (37.7337655048678, -122.44297647541) | |||
| 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) | ||||
| 163173 | 163173 | 120801 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4400 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 5ft | 5989725.4481 | 2109944.4345400003 | 37.7729128936687 | -122.478980576929 | (37.7729128936687, -122.478980576929) | |||
| 164059 | 164059 | 178087 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 201 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6003003.324659999 | 2086943.97699 | 37.7105210777575 | -122.431408625424 | (37.7105210777575, -122.431408625424) | |||
| 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) | ||||
| 164993 | 164993 | 118208 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 578 35th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 2ft | 5985073.59503 | 2111934.34638 | 37.7781053878802 | -122.495218423393 | (37.7781053878802, -122.495218423393) | |||
| 166452 | 166452 | 210925 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 43 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 10ft | 5999799.64358 | 2095482.9145400003 | 37.7337849536105 | -122.443094053648 | (37.7337849536105, -122.443094053648) | |||
| 168851 | 168851 | 194325 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 88 King St | 1 | : 4 | Tree 1 | Private 1 | 31 | Width 8ft | 6015700.5691599995 | 2111985.57661 | 37.779991570003205 | -122.38927130734601 | (37.7799915700032, -122.389271307346) | |||
| 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) | |||
| 174148 | 174148 | 234400 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4 Corwin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 3ft | 6001132.8816599995 | 2103964.26051 | 37.7571486461001 | -122.439092314277 | (37.7571486461001, -122.439092314277) | |||
| 175193 | 175193 | 182680 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2701 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985854.1638 | 2103629.5919999997 | 37.7553485282392 | -122.491906624733 | (37.7553485282392, -122.491906624733) | |||
| 176298 | 176298 | 247642 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 632 Banks St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 4ft | 6008490.96565 | 2095907.56445 | 37.7354426820387 | -122.41307547425501 | (37.7354426820387, -122.413075474255) | |||
| 176402 | 176402 | 210907 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1009 Kirkham St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 32 | Width 3ft | 5991740.69924 | 2105187.8933900003 | 37.7599695243799 | -122.47166295830499 | (37.7599695243799, -122.471662958305) | |||
| 177164 | 177164 | 234402 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 667 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002514.48058 | 2108813.7305400004 | 37.7705426279609 | -122.434660977745 | (37.7705426279609, -122.434660977745) | |||
| 179136 | 179136 | 124657 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 30 Presidio Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 7ft | 5995444.46973 | 2115398.79213 | 37.7882195529326 | -122.459593054716 | (37.7882195529326, -122.459593054716) | |||
| 182278 | 182278 | 210908 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1351 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5994231.8356099995 | 2106400.1375599997 | 37.7634418445856 | -122.463135347428 | (37.7634418445856, -122.463135347428) | |||
| 183295 | 183295 | 194277 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1301 Rhode Island St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | Width 7ft | 6012002.23785 | 2102241.02504 | 37.7530294975215 | -122.401380567153 | (37.7530294975215, -122.401380567153) | |||
| 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) | |||
| 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) | ||||
| 188102 | 188102 | 234372 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3782 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 3ft | 6005314.45638 | 2100807.30331 | 37.74871742098671 | -122.424406263843 | (37.7487174209867, -122.424406263843) | |||
| 188962 | 188962 | 182197 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1584 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 0ft | 5985008.2078 | 2104414.5267 | 37.7574542590905 | -122.494890024235 | (37.7574542590905, -122.494890024235) | |||
| 13733 | 13733 | 29537 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2600X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6015071.7012 | 2091079.6967 | 37.7225535544976 | -122.38998606447299 | (37.7225535544976, -122.389986064473) | |||
| 23714 | 23714 | 234376 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6008587.75214 | 2108113.66978 | 37.7689633348285 | -122.41360388622499 | (37.7689633348285, -122.413603886225) | |||
| 23789 | 23789 | 234390 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1600 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6005245.617219999 | 2098983.50062 | 37.7437057887861 | -122.42451459797199 | (37.7437057887861, -122.424514597972) | |||
| 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) | |||
| 26482 | 26482 | 210923 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1540 Plymouth Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 41 | Width 3ft | 5995839.221390001 | 2094293.33064 | 37.7302920326405 | -122.456700326779 | (37.7302920326405, -122.456700326779) | |||
| 30590 | 30590 | 118002 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 7 Shore View Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5984637.38492 | 2112844.95185 | 37.780580098776795 | -122.49679463074699 | (37.7805800987768, -122.496794630747) | |||
| 32150 | 32150 | 186007 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985000.2752 | 2101640.5507 | 37.749837221065 | -122.49471294958 | (37.749837221065, -122.49471294958) | |||
| 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) | |||
| 43303 | 43303 | 210921 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 Kingston St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 4ft | 5994023.0507 | 2099217.557 | 37.7437082889086 | -122.46333622000601 | (37.7437082889086, -122.463336220006) | |||
| 43396 | 43396 | 194272 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1022 Minna St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6007547.687530001 | 2109714.25342 | 37.7732997020571 | -122.41731485230801 | (37.7732997020571, -122.417314852308) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 48507 | 48507 | 118600 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 249 Point Lobos Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 5981958.17368 | 2112601.6345 | 37.779754673268705 | -122.506045091658 | (37.7797546732687, -122.506045091658) | ||||
| 48989 | 48989 | 233929 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 8 Octavia St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 6005769.81739 | 2109368.12443 | 37.77224912933389 | -122.42344014465901 | (37.7722491293339, -122.423440144659) | ||||
| 55136 | 55136 | 234387 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 986 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005043.99676 | 2102621.6014400003 | 37.7536837866767 | -122.425470611492 | (37.7536837866767, -122.425470611492) | |||
| 55424 | 55424 | 210903 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1939 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 2ft | 5991246.46009 | 2102193.40392 | 37.7517188372786 | -122.47315388853599 | (37.7517188372786, -122.473153888536) | |||
| 60454 | 60454 | 234382 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2624 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6010280.44455 | 2103423.11774 | 37.7561790447523 | -122.40741821967501 | (37.7561790447523, -122.407418219675) | |||
| 61791 | 61791 | 182681 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2701 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5985882.7747 | 2103629.0901 | 37.75534882242739 | -122.491807644065 | (37.7553488224274, -122.491807644065) | |||
| 68513 | 68513 | 210928 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 617 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | 5997342.33131 | 2095240.63361 | 37.732979290542104 | -122.451572201795 | (37.7329792905421, -122.451572201795) | ||||
| 69742 | 69742 | 210912 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 443 Gennessee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 5997433.76219 | 2094954.34243 | 37.732198438902294 | -122.451235463255 | (37.7321984389023, -122.451235463255) | ||||
| 71688 | 71688 | 182873 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1845 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5987506.6654 | 2102709.2443 | 37.7529179526447 | -122.486124291657 | (37.7529179526447, -122.486124291657) | |||
| 111110 | 111110 | 116685 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1x BIRD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005912.0 | 2105722.0 | 37.762245762674496 | -122.42268916815901 | (37.7622457626745, -122.422689168159) | ||||
| 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) | ||||
| 129577 | 129577 | 120800 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4400 Fulton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 5ft | 5989719.73075 | 2109944.0609999998 | 37.7729115360186 | -122.47900032637399 | (37.7729115360186, -122.479000326374) | |||
| 130062 | 130062 | 178088 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 201 Chicago Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 3ft | 6003023.7628 | 2086943.7814599997 | 37.7105216991954 | -122.431337972882 | (37.7105216991954, -122.431337972882) | |||
| 132845 | 132845 | 234388 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1069 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 5ft | 6005149.23502 | 2102137.71701 | 37.7523610979942 | -122.425072246905 | (37.7523610979942, -122.425072246905) | |||
| 132990 | 132990 | 234397 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3932 22nd St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 25 | Width 4ft | 6002267.50929 | 2102984.90864 | 37.7545240763369 | -122.435098296447 | (37.7545240763369, -122.435098296447) | |||
| 137503 | 137503 | 234343 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 769 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 7ft | 6005056.066269999 | 2103868.0427200003 | 37.7571069049763 | -122.42551757317601 | (37.7571069049763, -122.425517573176) | |||
| 149136 | 149136 | 234366 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 9 Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006381.599330001 | 2099941.08815 | 37.746399194477206 | -122.420654601644 | (37.7463991944772, -122.420654601644) | |||
| 157052 | 157052 | 210909 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 151 Garcia Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5994659.02084 | 2099296.69557 | 37.7439622025921 | -122.46114293900601 | (37.7439622025921, -122.461142939006) | |||
| 158189 | 158189 | 234383 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 3483 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005156.87556 | 2103096.1087599997 | 37.7549930502992 | -122.425114011399 | (37.7549930502992, -122.425114011399) | |||
| 159196 | 159196 | 210916 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 587 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 4ft | 5994027.5569 | 2099288.55437 | 37.7439034894442 | -122.46332578967 | (37.7439034894442, -122.46332578967) |
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");