Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, qCareAssistant, DBH, PlotSize
qCaretaker ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78259 | 78259 | 111280 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 700X BOSWORTH ST | 18 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 48 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 108375 | 108375 | 111357 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 600x MANSELL ST | 1 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 48 | 3x3 | 6010142.0 | 2090267.0 | 37.720047423695505 | -122.40696976451099 | (37.7200474236955, -122.406969764511) | |||
| 122091 | 122091 | 114098 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 219x VIDAL DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 40 | 5987664.0 | 2090565.0 | 37.719582202213104 | -122.48468943736401 | (37.7195822022131, -122.484689437364) | ||||
| 78878 | 78878 | 2044 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 700X Bosworth St | 1 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 36 | Permit Number 772999 | 6002154.6210393 | 2095431.8532492002 | 37.733778746199796 | -122.43494855504801 | (37.7337787461998, -122.434948555048) | |||
| 82056 | 82056 | 114939 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 15 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 36 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |||
| 86718 | 86718 | 114261 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800x BROTHERHOOD WAY | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 36 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 101205 | 101205 | 114262 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800x BROTHERHOOD WAY | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 36 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 914 | 914 | 225888 | Property Tree 7 | Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 | 3255x 24th St | 1 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 32 | 6x6 | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 118309 | 118309 | 114264 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800x BROTHERHOOD WAY | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 32 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 11071 | 11071 | 113042 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 Raymond Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/06/2015 12:00:00 AM | 30 | 3x3 | 6008233.879509999 | 2088473.9314700002 | 37.715017072864796 | -122.413438766187 | (37.7150170728648, -122.413438766187) | ||
| 80776 | 80776 | 114263 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800x BROTHERHOOD WAY | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 29 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 125158 | 125158 | 116956 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 380 SAN JOSE AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 28 | 3x3 | 6006172.0 | 2100967.0 | 37.7492042995658 | -122.421452219126 | (37.7492042995658, -122.421452219126) | |||
| 139135 | 139135 | 112417 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 98X BROADMOOR DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 28 | 3x3 | 5990934.0 | 2093194.0 | 37.7269906812088 | -122.47357801435 | (37.7269906812088, -122.47357801435) | |||
| 124433 | 124433 | 114265 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 6 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 26 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 114585 | 114585 | 115388 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 169x BOCANA ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 25 | 40x50 | 6007278.0 | 2097999.0 | 37.7411171346524 | -122.417417333034 | (37.7411171346524, -122.417417333034) | |||
| 5622 | 5622 | 87285 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1820 Webster St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 24 | 3x3 | Permit Number 50302 | 6003460.507999999 | 2115059.4384 | 37.7877454479518 | -122.43183468665801 | (37.7877454479518, -122.431834686658) | ||
| 42991 | 42991 | 105168 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 4755X 03RD ST | 2 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 23 | 3x3 | Permit Number 770204 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | ||
| 83931 | 83931 | 105169 | Property Tree 7 | Corymbia ficifolia :: Red Flowering Gum 60 | 4755X 03RD ST | 3 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 23 | 4x4 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 105054 | 105054 | 104686 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 140 26TH AVE | Front Yard : Cutout 8 | Tree 1 | Private 1 | 22 | 4x4 | 5987812.9 | 2115041.6 | 37.786797021543 | -122.485970438221 | (37.786797021543, -122.485970438221) | ||||
| 129412 | 129412 | 104753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2328 12TH AVE | Front Yard : Cutout 8 | Tree 1 | Private 1 | 22 | Permit Number 770921 | 5992676.8 | 2099585.2 | 37.7446400909628 | -122.468017927356 | (37.7446400909628, -122.468017927356) | ||||
| 9948 | 9948 | 114067 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 6 Higuera Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 20 | 5987898.0 | 2090420.0 | 37.719197693995795 | -122.48386996767 | (37.7191976939958, -122.48386996767) | ||||
| 81797 | 81797 | 115888 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 811 TREAT AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 20 | 3x3 | 6008597.0 | 2103712.0 | 37.7568778816719 | -122.413260590978 | (37.7568778816719, -122.413260590978) | |||
| 139674 | 139674 | 117208 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 25 MIDCREST WAY | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 20 | 5997992.0 | 2100464.0 | 37.747358577228496 | -122.44970241305 | (37.7473585772285, -122.44970241305) | ||||
| 123166 | 123166 | 105073 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 101 LUNDYS LN | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 18 | 6006875.0 | 2098969.0 | 37.7437578546964 | -122.41887954343599 | (37.7437578546964, -122.418879543436) | ||||
| 129263 | 129263 | 63301 | Permitted Site 1 | Tree(s) :: 17 | 3261 Harrison St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | 18 | Permit Number 53402 | 6009046.03746796 | 2099701.90725396 | 37.745892263304896 | -122.411424351246 | (37.7458922633049, -122.411424351246) | |
| 154324 | 154324 | 112045 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2418 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 18 | 3x3 | 6002446.95594 | 2117111.03197 | 37.7933210893366 | -122.435488200226 | (37.7933210893366, -122.435488200226) | |||
| 68819 | 68819 | 108096 | Significant Tree 6 | Ficus rubiginosa :: Port Jackson Fig 188 | 3370 Washington St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 17 | Permit Number 773610 | 5998674.83986 | 2115933.37372 | 37.789872594881295 | -122.44845507873801 | (37.7898725948813, -122.448455078738) | |||
| 928 | 928 | 224422 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 2 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 16 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 85675 | 85675 | 108214 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1611 47th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 15 | 3x3 | 5981530.432709999 | 2104091.45519 | 37.756363002508294 | -122.50689338520701 | (37.7563630025083, -122.506893385207) | |||
| 98792 | 98792 | 108275 | Significant Tree 6 | Arecastrum romanzoffianum :: Queen Palm 238 | 1800x ALAMEDA ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 15 | 6011533.0 | 2107928.0 | 37.7686184708296 | -122.40340334412501 | (37.7686184708296, -122.403403344125) | ||||
| 78703 | 78703 | 105804 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 117 ALPINE TER | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/10/2014 12:00:00 AM | 14 | 3x3 | Permit Number 772090 | 6001724.2 | 2108149.5 | 37.7686739192463 | -122.437346990121 | (37.7686739192463, -122.437346990121) | |
| 901 | 901 | 224716 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 5 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 13 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 13821 | 13821 | 105161 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600X Oakdale Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 13 | 3x3 | 6014869.34112 | 2095641.8363700002 | 37.735069048787 | -122.39100428831499 | (37.735069048787, -122.391004288315) | |||
| 29261 | 29261 | 105753 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 3636 Buchanan St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/21/2014 12:00:00 AM | 13 | Permit Number 771077 | 6003146.89414 | 2120799.57812 | 37.803488607670296 | -122.433330062032 | (37.8034886076703, -122.433330062032) | ||
| 46828 | 46828 | 84740 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 143 Alhambra St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 13 | 4x6 | Permit Number 49254 | 6001588.49283 | 2120281.76365 | 37.8019782934262 | -122.438685839601 | (37.8019782934262, -122.438685839601) | |
| 905 | 905 | 224715 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 4 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 12 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 100355 | 100355 | 116620 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 1 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 12 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | ||
| 123053 | 123053 | 113153 | Significant Tree 6 | Populus alba :: White Poplar 408 | 55 BRONTE ST | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12 | 3x3 | 6009403.0 | 2097128.0 | 37.738844891472894 | -122.410008345842 | (37.7388448914729, -122.410008345842) | ||||
| 141088 | 141088 | 115806 | Significant Tree 6 | Robinia pseudoacacia :: Black Locust 169 | 362 MISSOURI ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12 | 3x3 | 6013446.0 | 2105415.0 | 37.7618249904211 | -122.39661020099 | (37.7618249904211, -122.39661020099) | |||
| 916 | 916 | 224714 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 3 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 11 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 148125 | 148125 | 79257 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 571 35th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 11 | 3x3 | Permit Number 49957 | 5985010.61242 | 2111991.22713 | 37.7782578784089 | -122.495440495889 | (37.7782578784089, -122.495440495889) | |
| 84041 | 84041 | 114392 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 104x TAPIA DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10 | 5988688.0 | 2090939.0 | 37.72066869526729 | -122.481177253578 | (37.7206686952673, -122.481177253578) | ||||
| 96445 | 96445 | 114266 | Undocumented 2 | Pittosporum spp :: Pittosporum spp 128 | 800x BROTHERHOOD WAY | 7 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 9 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 111891 | 111891 | 105167 | Property Tree 7 | Corymbia ficifolia :: Red Flowering Gum 60 | 4755X 03RD ST | 1 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 8 | 3x3 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 121120 | 121120 | 103719 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 748 Treat Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 8 | 3x3 | 6008496.2 | 2104169.0 | 37.758127039951205 | -122.41364151852801 | (37.7581270399512, -122.413641518528) | |||
| 89540 | 89540 | 112569 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 7 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | |||
| 123578 | 123578 | 114260 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 800x BROTHERHOOD WAY | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 7 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 85684 | 85684 | 116955 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 46 | 818 Douglass St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6 | 3x3 | 6001245.0 | 2101454.0 | 37.7502624545247 | -122.43852471352 | (37.7502624545247, -122.43852471352) | |||
| 103533 | 103533 | 12529 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 105 Lake St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 07/12/2004 12:00:00 AM | 6 | 3x3 | Permit Number 773769 | 5995136.95364 | 2114887.49287 | 37.78679797610221 | -122.460619935074 | (37.7867979761022, -122.460619935074) |
| 56651 | 56651 | 31242 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2523 17th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50225 | 5991071.12499 | 2098214.14208 | 37.7407826611875 | -122.473469993967 | (37.7407826611875, -122.473469993967) | |
| 86072 | 86072 | 54809 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 150 Carmel St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/12/2007 12:00:00 AM | 5 | 3x3 | Permit Number 773425 | 5998092.51354995 | 2105385.25255364 | 37.760876867329294 | -122.449709427273 | (37.7608768673293, -122.449709427273) | |
| 96 | 96 | 251196 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 900X 14th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | 6002515.0 | 2107976.0 | 37.768242455454995 | -122.43459927073098 | (37.768242455455, -122.434599270731) | |||
| 563 | 563 | 173951 | Significant Tree 6 | Tree(s) :: 17 | 2646 Union St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/11/2017 12:00:00 AM | 3 | 10x10 | Permit Number 779549 | 6000338.0 | 2118225.0 | 37.796259749404605 | -122.442865342513 | (37.7962597494046, -122.442865342513) | |
| 1358 | 1358 | 173635 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |
| 2105 | 2105 | 251411 | Significant Tree 6 | Tree(s) :: 17 | 2751 Buchanan St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/21/2017 12:00:00 AM | 3 | 6x6 | Permit Number 779887 | 6003497.0 | 2117826.0 | 37.7953437887296 | -122.431906052505 | (37.7953437887296, -122.431906052505) | |
| 2436 | 2436 | 110026 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 2585 Pacific Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/18/2015 12:00:00 AM | 3 | Permit Number 779691 | 6001774.18039 | 2116969.68651 | 37.7928947585324 | -122.437805917729 | (37.7928947585324, -122.437805917729) | ||
| 2687 | 2687 | 253164 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 146 Cambridge St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/27/2017 12:00:00 AM | 3 | 4x4 | 6006598.94029 | 2094006.4119099998 | 37.7301161400075 | -122.419482094225 | (37.7301161400075, -122.419482094225) | ||
| 3318 | 3318 | 253415 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 Stoneybrook Ave | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/31/2017 12:00:00 AM | 3 | Permit Number 779907 | 6005926.97731 | 2093972.4268599998 | 37.729984953042795 | -122.421802746417 | (37.7299849530428, -122.421802746417) | |||
| 3709 | 3709 | 253265 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 180 San Aleso Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 5993319.0 | 2094440.0 | 37.730549723890206 | -122.465423653439 | (37.7305497238902, -122.465423653439) | ||
| 5087 | 5087 | 150676 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 548 Rhode Island St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 11/07/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780811 | 6011754.983990001 | 2105812.52377 | 37.762822244976505 | -122.402486741392 | (37.7628222449765, -122.402486741392) | |
| 8205 | 8205 | 110025 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2585 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/18/2015 12:00:00 AM | 3 | Permit Number 774536 | 6001760.7528800005 | 2116964.32872 | 37.7928792839017 | -122.437851993568 | (37.7928792839017, -122.437851993568) | ||
| 9848 | 9848 | 122687 | Significant Tree 6 | Tree(s) :: 17 | 1462 Funston Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/04/2017 12:00:00 AM | 3 | 3x8 | Permit Number 779171 | 5992142.99696903 | 2105491.66018597 | 37.7608268551195 | -122.470293739312 | (37.7608268551195, -122.470293739312) | |
| 10183 | 10183 | 173712 | Undocumented 2 | Tree(s) :: 17 | 699x 29th St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779391 | 6002089.0 | 2098776.0 | 37.7429572717864 | -122.435414565427 | (37.7429572717864, -122.435414565427) | |
| 10195 | 10195 | 173713 | Undocumented 2 | Tree(s) :: 17 | 699x 29th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779391 | 6002089.0 | 2098776.0 | 37.7429572717864 | -122.435414565427 | (37.7429572717864, -122.435414565427) | |
| 11497 | 11497 | 69940 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1295 30th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/06/2016 12:00:00 AM | 3 | 5x5 | Permit Number 778203 | 5986757.5345 | 2106473.3538 | 37.7632094781069 | -122.488991584645 | (37.7632094781069, -122.488991584645) | |
| 22873 | 22873 | 251137 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 25x Goettingen St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009828.0 | 2094364.0 | 37.7312793503434 | -122.40834398535401 | (37.7312793503434, -122.408343985354) | |
| 66196 | 66196 | 107892 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 162 Brewster St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773952 | 6010231.01704 | 2099016.49618 | 37.7440766668365 | -122.40727852777799 | (37.7440766668365, -122.407278527778) | ||
| 80053 | 80053 | 109497 | Permitted Site 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 254 | 785 Mangels Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771883 | 5996438.0 | 2095245.0 | 37.732939449865896 | -122.45469900823 | (37.7329394498659, -122.45469900823) |
| 85057 | 85057 | 115566 | Permitted Site 1 | Tree(s) :: 17 | 2026 36TH AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777529 | 5985134.0 | 2101392.0 | 37.7491625951009 | -122.49423221215099 | (37.7491625951009, -122.494232212151) | |
| 85532 | 85532 | 108239 | Permitted Site 1 | Tree(s) :: 17 | 15 ASHBURY TER | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/14/2015 12:00:00 AM | 3 | 5x50 | Permit Number 774721 | 5999554.7 | 2106911.6 | 37.7651513833487 | -122.444762103204 | (37.7651513833487, -122.444762103204) | |
| 85775 | 85775 | 114272 | Significant Tree 6 | Tree(s) :: 17 | 2241 Sacramento St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776884 | 6004082.4 | 2115905.7 | 37.79010430227179 | -122.42974344149499 | (37.7901043022718, -122.429743441495) | |
| 94493 | 94493 | 110787 | Section 143 8 | Tree(s) :: 17 | 850x SANCHEZ ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777427 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | |
| 98858 | 98858 | 114924 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 37X EVERGLADE DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/13/2016 12:00:00 AM | 3 | 3x3 | 5986312.0 | 2095495.0 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | ||
| 102481 | 102481 | 114925 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
| 103011 | 103011 | 114923 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 51X EVERGLADE DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/13/2016 12:00:00 AM | 3 | 3x3 | 5986312.0 | 2095495.0 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | ||
| 103199 | 103199 | 114934 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
| 106272 | 106272 | 115004 | Private 5 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1050 MCALLISTER ST | 1 | Front Yard : Cutout 8 | Tree 1 | Office of Mayor 21 | DPW 4 | 01/19/2016 09:19:00 AM | 3 | 3x3 | 6004148.0 | 2111858.0 | 37.778994045300706 | -122.42922772691401 | (37.7789940453007, -122.429227726914) | |
| 111849 | 111849 | 117150 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 TOLAND ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011950.0 | 2098029.0 | 37.7414612698949 | -122.401265252936 | (37.7414612698949, -122.401265252936) | |
| 115370 | 115370 | 107863 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 218 HOWTH ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3 | 5997350.1 | 2090721.9 | 37.720572361158105 | -122.451219574954 | (37.7205723611581, -122.451219574954) | ||||
| 128304 | 128304 | 115100 | Significant Tree 6 | Tree(s) :: 17 | 710 PACHECO ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777305 | 5992727.0 | 2102215.0 | 37.7518637464828 | -122.468035600741 | (37.7518637464828, -122.468035600741) | |
| 129398 | 129398 | 109973 | Undocumented 2 | Tree(s) :: 17 | 1458 43rd Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/16/2015 12:00:00 AM | 3 | 3x3 | 5982831.2 | 2105195.6 | 37.7594711884194 | -122.502476670215 | (37.7594711884194, -122.502476670215) | ||
| 142230 | 142230 | 120534 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2043 32nd Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/10/2016 12:00:00 AM | 3 | 3x3 | 5986293.0 | 2101328.0 | 37.7490546230695 | -122.49021972232599 | (37.7490546230695, -122.490219722326) | ||
| 142954 | 142954 | 110788 | Section 143 8 | Tree(s) :: 17 | 850x SANCHEZ ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777427 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | |
| 143274 | 143274 | 122379 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 466 Vernon St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/26/2016 12:00:00 AM | 3 | 3x3 | 5992521.0 | 2090937.0 | 37.7208852925782 | -122.46792773796801 | (37.7208852925782, -122.467927737968) | ||
| 88034 | 88034 | 111070 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 1836 08TH AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 2 | 3x15 | 5993799.0 | 2102987.0 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | |||
| 91973 | 91973 | 106184 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1327 ULLOA ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 2 | 4x4 | 5991893.8 | 2098371.4 | 37.7412620575898 | -122.470636971077 | (37.7412620575898, -122.470636971077) | ||
| 117969 | 117969 | 105170 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 4755X 03RD ST | 4 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 2 | 3x3 | 6015032.0 | 2095658.0 | 37.7351224553975 | -122.39044304267901 | (37.7351224553975, -122.390443042679) | |||
| 181559 | 181559 | 106870 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | 2 | Permit Number 769156 | 6008504.136630001 | 2111439.18954 | 37.778089733190605 | -122.414128411309 | (37.7780897331906, -122.414128411309) | ||
| 134828 | 134828 | 114679 | Permitted Site 1 | Malus :: Crab Apple 235 | 836 Brussels St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774714 | 6011176.24092 | 2090873.36995 | 37.7217702116011 | -122.403437363447 | (37.7217702116011, -122.403437363447) | ||
| 1337 | 1337 | 251410 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2777 Pine St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 779015 | 6000658.0 | 2114782.0 | 37.7868244087741 | -122.441510888069 | (37.7868244087741, -122.441510888069) | |||
| 1791 | 1791 | 251711 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 3 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1793 | 1793 | 251713 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 5 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1795 | 1795 | 251712 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 4 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1797 | 1797 | 251710 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 2 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1799 | 1799 | 251715 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 7 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1805 | 1805 | 251709 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 1 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1807 | 1807 | 251714 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 6 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 2134 | 2134 | 252904 | Undocumented 2 | Magnolia champaca :: Champa 170 | 1216 Clay St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6008866.0 | 2117029.0 | 37.7934583239602 | -122.41327198066799 | (37.7934583239602, -122.413271980668) | ||||
| 2712 | 2712 | 253178 | Significant Tree 6 | Washingtonia filifera :: California Fan Palm 189 | 4450 24th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Width 0ft | 6000289.52403 | 2101701.02913 | 37.7508863393389 | -122.441846529398 | (37.7508863393389, -122.441846529398) | ||||
| 2767 | 2767 | 252950 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) |
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");