Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
131575 | 131575 | 132122 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6014219.48603 | 2117650.76237 | 37.7954646414426 | -122.39479193780599 | (37.7954646414426, -122.394791937806) | |||
131945 | 131945 | 194301 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 550 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6014450.94814 | 2117319.50323 | 37.794567948092606 | -122.393967833244 | (37.7945679480926, -122.393967833244) | |||
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) | |||
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) | |||
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) | |||
138450 | 138450 | 28224 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
138478 | 138478 | 24290 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 386 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X17 | 6000963.19469 | 2086697.3561200001 | 37.709728074949204 | -122.43844208303699 | (37.7097280749492, -122.438442083037) | |||
139057 | 139057 | 28221 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X King St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.39616741711599 | (37.7745060991794, -122.396167417116) | ||||
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) | |||
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) | |||
157078 | 157078 | 120819 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 101 20th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 5989573.42956 | 2114582.3778 | 37.7856385654779 | -122.47984587101999 | (37.7856385654779, -122.47984587102) | |||
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) | |||
159189 | 159189 | 234375 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 9ft | 6004995.06327 | 2105009.72546 | 37.760238249920604 | -122.425809806971 | (37.7602382499206, -122.425809806971) | |||
162909 | 162909 | 194305 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 500 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 5ft | 6014543.5989 | 2117243.74376 | 37.7943650790379 | -122.393641942341 | (37.7943650790379, -122.393641942341) | |||
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) | |||
163255 | 163255 | 132126 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6014272.27117 | 2117547.1339 | 37.7951830367225 | -122.394602030674 | (37.7951830367225, -122.394602030674) | |||
163649 | 163649 | 132127 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 640 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6014286.02329 | 2117523.57721 | 37.79511912011571 | -122.39455279549401 | (37.7951191201157, -122.394552795494) | |||
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) | |||
173668 | 173668 | 194302 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 550 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 5ft | 6014474.29881 | 2117301.48742 | 37.7945197786065 | -122.393885774627 | (37.7945197786065, -122.393885774627) | |||
174857 | 174857 | 234391 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1600 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6005241.74432 | 2098978.16752 | 37.743690926593295 | -122.424527610268 | (37.7436909265933, -122.424527610268) | |||
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) | |||
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) | |||
179975 | 179975 | 234373 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 581 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 9ft | 6004999.25531 | 2105001.6441599997 | 37.76021629747461 | -122.42579473344401 | (37.7602162974746, -122.425794733444) | |||
181231 | 181231 | 234403 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 175 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 6ft | 6006066.151819999 | 2108969.9418900004 | 37.771172536524794 | -122.42238679931101 | (37.7711725365248, -122.422386799311) | |||
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) | |||
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) | |||
185824 | 185824 | 234392 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1379 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 7ft | 6005257.78896 | 2100266.47383 | 37.7472292273428 | -122.424563754022 | (37.7472292273428, -122.424563754022) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
35628 | 35628 | 210924 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1540 Plymouth Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | Width 3ft | 5995827.117740001 | 2094309.51389 | 37.730335772973206 | -122.45674334043699 | (37.7303357729732, -122.456743340437) | |||
35925 | 35925 | 234399 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 319 Virginia Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | Width 3ft | 6006918.01461 | 2098154.19018 | 37.7415229912067 | -122.418673038125 | (37.7415229912067, -122.418673038125) | |||
39528 | 39528 | 194389 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | 6013123.75243 | 2089902.89375 | 37.7192140640518 | -122.396637279208 | (37.7192140640518, -122.396637279208) | ||||
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) | |||
42834 | 42834 | 194390 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | 6013152.66051 | 2089880.8718700001 | 37.719155205216104 | -122.396535811395 | (37.7191552052161, -122.396535811395) | ||||
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) | |||
48345 | 48345 | 194388 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1031 Key Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | 6013107.94825 | 2089911.6587099999 | 37.7192372512804 | -122.39669252276501 | (37.7192372512804, -122.396692522765) | ||||
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) | ||||
57644 | 57644 | 210918 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 Kingston St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 4ft | 5994017.59782 | 2099245.20708 | 37.7437838949233 | -122.463357080672 | (37.7437838949233, -122.463357080672) | |||
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) | |||
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) | |||
70473 | 70473 | 210915 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 587 Dewey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | Width 4ft | 5994038.34106 | 2099299.34237 | 37.743933731866605 | -122.463289283487 | (37.7439337318666, -122.463289283487) | |||
72691 | 72691 | 234342 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 500 Dolores St | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 6ft | 6004943.9168300005 | 2104413.64545 | 37.7585986644128 | -122.425944266413 | (37.7585986644128, -122.425944266413) | |||
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) | |||
123442 | 123442 | 210919 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 Kingston St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 4ft | 5994015.85922 | 2099234.22929 | 37.7437536525071 | -122.463362295833 | (37.7437536525071, -122.463362295833) | |||
149367 | 149367 | 234380 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1001 San Jose Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6005142.82168 | 2096774.43039 | 37.7376343766353 | -122.424712922782 | (37.7376343766353, -122.424712922782) | |||
151219 | 151219 | 210920 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 Kingston St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 4ft | 5994018.2668699995 | 2099229.1721099997 | 37.7437399054734 | -122.463353603909 | (37.7437399054734, -122.463353603909) | |||
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) | |||
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) | ||||
162688 | 162688 | 210917 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 Kingston St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 4ft | 5994023.9222099995 | 2099259.0924400003 | 37.7438223849926 | -122.46333621999399 | (37.7438223849926, -122.463336219994) | |||
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) | ||||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | |||
22823 | 22823 | 251110 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22825 | 22825 | 251109 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22828 | 22828 | 251115 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 19 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22831 | 22831 | 251116 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22832 | 22832 | 251108 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22833 | 22833 | 251113 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 15 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22838 | 22838 | 251111 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
22839 | 22839 | 251114 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 16 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
23802 | 23802 | 132129 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6013671.61354 | 2118630.60451 | 37.79812457884061 | -122.39675640879999 | (37.7981245788406, -122.3967564088) | |||
24494 | 24494 | 233935 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150x Dolores St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6004826.52958 | 2107279.95522 | 37.766462234780604 | -122.426554344032 | (37.7664622347806, -122.426554344032) | ||||
25048 | 25048 | 132103 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 10ft | 6012095.78368 | 2120981.89347 | 37.8044928149639 | -122.402374687645 | (37.8044928149639, -122.402374687645) | |||
25236 | 25236 | 194362 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6016123.073030001 | 2114362.8388099996 | 37.786542411639 | -122.38797559828899 | (37.786542411639, -122.387975598289) | |||
25390 | 25390 | 132077 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012714.4120000005 | 2120058.1365799997 | 37.8019909162964 | -122.400168938451 | (37.8019909162964, -122.400168938451) | |||
25996 | 25996 | 194361 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6016114.70966 | 2114269.45463 | 37.786285536482296 | -122.38799801482 | (37.7862855364823, -122.38799801482) | |||
26160 | 26160 | 194311 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 7ft | 6015171.2298099995 | 2116694.38601 | 37.79289152546961 | -122.39143182424401 | (37.7928915254696, -122.391431824244) | |||
27134 | 27134 | 194292 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 43 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6014354.24031 | 2095291.86255 | 37.734079495961396 | -122.392760714642 | (37.7340794959614, -122.392760714642) | ||||
27286 | 27286 | 132113 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6013330.52243 | 2119204.92075 | 37.7996825238869 | -122.39797700193701 | (37.7996825238869, -122.397977001937) | |||
27329 | 27329 | 194334 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015942.04821 | 2112270.67914 | 37.7807877820727 | -122.388455820993 | (37.7807877820727, -122.388455820993) | |||
27355 | 27355 | 234354 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6004979.813630001 | 2104508.3497200003 | 37.7588607286626 | -122.425826859935 | (37.7588607286626, -122.425826859935) | ||||
27594 | 27594 | 194293 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 46 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6014318.796490001 | 2095319.19207 | 37.7341525685742 | -122.392885167337 | (37.7341525685742, -122.392885167337) | ||||
29064 | 29064 | 194335 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015932.5598 | 2112347.87113 | 37.7809992081901 | -122.38849403588999 | (37.7809992081901, -122.38849403589) | |||
29492 | 29492 | 194379 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015888.45756 | 2115624.95631 | 37.7899948982019 | -122.388875463533 | (37.7899948982019, -122.388875463533) | |||
30823 | 30823 | 132092 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011191.46105 | 2121714.3637599996 | 37.806453474602 | -122.405555813649 | (37.806453474602, -122.405555813649) | |||
32862 | 32862 | 132075 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012816.85763 | 2119903.53523 | 37.8015721299035 | -122.399803563704 | (37.8015721299035, -122.399803563704) | |||
33156 | 33156 | 234362 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6005144.45634 | 2101528.47617 | 37.7506879938715 | -122.425045428228 | (37.7506879938715, -122.425045428228) | ||||
33192 | 33192 | 194377 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6016027.16358 | 2115370.7776 | 37.789304668530896 | -122.388377800289 | (37.7893046685309, -122.388377800289) | |||
35273 | 35273 | 233937 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 230x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 6004843.94175 | 2106947.59382 | 37.7655506342911 | -122.42647045077801 | (37.7655506342911, -122.426470450778) | ||||
35368 | 35368 | 194364 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6016200.86003 | 2114659.13107 | 37.78736027221179 | -122.387727152497 | (37.7873602722118, -122.387727152497) | |||
35608 | 35608 | 194288 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6014411.93404 | 2095259.01392 | 37.733992504551296 | -122.392558950849 | (37.7339925045513, -122.392558950849) | ||||
35716 | 35716 | 194337 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6015953.29851 | 2112409.5704799998 | 37.781169770014294 | -122.38842659752198 | (37.7811697700143, -122.388426597522) | |||
35928 | 35928 | 194284 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6014504.15008 | 2095180.2076400002 | 37.733781239407 | -122.392234619349 | (37.733781239407, -122.392234619349) | ||||
37174 | 37174 | 132080 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 6012562.54875 | 2120282.53748 | 37.802598598112 | -122.40071023410101 | (37.802598598112, -122.400710234101) | |||
38595 | 38595 | 234356 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004985.9304599995 | 2104422.99085 | 37.7586266989802 | -122.42579962935301 | (37.7586266989802, -122.425799629353) | ||||
39870 | 39870 | 194287 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6014435.322380001 | 2095233.3766599998 | 37.733923408722795 | -122.392476296866 | (37.7339234087228, -122.392476296866) | ||||
41054 | 41054 | 194324 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 7ft | 6014719.872819999 | 2117222.0655900002 | 37.7943153492131 | -122.39303049145701 | (37.7943153492131, -122.393030491457) | |||
41120 | 41120 | 233936 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 230x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6004841.8872 | 2106976.70647 | 37.7656304545194 | -122.42647963012699 | (37.7656304545194, -122.426479630127) |
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");