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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94650 | 94650 | 61652 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | Permit Number 21641 | 5993002.2450542 | 2114941.18121592 | 37.7868223445778 | -122.468009369168 | (37.7868223445778, -122.468009369168) | ||
| 114410 | 114410 | 37147 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1998 12:00:00 AM | Permit Number 39729 | 6006163.65409791 | 2100221.79185056 | 37.7471576573064 | -122.42142816381799 | (37.7471576573064, -122.421428163818) | ||
| 122248 | 122248 | 37149 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1998 12:00:00 AM | Permit Number 39729 | 6006163.65409791 | 2100221.79185056 | 37.7471576573064 | -122.42142816381799 | (37.7471576573064, -122.421428163818) | ||
| 145907 | 145907 | 37148 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 27th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1998 12:00:00 AM | Permit Number 39729 | 6006163.65409791 | 2100221.79185056 | 37.7471576573064 | -122.42142816381799 | (37.7471576573064, -122.421428163818) | ||
| 99989 | 99989 | 50515 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Ankeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47153 | 6011089.84046191 | 2089620.59314796 | 37.718325516545704 | -122.40364792757799 | (37.7183255165457, -122.403647927578) | ||
| 42481 | 42481 | 71284 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 5 | 5998802.9816 | 2111041.8064 | 37.7764489521659 | -122.447659448254 | (37.7764489521659, -122.447659448254) | ||
| 108179 | 108179 | 36016 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1 Aztec St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39162 | 6007570.41549465 | 2099594.16926829 | 37.7455135625182 | -122.41651923089701 | (37.7455135625182, -122.416519230897) | ||
| 94667 | 94667 | 35933 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1 Bache St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | Permit Number 39099 | 6007238.86373216 | 2095730.63225463 | 37.7348864958229 | -122.41739193639299 | (37.7348864958229, -122.417391936393) | ||
| 91850 | 91850 | 40265 | Permitted Site 1 | Yucca elephantipes :: Giant Yucca 211 | 1 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41424 | 6006673.49895553 | 2103768.88738222 | 37.756925903179706 | -122.419916824047 | (37.7569259031797, -122.419916824047) | ||
| 117013 | 117013 | 40267 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41424 | 6006673.49895553 | 2103768.88738222 | 37.756925903179706 | -122.419916824047 | (37.7569259031797, -122.419916824047) | ||
| 136514 | 136514 | 35869 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Boutwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 6 | Permit Number 39080 | 6010666.93779 | 2096840.63562 | 37.7381266097475 | -122.40561798198799 | (37.7381266097475, -122.405617981988) | |
| 137431 | 137431 | 35870 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Boutwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 3 | Permit Number 39080 | 6010672.98165 | 2096855.55492 | 37.738167912917106 | -122.405598135739 | (37.7381679129171, -122.405598135739) | |
| 146077 | 146077 | 35868 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1 Boutwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | Permit Number 39080 | 6010677.15913478 | 2096883.63230355 | 37.7382452410033 | -122.405585668988 | (37.7382452410033, -122.405585668988) | ||
| 109757 | 109757 | 60992 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31624 | 6004216.5458966 | 2095763.6003461003 | 37.7348065076562 | -122.42784349558998 | (37.7348065076562, -122.42784349559) | ||
| 83369 | 83369 | 66220 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1 Dolores Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1990 12:00:00 AM | Permit Number 29312 | 6005304.82019082 | 2105877.54249684 | 37.7626385702507 | -122.424800241819 | (37.7626385702507, -122.424800241819) | ||
| 100373 | 100373 | 37439 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42376 | 6007699.64971821 | 2099462.43084291 | 37.7451591053054 | -122.416063030013 | (37.7451591053054, -122.416063030013) | ||
| 106844 | 106844 | 37438 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42376 | 6007699.64971821 | 2099462.43084291 | 37.7451591053054 | -122.416063030013 | (37.7451591053054, -122.416063030013) | ||
| 153310 | 153310 | 43137 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 7 | Permit Number 42953 | 6005718.46144 | 2093462.75751 | 37.728573751977 | -122.42248741098601 | (37.728573751977, -122.422487410986) | |
| 24815 | 24815 | 50693 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Harrison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2004 12:00:00 AM | 3 | Permit Number 47259 | 6015899.29772 | 2115328.09963 | 37.789180398403396 | -122.388817224359 | (37.7891803984034, -122.388817224359) | |
| 31060 | 31060 | 50697 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015787.30845 | 2115222.67912 | 37.7888847301024 | -122.389197332691 | (37.7888847301024, -122.389197332691) | |
| 31340 | 31340 | 50690 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015829.14658 | 2115263.74647 | 37.7889998109335 | -122.38905544574699 | (37.7889998109335, -122.389055445747) | |
| 58180 | 58180 | 50686 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015866.591659999 | 2115301.03346 | 37.7891042680871 | -122.38892849385701 | (37.7891042680871, -122.388928493857) | |
| 65933 | 65933 | 50696 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Harrison St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2004 12:00:00 AM | 4 | Permit Number 47259 | 6015925.73831 | 2115354.86226 | 37.7892553479159 | -122.388727611399 | (37.7892553479159, -122.388727611399) | |
| 132524 | 132524 | 50689 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2004 12:00:00 AM | 6 | Permit Number 47259 | 6015816.80871 | 2115251.31458 | 37.7889649918797 | -122.389097265149 | (37.7889649918797, -122.389097265149) | |
| 137508 | 137508 | 50695 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2004 12:00:00 AM | 4 | Permit Number 47259 | 6015937.15224 | 2115364.30383 | 37.7892819048945 | -122.38868877958099 | (37.7892819048945, -122.388688779581) | |
| 150556 | 150556 | 50687 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015799.79693 | 2115231.8840799998 | 37.7889106971282 | -122.389154766877 | (37.7889106971282, -122.389154766877) | |
| 165482 | 165482 | 50688 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2004 12:00:00 AM | 4 | Permit Number 47259 | 6015806.91345 | 2115242.27212 | 37.788939614816606 | -122.389130870094 | (37.7889396148166, -122.389130870094) | |
| 166065 | 166065 | 50694 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Harrison St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2004 12:00:00 AM | 3 | Permit Number 47259 | 6015915.16555 | 2115344.32909 | 37.7892258402606 | -122.388763456582 | (37.7892258402606, -122.388763456582) | |
| 185949 | 185949 | 50691 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015877.9319 | 2115306.82257 | 37.789120792226704 | -122.38888966205201 | (37.7891207922267, -122.388889662052) | |
| 140958 | 140958 | 46133 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44496 | 5996328.40935041 | 2106768.45994323 | 37.7645737153289 | -122.45591064533001 | (37.7645737153289, -122.45591064533) | ||
| 117708 | 117708 | 36932 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/2003 12:00:00 AM | Permit Number 39573 | 6000605.12386462 | 2102858.71031165 | 37.7540830303141 | -122.440838195083 | (37.7540830303141, -122.440838195083) | ||
| 142370 | 142370 | 36933 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39573 | 6000605.12386462 | 2102858.71031165 | 37.7540830303141 | -122.440838195083 | (37.7540830303141, -122.440838195083) | ||
| 145075 | 145075 | 36931 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Hoffman Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39573 | 6000605.12386462 | 2102858.71031165 | 37.7540830303141 | -122.440838195083 | (37.7540830303141, -122.440838195083) | ||
| 92700 | 92700 | 63366 | Permitted Site 1 | Olea Majestic Beauty :: 192 | 1 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41545 | 6006308.21143459 | 2096885.36921844 | 37.7380047408881 | -122.420691480393 | (37.7380047408881, -122.420691480393) | ||
| 959 | 959 | 83601 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2008 12:00:00 AM | 5 | 6009088.96788 | 2112689.1650900003 | 37.7815547005346 | -122.41219362785499 | (37.7815547005346, -122.412193627855) | ||
| 82561 | 82561 | 60444 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | Permit Number 20028 | 5997483.83946465 | 2089883.9709991 | 37.7182792597053 | -122.45069689971001 | (37.7182792597053, -122.45069689971) | ||
| 30093 | 30093 | 30664 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 3 | Permit Number 46640 | 6006594.41261 | 2109123.24947 | 37.7716232677391 | -122.420570406196 | (37.7716232677391, -122.420570406196) | |
| 56201 | 56201 | 30662 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 2 | Permit Number 46640 | 6006559.28152 | 2109117.66624 | 37.771605957578394 | -122.42069153050801 | (37.7716059575784, -122.420691530508) | |
| 103263 | 103263 | 30665 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 McCoppin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | Permit Number 46640 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
| 113758 | 113758 | 30668 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34595 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
| 141337 | 141337 | 30667 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34595 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
| 142462 | 142462 | 30666 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 McCoppin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | Permit Number 46640 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
| 168897 | 168897 | 30669 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 2 | Permit Number 46640 | 6006474.54027 | 2109116.5589 | 37.7715981406638 | -122.42098457729999 | (37.7715981406638, -122.4209845773) | |
| 177721 | 177721 | 30663 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 3 | Permit Number 46640 | 6006564.909030001 | 2109121.1634 | 37.7716158771129 | -122.420672312891 | (37.7716158771129, -122.420672312891) | |
| 98990 | 98990 | 96158 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767791 | 6003728.0 | 2095595.0 | 37.7343159198258 | -122.429520547314 | (37.7343159198258, -122.429520547314) | |
| 43560 | 43560 | 67530 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | 12 | Permit Number 31068 | 6013998.45944 | 2106956.61768 | 37.766088665392296 | -122.394807417822 | (37.7660886653923, -122.394807417822) | |
| 79272 | 79272 | 41698 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1 Mizpah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | ||
| 117825 | 117825 | 41697 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1 Mizpah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | ||
| 120499 | 120499 | 41696 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1 Mizpah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | ||
| 129271 | 129271 | 64809 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Newburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1991 12:00:00 AM | Permit Number 29687 | 6002621.59304129 | 2100025.86145885 | 37.74641933227171 | -122.433662314673 | (37.7464193322717, -122.433662314673) | ||
| 98840 | 98840 | 42078 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 Norwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42388 | 6009309.20723614 | 2099453.41599437 | 37.7452247183965 | -122.410496799342 | (37.7452247183965, -122.410496799342) | ||
| 121829 | 121829 | 42077 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42388 | 6009309.20723614 | 2099453.41599437 | 37.7452247183965 | -122.410496799342 | (37.7452247183965, -122.410496799342) | ||
| 9818 | 9818 | 46930 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9820 | 9820 | 46927 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9821 | 9821 | 46929 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 102098 | 102098 | 63132 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1986 12:00:00 AM | Permit Number 23647 | 6007381.00519533 | 2099650.19530239 | 37.745656743507205 | -122.417178153084 | (37.7456567435072, -122.417178153084) | ||
| 179289 | 179289 | 62212 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 11 | Permit Number 22335 | 6001303.33369 | 2093769.8822599999 | 37.729166984360795 | -122.437772711138 | (37.7291669843608, -122.437772711138) | |
| 81759 | 81759 | 46740 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Sargent St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44847 | 5994017.67630199 | 2089152.6927278999 | 37.7160723272597 | -122.46262485198 | (37.7160723272597, -122.46262485198) | ||
| 78496 | 78496 | 67777 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1992 12:00:00 AM | Permit Number 31410 | 6002409.66817054 | 2108299.95353081 | 37.7691259721047 | -122.43498677415 | (37.7691259721047, -122.43498677415) | ||
| 141736 | 141736 | 66862 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1 Seward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30169 | 6001132.20475531 | 2104197.53815823 | 37.7577891313172 | -122.43911137402 | (37.7577891313172, -122.43911137402) | ||
| 80475 | 80475 | 36472 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Southwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39369 | 5995851.10989113 | 2092636.8943718998 | 37.72574453903471 | -122.456539488375 | (37.7257445390347, -122.456539488375) | ||
| 98025 | 98025 | 36474 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Southwood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39369 | 5995851.10989113 | 2092636.8943718998 | 37.72574453903471 | -122.456539488375 | (37.7257445390347, -122.456539488375) | ||
| 98854 | 98854 | 36475 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39369 | 5995851.10989113 | 2092636.8943718998 | 37.72574453903471 | -122.456539488375 | (37.7257445390347, -122.456539488375) | ||
| 111906 | 111906 | 36473 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Southwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39369 | 5995851.10989113 | 2092636.8943718998 | 37.72574453903471 | -122.456539488375 | (37.7257445390347, -122.456539488375) | ||
| 42743 | 42743 | 108444 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 2 | 3x2.5 | 6014877.0 | 2117007.0 | 37.793733556134896 | -122.39247175850299 | (37.7937335561349, -122.392471758503) | |
| 99024 | 99024 | 33412 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37524 | 5994620.13154757 | 2093710.13909457 | 37.7286206582893 | -122.46087260530099 | (37.7286206582893, -122.460872605301) | ||
| 102234 | 102234 | 33413 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1 Upland Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37524 | 5994620.13154757 | 2093710.13909457 | 37.7286206582893 | -122.46087260530099 | (37.7286206582893, -122.460872605301) | ||
| 187546 | 187546 | 32262 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 10 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 3 | Permit Number 35561 | 6005748.8799 | 2099664.71545 | 37.7456046578383 | -122.422822837406 | (37.7456046578383, -122.422822837406) | |
| 149572 | 149572 | 43131 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 10 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 13 | Permit Number 42949 | 6005359.04012 | 2093269.09738 | 37.7280217211146 | -122.42371618797199 | (37.7280217211146, -122.423716187972) | |
| 109318 | 109318 | 63148 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 10 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1986 12:00:00 AM | Permit Number 23673 | 6007776.40437523 | 2099380.37669583 | 37.7449381181537 | -122.415791815827 | (37.7449381181537, -122.415791815827) | ||
| 60328 | 60328 | 80384 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 10 Bridgeview Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 4 | 6014069.489630001 | 2095395.06223 | 37.7343470415729 | -122.393752415043 | (37.7343470415729, -122.393752415043) | ||
| 89015 | 89015 | 66177 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | Permit Number 29250 | 6009347.85081362 | 2097405.9142613 | 37.739604892580296 | -122.41021864302 | (37.7396048925803, -122.41021864302) | ||
| 93120 | 93120 | 64177 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/1987 12:00:00 AM | Permit Number 24960 | 5992869.30578156 | 2093188.45106841 | 37.7270873338596 | -122.466887350359 | (37.7270873338596, -122.466887350359) | ||
| 165697 | 165697 | 37346 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 10 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 8 | Permit Number 39854 | 6000448.88189 | 2088637.7293200002 | 37.7150266380306 | -122.44035870091899 | (37.7150266380306, -122.440358700919) | |
| 122562 | 122562 | 65473 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 10 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29345 | 5995326.58257059 | 2091913.57647422 | 37.7237283530048 | -122.45830039747 | (37.7237283530048, -122.45830039747) | ||
| 19691 | 19691 | 108972 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 10 Dearborn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772927 | 6005770.7 | 2106026.5 | 37.7630738748169 | -122.42319951773399 | (37.7630738748169, -122.423199517734) |
| 38648 | 38648 | 68912 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 10 Florence St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32890 | 6008496.870730001 | 2118345.67653 | 37.797052862167604 | -122.41464241973 | (37.7970528621676, -122.41464241973) | |
| 140794 | 140794 | 33186 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 10 Hernandez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37395 | 5996266.46691621 | 2100062.84329994 | 37.7461582283752 | -122.45564015783 | (37.7461582283752, -122.45564015783) | ||
| 105011 | 105011 | 46168 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44497 | 5996113.80902962 | 2106861.13745227 | 37.7648158648531 | -122.45665958836399 | (37.7648158648531, -122.456659588364) | ||
| 118844 | 118844 | 66560 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 Lupine Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | Permit Number 29748 | 5998362.4893973 | 2113830.03162696 | 37.7840795084333 | -122.449384168554 | (37.7840795084333, -122.449384168554) | ||
| 119422 | 119422 | 44488 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 10 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43793 | 6005343.80293821 | 2093494.88287982 | 37.728640818207104 | -122.423784911051 | (37.7286408182071, -122.423784911051) | ||
| 84571 | 84571 | 66285 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31629 | 6004295.09294916 | 2095637.08175846 | 37.7344635592859 | -122.427562920462 | (37.7344635592859, -122.427562920462) | ||
| 108737 | 108737 | 50468 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 10 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 778534 | 5995312.36828974 | 2100223.18422456 | 37.7465436862786 | -122.45895089565501 | (37.7465436862786, -122.458950895655) | |
| 123229 | 123229 | 42079 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42389 | 6009265.41363365 | 2099503.07167939 | 37.7453586067376 | -122.41065173677299 | (37.7453586067376, -122.410651736773) | ||
| 165156 | 165156 | 69496 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 10 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 6 | Permit Number 33619 | 6000930.02783 | 2092989.43743 | 37.7270028279165 | -122.439007348127 | (37.7270028279165, -122.439007348127) | |
| 119134 | 119134 | 68399 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 10 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32230 | 5993170.65048654 | 2093114.37273837 | 37.7269013208382 | -122.465840234227 | (37.7269013208382, -122.465840234227) | ||
| 76190 | 76190 | 36891 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Presidio Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 8 | Permit Number 39545 | 5998941.55957 | 2116543.3234900003 | 37.7915626017771 | -122.447576181201 | (37.7915626017771, -122.447576181201) | |
| 164756 | 164756 | 36892 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 10 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 9 | Permit Number 39545 | 5998941.54083 | 2116530.8219 | 37.7915282746499 | -122.44757534573799 | (37.7915282746499, -122.447575345738) | |
| 79555 | 79555 | 36268 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.730188986750605 | -122.47264888645701 | (37.7301889867506, -122.472648886457) | ||
| 101773 | 101773 | 36269 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.730188986750605 | -122.47264888645701 | (37.7301889867506, -122.472648886457) | ||
| 114099 | 114099 | 36271 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Rossmoor Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.730188986750605 | -122.47264888645701 | (37.7301889867506, -122.472648886457) | ||
| 119787 | 119787 | 36270 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Rossmoor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.730188986750605 | -122.47264888645701 | (37.7301889867506, -122.472648886457) | ||
| 116649 | 116649 | 69544 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 10 Sunview Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | Permit Number 38761 | 5999147.7039919 | 2100445.64774603 | 37.7473742386597 | -122.445704765344 | (37.7473742386597, -122.445704765344) | ||
| 115398 | 115398 | 39512 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 10 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2005 12:00:00 AM | Permit Number 48185 | 6004053.55723632 | 2102994.83081039 | 37.7546525762409 | -122.428922380275 | (37.7546525762409, -122.428922380275) | ||
| 93538 | 93538 | 65368 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 10 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1989 12:00:00 AM | Permit Number 28206 | 6003053.48376145 | 2095454.29402477 | 37.733891359152395 | -122.43184252277 | (37.7338913591524, -122.43184252277) | ||
| 29132 | 29132 | 31972 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995228.46958 | 2114784.79077 | 37.786521248530995 | -122.46029586964701 | (37.786521248531, -122.460295869647) | |
| 29438 | 29438 | 31973 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995224.68838 | 2114814.58842 | 37.7866028473263 | -122.460311111336 | (37.7866028473263, -122.460311111336) | |
| 34675 | 34675 | 31971 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 9 | Permit Number 35372 | 5995225.90281 | 2114852.20624 | 37.786706205556 | -122.46030963631 | (37.786706205556, -122.46030963631) | |
| 51552 | 51552 | 68319 | Permitted Site 1 | Heteromeles arbutifolia :: Toyon 322 | 100 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32134 | 5993677.209627 | 2114838.05789906 | 37.786578151303104 | -122.46566667324801 | (37.7865781513031, -122.465666673248) | ||
| 62981 | 62981 | 56298 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 7 | Permit Number 32247 | 5993056.25051 | 2114776.86302 | 37.7863742905451 | -122.467810568951 | (37.7863742905451, -122.467810568951) |
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");