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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1851 | 1851 | 4718 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 3 | 6008205.1504 | 2120957.4944 | 37.804207866952204 | -122.415836885075 | (37.8042078669522, -122.415836885075) | |||
| 2899 | 2899 | 91782 | Permitted Site 1 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 152 | 1098 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 80 | 3x3 | Permit Number 780455 | 6010905.08721 | 2110652.14803 | 37.776063263843795 | -122.40576716423901 | (37.7760632638438, -122.405767164239) | |
| 5913 | 5913 | 23706 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 700X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 8X8 | 6003994.1877 | 2111257.6303 | 37.7773368699173 | -122.42971699343799 | (37.7773368699173, -122.429716993438) | |||
| 5917 | 5917 | 14486 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 281 Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5998954.4612 | 2111920.5161 | 37.7788703187651 | -122.447198694655 | (37.7788703187651, -122.447198694655) | |||
| 5926 | 5926 | 13119 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1641 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3x3 | 6004501.8382 | 2119760.0821 | 37.8007111944994 | -122.42856707818899 | (37.8007111944994, -122.428567078189) | |||
| 6099 | 6099 | 4714 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 3 | 6008373.9156 | 2120808.2881 | 37.8038076701269 | -122.415242289828 | (37.8038076701269, -122.415242289828) | |||
| 6819 | 6819 | 23867 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1460 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X6 | 6003686.8148 | 2113759.4476 | 37.7841888268021 | -122.430958893029 | (37.7841888268021, -122.430958893029) | |||
| 7253 | 7253 | 23719 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 780 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/1999 12:00:00 AM | 80 | 4X4 | 6004022.2052 | 2111346.6982 | 37.777583014840296 | -122.429626425718 | (37.7775830148403, -122.429626425718) | ||
| 8289 | 8289 | 4662 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 5X5 | 6009727.0981 | 2119617.2678 | 37.8006133797513 | -122.41047535239099 | (37.8006133797513, -122.410475352391) | |||
| 8403 | 8403 | 23863 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1420 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6003705.9488 | 2113626.0727 | 37.783823696929396 | -122.430883174483 | (37.7838236969294, -122.430883174483) | |||
| 8703 | 8703 | 2829 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1200 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6008547.0936900005 | 2116310.73962 | 37.7914682476113 | -122.414324580422 | (37.7914682476113, -122.414324580422) | |||
| 9376 | 9376 | 14452 | Permitted Site 1 | Tristania conferta :: 79 | 100 Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3x3 | 5998927.5567 | 2112628.8329 | 37.7808136360807 | -122.44734276226002 | (37.7808136360807, -122.44734276226) | |||
| 9826 | 9826 | 5367 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 247 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6004885.80801 | 2106938.09523 | 37.7655269200494 | -122.42632496832701 | (37.7655269200494, -122.426324968327) | |||
| 12021 | 12021 | 219 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2949 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 5X8 | 5990525.93487 | 2095591.0616 | 37.7335487664486 | -122.475163590944 | (37.7335487664486, -122.475163590944) | |||
| 14530 | 14530 | 12145 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6016306.3498599995 | 2095580.8792299998 | 37.734981307347205 | -122.386031740688 | (37.7349813073472, -122.386031740688) | |||
| 16356 | 16356 | 11215 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1050X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X4 | 6018142.31163 | 2094695.6186 | 37.732651993985705 | -122.37962262229799 | (37.7326519939857, -122.379622622298) | |||
| 16427 | 16427 | 4769 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 20 Commer Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6016624.63849 | 2094705.64307 | 37.732595693724605 | -122.384870339116 | (37.7325956937246, -122.384870339116) | |||
| 16962 | 16962 | 25071 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005127.376540001 | 2101840.69033 | 37.751544296835206 | -122.42512670443001 | (37.7515442968352, -122.42512670443) | |||
| 17131 | 17131 | 5742 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1755 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005373.18109 | 2098196.81653 | 37.741552935912 | -122.424017580443 | (37.741552935912, -122.424017580443) | |||
| 17522 | 17522 | 236 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2996X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X5 | 5990618.96661 | 2095242.77985 | 37.732597864700395 | -122.47481654436599 | (37.7325978647004, -122.474816544366) | |||
| 17686 | 17686 | 14577 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1135 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 5999374.0888 | 2108906.7208 | 37.7706191740488 | -122.445530268097 | (37.7706191740488, -122.445530268097) | |||
| 17694 | 17694 | 25052 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005070.62845 | 2102872.02457 | 37.7543728949014 | -122.42539633287 | (37.7543728949014, -122.42539633287) | |||
| 17936 | 17936 | 10282 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 359 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6004422.78828 | 2109427.83457 | 37.772336958917606 | -122.428103893873 | (37.7723369589176, -122.428103893873) | |||
| 17956 | 17956 | 5584 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1070 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 6005072.3503 | 2102110.66979 | 37.7522824891524 | -122.425336202406 | (37.7522824891524, -122.425336202406) | |||
| 18355 | 18355 | 5605 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1137 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005177.464240001 | 2101699.96728 | 37.7511607332939 | -122.424943483753 | (37.7511607332939, -122.424943483753) | |||
| 18429 | 18429 | 5662 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1359 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x3 | 6005250.93276 | 2100400.67941 | 37.747597337862004 | -122.424597007367 | (37.747597337862, -122.424597007367) | |||
| 18432 | 18432 | 25070 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005125.726319999 | 2101888.99536 | 37.751676838028395 | -122.425135847862 | (37.7516768380284, -122.425135847862) | |||
| 18446 | 18446 | 25173 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3062 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6000161.42067 | 2105438.6168299997 | 37.761141541560505 | -122.44255784368 | (37.7611415415605, -122.44255784368) | |||
| 18511 | 18511 | 10336 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 875 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3x3 | 6002010.71574 | 2109090.04543 | 37.7712727083875 | -122.43642328112101 | (37.7712727083875, -122.436423281121) | |||
| 18729 | 18729 | 4825 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 72 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 6006134.02134 | 2097745.6697400003 | 37.7403571145946 | -122.421354819194 | (37.7403571145946, -122.421354819194) | |||
| 19009 | 19009 | 5579 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1050 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005065.559280001 | 2102200.32224 | 37.7525282702792 | -122.42536606618401 | (37.7525282702792, -122.425366066184) | |||
| 19035 | 19035 | 5708 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1603 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005329.17263 | 2098980.1167599997 | 37.743701215741794 | -122.424225442544 | (37.7437012157418, -122.424225442544) | |||
| 19125 | 19125 | 28638 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.777378207850795 | -122.42957257421499 | (37.7773782078508, -122.429572574215) | |||
| 19224 | 19224 | 5582 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1064 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005071.776219999 | 2102139.99818 | 37.752362985666 | -122.425340274538 | (37.752362985666, -122.425340274538) | |||
| 19228 | 19228 | 5594 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1100 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x3 | 6005083.47223 | 2101907.17994 | 37.7517243815975 | -122.425283262017 | (37.7517243815975, -122.425283262017) | |||
| 19492 | 19492 | 25148 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6004781.85822 | 2108123.31219 | 37.7687753648286 | -122.426768919571 | (37.7687753648286, -122.426768919571) | |||
| 19687 | 19687 | 25091 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005204.68058 | 2100428.03656 | 37.7476698420965 | -122.42475889070299 | (37.7476698420965, -122.424758890703) | |||
| 20175 | 20175 | 10089 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 700 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005586.51976 | 2104851.24563 | 37.7598365074586 | -122.423752966647 | (37.7598365074586, -122.423752966647) | |||
| 20186 | 20186 | 5718 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1651 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 6005348.2159400005 | 2098686.18257 | 37.742895214531295 | -122.424138695771 | (37.7428952145313, -122.424138695771) | |||
| 20379 | 20379 | 9943 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | |||
| 20582 | 20582 | 233 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2980 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X4 | 5990616.421680001 | 2095336.99138 | 37.732856398203104 | -122.474832216845 | (37.7328563982031, -122.474832216845) | |||
| 20635 | 20635 | 5586 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1074 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005073.55005 | 2102092.66435 | 37.7522331181775 | -122.4253307723 | (37.7522331181775, -122.4253307723) | |||
| 20790 | 20790 | 25095 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300 Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005196.77931 | 2100544.39428 | 37.7479888873864 | -122.424794489489 | (37.7479888873864, -122.424794489489) | |||
| 20877 | 20877 | 5740 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1749 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005372.5481199995 | 2098218.79368 | 37.7416132444522 | -122.424021331535 | (37.7416132444522, -122.424021331535) | |||
| 20879 | 20879 | 25092 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005189.02223 | 2100681.47449 | 37.7483648399821 | -122.424831064022 | (37.7483648399821, -122.424831064022) | |||
| 20994 | 20994 | 5443 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/19/1992 12:00:00 AM | 80 | 6 | 6004908.86181 | 2105038.27798 | 37.7603117767003 | -122.426109970095 | (37.7603117767003, -122.426109970095) | ||
| 21184 | 21184 | 4827 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6006160.77573 | 2097729.74879 | 37.74031490761921 | -122.421261182679 | (37.7403149076192, -122.421261182679) | |||
| 21310 | 21310 | 5730 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1703 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x3 | 6005364.14251 | 2098372.71448 | 37.742035401517796 | -122.42406133876601 | (37.7420354015178, -122.424061338766) | |||
| 21444 | 21444 | 14592 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1222 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x3 | 5999472.8199 | 2108630.0925 | 37.7698652586639 | -122.445168866065 | (37.7698652586639, -122.445168866065) | |||
| 21503 | 21503 | 25093 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005193.32199 | 2100633.40551 | 37.7482330964805 | -122.424812776293 | (37.7482330964805, -122.424812776293) | |||
| 21504 | 21504 | 5727 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1677X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005353.56233 | 2098539.50836 | 37.742492782318 | -122.424109780756 | (37.742492782318, -122.424109780756) | |||
| 21563 | 21563 | 5331 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 121 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 6x8 | 6004849.02051 | 2107663.93155 | 37.7675178131103 | -122.42650389563299 | (37.7675178131103, -122.426503895633) | |||
| 21573 | 21573 | 10054 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 426 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X2 | 6005501.955709999 | 2106458.62904 | 37.764245228771 | -122.42415974799201 | (37.764245228771, -122.424159747992) | |||
| 21652 | 21652 | 5604 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1133 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005175.72714 | 2101732.2974900003 | 37.7512494064453 | -122.424951790803 | (37.7512494064453, -122.424951790803) | |||
| 21721 | 21721 | 25072 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005130.36391 | 2101800.2565200003 | 37.751433443721 | -122.425113497011 | (37.751433443721, -122.425113497011) | |||
| 21846 | 21846 | 5476 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 635 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6005015.06111 | 2104677.01858 | 37.7593258454205 | -122.425716962778 | (37.7593258454205, -122.425716962778) | |||
| 21888 | 21888 | 5353 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 211 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6004878.5791 | 2107096.4330599997 | 37.765961269229706 | -122.42636124607901 | (37.7659612692297, -122.426361246079) | |||
| 22041 | 22041 | 10235 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 33 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6005916.285540001 | 2109635.54908 | 37.77299167885221 | -122.42295250795401 | (37.7729916788522, -122.422952507954) | |||
| 22203 | 22203 | 5744 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1759 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005374.75018 | 2098167.6187400003 | 37.7414728539803 | -122.424010079215 | (37.7414728539803, -122.424010079215) | |||
| 22222 | 22222 | 4815 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 36 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005920.0488599995 | 2097862.788 | 37.740666628859294 | -122.42210297059799 | (37.7406666288593, -122.422102970598) | |||
| 24676 | 24676 | 25027 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 740X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6004958.5167563 | 2104022.9997464 | 37.75752686832129 | -122.425865966748 | (37.7575268683213, -122.425865966748) | |||
| 26684 | 26684 | 185578 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 80 | Width 0ft | 5984888.727999999 | 2099615.9854 | 37.744271786934796 | -122.49494941784201 | (37.7442717869348, -122.494949417842) | |||
| 29091 | 29091 | 186379 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 80 | Width 0ft | 5984812.5721 | 2102477.6444 | 37.7521246619181 | -122.495423755128 | (37.7521246619181, -122.495423755128) | |||
| 53598 | 53598 | 95407 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2X Cranleigh Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 80 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | ||||
| 55565 | 55565 | 185944 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 80 | Width 0ft | 5984848.1796 | 2101522.6398 | 37.7495045663334 | -122.49523020096001 | (37.7495045663334, -122.49523020096) | |||
| 77748 | 77748 | 11361 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1350X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6017253.696644001 | 2093959.2156363998 | 37.7305809242894 | -122.382643589629 | (37.7305809242894, -122.382643589629) | |||
| 78918 | 78918 | 332 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3402X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/2008 12:00:00 AM | 80 | 2X3 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 80368 | 80368 | 1624 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 788 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5995705.440230001 | 2110774.03064 | 37.775536193933895 | -122.45835526607401 | (37.7755361939339, -122.458355266074) | |||
| 80650 | 80650 | 23768 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1001 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6003798.77229 | 2112300.9395 | 37.7801904708611 | -122.430467458421 | (37.7801904708611, -122.430467458421) | |||
| 80856 | 80856 | 1585 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 661 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 5995607.60932 | 2111765.0412 | 37.7782516245837 | -122.458765446714 | (37.7782516245837, -122.458765446714) | |||
| 80895 | 80895 | 14438 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 15 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 5998742.700119999 | 2113096.36205 | 37.782086784697704 | -122.448015940361 | (37.7820867846977, -122.448015940361) | |||
| 81599 | 81599 | 10262 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 212 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005067.14002 | 2109566.5504900003 | 37.772754274276096 | -122.42588489611201 | (37.7727542742761, -122.425884896112) | |||
| 81675 | 81675 | 25075 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1198 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005087.7 | 2101404.7 | 37.7503449269028 | -122.425232889951 | (37.7503449269028, -122.425232889951) | |||
| 82439 | 82439 | 10255 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 140 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005448.277840001 | 2109623.5866799997 | 37.7729324136912 | -122.424570554491 | (37.7729324136912, -122.424570554491) | |||
| 82907 | 82907 | 23711 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 700X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6004027.2031566 | 2111122.3858595 | 37.776967391502296 | -122.42959313438801 | (37.7769673915023, -122.429593134388) | |||
| 83468 | 83468 | 1508 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 363 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 5995531.01478 | 2113825.6315900004 | 37.7839050536381 | -122.459179664391 | (37.7839050536381, -122.459179664391) | |||
| 83928 | 83928 | 4754 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1250 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 6007719.65165 | 2121534.5567900003 | 37.8057650284682 | -122.41755791876301 | (37.8057650284682, -122.417557918763) | |||
| 84513 | 84513 | 26639 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 6530X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1998 12:00:00 AM | 80 | 5 | 5987349.71414 | 2113973.9756400003 | 37.783838627391 | -122.48749447615101 | (37.783838627391, -122.487494476151) | ||
| 84548 | 84548 | 13398 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 332 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 5 | 5999526.1960451 | 2097456.6056762002 | 37.739188647769296 | -122.44418121753901 | (37.7391886477693, -122.444181217539) | |||
| 85336 | 85336 | 25079 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1162 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005068.3 | 2101554.8 | 37.7507559707678 | -122.42531065650499 | (37.7507559707678, -122.425310656505) | |||
| 85625 | 85625 | 382 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3721X 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 2 | 5990351.3309 | 2090950.31436 | 37.72079632016629 | -122.475428522866 | (37.7207963201663, -122.475428522866) | |||
| 86134 | 86134 | 1532 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 470X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5995618.1476548 | 2113146.4510222 | 37.782045214262205 | -122.458829030078 | (37.7820452142622, -122.458829030078) | |||
| 87130 | 87130 | 10269 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 215X Haight St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 6X12 | 6005099.693995 | 2109521.3764509996 | 37.7726320769714 | -122.42576907222299 | (37.7726320769714, -122.425769072223) | |||
| 87467 | 87467 | 10261 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X4 | 6005221.62679 | 2109603.34443 | 37.772864030808 | -122.425353127526 | (37.772864030808, -122.425353127526) | |||
| 88029 | 88029 | 5481 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 700X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 88340 | 88340 | 11272 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 89238 | 89238 | 12750 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1720 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5990071.960109999 | 2114756.1152 | 37.7861445495756 | -122.47813382493601 | (37.7861445495756, -122.478133824936) | |||
| 89398 | 89398 | 13018 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 418 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4x4 | 6010295.17865 | 2120692.75204 | 37.8035982248351 | -122.40858546229299 | (37.8035982248351, -122.408585462293) | |||
| 89424 | 89424 | 8145 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6002886.962169999 | 2111360.68278 | 37.7775570672136 | -122.43355460906601 | (37.7775570672136, -122.433554609066) | |||
| 91528 | 91528 | 12533 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 129 LAKE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 80 | 3X3 | 5995062.0 | 2114816.5 | 37.786598736379105 | -122.460874108141 | (37.7865987363791, -122.460874108141) | ||
| 92759 | 92759 | 25076 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1184 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005073.9 | 2101453.9 | 37.750479239095604 | -122.42528411198299 | (37.7504792390956, -122.425284111983) | |||
| 93138 | 93138 | 12611 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 737 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 4X4 | 5993219.0032 | 2114811.42762 | 37.7864785919076 | -122.467250004919 | (37.7864785919076, -122.467250004919) | |||
| 93699 | 93699 | 25077 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1178 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005072.5 | 2101478.6 | 37.750546980486895 | -122.42529071074 | (37.7505469804869, -122.42529071074) | |||
| 96390 | 96390 | 11261 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1145X Ingalls St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | |||
| 96497 | 96497 | 9942 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | |||
| 97100 | 97100 | 1478 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 255 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3PL | 5995470.91664 | 2114596.3439599997 | 37.7860177674927 | -122.45944341566099 | (37.7860177674927, -122.459443415661) | |||
| 97410 | 97410 | 113742 | Landmark tree 9 | Ficus macrophylla :: Morton Bay Fig 148 | 1580 Valencia St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 80 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | ||||
| 99200 | 99200 | 22800 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 5999029.37493 | 2111788.901 | 37.7785132178028 | -122.44693006588699 | (37.7785132178028, -122.446930065887) | |||
| 99687 | 99687 | 11344 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1300X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | |||
| 101813 | 101813 | 1603 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 728 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 5995692.41145 | 2111140.7732 | 37.77654242357001 | -122.458426887855 | (37.77654242357, -122.458426887855) |
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");