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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141266 | 141266 | 93607 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 118501 | 118501 | 93608 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 99567 | 99567 | 93609 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 81098 | 81098 | 93610 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 110482 | 110482 | 93611 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 32 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 99578 | 99578 | 93612 | Permitted Site 1 | Tree(s) :: 17 | 15 West Point Rd | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 53253 | 6017978.0 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | ||||
| 93582 | 93582 | 93724 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 415 Belvedere St | Front Yard : Yard 7 | Tree 1 | Private 1 | 5998488.0 | 2106798.0 | 37.7647785355325 | -122.44844336243601 | (37.7647785355325, -122.448443362436) | ||||||
| 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) | |||||
| 118024 | 118024 | 94228 | Property Tree 7 | Acer palmatum :: Japanese Maple 175 | 1097 Church St | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | Permit Number 53567 | 6004455.0 | 2102510.0 | 37.753344058808395 | -122.427499544702 | (37.7533440588084, -122.427499544702) | ||||
| 81311 | 81311 | 94411 | Permitted Site 1 | Tree(s) :: 17 | 905 California St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/27/2010 12:00:00 AM | 9 | Permit Number 53651 | 6010018.0 | 2116471.0 | 37.791990800007504 | -122.409246561226 | (37.7919908000075, -122.409246561226) | ||
| 171611 | 171611 | 94414 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53653 | 6013808.0998 | 2092150.7804 | 37.7254243749067 | -122.394429043825 | (37.7254243749067, -122.394429043825) | |
| 119759 | 119759 | 94415 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 5800 03rd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 103876 | 103876 | 94416 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 5800 03rd St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 95770 | 95770 | 94417 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 100907 | 100907 | 94418 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 78873 | 78873 | 94419 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 128623 | 128623 | 94420 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 178371 | 178371 | 94602 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2939 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/07/2010 12:00:00 AM | 9 | Permit Number 53770 | 5999468.945859999 | 2117347.95354 | 37.7938020288031 | -122.445809330858 | (37.7938020288031, -122.445809330858) | ||
| 140992 | 140992 | 94636 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 170X Crestmont Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/24/2010 12:00:00 AM | Permit Number 53783 | 5995178.5 | 2103444.0 | 37.7553795372421 | -122.45964703776801 | (37.7553795372421, -122.459647037768) | |||
| 145163 | 145163 | 94637 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 170X Crestmont Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/24/2010 12:00:00 AM | Permit Number 53783 | 5995178.5 | 2103444.0 | 37.7553795372421 | -122.45964703776801 | (37.7553795372421, -122.459647037768) | |||
| 117698 | 117698 | 94688 | Permitted Site 1 | Tree(s) :: 17 | 230 Upland Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/27/2010 12:00:00 AM | 23 | 2x3 | Permit Number 53827 | 5993701.0 | 2094087.0 | 37.729602496423 | -122.464077417771 | (37.729602496423, -122.464077417771) | |
| 81598 | 81598 | 94690 | Property Tree 7 | Brachychiton populneus :: Bottle Tree 329 | 749 Congo St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | Permit Number 53820 | 6000274.0 | 2096023.0 | 37.735294937499 | -122.441492809367 | (37.735294937499, -122.441492809367) | ||||
| 53190 | 53190 | 94850 | Significant Tree 6 | Tree(s) :: 17 | 1107 Bowdoin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | Permit Number 53929 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | |||
| 98300 | 98300 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1107 Bowdoin St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | ||
| 93838 | 93838 | 94852 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 769 Joost Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5997030.4 | 2094957.2 | 37.7321831815324 | -122.45263017562 | (37.7321831815324, -122.45263017562) | ||||
| 19350 | 19350 | 95161 | Significant Tree 6 | Acer palmatum :: Japanese Maple 175 | 2721 Pacific Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 54078 | 6001026.7 | 2116843.3 | 37.7925052022591 | -122.440383162252 | (37.7925052022591, -122.440383162252) | |||||
| 110495 | 110495 | 95215 | Significant Tree 6 | Acer palmatum :: Japanese Maple 175 | 2203 Divisadero St | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000868.0 | 2115894.0 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | ||||||
| 95808 | 95808 | 95230 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1@Carl Irving St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/16/2010 12:00:00 AM | 27 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | |||
| 98130 | 98130 | 95234 | Significant Tree 6 | Tree(s) :: 17 | 7 Almaden Ct | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/25/2011 12:00:00 AM | Permit Number 767129 | 5995849.0 | 2112535.0 | 37.780379598944705 | -122.457986127959 | (37.7803795989447, -122.457986127959) | ||||
| 105112 | 105112 | 95242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2620 Larkin St | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | Permit Number 56959 | 6006630.0 | 2120172.0 | 37.801962421987 | -122.421232011572 | (37.801962421987, -122.421232011572) | ||||
| 113676 | 113676 | 95299 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617005 | -122.422419858646 | (37.780652317617, -122.422419858646) | |||
| 54776 | 54776 | 95300 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617005 | -122.422419858646 | (37.780652317617, -122.422419858646) | |||
| 121702 | 121702 | 95777 | Significant Tree 6 | Acer palmatum 'Sango Kaku' :: Coral Bark Maple 518 | 30 Onondaga Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/11/2011 12:00:00 AM | Permit Number 767524 | 6001190.6 | 2091111.6 | 37.721861535681704 | -122.437972107548 | (37.7218615356817, -122.437972107548) | ||||
| 50166 | 50166 | 95953 | Significant Tree 6 | Tree(s) :: 17 | 499 Buena Vista East Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/18/2011 12:00:00 AM | 21 | Permit Number 57015 | 6000177.0 | 2107098.0 | 37.7656986843565 | -122.442623109531 | (37.7656986843565, -122.442623109531) | |||
| 146137 | 146137 | 96224 | Undocumented 2 | Tree(s) :: 17 | 185 Chilton Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6001587.1 | 2095138.7 | 37.732941575251004 | -122.436889661497 | (37.732941575251, -122.436889661497) | ||||
| 19781 | 19781 | 96412 | Significant Tree 6 | Acer palmatum :: Japanese Maple 175 | 185 Chilton Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/18/2011 12:00:00 AM | Permit Number 767805 | 6001587.1 | 2095138.7 | 37.732941575251004 | -122.436889661497 | (37.732941575251, -122.436889661497) | ||||
| 123568 | 123568 | 96765 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 184 Edgewood Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/12/2011 12:00:00 AM | Permit Number 767998 | 5996632.0 | 2105999.0 | 37.76247839448661 | -122.45480501488301 | (37.7624783944866, -122.454805014883) | |||
| 87949 | 87949 | 96848 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 1486 Innes Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016133.4 | 2096820.6 | 37.7383757570157 | -122.386716118251 | (37.7383757570157, -122.386716118251) | ||||||
| 79477 | 79477 | 96905 | Permitted Site 1 | Ulmus 'Frontier' :: Frontier Elm 464 | 1155@Greenwich Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/05/2011 12:00:00 AM | Park | Permit Number 768022 | 6012245.0 | 2120028.0 | 37.80188198386271 | -122.401791216362 | (37.8018819838627, -122.401791216362) | ||
| 88420 | 88420 | 96906 | Significant Tree 6 | Ulmus 'Frontier' :: Frontier Elm 464 | 1155@Sansome Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/05/2011 12:00:00 AM | Plaza | Permit Number 768022 | 6012245.0 | 2120028.0 | 37.80188198386271 | -122.401791216362 | (37.8018819838627, -122.401791216362) | ||
| 103074 | 103074 | 97264 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | Permit Number 768179 | 6016549.1 | 2098591.6 | 37.743261569489704 | -122.38540219642401 | (37.7432615694897, -122.385402196424) | |||
| 74398 | 74398 | 97290 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 55 Hiliritas Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 778896 | 6001461.7 | 2096833.2 | 37.7375871516219 | -122.437444499981 | (37.7375871516219, -122.437444499981) | |||||
| 86081 | 86081 | 97440 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 1900 Pacific Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/11/2011 12:00:00 AM | Permit Number 768364 | 6004943.9 | 2117474.7 | 37.794461125583794 | -122.42687450783701 | (37.7944611255838, -122.426874507837) | |||
| 75150 | 75150 | 97534 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 203 Surrey St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768282 | 6002070.0 | 2096079.6 | 37.73555250464221 | -122.435287431957 | (37.7355525046422, -122.435287431957) | ||||
| 142992 | 142992 | 97797 | Undocumented 2 | Tree(s) :: 17 | 400 Sussex St | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/14/2011 12:00:00 AM | 17 | Permit Number 768175 | 6000884.7 | 2096726.7 | 37.7372619068373 | -122.43943182637501 | (37.7372619068373, -122.439431826375) | |||
| 115263 | 115263 | 97894 | Significant Tree 6 | Tree(s) :: 17 | 2927 Folsom St | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/29/2012 12:00:00 AM | 30 | Permit Number 768566 | 6008395.0 | 2101384.0 | 37.7504743768844 | -122.413794517972 | (37.7504743768844, -122.413794517972) | |||
| 19797 | 19797 | 97906 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 401 Upper Ter | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2011 12:00:00 AM | 60 | Permit Number 768366 | 5999222.6 | 2106240.8 | 37.7632905770055 | -122.44586250428002 | (37.7632905770055, -122.44586250428) | ||
| 115185 | 115185 | 97924 | Permitted Site 1 | Tree(s) :: 17 | 2939 Divisadero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/02/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768415 | 6000521.0 | 2118346.0 | 37.7966024147448 | -122.442240817081 | (37.7966024147448, -122.442240817081) | |
| 82219 | 82219 | 97945 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2 Mendosa Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | ||||
| 124878 | 124878 | 97955 | Significant Tree 6 | Liquidambar styraciflua 'Slender Silhoutte' :: Upright Liquidambar 530 | 2 Mendosa Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | |||
| 70776 | 70776 | 97971 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 3x105 | 6008579.18793 | 2094106.30305 | 37.7305017590298 | -122.412643160269 | (37.7305017590298, -122.412643160269) | |||
| 162444 | 162444 | 97973 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 3x105 | Permit Number 767976 | 6008571.293930001 | 2094144.04925 | 37.7306049589414 | -122.412673118464 | (37.7306049589414, -122.412673118464) | ||
| 172978 | 172978 | 97975 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 3x105 | Permit Number 767976 | 6008564.43786 | 2094166.6254 | 37.73066656339879 | -122.41269841641399 | (37.7306665633988, -122.412698416414) | ||
| 168523 | 168523 | 97977 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 3x105 | Permit Number 767976 | 6008560.783419999 | 2094185.6842900002 | 37.7307186899072 | -122.41271239727301 | (37.7307186899072, -122.412712397273) | ||
| 40606 | 40606 | 97979 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 3x105 | Permit Number 767976 | 6008557.48708 | 2094193.9971900003 | 37.730741330331995 | -122.412724380735 | (37.730741330332, -122.412724380735) | ||
| 129157 | 129157 | 97980 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x105 | Permit Number 767976 | 6008582.5 | 2094142.5 | 37.730601333974796 | -122.412634267782 | (37.7306013339748, -122.412634267782) | |||
| 144952 | 144952 | 97981 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Bowdoin St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x105 | 6008582.5 | 2094142.5 | 37.730601333974796 | -122.412634267782 | (37.7306013339748, -122.412634267782) | ||||
| 92420 | 92420 | 98038 | Significant Tree 6 | Tree(s) :: 17 | 147 Lake St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/09/2011 12:00:00 AM | Permit Number 768423 | 5994977.2 | 2114852.5 | 37.7866927029397 | -122.461170103848 | (37.7866927029397, -122.461170103848) | |||
| 90230 | 90230 | 98140 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 315 San Marcos Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992920.8 | 2100212.1 | 37.746375486546704 | -122.467219803339 | (37.7463754865467, -122.467219803339) | ||||||
| 80392 | 80392 | 98149 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 850 Rockdale Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/23/2012 12:00:00 AM | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | |||
| 94269 | 94269 | 98150 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 850 Rockdale Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/23/2012 12:00:00 AM | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | |||
| 93506 | 93506 | 98151 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 850 Rockdale Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768501 | 5996729.9 | 2098301.3 | 37.7413480470066 | -122.453910481227 | (37.7413480470066, -122.453910481227) | ||||
| 95713 | 95713 | 98156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 149x Chaves Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996703.5 | 2098396.7 | 37.7416084783757 | -122.454008650942 | (37.7416084783757, -122.454008650942) | |||||
| 143196 | 143196 | 98157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 149x Chaves Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996703.5 | 2098396.7 | 37.7416084783757 | -122.454008650942 | (37.7416084783757, -122.454008650942) | |||||
| 109599 | 109599 | 98161 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 600 Front St | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2011 12:00:00 AM | Permit Number 768589 | 6012888.4 | 2118392.6 | 37.7974274520849 | -122.39944985704099 | (37.7974274520849, -122.399449857041) | ||||
| 108983 | 108983 | 98164 | Permitted Site 1 | Magnolia x alba :: White Champaca 342 | 90 Balceta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/22/2011 12:00:00 AM | Permit Number 768312 | 5995830.5 | 2099880.5 | 37.7456325309111 | -122.457134479076 | (37.7456325309111, -122.457134479076) | |||
| 123402 | 123402 | 98170 | Significant Tree 6 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 2324 Sacramento St | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/22/2011 12:00:00 AM | 3 | Permit Number 768454 | 6003670.2 | 2115963.1 | 37.7902385582714 | -122.43117371849199 | (37.7902385582714, -122.431173718492) | |||
| 151501 | 151501 | 98241 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 3760 Washington St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/10/2012 12:00:00 AM | 9 | Permit Number 768462 | 5996814.4677800005 | 2115674.0493799997 | 37.7890540175629 | -122.45487301496999 | (37.7890540175629, -122.45487301497) | ||
| 59539 | 59539 | 98244 | Significant Tree 6 | Taxus baccata :: Irish Yew 241 | 901 Bay St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6006420.63185 | 2121080.7781 | 37.8044458892203 | -122.422021121489 | (37.8044458892203, -122.422021121489) | ||||
| 109838 | 109838 | 98274 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 766 Anderson St | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/23/2012 12:00:00 AM | 18 | Permit Number 768445 | 6007723.0 | 2095324.0 | 37.7337971999422 | -122.41568932106199 | (37.7337971999422, -122.415689321062) | |||
| 117957 | 117957 | 98300 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 6 Locksley Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994194.0 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | |||||
| 142723 | 142723 | 98301 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 6 Locksley Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994194.0 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | |||||
| 109474 | 109474 | 98302 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 6 Locksley Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994194.0 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | |||||
| 109657 | 109657 | 98303 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 6 Locksley Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994194.0 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | |||||
| 82114 | 82114 | 98455 | Significant Tree 6 | Washingtonia filifera :: California Fan Palm 189 | 2200 22nd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6011565.2 | 2103754.7 | 37.7571613219705 | -122.402998394603 | (37.7571613219705, -122.402998394603) | |||||
| 95709 | 95709 | 98492 | Significant Tree 6 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Laguna St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004211.7 | 2116183.0 | 37.7908730187591 | -122.429315856087 | (37.7908730187591, -122.429315856087) | |||||
| 102829 | 102829 | 98542 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 555 Teresita Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 105359 | 105359 | 98545 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 555@Rio Teresita Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 124444 | 124444 | 98547 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 555@Rio Teresita Blvd | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 124987 | 124987 | 98548 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 132 Hamerton Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6001332.8 | 2095440.7 | 37.7337563407686 | -122.437790462907 | (37.7337563407686, -122.437790462907) | |||||
| 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) | ||||||
| 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) | ||||||
| 98982 | 98982 | 98757 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 340 Castenada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993579.1 | 2100062.8 | 37.7460035255592 | -122.464932655613 | (37.7460035255592, -122.464932655613) | |||||
| 87158 | 87158 | 98835 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1100X Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5995262.0 | 2098056.7 | 37.7405921639667 | -122.458968225676 | (37.7405921639667, -122.458968225676) | |||||
| 145393 | 145393 | 98880 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Lansdale Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 5994747.9 | 2097283.1 | 37.738438484278895 | -122.460689725403 | (37.7384384842789, -122.460689725403) | ||||
| 86202 | 86202 | 98947 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 340 | 401 Grove St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005778.2 | 2111279.0 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | |||||
| 89800 | 89800 | 98948 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 108 | 401 Grove St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005778.2 | 2111279.0 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | |||||
| 140965 | 140965 | 98949 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 340 | 401 Grove St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005778.2 | 2111279.0 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | |||||
| 79287 | 79287 | 98950 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 108 | 401 Grove St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005778.2 | 2111279.0 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | |||||
| 112521 | 112521 | 98951 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 401 Grove St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005778.2 | 2111279.0 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | |||||
| 126530 | 126530 | 98952 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 302 Ivy St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | |||||
| 87916 | 87916 | 98953 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 302 Ivy St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | |||||
| 97455 | 97455 | 98954 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 302 Ivy St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | |||||
| 126121 | 126121 | 99105 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1400@ Mendell Evans Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/09/2012 12:00:00 AM | Permit Number 768768 | 6016404.0 | 2098045.1 | 37.741752963260105 | -122.38586583443899 | (37.7417529632601, -122.385865834439) | |||
| 112374 | 112374 | 99106 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1400 Evans Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/09/2012 12:00:00 AM | Permit Number 768768 | 6016404.0 | 2098045.1 | 37.741752963260105 | -122.38586583443899 | (37.7417529632601, -122.385865834439) | |||
| 69736 | 69736 | 99191 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155@Sansome Battery St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Plaza | Permit Number 768022 | 6012232.15659 | 2120086.23158 | 37.8020411569217 | -122.401839756495 | (37.8020411569217, -122.401839756495) | ||
| 91730 | 91730 | 99192 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1155@Sansome Battery St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Plaza | Permit Number 768022 | 6012245.0 | 2120028.0 | 37.80188198386271 | -122.401791216362 | (37.8018819838627, -122.401791216362) | |||
| 97530 | 97530 | 99275 | Property Tree 7 | Tree(s) :: 17 | 85X 10th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517.0 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | |||
| 125343 | 125343 | 99276 | Property Tree 7 | Tree(s) :: 17 | 85X 10th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517.0 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) |
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");