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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188289 | 188289 | 178905 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 320 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999575.27021 | 2086527.1037599999 | 37.7091815546459 | -122.443226763913 | (37.7091815546459, -122.443226763913) | |||
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) | |||
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) | |||
159671 | 159671 | 175338 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 248 Wilson St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5994374.45478 | 2086640.5688599998 | 37.709195169503005 | -122.461209673184 | (37.709195169503, -122.461209673184) | |||
172772 | 172772 | 177709 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 41 Rhine St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994451.68551 | 2086639.1998299998 | 37.7091958547847 | -122.460942654584 | (37.7091958547847, -122.460942654584) | |||
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) | |||
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) | |||||
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) | |||
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) | |||
56147 | 56147 | 179476 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 245 Wilson St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5994306.081069999 | 2086649.9682200002 | 37.7092170428021 | -122.461446662549 | (37.7092170428021, -122.461446662549) | ||||
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) | |||
62750 | 62750 | 175647 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 199 Shakespeare St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5993520.37631 | 2086668.28967 | 37.7092220951912 | -122.464163488366 | (37.7092220951912, -122.464163488366) | |||
64681 | 64681 | 177708 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 41 Rhine St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994462.16701 | 2086650.7454 | 37.7092281593337 | -122.460907265375 | (37.7092281593337, -122.460907265375) | |||
137396 | 137396 | 175750 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 348 Naylor St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6002816.75765 | 2086477.59625 | 37.7092299219895 | -122.43202015901899 | (37.7092299219895, -122.432020159019) | |||
30981 | 30981 | 71589 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 177 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 8 | 5994699.454059999 | 2086647.11862 | 37.7092318519263 | -122.460086907391 | (37.7092318519263, -122.460086907391) | ||
186888 | 186888 | 175547 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 348 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002373.36986 | 2086487.8856799998 | 37.709233027364995 | -122.433553309758 | (37.709233027365, -122.433553309758) | |||
130669 | 130669 | 180221 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 248 Wilson St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5994358.2246 | 2086656.8417599997 | 37.70923891700821 | -122.461266945616 | (37.7092389170082, -122.461266945616) | |||
4244 | 4244 | 180664 | Undocumented 2 | Magnolia champaca :: Champa 170 | 339 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:55:00 PM | 3 | Width 6ft | 6002468.5653 | 2086489.08528 | 37.7092417219876 | -122.43322438540399 | (37.7092417219876, -122.433224385404) | ||
48866 | 48866 | 180170 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5845 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5997301.475190001 | 2086598.6429400002 | 37.7092480658079 | -122.45109046644501 | (37.7092480658079, -122.451090466445) | |||
25522 | 25522 | 175043 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 199 Shakespeare St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 8ft | 5993498.29454 | 2086678.39145 | 37.709248559547504 | -122.464240538697 | (37.7092485595475, -122.464240538697) | |||
177290 | 177290 | 179475 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 245 Wilson St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5994292.07601 | 2086663.3492700001 | 37.7092529779255 | -122.46149603531401 | (37.7092529779255, -122.461496035314) | ||||
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) | |||
26224 | 26224 | 177707 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 41 Rhine St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5994471.04103 | 2086660.75611 | 37.709256157011794 | -122.46087732063499 | (37.7092561570118, -122.460877320635) | |||
51423 | 51423 | 180184 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5818 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 5997152.40975 | 2086607.26455 | 37.7092632032078 | -122.451606278907 | (37.7092632032078, -122.451606278907) | |||
169725 | 169725 | 175749 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 348 Naylor St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6002804.80085 | 2086492.5452299998 | 37.7092702907661 | -122.432062550353 | (37.7092702907661, -122.432062550353) | |||
4231 | 4231 | 180667 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 344 Chicago Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 01:51:00 PM | 3 | Width 6ft | 6002403.88387 | 2086502.6359 | 37.709275259527296 | -122.43344890203998 | (37.7092752595273, -122.43344890204) | ||
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) | |||
146572 | 146572 | 73606 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 40 Rhine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994431.8230800005 | 2086668.6372599998 | 37.7092755401168 | -122.461013433922 | (37.7092755401168, -122.461013433922) | ||
152452 | 152452 | 175339 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 248 Wilson St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5994341.375580001 | 2086670.8513099998 | 37.709276414241295 | -122.46132619294399 | (37.7092764142413, -122.461326192944) | |||
157475 | 157475 | 78846 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 259 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2001 12:00:00 AM | 4 | 5992056.72748 | 2086721.95578 | 37.7092849811889 | -122.46922594483101 | (37.7092849811889, -122.469225944831) | ||
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) | |||
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) | |||
67879 | 67879 | 177706 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 41 Rhine St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5994482.436290001 | 2086673.39058 | 37.709291503981795 | -122.46083885215499 | (37.7092915039818, -122.460838852155) | |||
158680 | 158680 | 177644 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5818 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5997179.78016 | 2086617.18219 | 37.7092920021922 | -122.45151239779699 | (37.7092920021922, -122.451512397797) | |||
3944 | 3944 | 251758 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 241 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 10:31:00 AM | 3 | 3x3 | 6001856.0 | 2086522.0 | 37.7092973294849 | -122.435343856961 | (37.7092973294849, -122.435343856961) | ||
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) | |||
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) | |||
163068 | 163068 | 71608 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 250 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994331.5401 | 2086682.33238 | 37.7093073724942 | -122.46136101741502 | (37.7093073724942, -122.461361017415) | ||
1830 | 1830 | 251757 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 233 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001887.0 | 2086528.0 | 37.7093155646434 | -122.43523714505 | (37.7093155646434, -122.43523714505) | ||||
1839 | 1839 | 251756 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 233 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001887.0 | 2086528.0 | 37.7093155646434 | -122.43523714505 | (37.7093155646434, -122.43523714505) | ||||
55122 | 55122 | 71593 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 34 Rhine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994443.94493 | 2086683.2861799998 | 37.70931646014839 | -122.46097260021001 | (37.7093164601484, -122.46097260021) | ||
183586 | 183586 | 180171 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5845 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5997361.4678 | 2086623.37535 | 37.709319409930394 | -122.450884905728 | (37.7093194099304, -122.450884905728) | |||
121000 | 121000 | 98352 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001689.0 | 2086535.0 | 37.709323539126004 | -122.435921964243 | (37.709323539126, -122.435921964243) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
166100 | 166100 | 71685 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 249 Wilson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994260.16312 | 2086694.7455400003 | 37.7093373478025 | -122.461608605251 | (37.7093373478025, -122.461608605251) | ||
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) | ||||
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) | |||
59244 | 59244 | 71583 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 266 Flournoy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5993925.4185 | 2086705.1573599998 | 37.7093466620935 | -122.462766282735 | (37.7093466620935, -122.462766282735) | ||
171613 | 171613 | 180183 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5810 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5997223.97549 | 2086636.40948 | 37.7093473266958 | -122.451361038275 | (37.7093473266958, -122.451361038275) | |||
47789 | 47789 | 73626 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 249 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994249.9774400005 | 2086699.51142 | 37.7093498474797 | -122.461644153659 | (37.7093498474797, -122.461644153659) | ||
164072 | 164072 | 180400 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 511 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6002102.27199 | 2086536.9163099998 | 37.709352269366995 | -122.434493768575 | (37.709352269367, -122.434493768575) | |||
4242 | 4242 | 251735 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 338 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 02:05:00 PM | 3 | 3x3 | 6002437.0 | 2086534.0 | 37.709363257317705 | -122.43333668725799 | (37.7093632573177, -122.433336687258) | ||
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) | ||||
4393 | 4393 | 71591 | Undocumented 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 187 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2017 11:19:00 AM | 3 | 5994642.6055 | 2086698.5979 | 37.709369932055004 | -122.460287110874 | (37.709369932055, -122.460287110874) | ||
4287 | 4287 | 181059 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 5810 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:37:00 PM | 3 | Width 3ft | 5997243.54219 | 2086644.28205 | 37.7093700633606 | -122.451293980329 | (37.7093700633606, -122.451293980329) | ||
63848 | 63848 | 177912 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Rhine St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994504.97936 | 2086701.6160799998 | 37.709370301666496 | -122.460762984428 | (37.7093703016665, -122.460762984428) | |||
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) | |||
166383 | 166383 | 176290 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 324 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002773.326830001 | 2086530.28935 | 37.7093721434675 | -122.43217402313101 | (37.7093721434675, -122.432174023131) | |||
10539 | 10539 | 97421 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 84 Liebig St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2011 12:00:00 AM | 3 | 6x15 | Permit Number 768371 | 5995500.38132 | 2086681.7504200002 | 37.709372977163504 | -122.457321298761 | (37.7093729771635, -122.457321298761) | |
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) | |||
59246 | 59246 | 177825 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 253 Wilson St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 10ft | 5994242.183759999 | 2086709.3481 | 37.709376408063 | -122.461671802408 | (37.709376408063, -122.461671802408) | |||
157791 | 157791 | 178455 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 35 Watt Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000205.28037 | 2086586.95186 | 37.70938178870121 | -122.441053648418 | (37.7093817887012, -122.441053648418) | |||
154839 | 154839 | 178566 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 440 Argonaut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007693.49818 | 2086433.63947 | 37.7093844992558 | -122.415162221581 | (37.7093844992558, -122.415162221581) | |||
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) | |||
68232 | 68232 | 180182 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5800 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997258.08151 | 2086650.3270400001 | 37.7093874940164 | -122.45124416598999 | (37.7093874940164, -122.45124416599) | |||
158863 | 158863 | 176275 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 23 Byron Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999165.787269999 | 2086612.0753799998 | 37.7093915094837 | -122.444648098339 | (37.7093915094837, -122.444648098339) | |||
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) | |||
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) | |||
48408 | 48408 | 187498 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005143.26682 | 2086489.02091 | 37.7093929151184 | -122.42398018305599 | (37.7093929151184, -122.423980183056) | ||||
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) | ||||
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) | |||
10115 | 10115 | 173855 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 511 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5xt | 6002114.0 | 2086554.0 | 37.7093998431938 | -122.43445445536699 | (37.7093998431938, -122.434454455367) | ||||
166770 | 166770 | 106909 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 254 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 51 | 6x6 | 6001705.95388 | 2086562.81591 | 37.709400878615796 | -122.435865357921 | (37.7094008786158, -122.435865357921) | |||
45423 | 45423 | 177824 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 253 Wilson St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 10ft | 5994231.54615 | 2086719.8133200002 | 37.7094045307537 | -122.461709325737 | (37.7094045307537, -122.461709325737) | |||
134205 | 134205 | 180181 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5800 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5997274.84313 | 2086656.60213 | 37.709405683693 | -122.451186687614 | (37.709405683693, -122.451186687614) | |||
23442 | 23442 | 187500 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005130.65162 | 2086494.3835099998 | 37.709406927448796 | -122.424024164397 | (37.7094069274488, -122.424024164397) | ||||
134081 | 134081 | 187501 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6005123.3425 | 2086496.8566299998 | 37.7094133054443 | -122.42404960170099 | (37.7094133054443, -122.424049601701) | ||||
172601 | 172601 | 117182 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 26 Watt Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000152.35367 | 2086600.7137400003 | 37.709416560993 | -122.441237557982 | (37.709416560993, -122.441237557982) |
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");