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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 107044 | 107044 | 107197 | Significant Tree 6 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 339 Kirkham St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/07/2014 12:00:00 AM | 3x3 | Permit Number 773549 | 5993785.2645 | 2105241.5874099997 | 37.7602350326789 | -122.464595750688 | (37.7602350326789, -122.464595750688) | ||
| 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) | ||
| 119856 | 119856 | 85365 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 66 Clarendon Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/17/2007 12:00:00 AM | Permit Number 49641 | 5997837.8 | 2104660.2 | 37.758871479144396 | -122.45053809231199 | (37.7588714791444, -122.450538092312) | |||
| 56265 | 56265 | 104652 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 94 | 953 Indiana St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6015057.1 | 2104275.7 | 37.758786250670205 | -122.39095836980302 | (37.7587862506702, -122.390958369803) | |||||
| 80785 | 80785 | 104444 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 507 Capp St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 2x6 | Permit Number 770679 | 6007300.0 | 2104257.5 | 37.7583027968034 | -122.41778477647301 | (37.7583027968034, -122.417784776473) | |||
| 144956 | 144956 | 104445 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 507 Capp St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 2x6 | Permit Number 770679 | 6007300.0 | 2104257.5 | 37.7583027968034 | -122.41778477647301 | (37.7583027968034, -122.417784776473) | |||
| 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) | |||
| 104404 | 104404 | 106685 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Yukon St | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 772768 | 6000197.4 | 2104288.0 | 37.757984281634 | -122.44235080136299 | (37.757984281634, -122.442350801363) | |||||
| 88934 | 88934 | 107130 | Property Tree 7 | Phoenix dactylifera :: Date Palm 65 | 751 DOLORES ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005081.8 | 2103948.4 | 37.7573290011944 | -122.42543429450701 | (37.7573290011944, -122.425434294507) | |||||
| 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) | |||
| 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) | |||
| 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) | |
| 129431 | 129431 | 110789 | Section 143 8 | Pinus radiata :: Monterey Pine 3 | 850x SANCHEZ ST | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | ||||
| 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) | |
| 87119 | 87119 | 112572 | Significant Tree 6 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | ||||
| 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) | |||
| 102533 | 102533 | 112571 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | ||||
| 117877 | 117877 | 112570 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | ||||
| 4182 | 4182 | 253620 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 1120 South Van Ness Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Width 3ft | 6007603.98274 | 2103104.1444200003 | 37.755153048679205 | -122.41665176419201 | (37.7551530486792, -122.416651764192) | ||||
| 79308 | 79308 | 111069 | Significant Tree 6 | Ilex spp :: Holly Species 163 | 1836 08TH AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x15 | 5993799.0 | 2102987.0 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | ||||
| 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) | |||
| 103820 | 103820 | 111068 | Significant Tree 6 | Ilex spp :: Holly Species 163 | 1836 08TH AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x15 | 5993799.0 | 2102987.0 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | ||||
| 78331 | 78331 | 117161 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1383X VERMONT ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6011571.0 | 2102081.0 | 37.752566033842896 | -122.40286062573799 | (37.7525660338429, -122.402860625738) | |||||
| 87235 | 87235 | 117162 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1383X VERMONT ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | DPW 4 | 6011571.0 | 2102081.0 | 37.752566033842896 | -122.40286062573799 | (37.7525660338429, -122.402860625738) | ||||
| 95257 | 95257 | 93959 | Permitted Site 1 | Prunus spp :: Cherry 84 | 419 Elizabeth St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 53399 | 6003681.0 | 2102149.0 | 37.752309029626495 | -122.430150445418 | (37.7523090296265, -122.430150445418) | ||||
| 124228 | 124228 | 111770 | Significant Tree 6 | Pittosporum tobira :: Japanese Mockorange 243 | 707 Douglass St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 775627 | 6001281.0 | 2102187.2 | 37.7522776937422 | -122.438452748375 | (37.7522776937422, -122.438452748375) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 119287 | 119287 | 85367 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1990 09th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/17/2007 12:00:00 AM | Permit Number 49643 | 5993523.3 | 2101996.8 | 37.7513105791605 | -122.46526605884199 | (37.7513105791605, -122.465266058842) | |||
| 95797 | 95797 | 114729 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1930 35TH AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/03/2015 12:00:00 AM | 4x4 | 5985421.0 | 2102058.0 | 37.7510080399178 | -122.493288836187 | (37.7510080399178, -122.493288836187) | |||
| 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) | ||||
| 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) | |||
| 103688 | 103688 | 92051 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 140608 | 140608 | 92050 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | ||||
| 74401 | 74401 | 121592 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4233 Cesar Chavez St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6002342.0 | 2100313.0 | 37.7471918787018 | -122.434649642859 | (37.7471918787018, -122.434649642859) | ||||
| 140914 | 140914 | 114321 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2118 47th Ave | 1 | Front Yard : Cutout 8 | Landscaping 2 | Private 1 | 01/14/2016 12:00:00 AM | 5x16 | Permit Number 777356 | 5981743.9 | 2100646.6 | 37.7469169691931 | -122.505899765145 | (37.7469169691931, -122.505899765145) | ||
| 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) | |
| 105928 | 105928 | 109708 | Significant Tree 6 | Tree(s) :: 17 | 621 Laguna Honda Blvd | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 07/29/2015 12:00:00 AM | Permit Number 774799 | 5995723.9 | 2099907.4 | 37.745700269008296 | -122.457505029341 | (37.7457002690083, -122.457505029341) | ||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 9868 | 9868 | 173714 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699x 29th St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6002089.0 | 2098776.0 | 37.7429572717864 | -122.435414565427 | (37.7429572717864, -122.435414565427) | ||||
| 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) | |
| 91613 | 91613 | 88453 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2801 Oakdale Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 106407 | 106407 | 88454 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2801 Oakdale Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 111585 | 111585 | 88455 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2801 Oakdale Ave | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 97229 | 97229 | 85428 | Significant Tree 6 | Tree(s) :: 17 | 43 Ora Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/23/2007 12:00:00 AM | Permit Number 49665 | 6001553.3 | 2098294.6 | 37.741605021987205 | -122.437232403771 | (37.7416050219872, -122.437232403771) | |||
| 80984 | 80984 | 88447 | Permitted Site 1 | Tree(s) :: 17 | 93 Prentiss St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/14/2008 12:00:00 AM | 3x3 | Permit Number 51413 | 6008891.7 | 2098141.7 | 37.7415996198956 | -122.411847801096 | (37.7415996198956, -122.411847801096) | ||
| 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) | |
| 94216 | 94216 | 100680 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 387 Beacon St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 7' wide public RoW | 6002378.0 | 2098199.0 | 37.7413893731095 | -122.434374040118 | (37.7413893731095, -122.434374040118) | |||||
| 117945 | 117945 | 104498 | Permitted Site 1 | Chionanthus retusa :: Chinese Fringe Tree 526 | 26 Allston Way | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/11/2013 12:00:00 AM | 3x3 | Permit Number 770732 | 5994373.7 | 2098352.0 | 37.741351881225704 | -122.46206101169201 | (37.7413518812257, -122.462061011692) | ||
| 128374 | 128374 | 104497 | Permitted Site 1 | Chionanthus retusa :: Chinese Fringe Tree 526 | 26 Allston Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/11/2013 12:00:00 AM | 3x3 | Permit Number 770732 | 5994373.7 | 2098352.0 | 37.741351881225704 | -122.46206101169201 | (37.7413518812257, -122.462061011692) | ||
| 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) | ||
| 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) | |||
| 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) | |
| 102290 | 102290 | 31648 | Permitted Site 1 | Tree(s) :: 17 | 4500 Ulloa St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | ||
| 113764 | 113764 | 31646 | Permitted Site 1 | Tree(s) :: 17 | 4500 Ulloa St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | ||
| 127767 | 127767 | 31647 | Permitted Site 1 | Tree(s) :: 17 | 4500 Ulloa St | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/13/2009 12:00:00 AM | 3x3 | Permit Number 52054 | 5982086.63822537 | 2098111.49533937 | 37.7399764418309 | -122.504526837106 | (37.7399764418309, -122.504526837106) | ||
| 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) | ||||
| 129310 | 129310 | 99268 | Property Tree 7 | Tree(s) :: 17 | 292 Whitney St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6004280.0 | 2096681.0 | 37.7373290690714 | -122.42768945491501 | (37.7373290690714, -122.427689454915) | ||||||
| 104759 | 104759 | 87819 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 390 Lansdale Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 50681 | 5995630.7 | 2096410.1 | 37.736092191921294 | -122.457574304331 | (37.7360921919213, -122.457574304331) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) |
| 79626 | 79626 | 94583 | Permitted Site 1 | Tree(s) :: 17 | 90 Joost Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6001518.0 | 2094975.2 | 37.732488714298 | -122.43711685564699 | (37.732488714298, -122.437116855647) | ||||
| 77706 | 77706 | 114927 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 78663 | 78663 | 114932 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 8 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 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) | |||
| 82154 | 82154 | 114926 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 91895 | 91895 | 114933 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 9 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 100601 | 100601 | 114931 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 7 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 100636 | 100636 | 114940 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 16 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 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) | |
| 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) | |
| 103256 | 103256 | 114928 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 106106 | 106106 | 114937 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 13 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 139185 | 139185 | 114938 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 14 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 140796 | 140796 | 114929 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 141835 | 141835 | 114936 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 12 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 141973 | 141973 | 114935 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 11 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 144669 | 144669 | 114930 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4400x OCEAN AVE | 6 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | ||||
| 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) | |
| 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) |
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");