Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12540 | 12540 | 108677 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 11 Otsego Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | Permit Number 773206 | 6000966.57436 | 2092971.8241299998 | 37.7269565451936 | -122.438879746024 | (37.7269565451936, -122.438879746024) | |
| 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) | |||
| 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) | |||
| 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) | ||
| 113085 | 113085 | 65849 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 66 Rico Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50013 | 6001352.95008446 | 2121456.09779386 | 37.8051893002679 | -122.439585161616 | (37.8051893002679, -122.439585161616) | ||
| 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) | ||
| 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) | ||
| 144047 | 144047 | 108298 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 10X Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | Permit Number 774449 | 6012830.0 | 2116175.0 | 37.791335193350896 | -122.399496166675 | (37.7913351933509, -122.399496166675) | ||
| 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) | |||
| 116818 | 116818 | 113391 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2151 15TH AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 12/10/2015 12:00:00 AM | 1 | Permit Number 776062 | 5991602.0 | 2100781.0 | 37.7478613219593 | -122.47182147099899 | (37.7478613219593, -122.471821470999) | |
| 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) | |||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |||
| 90103 | 90103 | 100046 | Property Tree 7 | Tree(s) :: 17 | 562 28th St | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/28/2012 12:00:00 AM | 17 | Permit Number 769057 | 6002262.0 | 2099459.0 | 37.7448424535299 | -122.43486521318898 | (37.7448424535299, -122.434865213189) | |||
| 99637 | 99637 | 100135 | Undocumented 2 | Tree(s) :: 17 | 155 05th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/27/2012 12:00:00 AM | 9 | Permit Number 769351 | 6011029.6 | 2112857.4 | 37.782125333955705 | -122.40549178692301 | (37.7821253339557, -122.405491786923) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||
| 81584 | 81584 | 107564 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 8 | 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) | ||
| 83430 | 83430 | 107562 | DPW Maintained 3 | 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) | ||
| 103606 | 103606 | 107561 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 12 | 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) | ||
| 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) | ||
| 120274 | 120274 | 107563 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 5 | 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) | ||
| 142715 | 142715 | 107544 | DPW Maintained 3 | Tree(s) :: 17 | 198X Jennings St | 5 | 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) | ||
| 103672 | 103672 | 113311 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 1001x Alemany Blvd | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/09/2015 12:00:00 AM | 20 | Permit Number 776808 | 6003491.75626 | 2094313.44879 | 37.7307836910976 | -122.430245918511 | (37.7307836910976, -122.430245918511) | ||
| 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) | |
| 102514 | 102514 | 107902 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 133 Elsie St | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 773996 | 6007164.40736 | 2098513.6513900002 | 37.742523860763995 | -122.417846568545 | (37.742523860764, -122.417846568545) | |||
| 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) | |||
| 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) | ||||
| 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) | |
| 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) | ||||
| 4771 | 4771 | 253556 | Permitted Site 1 | Tree(s) :: 17 | 27 Ceres St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:00:00 AM | 3 | Permit Number 780682 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | |
| 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) | ||
| 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) | |||
| 145579 | 145579 | 107674 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 133 ELSIE ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/10/2014 12:00:00 AM | 3 | 6007164.4 | 2098513.7 | 37.742523993822 | -122.41784659743799 | (37.742523993822, -122.417846597438) | |||
| 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) | ||||
| 84695 | 84695 | 113360 | Permitted Site 1 | Tree(s) :: 17 | 821 HEAD ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/08/2015 12:00:00 AM | 25 | 3x3 | Permit Number 776477 | 5993783.0 | 2091497.0 | 37.7224957130636 | -122.463606040268 | (37.7224957130636, -122.463606040268) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 77551 | 77551 | 116996 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 606x FULTON ST | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/29/2016 12:00:00 AM | 3 | 6004628.0 | 2111737.0 | 37.7786889706302 | -122.42755859051901 | (37.7786889706302, -122.427558590519) | ||||
| 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) | ||
| 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) | |||
| 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) | |||
| 40015 | 40015 | 58273 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 211 Brighton Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/20/1978 12:00:00 AM | Permit Number 17285 | 5996205.3244984 | 2091294.13562794 | 37.722077972487504 | -122.455218010255 | (37.7220779724875, -122.455218010255) | |||
| 3686 | 3686 | 253401 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3690 | 3690 | 253398 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3692 | 3692 | 253403 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3696 | 3696 | 253396 | Undocumented 2 | Tree(s) :: 17 | 400x Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6016185.0 | 2098125.0 | 37.741960230665995 | -122.38662864108801 | (37.741960230666, -122.386628641088) | |
| 3697 | 3697 | 253402 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3699 | 3699 | 253406 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3703 | 3703 | 253397 | Undocumented 2 | Tree(s) :: 17 | 400x Newhall St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6016185.0 | 2098125.0 | 37.741960230665995 | -122.38662864108801 | (37.741960230666, -122.386628641088) | |
| 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) |
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");