Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||
| 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 | ||||||||
| 22823 | 22823 | 251110 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 22824 | 22824 | 251112 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 14 | Median : 22 | 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 | ||||||||||
| 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) | ||||
| 59904 | 59904 | 187497 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6005151.09396 | 2086478.68565 | 37.7093649785846 | -122.42395239669399 | (37.7093649785846, -122.423952396694) | ||||
| 163407 | 163407 | 187499 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005135.10052 | 2086491.02363 | 37.7093979531098 | -122.42400854947999 | (37.7093979531098, -122.42400854948) | ||||
| 48420 | 48420 | 187504 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Walbridge St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6005101.69485 | 2086503.71935 | 37.7094309267755 | -122.424124907354 | (37.7094309267755, -122.424124907354) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 32439 | 32439 | 194391 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 828x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 5ft | 6014866.8225 | 2088973.5540099998 | 37.7167591360948 | -122.39054719349899 | (37.7167591360948, -122.390547193499) | |||
| 30035 | 30035 | 194392 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 860x Jamestown Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 6014755.052209999 | 2089115.5775900001 | 37.7171429037943 | -122.39094345187799 | (37.7171429037943, -122.390943451878) | |||
| 151174 | 151174 | 194393 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 860x Jamestown Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 5ft | 6014647.11529 | 2089218.63866 | 37.7174198994758 | -122.391323741894 | (37.7174198994758, -122.391323741894) | |||
| 41784 | 41784 | 194394 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 920x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 5ft | 6014490.42947 | 2089308.0420799998 | 37.717656686497506 | -122.39187158462799 | (37.7176566864975, -122.391871584628) | |||
| 183995 | 183995 | 194395 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 920x Jamestown Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 5ft | 6014427.53162 | 2089348.9061599998 | 37.7177653992236 | -122.392091851971 | (37.7177653992236, -122.392091851971) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 80229 | 80229 | 18563 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
| 85028 | 85028 | 18558 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
| 86395 | 86395 | 18554 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
| 94802 | 94802 | 18548 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
| 16811 | 16811 | 18551 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014649.71614 | 2095074.3239900002 | 37.733498586072294 | -122.391723949223 | (37.7334985860723, -122.391723949223) | |||
| 16768 | 16768 | 18555 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014626.04256 | 2095092.9200799998 | 37.733548332979105 | -122.39180709603201 | (37.7335483329791, -122.391807096032) | |||
| 13621 | 13621 | 18556 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014603.96741 | 2095108.67042 | 37.7335903547148 | -122.391884517749 | (37.7335903547148, -122.391884517749) | |||
| 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) | ||||
| 16559 | 16559 | 18559 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014565.4208 | 2095135.4289 | 37.733661688034104 | -122.392019656183 | (37.7336616880341, -122.392019656183) | |||
| 14049 | 14049 | 18560 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014546.06488 | 2095149.2171099999 | 37.7336984729967 | -122.392087539714 | (37.7336984729967, -122.392087539714) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 166815 | 166815 | 194285 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6014471.94536 | 2095201.4069599998 | 37.7338376601657 | -122.39234744377701 | (37.7338376601657, -122.392347443777) | ||||
| 150397 | 150397 | 194286 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 6014450.16973 | 2095221.3993900002 | 37.7338913460907 | -122.392424127176 | (37.7338913460907, -122.392424127176) | ||||
| 39870 | 39870 | 194287 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6014435.322380001 | 2095233.3766599998 | 37.733923408722795 | -122.392476296866 | (37.7339234087228, -122.392476296866) | ||||
| 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) | ||||
| 58702 | 58702 | 194289 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 6014396.14271 | 2095264.76436 | 37.734007417094 | -122.39261394888901 | (37.734007417094, -122.392613948889) | ||||
| 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) | |||
| 70141 | 70141 | 194290 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 40 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6014381.3022300005 | 2095272.57767 | 37.7340280466394 | -122.39266580380101 | (37.7340280466394, -122.392665803801) | ||||
| 54354 | 54354 | 194291 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6014364.32912 | 2095287.3135099998 | 37.7340675655682 | -122.39272551607701 | (37.7340675655682, -122.392725516077) | ||||
| 27134 | 27134 | 194292 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 43 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6014354.24031 | 2095291.86255 | 37.734079495961396 | -122.392760714642 | (37.7340794959614, -122.392760714642) | ||||
| 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) | |||
| 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) | ||||
| 54350 | 54350 | 194294 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 49 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6014297.19865 | 2095334.47415 | 37.7341933303645 | -122.392960907318 | (37.7341933303645, -122.392960907318) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 171992 | 171992 | 218157 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1396 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 44 | 5993196.82548 | 2097677.0995099996 | 37.7394309459859 | -122.46608116671001 | (37.7394309459859, -122.46608116671) | ||||
| 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) | ||||
| 80018 | 80018 | 25143 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
| 99831 | 99831 | 25146 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
| 103351 | 103351 | 25147 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
| 113894 | 113894 | 25144 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
| 122371 | 122371 | 25145 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
| 19402 | 19402 | 25141 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005346.329580001 | 2097965.45382 | 37.740916150253604 | -122.424093974258 | (37.7409161502536, -122.424093974258) | |||
| 19258 | 19258 | 25140 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005337.960390001 | 2097982.3892099997 | 37.74096217846979 | -122.424124115947 | (37.7409621784698, -122.424124115947) | |||
| 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) | |||
| 47964 | 47964 | 234371 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6005338.50183 | 2098008.71997 | 37.7410345073494 | -122.42412411595 | (37.7410345073494, -122.42412411595) | ||||
| 148964 | 148964 | 234370 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6005335.592730001 | 2098044.06455 | 37.7411313913144 | -122.42413668757 | (37.7411313913144, -122.42413668757) | ||||
| 68375 | 68375 | 234369 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6005339.90624 | 2098058.76544 | 37.7411720001789 | -122.42412281821899 | (37.7411720001789, -122.424122818219) | ||||
| 173622 | 173622 | 234381 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Eugenia Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6006554.5281 | 2098105.53483 | 37.74136892295 | -122.41992640079599 | (37.74136892295, -122.419926400796) | ||||
| 123736 | 123736 | 234368 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6005333.75186 | 2098133.92444 | 37.7413780222889 | -122.42414944174 | (37.7413780222889, -122.42414944174) | ||||
| 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) | |||
| 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) | |||
| 94540 | 94540 | 106114 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1752X DOLORES ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6005197.0 | 2098194.1 | 37.741535528464496 | -122.424626562024 | (37.7415355284645, -122.424626562024) | |||||
| 17005 | 17005 | 25139 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005326.84877 | 2098252.91312 | 37.741704348480795 | -122.42418177058599 | (37.7417043484808, -122.424181770586) | |||
| 78381 | 78381 | 23674 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 319 Virginia Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 12 | 6006936.2458165 | 2098250.5638735 | 37.741788638281996 | -122.418616833275 | (37.741788638282, -122.418616833275) | |||
| 21419 | 21419 | 25138 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005319.278030001 | 2098285.9295200002 | 37.7417945765605 | -122.424210295287 | (37.7417945765605, -122.424210295287) |
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");