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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 185946 | 185946 | 31054 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 209 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 4 | Permit Number 34807 | 6003260.06759 | 2086751.8746200001 | 37.7100081539218 | -122.430507568565 | (37.7100081539218, -122.430507568565) | |
| 102786 | 102786 | 69410 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1033 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33515 | 6001287.00169166 | 2086793.18756043 | 37.7100096203988 | -122.43732980748699 | (37.7100096203988, -122.437329807487) | ||
| 185618 | 185618 | 78542 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 918 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 11 | 5996973.29255 | 2086886.4307 | 37.710019470088206 | -122.452245463059 | (37.7100194700882, -122.452245463059) | ||
| 25304 | 25304 | 78734 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 901 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 4 | 5997023.15719 | 2086886.0352900003 | 37.710021240846 | -122.452073093618 | (37.710021240846, -122.452073093618) | ||
| 100721 | 100721 | 57262 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1063 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | Permit Number 14553 | 6001117.51152299 | 2086803.56775356 | 37.7100284852727 | -122.43791633997101 | (37.7100284852727, -122.437916339971) | ||
| 129674 | 129674 | 44736 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 219 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 11 | Permit Number 43853 | 5992060.83811 | 2086996.78191 | 37.7100398253609 | -122.469231727479 | (37.7100398253609, -122.469231727479) | |
| 4279 | 4279 | 78830 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 35 Laura St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/2017 04:01:00 PM | 3 | 5997431.0713 | 2086896.39523 | 37.7100730444948 | -122.450664016958 | (37.7100730444948, -122.450664016958) | ||
| 103749 | 103749 | 69409 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 990 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33514 | 6001528.72905075 | 2086815.30428152 | 37.710084087104896 | -122.43649593455099 | (37.7100840871049, -122.436495934551) | ||
| 54723 | 54723 | 78733 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 901.2 Huron Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 3 | 5997045.646919999 | 2086908.4630900002 | 37.7100841106663 | -122.45199698219801 | (37.7100841106663, -122.451996982198) | ||
| 11377 | 11377 | 108847 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 970 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001586.13513 | 2086816.33243 | 37.7100901720951 | -122.43629760175101 | (37.7100901720951, -122.436297601751) | |
| 12058 | 12058 | 108846 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 970 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001611.41863 | 2086816.80035 | 37.7100928934503 | -122.436210250619 | (37.7100928934503, -122.436210250619) | |
| 53994 | 53994 | 31055 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 209 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 6 | Permit Number 34807 | 6003240.30345 | 2086787.7714 | 37.7101055990722 | -122.430578436949 | (37.7101055990722, -122.430578436949) | |
| 154735 | 154735 | 81046 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 35 Laura St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 0 | 5997413.7835 | 2086913.9109900002 | 37.7101201491898 | -122.450725028737 | (37.7101201491898, -122.450725028737) | ||
| 94038 | 94038 | 31044 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1170 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34802 | 6000764.32963575 | 2086845.61786645 | 37.710123855039896 | -122.439140013916 | (37.7101238550399, -122.439140013916) | ||
| 127451 | 127451 | 31045 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1170 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34802 | 6000764.32963575 | 2086845.61786645 | 37.710123855039896 | -122.439140013916 | (37.7101238550399, -122.439140013916) | ||
| 99233 | 99233 | 31042 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1160 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34801 | 6000799.02081427 | 2086846.59721813 | 37.7101285180714 | -122.43902018475201 | (37.7101285180714, -122.439020184752) | ||
| 105127 | 105127 | 31041 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1150 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34800 | 6000833.71199279 | 2086847.57656981 | 37.7101331809809 | -122.43890035557199 | (37.7101331809809, -122.438900355572) | ||
| 116522 | 116522 | 31040 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1142 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34799 | 6000861.46493561 | 2086848.36005116 | 37.7101369112208 | -122.438804492218 | (37.7101369112208, -122.438804492218) | ||
| 12043 | 12043 | 108683 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 384 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774613 | 6000302.208459999 | 2086863.37515 | 37.7101463059777 | -122.44073846482401 | (37.7101463059777, -122.440738464824) |
| 34901 | 34901 | 108776 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 80279 | 80279 | 108768 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 80792 | 80792 | 108763 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 84811 | 84811 | 108770 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 97559 | 97559 | 108774 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 103563 | 103563 | 108764 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 103669 | 103669 | 108777 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 103975 | 103975 | 108778 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 114658 | 114658 | 108766 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 115794 | 115794 | 108772 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 115978 | 115978 | 108771 | Undocumented 2 | :: 54 | 500X Lathrop Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | ||||
| 122059 | 122059 | 108765 | Undocumented 2 | :: 54 | 500X Lathrop Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | ||||
| 126629 | 126629 | 108762 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 127494 | 127494 | 108775 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 500X Lathrop Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 128675 | 128675 | 108767 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Lathrop Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 144398 | 144398 | 108769 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 145235 | 145235 | 108773 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 500X Lathrop Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | |
| 70257 | 70257 | 37359 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 200 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 7 | Permit Number 39865 | 5999585.23741 | 2086907.24047 | 37.7102258932876 | -122.44321959991899 | (37.7102258932876, -122.443219599919) | |
| 12022 | 12022 | 108898 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 378 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772818 | 6000293.95374 | 2086893.3367700002 | 37.7102281038126 | -122.440769142495 | (37.7102281038126, -122.440769142495) |
| 97508 | 97508 | 108899 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 16 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772775 | 6000547.04329 | 2086890.00633 | 37.710233369404605 | -122.43989417722 | (37.7102333694046, -122.43989417722) |
| 163155 | 163155 | 44418 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 4 | Permit Number 43768 | 6002034.50312 | 2086862.32419 | 37.7102419210068 | -122.43475124269199 | (37.7102419210068, -122.434751242692) | |
| 186303 | 186303 | 65735 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 381 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 9 | Permit Number 28671 | 6000320.2870000005 | 2086910.79586 | 37.710277542235396 | -122.440679381145 | (37.7102775422354, -122.440679381145) | |
| 49228 | 49228 | 44454 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 95 Winding Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43779 | 6002576.22413505 | 2086867.96270094 | 37.710288143695 | -122.43287934894899 | (37.710288143695, -122.432879348949) | ||
| 95542 | 95542 | 44455 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 95 Winding Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43779 | 6002576.22413505 | 2086867.96270094 | 37.710288143695 | -122.43287934894899 | (37.710288143695, -122.432879348949) | ||
| 115695 | 115695 | 44453 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 95 Winding Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43779 | 6002576.22413505 | 2086867.96270094 | 37.710288143695 | -122.43287934894899 | (37.710288143695, -122.432879348949) | ||
| 159758 | 159758 | 44419 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002078.76238 | 2086879.7985099999 | 37.71029241432179 | -122.434599522549 | (37.7102924143218, -122.434599522549) | |
| 12503 | 12503 | 93870 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400-422X Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773818 | 6012462.01959 | 2086667.4072599998 | 37.7102932120209 | -122.398697717749 | (37.7102932120209, -122.398697717749) |
| 182397 | 182397 | 78518 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 Laura St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 0 | 5997355.58596 | 2086978.87375 | 37.7102951905332 | -122.450930851174 | (37.7102951905332, -122.450930851174) | ||
| 106055 | 106055 | 95590 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 95 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767380 | 6002599.7 | 2086870.1 | 37.7102953437444 | -122.432798364191 | (37.7102953437444, -122.432798364191) | |
| 180116 | 180116 | 44421 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002090.25454 | 2086883.7470599997 | 37.7103039085691 | -122.434560085477 | (37.7103039085691, -122.434560085477) | |
| 29342 | 29342 | 78567 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 40 Sears St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 0 | 5996717.44875 | 2086996.04025 | 37.7103057728767 | -122.453137611232 | (37.7103057728767, -122.453137611232) | ||
| 37323 | 37323 | 44456 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 95 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | 5 | Permit Number 43779 | 6002571.72829 | 2086874.98861 | 37.710307180311105 | -122.432895389109 | (37.7103071803111, -122.432895389109) | |
| 36205 | 36205 | 44457 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 95 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 5 | Permit Number 43779 | 6002582.01071 | 2086882.75579 | 37.7103290904997 | -122.432860405496 | (37.7103290904997, -122.432860405496) | |
| 39626 | 39626 | 78781 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 Laura St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 0 | 5997342.70536 | 2086993.5441299998 | 37.7103347346378 | -122.450976426135 | (37.7103347346378, -122.450976426135) | ||
| 13070 | 13070 | 93869 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400-422X Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773818 | 6012466.99875 | 2086683.8296 | 37.7103385819422 | -122.398681660343 | (37.7103385819422, -122.398681660343) |
| 177445 | 177445 | 65734 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 366 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 7 | Permit Number 28670 | 6000278.09754 | 2086937.20541 | 37.710347654302794 | -122.440827089403 | (37.7103476543028, -122.440827089403) | |
| 56327 | 56327 | 44423 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002132.446330001 | 2086900.81583 | 37.7103531707288 | -122.4344154817 | (37.7103531707288, -122.4344154817) | |
| 81006 | 81006 | 44422 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838002 | (37.7103613194328, -122.43434417838) | ||
| 95605 | 95605 | 44435 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838002 | (37.7103613194328, -122.43434417838) | ||
| 96321 | 96321 | 44427 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838002 | (37.7103613194328, -122.43434417838) | ||
| 120731 | 120731 | 44424 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838002 | (37.7103613194328, -122.43434417838) | ||
| 122782 | 122782 | 44426 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838002 | (37.7103613194328, -122.43434417838) | ||
| 128455 | 128455 | 44432 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838002 | (37.7103613194328, -122.43434417838) | ||
| 153681 | 153681 | 44451 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 81 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 10 | Permit Number 48336 | 6002602.78622 | 2086898.2858 | 37.710372910849706 | -122.43278970978001 | (37.7103729108497, -122.43278970978) | |
| 49920 | 49920 | 44434 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002147.41851 | 2086908.48033 | 37.7103750656342 | -122.434364282404 | (37.7103750656342, -122.434364282404) | |
| 134225 | 134225 | 37343 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 517 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 4 | Permit Number 39851 | 5999456.75939 | 2086965.30426 | 37.71037799650679 | -122.443667813037 | (37.7103779965068, -122.443667813037) | |
| 176823 | 176823 | 44433 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 4 | Permit Number 43768 | 6002157.33037 | 2086913.45824 | 37.710389296500296 | -122.434330380639 | (37.7103892965003, -122.434330380639) | |
| 11621 | 11621 | 76445 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 3x3 | 5998808.0264099995 | 2086988.0844400001 | 37.710403523785 | -122.445911599067 | (37.710403523785, -122.445911599067) | |
| 105452 | 105452 | 37342 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 507 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 15 | Permit Number 39850 | 5999504.92576 | 2086983.7691900001 | 37.71043144412221 | -122.44350266602801 | (37.7104314441222, -122.443502666028) | |
| 64098 | 64098 | 44448 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 6 | Permit Number 43777 | 6002641.71413 | 2086935.0699 | 37.710476119736704 | -122.432657792736 | (37.7104761197367, -122.432657792736) | |
| 166288 | 166288 | 44417 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 848 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 10 | Permit Number 43767 | 6002130.68513 | 2086945.75609 | 37.710476466874496 | -122.43442477978 | (37.7104764668745, -122.43442477978) | |
| 3953 | 3953 | 44431 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 859 Prague St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2017 11:19:00 AM | 3 | Permit Number 43768 | 6002228.37284 | 2086951.06128 | 37.71049657842789 | -122.434087529513 | (37.7104965784279, -122.434087529513) | |
| 156552 | 156552 | 44430 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 2 | Permit Number 43768 | 6002242.73231 | 2086958.14042 | 37.7105168311469 | -122.43403840586201 | (37.7105168311469, -122.434038405862) | |
| 59346 | 59346 | 44416 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 842 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 13 | Permit Number 43766 | 6002162.64544 | 2086961.7492400003 | 37.7105221947079 | -122.43431546089501 | (37.7105221947079, -122.434315460895) | |
| 12985 | 12985 | 76427 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 3 | 3x3 | 5998792.69271 | 2087037.2667900003 | 37.710537691825294 | -122.445968130449 | (37.7105376918253, -122.445968130449) | |
| 94957 | 94957 | 42745 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 104272 | 104272 | 42748 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 104865 | 104865 | 42746 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 117521 | 117521 | 42753 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 120556 | 120556 | 42751 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 121918 | 121918 | 42752 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 123346 | 123346 | 42750 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 141602 | 141602 | 42744 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 144135 | 144135 | 42747 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 144300 | 144300 | 42749 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 41536 | 41536 | 44425 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 2 | Permit Number 43768 | 6002264.418869999 | 2086971.0481599998 | 37.7105535037251 | -122.433964374559 | (37.7105535037251, -122.433964374559) | |
| 79808 | 79808 | 37377 | Permitted Site 1 | Shrub :: Shrub 98 | 755 Morse St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 2 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 84241 | 84241 | 37371 | Permitted Site 1 | Shrub :: Shrub 98 | 755 Morse St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 2 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 84417 | 84417 | 37376 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 84675 | 84675 | 37375 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 755 Morse St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 91068 | 91068 | 37374 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 93477 | 93477 | 37378 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 95427 | 95427 | 37372 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 101108 | 101108 | 37381 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 755 Morse St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 102673 | 102673 | 37386 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 755 Morse St | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 106497 | 106497 | 37368 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 107719 | 107719 | 37383 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 755 Morse St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 109826 | 109826 | 37384 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 110425 | 110425 | 37367 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | 5 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 111807 | 111807 | 37385 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 755 Morse St | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 112545 | 112545 | 37370 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 755 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 4 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
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");