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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 144388 | 144388 | 114393 | Significant Tree 6 | Ficus Spp. :: 253 | 118x TAPIA DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5988638.0 | 2090878.0 | 37.72049829773871 | -122.48134562114099 | (37.7204982977387, -122.481345621141) | ||||
| 157070 | 157070 | 178304 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 855 Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 0ft | 5989161.975 | 2088639.9797 | 37.7143837028079 | -122.479370782233 | (37.7143837028079, -122.479370782233) | |||
| 77632 | 77632 | 110165 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 129x GARCES DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 5989202.0 | 2088902.0 | 37.7151054701837 | -122.47925159789301 | (37.7151054701837, -122.479251597893) | ||||
| 125550 | 125550 | 110166 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 131x GARCES DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 5989202.0 | 2088902.0 | 37.7151054701837 | -122.47925159789301 | (37.7151054701837, -122.479251597893) | ||||
| 125585 | 125585 | 110162 | Undocumented 2 | Tree(s) :: 17 | 123x GARCES DR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 777996 | 5989202.0 | 2088902.0 | 37.7151054701837 | -122.47925159789301 | (37.7151054701837, -122.479251597893) | ||
| 138607 | 138607 | 110163 | Undocumented 2 | Tree(s) :: 17 | 121x GARCES DR | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 777996 | 5989202.0 | 2088902.0 | 37.7151054701837 | -122.47925159789301 | (37.7151054701837, -122.479251597893) | ||
| 145988 | 145988 | 110164 | Undocumented 2 | Tree(s) :: 17 | 121x GARCES DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 777996 | 5989202.0 | 2088902.0 | 37.7151054701837 | -122.47925159789301 | (37.7151054701837, -122.479251597893) | ||
| 46507 | 46507 | 178305 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 825 Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 5989317.6879900005 | 2088635.9257200002 | 37.7143816145814 | -122.47883228617901 | (37.7143816145814, -122.478832286179) | |||
| 108061 | 108061 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5989494.0 | 2090180.0 | 37.7186314952818 | -122.47833572411999 | (37.7186314952818, -122.47833572412) | |||||
| 41942 | 41942 | 176158 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 825 Brotherhood Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | Width 0ft | 5989484.91598 | 2088634.67131 | 37.7143878792713 | -122.47825419477199 | (37.7143878792713, -122.478254194772) | |||
| 55715 | 55715 | 102680 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 77775 | 77775 | 102678 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 107377 | 107377 | 102675 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 107438 | 107438 | 102679 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 114786 | 114786 | 102677 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 122724 | 122724 | 102676 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 333 Eucalyptus Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133154995 | -122.476573573496 | (37.731002133155, -122.476573573496) | |||
| 26932 | 26932 | 178306 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 777 Brotherhood Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 0ft | 5990015.12646 | 2088607.4961599999 | 37.7143440274236 | -122.47641961286999 | (37.7143440274236, -122.47641961287) | |||
| 11662 | 11662 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 0 Diaz Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.8197400002 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | ||
| 106519 | 106519 | 105769 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2014 12:00:00 AM | Permit Number 772589 | 5990111.8 | 2090190.8 | 37.718696994740704 | -122.476201051717 | (37.7186969947407, -122.476201051717) | |||
| 117533 | 117533 | 105764 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1X GONZALEZ DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990111.8 | 2090190.8 | 37.718696994740704 | -122.476201051717 | (37.7186969947407, -122.476201051717) | |||||
| 142961 | 142961 | 104761 | Significant Tree 6 | Ilex aquifolium :: European Holly 277 | 1665 18TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 9x9 | 5990543.2 | 2104073.0 | 37.756838968238 | -122.475723071248 | (37.756838968238, -122.475723071248) | ||||
| 144810 | 144810 | 104762 | Significant Tree 6 | Ilex aquifolium :: European Holly 277 | 1665 18TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 9x9 | 5990543.2 | 2104073.0 | 37.756838968238 | -122.475723071248 | (37.756838968238, -122.475723071248) | ||||
| 98711 | 98711 | 105649 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990274.6 | 2090665.2 | 37.7200090188364 | -122.475672946469 | (37.7200090188364, -122.475672946469) | |||||
| 88589 | 88589 | 114269 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 91685 | 91685 | 114268 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 114769 | 114769 | 114267 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 47993 | 47993 | 105254 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 130 GONZALEZ DR | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 5990327.0 | 2090136.0 | 37.7185590045312 | -122.47545320091999 | (37.7185590045312, -122.47545320092) | |||||
| 140646 | 140646 | 121962 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 20 16th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 5x10 | Permit Number 778592 | 5990850.71184 | 2114913.60159 | 37.78662213560371 | -122.47545108088 | (37.7866221356037, -122.47545108088) | |
| 81688 | 81688 | 93931 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.5528400003 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | |||||
| 99064 | 99064 | 93932 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.5528400003 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | |||||
| 77987 | 77987 | 100070 | Property Tree 7 | Tree(s) :: 17 | 331 Serrano Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 777990 | 5990400.0 | 2090718.0 | 37.7201612636948 | -122.47524333880699 | (37.7201612636948, -122.475243338807) | ||||
| 96627 | 96627 | 104900 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 317 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 99835 | 99835 | 104913 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 608 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 102326 | 102326 | 104898 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 310 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 118620 | 118620 | 104908 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 500 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 119511 | 119511 | 104899 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 314 Gonzalez Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 140531 | 140531 | 104916 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 700 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 142126 | 142126 | 104912 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 606 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 143237 | 143237 | 104888 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 146 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 72156 | 72156 | 104935 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 835 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 80537 | 80537 | 104931 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 841 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 99811 | 99811 | 104936 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 837 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 104432 | 104432 | 104929 | Undocumented 2 | Tree(s) :: 17 | 815 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/11/2014 12:00:00 AM | 3 | Permit Number 770295 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | ||
| 109347 | 109347 | 104937 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 839 Gonzalez Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 114209 | 114209 | 104934 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 805 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 144801 | 144801 | 104930 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 839 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 104018 | 104018 | 104932 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 717 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990427.0 | 2090598.0 | 37.7198333383806 | -122.47514125414499 | (37.7198333383806, -122.475141254145) | |||||
| 142616 | 142616 | 104933 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 755 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990427.0 | 2090598.0 | 37.7198333383806 | -122.47514125414499 | (37.7198333383806, -122.475141254145) | |||||
| 80921 | 80921 | 104904 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 417 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 81710 | 81710 | 104892 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Gonzalez Dr | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | ||||||
| 124358 | 124358 | 104909 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 533 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 93221 | 93221 | 106514 | Significant Tree 6 | Tree(s) :: 17 | 190 EUCALYPTUS DR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990695.4 | 2094728.8 | 37.7311910349726 | -122.474514801842 | (37.7311910349726, -122.474514801842) | |||||
| 98469 | 98469 | 107308 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 190 EUCALYPTUS DR | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5990695.4 | 2094728.8 | 37.7311910349726 | -122.474514801842 | (37.7311910349726, -122.474514801842) | ||||
| 122000 | 122000 | 107498 | Undocumented 2 | Acacia spp :: Acacia Spp 176 | 130 DENSLOWE DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990637.6 | 2091559.3 | 37.722485033503105 | -122.474483407877 | (37.7224850335031, -122.474483407877) | |||||
| 98505 | 98505 | 100433 | Significant Tree 6 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 152 | 200X Stonecrest Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | |||||
| 99170 | 99170 | 100432 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 200X Stonecrest Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | |||||
| 114083 | 114083 | 100431 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 200X Stonecrest Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | |||||
| 129429 | 129429 | 100423 | Significant Tree 6 | Leptospermum laevigatum :: Australian Tea Tree 38 | 155 Winston Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990788.0 | 2093142.6 | 37.7268410933597 | -122.474078979965 | (37.7268410933597, -122.474078979965) | |||||
| 129345 | 129345 | 107666 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 140 STRATFORD DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 3 | Permit Number 774157 | 5990881.4 | 2091504.3 | 37.722348139716296 | -122.473636645054 | (37.7223481397163, -122.473636645054) | ||
| 123839 | 123839 | 114250 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 131 FONT BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 138404 | 138404 | 114251 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 129 FONT BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 75 | 5990853.0 | 2088876.0 | 37.715129831054796 | -122.473543194374 | (37.7151298310548, -122.473543194374) | ||||
| 88070 | 88070 | 107506 | Undocumented 2 | Tree(s) :: 17 | 129 STRATFORD DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12' PROW | 5990962.6 | 2091579.6 | 37.7225595971545 | -122.47336144782801 | (37.7225595971545, -122.473361447828) | ||||
| 140530 | 140530 | 107504 | Undocumented 2 | Tree(s) :: 17 | 51 Stratford Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990982.0 | 2092029.0 | 37.7237946613386 | -122.47332714801901 | (37.7237946613386, -122.473327148019) | |||||
| 91183 | 91183 | 114258 | Private 5 | Pinus radiata :: Monterey Pine 3 | 70x CHUMASERO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | ||||
| 145474 | 145474 | 114257 | Significant Tree 6 | Leptospermum quinquenervia :: Tea Tree 151 | 50x CHUMASERO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | |||||
| 9641 | 9641 | 114157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9643 | 9643 | 114152 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9644 | 9644 | 114150 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9647 | 9647 | 114149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9651 | 9651 | 114156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9655 | 9655 | 114155 | Significant Tree 6 | Pittosporum spp :: Pittosporum spp 128 | 1200X JUNIPERO SERRA BLVD | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||||
| 9656 | 9656 | 114151 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9657 | 9657 | 114153 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9661 | 9661 | 114148 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9677 | 9677 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9996 | 9996 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10002 | 10002 | 114158 | Significant Tree 6 | Prunus armeniaca :: Apricot 259 | 1200X JUNIPERO SERRA BLVD | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10011 | 10011 | 173616 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1200X JUNIPERO SERRA BLVD | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 89097 | 89097 | 114144 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 89972 | 89972 | 114147 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 118401 | 118401 | 114145 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 140509 | 140509 | 114146 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 10020 | 10020 | 115676 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X Junipero Serra Blvd | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.2 | 2089585.5 | 37.717093588438 | -122.472660975441 | (37.717093588438, -122.472660975441) | |||
| 105305 | 105305 | 104205 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 710X Brotherhood Way | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 770788 | 5991124.9259 | 2088065.41222 | 37.7129198985758 | -122.472544248538 | (37.7129198985758, -122.472544248538) | ||||
| 113961 | 113961 | 104204 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 710X Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 770788 | 5991124.9259 | 2088065.41222 | 37.7129198985758 | -122.472544248538 | (37.7129198985758, -122.472544248538) | ||||
| 154023 | 154023 | 207128 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 0ft | 5991324.62806 | 2095649.6189400002 | 37.7337558092758 | -122.472406573513 | (37.7337558092758, -122.472406573513) | |||
| 72315 | 72315 | 207127 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 5991327.69264 | 2095651.06492 | 37.7337599569436 | -122.472396083831 | (37.7337599569436, -122.472396083831) | |||
| 60545 | 60545 | 207126 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 5991329.52565 | 2095655.7745299998 | 37.733772994434204 | -122.472390089849 | (37.7337729944342, -122.472390089849) | |||
| 53270 | 53270 | 207125 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 5991332.892440001 | 2095658.5010099998 | 37.733780675521395 | -122.47237864866001 | (37.7337806755214, -122.47237864866) | |||
| 44916 | 44916 | 211086 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 15th Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 5991533.70356 | 2105111.6781900004 | 37.759748279467296 | -122.47237329318999 | (37.7597482794673, -122.47237329319) | ||||
| 75698 | 75698 | 217493 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1501 15th Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5991534.00074 | 2105121.21234 | 37.7597744749213 | -122.472372960446 | (37.7597744749213, -122.472372960446) | ||||
| 188736 | 188736 | 207124 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 5991335.55729 | 2095661.67857 | 37.7337895545331 | -122.472369667134 | (37.7337895545331, -122.472369667134) | |||
| 167941 | 167941 | 209382 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 900 Lawton St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5991530.80224 | 2104909.87583 | 37.7591940156155 | -122.472368615844 | (37.7591940156155, -122.472368615844) | ||||
| 25153 | 25153 | 219212 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 1501 15th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5991536.71945 | 2105150.6616 | 37.759855492149704 | -122.47236570472 | (37.7598554921497, -122.47236570472) | ||||
| 179845 | 179845 | 207123 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 5991338.6165 | 2095665.48618 | 37.733800186326604 | -122.472359368113 | (37.7338001863266, -122.472359368113) | |||
| 139726 | 139726 | 98721 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 700X Brotherhood Way | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5991178.9 | 2088065.4 | 37.7129229890255 | -122.47235769727399 | (37.7129229890255, -122.472357697274) | ||||||
| 184814 | 184814 | 207122 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 5991343.33969 | 2095670.4637 | 37.7338141267018 | -122.47234340152399 | (37.7338141267018, -122.472343401524) | |||
| 180846 | 180846 | 207121 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 0ft | 5991346.9817 | 2095677.27593 | 37.733833042151105 | -122.47233130655898 | (37.7338330421511, -122.472331306559) | |||
| 178438 | 178438 | 207120 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 5991349.86178 | 2095682.72956 | 37.7338481831293 | -122.472321746778 | (37.7338481831293, -122.472321746778) | |||
| 53273 | 53273 | 219211 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 1500 15th Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 5991550.42376 | 2105114.9224099996 | 37.759758154937295 | -122.472315703333 | (37.7597581549373, -122.472315703333) |
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");