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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
61697 | 61697 | 28231 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
73838 | 73838 | 28232 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
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) | |||
79238 | 79238 | 28220 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
79855 | 79855 | 28229 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
81194 | 81194 | 28236 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
81864 | 81864 | 28226 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
83893 | 83893 | 110583 | Significant Tree 6 | Phoenix canariensis :: Canary Island Date Palm 100 | 46 COOK ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 5997534.0 | 2113434.0 | 37.782944683725 | -122.45222184269899 | (37.782944683725, -122.452221842699) | ||||
89467 | 89467 | 28227 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
93618 | 93618 | 28237 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
103796 | 103796 | 28225 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
107571 | 107571 | 28235 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
108524 | 108524 | 28230 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
111408 | 111408 | 28223 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
111889 | 111889 | 28228 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
115023 | 115023 | 28238 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
116814 | 116814 | 28222 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
117955 | 117955 | 28218 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
119895 | 119895 | 28234 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
96723 | 96723 | 104248 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 8X Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 10x20 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
110991 | 110991 | 104247 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 8X Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 10x20 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
11148 | 11148 | 20065 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 STAIRWAY54 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
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) | |||
138478 | 138478 | 24290 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 386 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X17 | 6000963.19469 | 2086697.3561200001 | 37.709728074949204 | -122.43844208303699 | (37.7097280749492, -122.438442083037) | |||
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) | |||
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) | |||
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) | |||
17398 | 17398 | 5707 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1600 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6005241.864159999 | 2098983.9941 | 37.74370693182271 | -122.424527610259 | (37.7437069318227, -122.424527610259) | |||
19964 | 19964 | 703 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1375X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6005257.21277 | 2100319.77841 | 37.747375556949 | -122.424569537574 | (37.747375556949, -122.424569537574) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
20528 | 20528 | 5557 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 977 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/2006 12:00:00 AM | 32 | 3x3 | 6005125.10547 | 2102657.90315 | 37.753788045101 | -122.42519270209499 | (37.753788045101, -122.425192702095) | ||
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) | ||
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) | |||
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) | ||||
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) | ||
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) | |||
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) | ||
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) | ||
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) | ||
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) | ||
104182 | 104182 | 14173 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1797X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 4X4 | 6005740.867306 | 2109154.5344128003 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | |||
104348 | 104348 | 119624 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1797X Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4X4 | 6005740.867306 | 2109154.5344128003 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | ||||
129459 | 129459 | 14174 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1797X Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 4X4 | 6005740.867306 | 2109154.5344128003 | 37.7716610284995 | -122.423525097847 | (37.7716610284995, -122.423525097847) | |||
107507 | 107507 | 96673 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1449 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6014955.39834 | 2095258.9558 | 37.7340225115191 | -122.390680007822 | (37.7340225115191, -122.390680007822) | |||
15304 | 15304 | 19794 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 STAIRWAY19 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
17523 | 17523 | 5503 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 773 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6005056.9343 | 2103834.44184 | 37.757014693887704 | -122.42551217994301 | (37.7570146938877, -122.425512179943) | |||
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) | |
19857 | 19857 | 5683 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1488 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/08/1997 12:00:00 AM | 12 | 6 | 6005201.38668 | 2099720.6305299997 | 37.745727281286705 | -122.42471996446301 | (37.7457272812867, -122.424719964463) | ||
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) | |||
101187 | 101187 | 5485 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
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) | |||
17235 | 17235 | 708 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1504X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/06/2015 02:27:00 PM | 3 | 6x6 | 6005213.6425 | 2099570.03766 | 37.745314479891896 | -122.42466687479799 | (37.7453144798919, -122.424666874798) | ||
21228 | 21228 | 5457 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 8 | 6004998.45452 | 2104996.17843 | 37.760201244618294 | -122.42579711395099 | (37.7602012446183, -122.425797113951) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
73625 | 73625 | 178085 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 210 Tocoloma Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012726.322790001 | 2087488.8573099999 | 37.712563474091894 | -122.397841808652 | (37.7125634740919, -122.397841808652) | |||
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) | |||
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) | |||
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) | |||
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) | |||
163198 | 163198 | 234393 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1557 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003994.29589 | 2099192.81462 | 37.7442097715744 | -122.42885628561001 | (37.7442097715744, -122.42885628561) | |||
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) | |||
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) | |||
170283 | 170283 | 234385 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 384 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004737.93375 | 2109866.7423400003 | 37.773559918201606 | -122.427045042888 | (37.7735599182016, -122.427045042888) | |||
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) | |||
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) | |||
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) | |||
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) | |||
130104 | 130104 | 210913 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1800 18th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5990641.4505900005 | 2103071.06132 | 37.754093605056795 | -122.47531013997101 | (37.7540936050568, -122.475310139971) | |||
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) | |||
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) | |||
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) | |||
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) |
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");