Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86 | 86 | 119601 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4357x Mission St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774415 | |||||||||
| 363 | 363 | 119608 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 299x Avalon Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 595 | 595 | 119606 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 299x Avalon Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 870 | 870 | 117001 | DPW Maintained 3 | :: 54 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 1177 | 1177 | 251471 | DPW Maintained 3 | Brugmansia spp :: Angel trumpet 137 | 2423 Market St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 1493 | 1493 | 103663 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 2196 | 2196 | 119600 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4357x Mission St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774415 | |||||||||
| 3723 | 3723 | 253167 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 5598 | 5598 | 103666 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 7681 | 7681 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 7764 | 7764 | 103662 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 7809 | 7809 | 119599 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4357x Mission St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774415 | |||||||||
| 7810 | 7810 | 119607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 299x Avalon Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 7834 | 7834 | 119605 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 299x Avalon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 8128 | 8128 | 87100 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 700 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 50056 | ||||||||
| 8197 | 8197 | 103668 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 8408 | 8408 | 103664 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 10665 | 10665 | 103665 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 11212 | 11212 | 103658 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 11415 | 11415 | 103667 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 12113 | 12113 | 103660 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 12440 | 12440 | 100166 | Property Tree 7 | Salix spp :: Willow 218 | 2340 Twin Peaks Blvd | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769026 | ||||||||||
| 12885 | 12885 | 103661 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 15949 | 15949 | 103659 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 16097 | 16097 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X Portola Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 16457 | 16457 | 93053 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 36 | Permit Number 53387 | |||||||||
| 19583 | 19583 | 119914 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 400X Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 100x100 | |||||||||
| 86068 | 86068 | 121227 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 4299x 17th St | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 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) | ||||
| 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) | ||||
| 77391 | 77391 | 92760 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 78407 | 78407 | 92764 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 82826 | 82826 | 92763 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 83452 | 83452 | 92762 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 86127 | 86127 | 92761 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 96352 | 96352 | 92759 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 106998 | 106998 | 92755 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 113684 | 113684 | 92767 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 116515 | 116515 | 92766 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 124823 | 124823 | 92756 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 127045 | 127045 | 92765 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 140658 | 140658 | 92758 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 144843 | 144843 | 92757 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 30008 | 30008 | 178244 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 62 Tomaso Ct | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 8ft | 6009170.0421 | 2086265.24197 | 37.7090049835504 | -122.410047143074 | (37.7090049835504, -122.410047143074) | |||
| 37802 | 37802 | 178243 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 62 Tomaso Ct | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | Width 8ft | 6009152.06447 | 2086268.0035 | 37.7090115585089 | -122.410109471469 | (37.7090115585089, -122.410109471469) | |||
| 180452 | 180452 | 177816 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 60 Tomaso Ct | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 3ft | 6009147.33252 | 2086269.1354099999 | 37.7090144012735 | -122.41012590570601 | (37.7090144012735, -122.410125905706) | |||
| 132971 | 132971 | 178242 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 62 Tomaso Ct | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 8ft | 6009144.65272 | 2086270.07017 | 37.709016817728 | -122.41013523347401 | (37.709016817728, -122.410135233474) | |||
| 183568 | 183568 | 176102 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 62 Tomaso Ct | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 8ft | 6009173.04361 | 2086270.9274900001 | 37.709020763061396 | -122.41003717048099 | (37.7090207630614, -122.410037170481) | |||
| 53016 | 53016 | 180001 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 62 Tomaso Ct | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 8ft | 6009181.15123 | 2086279.38185 | 37.709044431429604 | -122.41000974567899 | (37.7090444314296, -122.410009745679) | |||
| 999 | 999 | 251422 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 480x De Long St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992963.0 | 2086633.0 | 37.709093057147996 | -122.466087289133 | (37.709093057148, -122.466087289133) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 73009 | 73009 | 187502 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005111.53197 | 2086501.51554 | 37.7094254309976 | -122.424090751982 | (37.7094254309976, -122.424090751982) | ||||
| 60503 | 60503 | 187503 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005106.379430001 | 2086503.4563099998 | 37.7094304690223 | -122.424108697959 | (37.7094304690223, -122.424108697959) | ||||
| 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) | ||||
| 162173 | 162173 | 177805 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 62 Tomaso Ct | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 8ft | 6009236.846480001 | 2086428.13607 | 37.709456001673296 | -122.409827747151 | (37.7094560016733, -122.409827747151) | |||
| 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) | |||
| 38897 | 38897 | 177806 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 62 Tomaso Ct | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 8ft | 6009249.93875 | 2086480.54598 | 37.709600642326606 | -122.409786194885 | (37.7096006423266, -122.409786194885) | |||
| 147478 | 147478 | 177648 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451 Tocoloma Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 5ft | 6012427.630469999 | 2086427.74351 | 37.7096332265644 | -122.398799765591 | (37.7096332265644, -122.398799765591) | |||
| 136625 | 136625 | 175549 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 62 Tomaso Ct | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 8ft | 6009261.65543 | 2086500.8991200002 | 37.709657184513 | -122.40974713551901 | (37.709657184513, -122.409747135519) | |||
| 47525 | 47525 | 177649 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451 Tocoloma Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 5ft | 6012431.1901 | 2086436.64385 | 37.709657863481205 | -122.398788087022 | (37.7096578634812, -122.398788087022) | |||
| 153886 | 153886 | 177650 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451 Tocoloma Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 5ft | 6012434.26652 | 2086449.4800599997 | 37.7096932805964 | -122.39877835455201 | (37.7096932805964, -122.398778354552) | |||
| 173643 | 173643 | 187485 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 9ft | 6006777.87289 | 2086579.02758 | 37.7097322050565 | -122.41833708111 | (37.7097322050565, -122.41833708111) | |||
| 184202 | 184202 | 177807 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 62 Tomaso Ct | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 8ft | 6009274.965480001 | 2086528.64182 | 37.7097341062031 | -122.409703090337 | (37.7097341062031, -122.409703090337) | |||
| 155889 | 155889 | 187486 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 9ft | 6006768.10436 | 2086582.6135 | 37.7097415013489 | -122.41837109707 | (37.7097415013489, -122.41837109707) | |||
| 157169 | 157169 | 187487 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 9ft | 6006739.4924099995 | 2086592.2880099998 | 37.709766454838096 | -122.418470670891 | (37.7097664548381, -122.418470670891) | |||
| 57550 | 57550 | 187488 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 4ft | 6006708.59512 | 2086603.96966 | 37.7097967907675 | -122.418578285583 | (37.7097967907675, -122.418578285583) | |||
| 181907 | 181907 | 187489 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006684.44019 | 2086612.8401400002 | 37.7098197873211 | -122.418662398253 | (37.7098197873211, -122.418662398253) | ||||
| 78769 | 78769 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
| 81752 | 81752 | 116834 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
| 95921 | 95921 | 116835 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
| 110125 | 110125 | 116836 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
| 114433 | 114433 | 116837 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
| 181734 | 181734 | 175012 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 8ft | 6013182.79855 | 2087056.1572599998 | 37.71140077569589 | -122.396233767795 | (37.7114007756959, -122.396233767795) | |||
| 37054 | 37054 | 175013 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 8ft | 6013185.59041 | 2087064.24232 | 37.7114231310315 | -122.396224684625 | (37.7114231310315, -122.396224684625) | |||
| 33886 | 33886 | 175014 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 8ft | 6013188.07866 | 2087071.7521799998 | 37.7114438900863 | -122.396216610525 | (37.7114438900863, -122.396216610525) | |||
| 47330 | 47330 | 175015 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 8ft | 6013189.92411 | 2087076.3672900002 | 37.7114566649583 | -122.39621055536999 | (37.7114566649583, -122.39621055537) | |||
| 174696 | 174696 | 175016 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 81 Gillette Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 8ft | 6013191.1859 | 2087080.9939 | 37.711469438930294 | -122.396206518314 | (37.7114694389303, -122.396206518314) | |||
| 3034 | 3034 | 253070 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 132 Sagamore St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 0ft | Permit Number 780451 | 5995539.3842400005 | 2087458.9579900003 | 37.7115092483173 | -122.45724268539699 | (37.7115092483173, -122.457242685397) | |||
| 767 | 767 | 251382 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 731 Huron Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
| 3748 | 3748 | 175358 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 5ft | 5992915.27224 | 2087806.8926400002 | 37.7123135327144 | -122.466337499576 | (37.7123135327144, -122.466337499576) | |||
| 3733 | 3733 | 175357 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 5ft | 5992890.63105 | 2087809.5806900002 | 37.7123194916216 | -122.466422861444 | (37.7123194916216, -122.466422861444) | |||
| 3740 | 3740 | 175359 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 5ft | 5993023.53483 | 2087808.23472 | 37.7123234639353 | -122.465963412176 | (37.7123234639353, -122.465963412176) | |||
| 3747 | 3747 | 175360 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 5ft | 5993054.1062900005 | 2087811.2090200002 | 37.7123333942521 | -122.46585796488002 | (37.7123333942521, -122.46585796488) | |||
| 128128 | 128128 | 93153 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 222 Sadowa St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 3x24 | 5994796.0 | 2087777.0 | 37.7123397937745 | -122.45983502172301 | (37.7123397937745, -122.459835021723) | |||
| 3738 | 3738 | 175361 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 5ft | 5993097.02114 | 2087813.9243700001 | 37.7123433254574 | -122.465709836634 | (37.7123433254574, -122.465709836634) | |||
| 107166 | 107166 | 98714 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 500X Brotherhood Way | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||||
| 33613 | 33613 | 181300 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Nueva Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 48 | Width 4ft | 6013063.40285 | 2087533.07945 | 37.712703665812796 | -122.39667984502199 | (37.7127036658128, -122.396679845022) | |||
| 167463 | 167463 | 181301 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Nueva Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 4ft | 6013065.73831 | 2087544.18077 | 37.7127342778318 | -122.39667255061701 | (37.7127342778318, -122.396672550617) | |||
| 147931 | 147931 | 181302 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Nueva Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 4ft | 6013064.24149 | 2087553.26 | 37.712759124299296 | -122.396678360222 | (37.7127591242993, -122.396678360222) | |||
| 168919 | 168919 | 181303 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Nueva Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 4ft | 6013062.584369999 | 2087561.0422 | 37.712780400456 | -122.39668463301399 | (37.712780400456, -122.396684633014) | |||
| 71645 | 71645 | 175280 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Tocoloma Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012813.92638 | 2087567.88235 | 37.7127853395403 | -122.397544560234 | (37.7127853395403, -122.397544560234) | ||||
| 162192 | 162192 | 175281 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Tocoloma Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012823.449990001 | 2087568.74091 | 37.7127882272645 | -122.39751170352699 | (37.7127882272645, -122.397511703527) |
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");