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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34606 | 34606 | 178520 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 74 Kelloch Ave | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6008160.20585 | 2086291.9091900003 | 37.7090215544595 | -122.413539180899 | (37.7090215544595, -122.413539180899) | |||
| 70765 | 70765 | 178552 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 80 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008167.33564 | 2086292.8160599999 | 37.7090244448819 | -122.413514603312 | (37.7090244448819, -122.413514603312) | |||
| 111059 | 111059 | 108382 | Undocumented 2 | Tree(s) :: 17 | 30 CASTILLO ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6x12 | 6006869.1 | 2086298.1 | 37.7089659714277 | -122.418001881162 | (37.7089659714277, -122.418001881162) | ||||
| 150256 | 150256 | 178521 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 90 Kelloch Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6008137.560430001 | 2086303.76828 | 37.7090528454867 | -122.413618285264 | (37.7090528454867, -122.413618285264) | |||
| 156268 | 156268 | 177815 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 520 Carter St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6005230.32972 | 2086303.80615 | 37.708889269593705 | -122.42366611910299 | (37.7088892695937, -122.423666119103) | ||||
| 27333 | 27333 | 180168 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5935 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996569.70599 | 2086304.01805 | 37.7083971704608 | -122.453598302421 | (37.7083971704608, -122.453598302421) | |||
| 182795 | 182795 | 177819 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009193.28856 | 2086304.97531 | 37.709115386123 | -122.40996960262501 | (37.709115386123, -122.409969602625) | |||
| 52762 | 52762 | 71598 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 126 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 9 | 5994743.91592 | 2086305.62835 | 37.70829675666771 | -122.45990852057301 | (37.7082967566677, -122.459908520573) | ||
| 160633 | 160633 | 176276 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 62 Tomaso Ct | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 8ft | 6009192.32266 | 2086308.3659400002 | 37.7091246419674 | -122.40997318013201 | (37.7091246419674, -122.409973180132) | |||
| 167412 | 167412 | 178553 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 90 Kelloch Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008120.85709 | 2086313.06742 | 37.7090774410456 | -122.413676671965 | (37.7090774410456, -122.413676671965) | |||
| 60266 | 60266 | 177814 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 520 Carter St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6005234.109619999 | 2086313.99971 | 37.70891747232 | -122.423653779491 | (37.70891747232, -122.423653779491) | ||||
| 116815 | 116815 | 102841 | Undocumented 2 | Tree(s) :: 17 | 5 Canyon Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2013 12:00:00 AM | Permit Number 770737 | 6003515.0 | 2086316.0 | 37.7088257745465 | -122.429595407579 | (37.7088257745465, -122.429595407579) | |||
| 148750 | 148750 | 177906 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 345 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008626.38347 | 2086318.08135 | 37.709119583283204 | -122.411929844982 | (37.7091195832832, -122.411929844982) | |||
| 180877 | 180877 | 175103 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 56 Tomaso Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009154.75517 | 2086318.89701 | 37.709151452539004 | -122.410103762579 | (37.709151452539, -122.410103762579) | |||
| 35802 | 35802 | 71599 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 130 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994726.40181 | 2086320.41636 | 37.7083363538073 | -122.45997012143101 | (37.7083363538073, -122.459970121431) | ||
| 177259 | 177259 | 175096 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 56 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6009154.581590001 | 2086320.62957 | 37.7091562000666 | -122.410104484734 | (37.7091562000666, -122.410104484734) | |||
| 34590 | 34590 | 178546 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 304 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008580.640819999 | 2086320.97824 | 37.709124971097296 | -122.412088143666 | (37.7091249710973, -122.412088143666) | |||
| 168228 | 168228 | 178515 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 304 Schwerin St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 5ft | 6008576.98547 | 2086321.37555 | 37.709125856931706 | -122.41210080521601 | (37.7091258569317, -122.412100805216) | |||
| 166675 | 166675 | 178558 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 525 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6007875.12546 | 2086323.01846 | 37.7090909623615 | -122.414526663487 | (37.7090909623615, -122.414526663487) | |||
| 4188 | 4188 | 181057 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5931 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:33:00 PM | 3 | Width 3ft | 5996618.07355 | 2086323.26043 | 37.7084527782463 | -122.453432527712 | (37.7084527782463, -122.453432527712) | ||
| 156682 | 156682 | 175042 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 98 San Diego Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | 5992757.09235 | 2086323.81583 | 37.7082322293939 | -122.466776470378 | (37.7082322293939, -122.466776470378) | ||||
| 168435 | 168435 | 176111 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 64 | 6005239.18473 | 2086329.3019599998 | 37.7089597755375 | -122.423637326411 | (37.7089597755375, -122.423637326411) | ||||
| 115840 | 115840 | 176282 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 35 Tomaso Ct | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 3ft | 6009202.48899 | 2086331.0577900002 | 37.709187518951296 | -122.40993964441401 | (37.7091875189513, -122.409939644414) | |||
| 137279 | 137279 | 73608 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 136 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 14 | 5994710.3414 | 2086333.6948099998 | 37.7083718896252 | -122.46002658894899 | (37.7083718896252, -122.460026588949) | ||
| 42963 | 42963 | 113115 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 81845 | 81845 | 113126 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 82974 | 82974 | 113119 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 84245 | 84245 | 113122 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1x TOMASO CT | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 84522 | 84522 | 113121 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1x TOMASO CT | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 85460 | 85460 | 113113 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1x TOMASO CT | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 88545 | 88545 | 113118 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 94966 | 94966 | 113130 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 95231 | 95231 | 113127 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 97630 | 97630 | 113116 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 1x TOMASO CT | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 100041 | 100041 | 113128 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 109788 | 109788 | 113131 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 109839 | 109839 | 113123 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 120329 | 120329 | 113129 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 126278 | 126278 | 113114 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1x TOMASO CT | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 138402 | 138402 | 113117 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 141988 | 141988 | 113120 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1x TOMASO CT | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 173412 | 173412 | 178557 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 520 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6007843.02927 | 2086335.9512200002 | 37.709124669828796 | -122.41463850766199 | (37.7091246698288, -122.414638507662) | |||
| 28269 | 28269 | 178750 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 52 Tomaso Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009169.8221 | 2086336.97845 | 37.709201944987605 | -122.410052964391 | (37.7092019449876, -122.410052964391) | |||
| 40286 | 40286 | 178844 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 52 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 2ft | 6009171.05644 | 2086338.49099 | 37.7092061672978 | -122.410048805012 | (37.7092061672978, -122.410048805012) | |||
| 77276 | 77276 | 176283 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 35 Tomaso Ct | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 6009206.42472 | 2086339.2337599997 | 37.7092101890802 | -122.40992661863999 | (37.7092101890802, -122.40992661864) | |||
| 4180 | 4180 | 180661 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 551 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 01:41:00 PM | 3 | Width 5ft | 6002181.0 | 2086340.0 | 37.7088160489029 | -122.434207604104 | (37.7088160489029, -122.434207604104) | ||
| 25780 | 25780 | 178245 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 62 Tomaso Ct | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 39 | Width 8ft | 6009206.68729 | 2086340.63676 | 37.7092140561483 | -122.409925810128 | (37.7092140561483, -122.409925810128) | |||
| 173162 | 173162 | 178509 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 515 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007885.078480001 | 2086346.0784099998 | 37.7091548393851 | -122.41449389489901 | (37.7091548393851, -122.414493894899) | |||
| 183973 | 183973 | 176110 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 47 | 6005248.37143 | 2086351.63031 | 37.709021603021604 | -122.423607162245 | (37.7090216030216, -122.423607162245) | ||||
| 159957 | 159957 | 71600 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 136 Wilson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994689.24707 | 2086354.8441299999 | 37.708428747449204 | -122.460101024051 | (37.7084287474492, -122.460101024051) | ||
| 131663 | 131663 | 178559 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 505 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6007887.65657 | 2086358.0557400002 | 37.7091878714972 | -122.414485831553 | (37.7091878714972, -122.414485831553) | |||
| 63245 | 63245 | 71602 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 149 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994628.01123 | 2086360.41662 | 37.7084405258897 | -122.46031306439899 | (37.7084405258897, -122.460313064399) | ||
| 11387 | 11387 | 104350 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 349 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5999840.77458 | 2086361.4281900001 | 37.708741782568104 | -122.44229725703 | (37.7087417825681, -122.44229725703) | |||
| 150864 | 150864 | 178273 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 98 San Diego Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5992768.65673 | 2086361.85687 | 37.708337348457896 | -122.46673926632499 | (37.7083373484579, -122.466739266325) | ||||
| 55464 | 55464 | 74182 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 138 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994679.00139 | 2086362.0842900001 | 37.7084480379267 | -122.46013695827 | (37.7084480379267, -122.46013695827) | ||
| 24565 | 24565 | 176109 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6005252.95246 | 2086362.20208 | 37.7090508894465 | -122.42359208063299 | (37.7090508894465, -122.423592080633) | ||||
| 162639 | 162639 | 177639 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5900 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 4ft | 5996554.50989 | 2086363.6080900002 | 37.708559919867895 | -122.45365512159799 | (37.7085599198679, -122.453655121598) | |||
| 157289 | 157289 | 178971 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 509 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010024.16897 | 2086365.7166900001 | 37.7093287026266 | -122.407102219496 | (37.7093287026266, -122.407102219496) | |||
| 176020 | 176020 | 178272 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | Width 3ft | 6009218.69223 | 2086367.8804 | 37.709289534449894 | -122.409886240875 | (37.7092895344499, -122.409886240875) | |||
| 134907 | 134907 | 176619 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 375 Hanover St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 5999272.06122 | 2086368.18274 | 37.7087278988324 | -122.444263284724 | (37.7087278988324, -122.444263284724) | |||
| 184151 | 184151 | 178510 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 505 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6007893.56338 | 2086370.2440099998 | 37.709221669809104 | -122.414466278505 | (37.7092216698091, -122.414466278505) | |||
| 24631 | 24631 | 176638 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 65 Santa Barbara Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5993323.454919999 | 2086371.47099 | 37.7083957495352 | -122.46482253315399 | (37.7083957495352, -122.464822533154) | |||
| 172551 | 172551 | 176108 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 520 Carter St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 6005255.13814 | 2086372.0334299998 | 37.7090780076251 | -122.4235852251 | (37.7090780076251, -122.4235852251) | ||||
| 65128 | 65128 | 73960 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 138 Wilson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994666.9696 | 2086372.6899 | 37.7084764663958 | -122.46017930913601 | (37.7084764663958, -122.460179309136) | ||
| 41427 | 41427 | 177907 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 345 Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008650.42437 | 2086374.37251 | 37.7092754960461 | -122.411850730737 | (37.7092754960461, -122.411850730737) | |||
| 60858 | 60858 | 177640 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5900 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 4ft | 5996580.5488 | 2086374.8113099998 | 37.7085921740666 | -122.453565936738 | (37.7085921740666, -122.453565936738) | |||
| 48879 | 48879 | 177820 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009221.96633 | 2086380.57337 | 37.7093245702546 | -122.409875820418 | (37.7093245702546, -122.409875820418) | |||
| 54550 | 54550 | 178562 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 480 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6007827.05834 | 2086383.84807 | 37.709255287375996 | -122.414697093097 | (37.709255287376, -122.414697093097) | |||
| 136095 | 136095 | 71601 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 138 Wilson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994653.0975 | 2086384.07363 | 37.708506925528795 | -122.46022807666401 | (37.7085069255288, -122.460228076664) | ||
| 152808 | 152808 | 180169 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5921 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996782.55272 | 2086390.1360799999 | 37.7086458303022 | -122.45286889471001 | (37.7086458303022, -122.45286889471) | |||
| 38147 | 38147 | 177908 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 345 Schwerin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008656.15761 | 2086392.69055 | 37.7093261152759 | -122.411832209211 | (37.7093261152759, -122.411832209211) | |||
| 55681 | 55681 | 178511 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 541 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6007882.79465 | 2086395.27125 | 37.7092897844697 | -122.414505266807 | (37.7092897844697, -122.414505266807) | |||
| 166470 | 166470 | 178560 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 445 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6007876.17075 | 2086399.2113299998 | 37.7093002309861 | -122.414528438753 | (37.7093002309861, -122.414528438753) | |||
| 32710 | 32710 | 178563 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 480 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6007783.22647 | 2086400.60158 | 37.70929882625379 | -122.414849768326 | (37.7092988262538, -122.414849768326) | |||
| 45077 | 45077 | 177085 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 466 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012392.66028 | 2086405.7608400001 | 37.7095709179289 | -122.39891908764099 | (37.7095709179289, -122.398919087641) | |||
| 48922 | 48922 | 181271 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 40 Tomaso Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6009195.7252 | 2086405.87787 | 37.7093925805717 | -122.409968299499 | (37.7093925805717, -122.409968299499) | |||
| 30518 | 30518 | 179954 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 40 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 2ft | 6009197.20014 | 2086405.9588 | 37.709392885454 | -122.409963207553 | (37.709392885454, -122.409963207553) | |||
| 1556 | 1556 | 251583 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 75 Rice St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995352.0 | 2086409.0 | 37.7086155444167 | -122.45781440192499 | (37.7086155444167, -122.457814401925) | |||||
| 69667 | 69667 | 175035 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 177 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010415.17043 | 2086409.0149299998 | 37.70946946450071 | -122.405753896527 | (37.7094694645007, -122.405753896527) | |||
| 159797 | 159797 | 177909 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 345 Schwerin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008661.36431 | 2086409.07843 | 37.7093714051391 | -122.411815371178 | (37.7093714051391, -122.411815371178) | |||
| 154364 | 154364 | 178512 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 439 Argonaut Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6007843.62507 | 2086410.5828099998 | 37.7093296262441 | -122.41464172634599 | (37.7093296262441, -122.414641726346) | |||
| 90824 | 90824 | 73959 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 75 Rice St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1995 12:00:00 AM | 4 | 2x4 | Permit Number 773591 | 5995358.56494273 | 2086411.36688337 | 37.7086224204841 | -122.457791883945 | (37.7086224204841, -122.457791883945) | |
| 146195 | 146195 | 71596 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 75 Rice St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1995 12:00:00 AM | 12 | 2x3 | 5995358.56494273 | 2086411.36688337 | 37.7086224204841 | -122.457791883945 | (37.7086224204841, -122.457791883945) | ||
| 26302 | 26302 | 178561 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 439 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6007844.07465 | 2086412.1441 | 37.709333938483205 | -122.414640282934 | (37.7093339384832, -122.414640282934) | |||
| 28678 | 28678 | 179035 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 178 Desmond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010379.06325 | 2086412.1514400002 | 37.709476057444796 | -122.40587891040899 | (37.7094760574448, -122.405878910409) | |||
| 46024 | 46024 | 177585 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 51 Melra Ct | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 5ft | 6008966.99196 | 2086413.05326 | 37.7093994603862 | -122.410759348591 | (37.7093994603862, -122.410759348591) | |||
| 171587 | 171587 | 179814 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 522 Sunnydale Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6010066.66697 | 2086413.12079 | 37.7094612429124 | -122.406958677794 | (37.7094612429124, -122.406958677794) | ||||
| 31653 | 31653 | 175608 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 466 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6012381.21088 | 2086413.92424 | 37.709592695022295 | -122.398959231579 | (37.7095926950223, -122.398959231579) | |||
| 154599 | 154599 | 177647 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451 Tocoloma Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 5ft | 6012423.949469999 | 2086414.60679 | 37.7095969506192 | -122.398811566514 | (37.7095969506192, -122.398811566514) | |||
| 33909 | 33909 | 178753 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 288 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008616.33006 | 2086415.6536599998 | 37.7093869328198 | -122.41197148180099 | (37.7093869328198, -122.411971481801) | |||
| 177503 | 177503 | 178590 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 162 Garrison Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008387.31542 | 2086415.8204700002 | 37.70937453926629 | -122.412763008431 | (37.7093745392663, -122.412763008431) | |||
| 165737 | 165737 | 178848 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 284 Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008617.09448 | 2086417.42045 | 37.709391826951105 | -122.411968964603 | (37.7093918269511, -122.411968964603) | |||
| 75585 | 75585 | 178565 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 460 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007731.20011 | 2086418.54573 | 37.7093451736989 | -122.41503084952 | (37.7093451736989, -122.41503084952) | |||
| 157209 | 157209 | 179360 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 522 Sunnydale Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | 6010043.89457 | 2086419.58682 | 37.709477722997 | -122.40703783884399 | (37.709477722997, -122.407037838844) | ||||
| 63565 | 63565 | 178691 | Undocumented 2 | Prunus armeniaca :: Apricot 259 | 549 Cordova St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6002129.66344 | 2086422.5793700002 | 37.709039879958 | -122.43439093020099 | (37.709039879958, -122.434390930201) | |||
| 155933 | 155933 | 177910 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 345 Schwerin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008668.51888 | 2086425.42684 | 37.7094166958987 | -122.41179179815201 | (37.7094166958987, -122.411791798152) | |||
| 45207 | 45207 | 178692 | Undocumented 2 | Prunus armeniaca :: Apricot 259 | 549 Cordova St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6002131.76754 | 2086425.47642 | 37.7090479540599 | -122.43438386511801 | (37.7090479540599, -122.434383865118) | |||
| 131206 | 131206 | 179380 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 77 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5993077.06779 | 2086425.7469099998 | 37.7085305695939 | -122.46567800964199 | (37.7085305695939, -122.465678009642) | |||
| 119320 | 119320 | 177821 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6009239.86768 | 2086426.74333 | 37.7094523468075 | -122.40981720709101 | (37.7094523468075, -122.409817207091) | |||
| 132730 | 132730 | 71684 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 163 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994555.12862 | 2086427.38157 | 37.7086202032335 | -122.46056980286501 | (37.7086202032335, -122.460569802865) |
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");