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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64137 | 64137 | 75992 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 188 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994660.40681 | 2086732.9831599998 | 37.7094653698917 | -122.46022807666401 | (37.7094653698917, -122.460228076664) | ||
| 135069 | 135069 | 71610 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 265 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 8 | 5994208.54554 | 2086740.2113599998 | 37.7094592149285 | -122.46179029709499 | (37.7094592149285, -122.461790297095) | ||
| 148621 | 148621 | 37360 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 256 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | Permit Number 39866 | 5999649.26348 | 2086749.4239700001 | 37.7097962152035 | -122.44298698756 | (37.7097962152035, -122.44298698756) | |
| 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) | |
| 82368 | 82368 | 31007 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34781 | 6001462.17793128 | 2086756.21041895 | 37.7099180463866 | -122.43672172056601 | (37.7099180463866, -122.436721720566) | ||
| 40596 | 40596 | 69408 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 981 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33513 | 6001538.598040001 | 2086768.9797900002 | 37.7099574510375 | -122.43645851206301 | (37.7099574510375, -122.436458512063) | |
| 169684 | 169684 | 81047 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 961 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 2 | 6001634.7016900005 | 2086773.55642 | 37.7099754779527 | -122.436126687404 | (37.7099754779527, -122.436126687404) | ||
| 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) | ||
| 135030 | 135030 | 75408 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994441.08765 | 2086786.6315099997 | 37.7096000577555 | -122.460989960739 | (37.7096000577555, -122.460989960739) | ||
| 176496 | 176496 | 75331 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994458.53323 | 2086786.7483599999 | 37.709601382461294 | -122.460929674682 | (37.7096013824613, -122.460929674682) | ||
| 149098 | 149098 | 75250 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994476.95751 | 2086787.3271700002 | 37.7096040318843 | -122.460866039547 | (37.7096040318843, -122.460866039547) | ||
| 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) | |
| 11809 | 11809 | 108541 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401-423X Wheeler Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011955.27785 | 2086793.07341 | 37.710610019802296 | -122.40045795358999 | (37.7106100198023, -122.40045795359) |
| 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) | ||
| 102413 | 102413 | 108826 | Undocumented 2 | :: 54 | 146-150X Gillette Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6013072.89275 | 2086799.9167400002 | 37.7106910734067 | -122.39659568235001 | (37.7106910734067, -122.39659568235) | ||||
| 128846 | 128846 | 108824 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 146-150X Gillette Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6013072.89275 | 2086799.9167400002 | 37.7106910734067 | -122.39659568235001 | (37.7106910734067, -122.39659568235) | |
| 140964 | 140964 | 108825 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 146-150X Gillette Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6013072.89275 | 2086799.9167400002 | 37.7106910734067 | -122.39659568235001 | (37.7106910734067, -122.39659568235) | |
| 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) | ||
| 10329 | 10329 | 109051 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772570 | 5995048.30925 | 2086814.9244099997 | 37.7097126663738 | -122.45889335865 | (37.7097126663738, -122.45889335865) |
| 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) | ||
| 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) | |
| 10657 | 10657 | 108540 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401-423X Wheeler Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011963.42578 | 2086819.2708400001 | 37.710682407129795 | -122.400431631316 | (37.7106824071298, -122.400431631316) |
| 11149 | 11149 | 61515 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 84 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 11 | 3x3 | Permit Number 21471 | 5994704.395 | 2086819.71376 | 37.7097060419596 | -122.46008232624901 | (37.7097060419596, -122.460082326249) |
| 36293 | 36293 | 71578 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 94X De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 13 | 5994610.40755 | 2086820.2353700001 | 37.709702067873 | -122.460407199135 | (37.709702067873, -122.460407199135) | ||
| 117477 | 117477 | 37344 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 571 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39852 | 5999120.28976365 | 2086823.35415522 | 37.7099690371181 | -122.444820521553 | (37.7099690371181, -122.444820521553) | ||
| 11587 | 11587 | 108539 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401-423X Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011972.2839 | 2086844.7313299999 | 37.710752810563996 | -122.400402802668 | (37.710752810564, -122.400402802668) |
| 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) | ||
| 116313 | 116313 | 52513 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 60 Lawrence Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48618 | 5997208.37126376 | 2086857.00593017 | 37.709952140530895 | -122.451430868837 | (37.7099521405309, -122.451430868837) | ||
| 111474 | 111474 | 98267 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 98X De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5994599.8 | 2086859.2 | 37.7098084453918 | -122.460446681932 | (37.7098084453918, -122.460446681932) | |||
| 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) | |
| 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) |
| 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) | ||
| 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) | |
| 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) | |
| 58904 | 58904 | 44740 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 235 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 5 | Permit Number 43858 | 5992059.17709 | 2086878.10482 | 37.7097138705641 | -122.469228836168 | (37.7097138705641, -122.469228836168) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 126483 | 126483 | 49776 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 110 Talbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46562 | 6010272.64518115 | 2086887.71649918 | 37.710775910974704 | -122.406280195673 | (37.7107759109747, -122.406280195673) | ||
| 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) |
| 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) |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 130109 | 130109 | 78715 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 190 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | 5 | 6008812.7369 | 2086938.0409099997 | 37.710832318719504 | -122.411329543927 | (37.7108323187195, -122.411329543927) | ||
| 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) | |
| 179704 | 179704 | 44738 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 224 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 6 | Permit Number 43855 | 5992028.811919999 | 2086945.8058900002 | 37.7098980067533 | -122.46933870721901 | (37.7098980067533, -122.469338707219) | |
| 134606 | 134606 | 44739 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 227 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 43856 | 5992060.248430001 | 2086948.89288 | 37.709908299502004 | -122.469230282263 | (37.709908299502, -122.469230282263) | |
| 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) | |
| 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) | |
| 48000 | 48000 | 77997 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 924 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 5 | 6009714.16253 | 2086968.8520900002 | 37.710967436463704 | -122.408216166539 | (37.7109674364637, -122.408216166539) | ||
| 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) | |
| 170312 | 170312 | 44447 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 59 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 5 | Permit Number 43776 | 6002676.42201 | 2086971.7309400002 | 37.7105787512666 | -122.432540451876 | (37.7105787512666, -122.432540451876) | |
| 10689 | 10689 | 44737 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 220 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 10 | Permit Number 43854 | 5992028.1183 | 2086972.4785799999 | 37.7099712034746 | -122.469343044645 | (37.7099712034746, -122.469343044645) | |
| 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) | ||
| 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) | |
| 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) | |
| 158534 | 158534 | 44429 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002292.23602 | 2086990.00901 | 37.7106071446722 | -122.433869586918 | (37.7106071446722, -122.433869586918) | |
| 47084 | 47084 | 49781 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 308@ BLANKEN Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 6 | Permit Number 46566 | 6012565.764330001 | 2086991.30055 | 37.71118833875371 | -122.39836186320801 | (37.7111883387537, -122.398361863208) | |
| 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) | ||
| 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) | ||
| 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) | |
| 146266 | 146266 | 109076 | Property Tree 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1137 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 772744 | 6001554.7 | 2087011.6 | 37.7106245477128 | -122.43642021389401 | (37.7106245477128, -122.436420213894) | ||
| 3991 | 3991 | 44420 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 859 Prague St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2017 08:03:00 AM | 3 | Permit Number 43768 | 6002331.23577 | 2087017.31055 | 37.710684321803896 | -122.433736745364 | (37.7106843218039, -122.433736745364) | |
| 1846 | 1846 | 251738 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) | ||||
| 29180 | 29180 | 44428 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 2 | Permit Number 43768 | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) |
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");