Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21616 | 21616 | 25457 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/10/1997 12:00:00 AM | 6 | 3X3 | 5993681.7949 | 2088543.8714 | 37.7143812997511 | -122.463741645146 | (37.7143812997511, -122.463741645146) | ||
| 21638 | 21638 | 18577 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/12/1998 12:00:00 AM | 6 | 3X3 | 5993712.2633 | 2088544.8235 | 37.7143856696584 | -122.46363640417201 | (37.7143856696584, -122.463636404172) | ||
| 14183 | 14183 | 7380 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010853.2469 | 2111475.4662 | 37.7783210049209 | -122.40600450833401 | (37.7783210049209, -122.406004508334) | |||
| 15454 | 15454 | 7377 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010910.3764 | 2111530.9317 | 37.7784764953194 | -122.405810783213 | (37.7784764953194, -122.405810783213) | |||
| 15604 | 15604 | 7382 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 60 | 3X3 | 6010814.6984 | 2111439.6909 | 37.7782206182135 | -122.406135341461 | (37.7782206182135, -122.406135341461) | |||
| 15693 | 15693 | 7378 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010884.8623 | 2111505.4176 | 37.7784050126686 | -122.40589724881 | (37.7784050126686, -122.40589724881) | |||
| 16764 | 16764 | 7379 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010870.4412 | 2111489.3325 | 37.7783600402028 | -122.40594600363998 | (37.7783600402028, -122.40594600364) | |||
| 78664 | 78664 | 13380 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000X Mansell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 86895 | 86895 | 13384 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1000X Mansell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 92208 | 92208 | 13378 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000X Mansell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/13/2000 12:00:00 AM | 3 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | ||
| 108952 | 108952 | 13376 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000X Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 109944 | 109944 | 13381 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000X Mansell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 113947 | 113947 | 13383 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000X Mansell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 119188 | 119188 | 13379 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000X Mansell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 126625 | 126625 | 13385 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000X Mansell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 31 | 31 | 22614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.781365013820206 | -122.424863625752 | (37.7813650138202, -122.424863625752) | |||
| 85 | 85 | 22613 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005358.7073 | 2112686.5825 | 37.7813375942673 | -122.42509837168001 | (37.7813375942673, -122.42509837168) | |||
| 7925 | 7925 | 22616 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005581.297 | 2112717.6262 | 37.7814354041528 | -122.424330527926 | (37.7814354041528, -122.424330527926) | |||
| 8575 | 8575 | 22617 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/25/1997 12:00:00 AM | 6 | 3x5 | 6005634.7978 | 2112724.8918 | 37.781458374599794 | -122.424145957729 | (37.7814583745998, -122.424145957729) | ||
| 88826 | 88826 | 22610 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
| 120636 | 120636 | 22615 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
| 126289 | 126289 | 22618 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
| 87911 | 87911 | 29065 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1001X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138356997 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | ||
| 113978 | 113978 | 29066 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1001X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138356997 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | ||
| 54664 | 54664 | 29069 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1002X Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 15 | 3x3 | 6004818.3149515 | 2112301.2204093 | 37.780248943687205 | -122.4269404119 | (37.7802489436872, -122.4269404119) | ||
| 78978 | 78978 | 87642 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1002X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004813.344433 | 2112300.6630169996 | 37.7802471321724 | -122.42695756751101 | (37.7802471321724, -122.426957567511) | |||||
| 91746 | 91746 | 87641 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1002X Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004813.344433 | 2112300.6630169996 | 37.7802471321724 | -122.42695756751101 | (37.7802471321724, -122.426957567511) | |||||
| 107812 | 107812 | 87643 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1002X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004813.344433 | 2112300.6630169996 | 37.7802471321724 | -122.42695756751101 | (37.7802471321724, -122.426957567511) | |||||
| 126681 | 126681 | 10586 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1050X Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 75 | 3X3 | 6011036.2882597 | 2110765.2479161 | 37.7763811461579 | -122.40532126913901 | (37.7763811461579, -122.405321269139) | |||
| 115377 | 115377 | 29070 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1050X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004796.752563099 | 2112456.6816498 | 37.7806745826486 | -122.427026081915 | (37.7806745826486, -122.427026081915) | ||
| 118030 | 118030 | 29072 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1050X Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004796.752563099 | 2112456.6816498 | 37.7806745826486 | -122.427026081915 | (37.7806745826486, -122.427026081915) | ||
| 127866 | 127866 | 29071 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1050X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004796.752563099 | 2112456.6816498 | 37.7806745826486 | -122.427026081915 | (37.7806745826486, -122.427026081915) | ||
| 146163 | 146163 | 29073 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1050X Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004796.752563099 | 2112456.6816498 | 37.7806745826486 | -122.427026081915 | (37.7806745826486, -122.427026081915) | ||
| 81054 | 81054 | 2804 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 88529 | 88529 | 2808 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3x3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 109159 | 109159 | 2806 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 115677 | 115677 | 2805 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 65 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 126954 | 126954 | 2807 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 139043 | 139043 | 2809 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 35 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 100807 | 100807 | 29067 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1091X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004816.84954 | 2112603.0518286 | 37.781077615403596 | -122.426966984587 | (37.7810776154036, -122.426966984587) | ||
| 128333 | 128333 | 29068 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1091X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004816.84954 | 2112603.0518286 | 37.781077615403596 | -122.426966984587 | (37.7810776154036, -122.426966984587) | ||
| 12296 | 12296 | 19104 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 10X Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/29/2007 12:00:00 AM | 3 | 4X30 | 6011705.43586 | 2090789.4617400002 | 37.721569360619604 | -122.40160216911 | (37.7215693606196, -122.40160216911) | ||
| 2010 | 2010 | 142062 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 10 | Width 0ft | Permit Number 771276 | 6004214.4178 | 2112228.4 | 37.780014831771 | -122.429024376887 | (37.780014831771, -122.429024376887) | |
| 2525 | 2525 | 9534 | Permitted Site 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 6 | 3X3 | Permit Number 771276 | 6004154.8546 | 2112220.8365 | 37.779990692526 | -122.42922989330201 | (37.779990692526, -122.429229893302) | |
| 3190 | 3190 | 9537 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6004100.4915 | 2112210.9093 | 37.779960357201205 | -122.429417251502 | (37.7799603572012, -122.429417251502) | ||
| 5025 | 5025 | 9541 | Permitted Site 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 3 | 3X3 | Permit Number 771276 | 6003998.856000001 | 2112198.1457 | 37.7799195567604 | -122.429767943463 | (37.7799195567604, -122.429767943463) | |
| 7440 | 7440 | 9542 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6003977.1107 | 2112193.8912 | 37.7799066435706 | -122.429842866574 | (37.7799066435706, -122.429842866574) | ||
| 7827 | 7827 | 9544 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6003937.8747 | 2112189.6367 | 37.7798927397998 | -122.429978297745 | (37.7798927397998, -122.429978297745) | |||
| 7831 | 7831 | 9536 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004118.455 | 2112215.6365 | 37.779974353933 | -122.42935544491999 | (37.779974353933, -122.42935544492) | ||
| 8608 | 8608 | 9533 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6004176.1272 | 2112221.7819 | 37.7799944925987 | -122.429156369266 | (37.7799944925987, -122.429156369266) | |||
| 8706 | 8706 | 9539 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004035.7284 | 2112200.9821 | 37.779929432705 | -122.429640587781 | (37.779929432705, -122.429640587781) | ||
| 99504 | 99504 | 9535 | Permitted Site 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 12 | 3X3 | Permit Number 771276 | 6004321.7721315995 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | |
| 100247 | 100247 | 9546 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004321.7721315995 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | ||
| 112928 | 112928 | 9545 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6004321.7721315995 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | |||
| 139901 | 139901 | 9540 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004321.7721315995 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | ||
| 143168 | 143168 | 9547 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1100X Golden Gate Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6004321.7721315995 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | ||
| 630 | 630 | 20157 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 4X4 | 6002895.0285 | 2112125.5503 | 37.7796576600117 | -122.433581380876 | (37.7796576600117, -122.433581380876) | |||
| 7614 | 7614 | 20156 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 4X4 | 6002897.8994 | 2112109.7603 | 37.7796144675148 | -122.43357032043899 | (37.7796144675148, -122.433570320439) | |||
| 93863 | 93863 | 94301 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1150X Fillmore St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 101234 | 101234 | 94303 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 102570 | 102570 | 94295 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 103966 | 103966 | 94293 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 107857 | 107857 | 94299 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1150X Fillmore St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 123205 | 123205 | 94297 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1150X Fillmore St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 84190 | 84190 | 113977 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1180 STANYAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 98380 | 98380 | 113980 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1180 STANYAN ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 120849 | 120849 | 113976 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1180 STANYAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 128979 | 128979 | 113978 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1180 STANYAN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 142159 | 142159 | 113981 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1180 STANYAN ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 38128 | 38128 | 88409 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009413.9789 | 2117291.03714 | 37.7942085637169 | -122.41139444529 | (37.7942085637169, -122.41139444529) | |
| 44141 | 44141 | 88407 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009407.88363 | 2117347.72867 | 37.7943638829406 | -122.411419542685 | (37.7943638829406, -122.411419542685) | |
| 66520 | 66520 | 100031 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009418.42249 | 2117262.251 | 37.7941297732341 | -122.411377035334 | (37.7941297732341, -122.411377035334) | |
| 120980 | 120980 | 100033 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | |||
| 124487 | 124487 | 100032 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 3x3 | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | ||
| 182553 | 182553 | 88408 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769129 | 6009412.43491 | 2117319.72378 | 37.794287243625604 | -122.411401815264 | (37.7942872436256, -122.411401815264) | |
| 88615 | 88615 | 100034 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | |||
| 112616 | 112616 | 100037 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | |||
| 116126 | 116126 | 100035 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | |||
| 144094 | 144094 | 100036 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | |||
| 10993 | 10993 | 764 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.76418358274471 | -122.496433785178 | (37.7641835827447, -122.496433785178) | |||
| 104399 | 104399 | 765 | Permitted Site 1 | Acacia spp :: Acacia Spp 176 | 1200X 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3 | 5984609.996333099 | 2107018.7644647 | 37.764581448379396 | -122.496459340328 | (37.7645814483794, -122.496459340328) | |||
| 34305 | 34305 | 20466 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | |||
| 80523 | 80523 | 20465 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | |||
| 100327 | 100327 | 20463 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | |||
| 105704 | 105704 | 20464 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/05/1997 12:00:00 AM | 3 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | ||
| 112463 | 112463 | 20462 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | |||
| 78402 | 78402 | 20478 | Permitted Site 1 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 1203X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 80842 | 80842 | 20504 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/02/1991 12:00:00 AM | 18 | 10 | 5984781.8902056 | 2107224.2505442 | 37.7651557239541 | -122.495879974111 | (37.7651557239541, -122.495879974111) | ||
| 81048 | 81048 | 20479 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1203X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 82157 | 82157 | 20474 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1203X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 91646 | 91646 | 20468 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1203X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 93970 | 93970 | 20470 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 1203X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 95715 | 95715 | 20475 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1203X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 98213 | 98213 | 20471 | Permitted Site 1 | Cedrus deodara :: Deodar Cedar 129 | 1203X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 107129 | 107129 | 20472 | Permitted Site 1 | Cedrus deodara :: Deodar Cedar 129 | 1203X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 107253 | 107253 | 20476 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 113448 | 113448 | 20473 | Permitted Site 1 | Cedrus deodara :: Deodar Cedar 129 | 1203X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 115969 | 115969 | 20467 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 123025 | 123025 | 20477 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1203X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 146051 | 146051 | 20469 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) |
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");