Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 98992 | 98992 | 114476 | Significant Tree 6 | Pittosporum spp :: Pittosporum spp 128 | 299x UNION ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 6011527.0 | 2119680.0 | 37.8008863659875 | -122.40425133897 | (37.8008863659875, -122.40425133897) | ||||
| 19018 | 19018 | 102131 | Significant Tree 6 | Tree(s) :: 17 | 850 Treat Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/24/2012 12:00:00 AM | Permit Number 769452 | 6008548.2 | 2103592.2 | 37.7565461982029 | -122.41342088796499 | (37.7565461982029, -122.413420887965) | |||
| 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) | |||
| 39637 | 39637 | 101740 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Broadway | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 10 | Permit Number 769428 | 6006182.95151 | 2117984.64817 | 37.7959312951427 | -122.42262348648998 | (37.7959312951427, -122.42262348649) | ||
| 58626 | 58626 | 101743 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Broadway | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 12 | Permit Number 769428 | 6006129.33795 | 2117976.30804 | 37.795905370388205 | -122.422808406898 | (37.7959053703882, -122.422808406898) | ||
| 143100 | 143100 | 101741 | Significant Tree 6 | Tree(s) :: 17 | 1590 Broadway | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | Permit Number 769428 | 6006147.8 | 2117991.4 | 37.795947850763895 | -122.422745597666 | (37.7959478507639, -122.422745597666) | |||
| 155517 | 155517 | 101742 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Broadway | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 8 | Permit Number 769428 | 6006220.9946099995 | 2117990.3045099997 | 37.7959489722299 | -122.422492252021 | (37.7959489722299, -122.422492252021) | ||
| 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) | ||||
| 87470 | 87470 | 102106 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 50X Noe St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/19/2012 12:00:00 AM | 25 | Permit Number 769282 | 6002816.1 | 2107996.5 | 37.7683158318555 | -122.433559261751 | (37.7683158318555, -122.433559261751) | ||
| 86608 | 86608 | 85093 | Significant Tree 6 | Tree(s) :: 17 | 100 32nd Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/18/2009 12:00:00 AM | Permit Number 53112 | 5985781.7 | 2114962.8 | 37.786462080845396 | -122.49299200677 | (37.7864620808454, -122.49299200677) | |||
| 144783 | 144783 | 92909 | Significant Tree 6 | Tree(s) :: 17 | 100 32nd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/18/2009 12:00:00 AM | 11 | Permit Number 53112 | 5985781.7 | 2114962.8 | 37.786462080845396 | -122.49299200677 | (37.7864620808454, -122.49299200677) | ||
| 125036 | 125036 | 92852 | Significant Tree 6 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 3794 16th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | Permit Number 53072 | 6001901.0 | 2106436.0 | 37.76397911869721 | -122.436612788339 | (37.7639791186972, -122.436612788339) | |||
| 140721 | 140721 | 92853 | Significant Tree 6 | Cercis occidentalis :: Western Redbud 246 | 3794 16th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | Permit Number 53072 | 6001901.0 | 2106436.0 | 37.76397911869721 | -122.436612788339 | (37.7639791186972, -122.436612788339) | |||
| 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) | |||
| 86280 | 86280 | 113491 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 132 | 366x 07TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/07/2015 12:00:00 AM | 6 | 3x3 | Permit Number 776681 | 5993712.0 | 2113143.0 | 37.7819259902039 | -122.465423128165 | (37.7819259902039, -122.465423128165) | |
| 88445 | 88445 | 122634 | Significant Tree 6 | Tree(s) :: 17 | 3680X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/05/2016 12:00:00 AM | 3 | 3x10 | Permit Number 779220 | 5990592.0 | 2091224.0 | 37.7215617409212 | -122.474616575991 | (37.7215617409212, -122.474616575991) | |
| 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) | |||
| 9986 | 9986 | 1263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/1998 12:00:00 AM | 10 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |
| 98560 | 98560 | 114194 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 555x SAN JOSE AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | 30 | 3x3 | Permit Number 777057 | 6006305.0 | 2100249.0 | 37.747240333103 | -122.420941331562 | (37.747240333103, -122.420941331562) | |
| 8728 | 8728 | 121206 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 930 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778903 | 6007356.48577 | 2120579.5282099997 | 37.803122321012296 | -122.418746939923 | (37.8031223210123, -122.418746939923) | |
| 93295 | 93295 | 104872 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1753 Noe St | 1 | Hanging basket : Yard 27 | Tree 1 | Private 1 | 11/22/2013 12:00:00 AM | Permit Number 770054 | 6003434.1 | 2098036.1 | 37.7410019772539 | -122.430710793678 | (37.7410019772539, -122.430710793678) | |||
| 104145 | 104145 | 101810 | Significant Tree 6 | Tree(s) :: 17 | 38 Nebraska St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 11/22/2012 12:00:00 AM | Permit Number 769374 | 6009268.6 | 2097830.3 | 37.740765720819 | -122.41052261908999 | (37.740765720819, -122.41052261909) | |||
| 18402 | 18402 | 48402 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/19/2010 12:00:00 AM | Permit Number 53935 | 6012689.64928807 | 2104214.1545054 | 37.7584856101735 | -122.399141839868 | (37.7584856101735, -122.399141839868) | |||
| 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) | ||
| 1159 | 1159 | 112361 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 561X Folsom St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/16/2015 12:00:00 AM | 3 | 10x30 | Permit Number 775828 | 6013749.7362 | 2114198.9064599997 | 37.785960521430205 | -122.396175324952 | (37.7859605214302, -122.396175324952) | |
| 91700 | 91700 | 95229 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1@Carl Irving St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/16/2010 12:00:00 AM | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | |||
| 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) | |||
| 104669 | 104669 | 95231 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1@Carl Irving St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/16/2010 12:00:00 AM | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | ||||
| 20656 | 20656 | 107549 | Significant Tree 6 | Tree(s) :: 17 | 198X Jennings St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | ||
| 79120 | 79120 | 107551 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 96078 | 96078 | 108000 | Significant Tree 6 | Tree(s) :: 17 | 1000 Rhode Island St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774025 | 6011852.20179 | 2103661.18899 | 37.7569205837919 | -122.401999252275 | (37.7569205837919, -122.401999252275) | ||
| 108428 | 108428 | 107553 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 128143 | 128143 | 107552 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 142812 | 142812 | 107493 | Significant Tree 6 | Tree(s) :: 17 | 180 BARTLETT ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | Permit Number 774017 | 6006657.2 | 2102756.7 | 37.7541457516772 | -122.419901368465 | (37.7541457516772, -122.419901368465) | ||
| 52920 | 52920 | 120918 | Significant Tree 6 | Tree(s) :: 17 | 555x SAN JOSE AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778877 | 6006305.0 | 2100249.0 | 37.747240333103 | -122.420941331562 | (37.747240333103, -122.420941331562) | |
| 101898 | 101898 | 114193 | Significant Tree 6 | Tree(s) :: 17 | 555x SAN JOSE AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778877 | 6006305.0 | 2100249.0 | 37.747240333103 | -122.420941331562 | (37.747240333103, -122.420941331562) | |
| 105823 | 105823 | 116009 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 199x SAN BUENAVENTURA WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777954 | 5993547.0 | 2095667.0 | 37.7339319096844 | -122.464724497297 | (37.7339319096844, -122.464724497297) | |
| 85444 | 85444 | 104728 | Significant Tree 6 | Tree(s) :: 17 | 3212 Jackson St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 11/06/2013 12:00:00 AM | Permit Number 770525 | 5998810.5 | 2116292.9 | 37.7908675143955 | -122.448011605492 | (37.7908675143955, -122.448011605492) | |||
| 4916 | 4916 | 251372 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1526 Masonic Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/01/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779800 | 5999767.0 | 2107205.0 | 37.7659690994291 | -122.44404889486401 | (37.7659690994291, -122.444048894864) | |
| 107622 | 107622 | 104691 | Significant Tree 6 | Tree(s) :: 17 | 1435X La Salle Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/31/2013 12:00:00 AM | Permit Number 770699 | 6016460.43075 | 2095036.9864400001 | 37.733496412822205 | -122.385461132957 | (37.7334964128222, -122.385461132957) | |||
| 106619 | 106619 | 86895 | Significant Tree 6 | Tree(s) :: 17 | 321 Haight St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/26/2007 12:00:00 AM | Permit Number 49844 | 6004599.9 | 2109420.1 | 37.7723257406977 | -122.427490696784 | (37.7723257406977, -122.427490696784) | ||||
| 103175 | 103175 | 107720 | Significant Tree 6 | Tree(s) :: 17 | 2301x Baker St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/20/2014 12:00:00 AM | 3 | Permit Number 773397 | 5999765.63181 | 2116886.19958 | 37.792551109743705 | -122.44474956777 | (37.7925511097437, -122.44474956777) | ||
| 10461 | 10461 | 92319 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985889.2586 | 2096423.8922 | 37.7355656712712 | -122.491254961509 | (37.7355656712712, -122.491254961509) | |
| 10597 | 10597 | 92315 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985839.9086 | 2096474.3035 | 37.73570120363421 | -122.491429290175 | (37.7357012036342, -122.491429290175) | |
| 10790 | 10790 | 80073 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 5985889.2586 | 2096432.3825 | 37.735588983385 | -122.49125558617901 | (37.735588983385, -122.491255586179) | ||
| 10899 | 10899 | 92314 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985837.7861 | 2096464.2212 | 37.7356733962807 | -122.491435886509 | (37.7356733962807, -122.491435886509) | |
| 12363 | 12363 | 92312 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2711 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985822.132 | 2096946.3119 | 37.7369961745626 | -122.49152548244 | (37.7369961745626, -122.49152548244) | |
| 12500 | 12500 | 92318 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985842.0312 | 2096446.1793 | 37.7356241060746 | -122.49141988222999 | (37.7356241060746, -122.49141988223) | |
| 12690 | 12690 | 92317 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.9699 | 2096433.9745 | 37.7355905329114 | -122.491422653463 | (37.7355905329114, -122.491422653463) | |
| 13114 | 13114 | 92316 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.4393 | 2096424.4229 | 37.7355642757438 | -122.49142378511002 | (37.7355642757438, -122.49142378511) | |
| 80217 | 80217 | 92320 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2733 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5984522.0 | 2096783.0 | 37.736471699686206 | -122.49600850837099 | (37.7364716996862, -122.496008508371) | |
| 83580 | 83580 | 92310 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2591 26th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3x3 | 5988279.0 | 2097698.2 | 37.7392039339278 | -122.48308618722099 | (37.7392039339278, -122.483086187221) | ||
| 108780 | 108780 | 92311 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2211 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5986022.3 | 2100155.2 | 37.7458186185696 | -122.491069496457 | (37.7458186185696, -122.491069496457) | |
| 96372 | 96372 | 113732 | Significant Tree 6 | Tree(s) :: 17 | 1580 Valencia St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/08/2015 12:00:00 AM | Permit Number 775128 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||
| 143507 | 143507 | 113729 | Significant Tree 6 | Tree(s) :: 17 | 1580 Valencia St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/08/2015 12:00:00 AM | Permit Number 775128 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||
| 143921 | 143921 | 113737 | Significant Tree 6 | Tree(s) :: 17 | 1580 Valencia St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/08/2015 12:00:00 AM | Permit Number 775128 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||
| 11071 | 11071 | 113042 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 Raymond Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/06/2015 12:00:00 AM | 30 | 3x3 | 6008233.879509999 | 2088473.9314700002 | 37.715017072864796 | -122.413438766187 | (37.7150170728648, -122.413438766187) | ||
| 50075 | 50075 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/06/2015 12:00:00 AM | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | |||
| 101996 | 101996 | 101236 | Significant Tree 6 | Tree(s) :: 17 | 895X Church St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10/05/2012 12:00:00 AM | 13 | Permit Number 769299 | 6004383.5 | 2103691.7 | 37.7565846850157 | -122.42783100085899 | (37.7565846850157, -122.427831000859) | ||
| 145255 | 145255 | 101233 | Significant Tree 6 | Tree(s) :: 17 | 3740 25th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/04/2012 12:00:00 AM | Permit Number 769197 | 6005584.0 | 2101403.0 | 37.7503682845448 | -122.423516527668 | (37.7503682845448, -122.423516527668) | |||
| 90145 | 90145 | 101204 | Significant Tree 6 | Tree(s) :: 17 | 1290 Stanyan St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769288 | 5997580.9 | 2104992.4 | 37.7597689094704 | -122.451450528065 | (37.7597689094704, -122.451450528065) | |||
| 104638 | 104638 | 101202 | Significant Tree 6 | Tree(s) :: 17 | 7070 California St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769231 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.49337605842699 | (37.7850123376907, -122.493376058427) | |||
| 122098 | 122098 | 101203 | Significant Tree 6 | Tree(s) :: 17 | 7070 California St | 2 | Front Yard : 25 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769231 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.49337605842699 | (37.7850123376907, -122.493376058427) | |||
| 3879 | 3879 | 253286 | Significant Tree 6 | Tree(s) :: 17 | 40 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2017 12:00:00 AM | 3 | 6x10 | Permit Number 780599 | 5993445.0 | 2101187.0 | 37.7490825597194 | -122.465478005037 | (37.7490825597194, -122.465478005037) | |
| 128628 | 128628 | 107635 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 1150 Lombard St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773092 | 6006825.00646 | 2120436.80144 | 37.8027004912885 | -122.42057600387301 | (37.8027004912885, -122.420576003873) | ||
| 113111 | 113111 | 107322 | Significant Tree 6 | Tree(s) :: 17 | 68 ROSENKRANZ ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/29/2014 12:00:00 AM | 3 | Permit Number 773942 | 6009212.0 | 2098349.0 | 37.7421867844178 | -122.41075494435499 | (37.7421867844178, -122.410754944355) | ||
| 50498 | 50498 | 100711 | Significant Tree 6 | Tree(s) :: 17 | 966-968 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/27/2012 12:00:00 AM | 14 | Permit Number 769148 | 6005605.8 | 2103343.5 | 37.7556976788024 | -122.423579088745 | (37.7556976788024, -122.423579088745) | ||
| 139196 | 139196 | 72854 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 24 Lunado Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/1998 12:00:00 AM | 5991516.52955398 | 2091408.89207172 | 37.722122935753106 | -122.47143422303499 | (37.7221229357531, -122.471434223035) | ||||
| 84808 | 84808 | 100529 | Significant Tree 6 | Tree(s) :: 17 | 720 Victoria St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/24/2012 12:00:00 AM | Permit Number 769203 | 5993611.6 | 2091925.6 | 37.723662667106 | -122.464229627127 | (37.723662667106, -122.464229627127) | |||
| 110845 | 110845 | 100434 | Significant Tree 6 | Tree(s) :: 17 | 2430 Sacramento St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/24/2012 12:00:00 AM | Permit Number 769154 | 6003168.3 | 2115899.0 | 37.7900341016439 | -122.432905672523 | (37.7900341016439, -122.432905672523) | |||
| 3709 | 3709 | 253265 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 180 San Aleso Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 5993319.0 | 2094440.0 | 37.730549723890206 | -122.465423653439 | (37.7305497238902, -122.465423653439) | ||
| 84182 | 84182 | 104279 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 86272 | 86272 | 104288 | Significant Tree 6 | Tree(s) :: 17 | 137X Middle Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 90953 | 90953 | 104290 | Significant Tree 6 | Tree(s) :: 17 | 11X Hare St | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 107391 | 107391 | 104289 | Significant Tree 6 | Tree(s) :: 17 | 10X Hare St | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 108419 | 108419 | 104281 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 3 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 111442 | 111442 | 104286 | Significant Tree 6 | Tree(s) :: 17 | 200X West Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 119692 | 119692 | 104284 | Significant Tree 6 | Tree(s) :: 17 | 45X Middle Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 125137 | 125137 | 104285 | Significant Tree 6 | Tree(s) :: 17 | 71X Middle Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 127056 | 127056 | 104283 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 5 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 129300 | 129300 | 104280 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 2 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 140648 | 140648 | 104282 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 4 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 141507 | 141507 | 104287 | Significant Tree 6 | Tree(s) :: 17 | 119X Middle Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 85674 | 85674 | 113134 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 03rd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | ||
| 140337 | 140337 | 113133 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 50 03rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | ||
| 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) | |||
| 85402 | 85402 | 100699 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 87097 | 87097 | 100696 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 89364 | 89364 | 100695 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 100107 | 100107 | 100701 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 102887 | 102887 | 100698 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 114181 | 114181 | 100694 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 139348 | 139348 | 100700 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 139418 | 139418 | 100697 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 96251 | 96251 | 107399 | Significant Tree 6 | Tree(s) :: 17 | 1300X Sansome St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/02/2014 12:00:00 AM | 3 | Permit Number 772689 | 6012222.0 | 2120529.0 | 37.8032563246841 | -122.40190604611401 | (37.8032563246841, -122.401906046114) | ||
| 93028 | 93028 | 115827 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 60X CHUMASERO DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777531 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | |
| 107759 | 107759 | 120952 | Significant Tree 6 | Tree(s) :: 17 | 100X 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 10x10 | Permit Number 778529 | 5985781.0 | 2114962.0 | 37.7864598433405 | -122.492994369609 | (37.7864598433405, -122.492994369609) | |
| 113067 | 113067 | 104750 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1X Junipero Serra Blvd Off Ramp | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719553998 | (37.7132507161795, -122.47185719554) | ||
| 82951 | 82951 | 109969 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 1x DAVIS ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/28/2015 12:00:00 AM | 18 | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) |
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");