Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104863 | 104863 | 106838 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 735 Battery St | 1 | Front Yard : Pot 30 | Tree 1 | Private 1 | Permit Number 773117 | 6012413.67639 | 2118682.92207 | 37.798198135735895 | -122.40111294506201 | (37.7981981357359, -122.401112945062) | ||||
| 93295 | 93295 | 104872 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1753 Noe St | 1 | Hanging basket : Yard 27 | Tree 1 | Private 1 | 11/22/2013 12:00:00 AM | Permit Number 770054 | 6003434.1 | 2098036.1 | 37.7410019772539 | -122.430710793678 | (37.7410019772539, -122.430710793678) | |||
| 82961 | 82961 | 96186 | Significant Tree 6 | Tree(s) :: 17 | 333 Harrison St | 3 | Sidewalk: Property side : 26 | Tree 1 | Private 1 | Permit Number 767224 | 6015127.7 | 2114620.1 | 37.7871935976335 | -122.39143736362 | (37.7871935976335, -122.39143736362) | ||||
| 93937 | 93937 | 96184 | Significant Tree 6 | Tree(s) :: 17 | 333 Harrison St | 1 | Sidewalk: Property side : 26 | Tree 1 | Private 1 | Permit Number 767224 | 6015127.7 | 2114620.1 | 37.7871935976335 | -122.39143736362 | (37.7871935976335, -122.39143736362) | ||||
| 104230 | 104230 | 96185 | Significant Tree 6 | Tree(s) :: 17 | 333 Harrison St | 2 | Sidewalk: Property side : 26 | Tree 1 | Private 1 | Permit Number 767224 | 6015127.7 | 2114620.1 | 37.7871935976335 | -122.39143736362 | (37.7871935976335, -122.39143736362) | ||||
| 111357 | 111357 | 96617 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ Valencia 19th St | 251 | Sidewalk: Property side : 26 | Tree 1 | Rec/Park 3 | Permit Number 771218 | 6006277.0 | 2104934.0 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | ||||
| 139364 | 139364 | 96618 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ 19th St 19th St | 268 | Sidewalk: Property side : 26 | Tree 1 | Rec/Park 3 | Permit Number 771218 | 6006277.0 | 2104934.0 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | ||||
| 66105 | 66105 | 98309 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 401X Newhall St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 6 | 3x3 | 6016081.14502 | 2097910.9401599998 | 37.741366715992896 | -122.386972815546 | (37.7413667159929, -122.386972815546) | |||
| 75158 | 75158 | 95137 | Significant Tree 6 | Tree(s) :: 17 | 2130 Fulton St | 127 | Front Yard : 25 | Tree 1 | Private 1 | 01/07/2011 12:00:00 AM | 3x3 | Permit Number 54069 | 5997590.0 | 2110608.0 | 37.7751884337973 | -122.45182417211599 | (37.7751884337973, -122.451824172116) | ||
| 77945 | 77945 | 95138 | Significant Tree 6 | Tree(s) :: 17 | 2130 Fulton St | 128 | Front Yard : 25 | Tree 1 | Private 1 | 01/07/2011 12:00:00 AM | 3x3 | Permit Number 54069 | 5997590.0 | 2110608.0 | 37.7751884337973 | -122.45182417211599 | (37.7751884337973, -122.451824172116) | ||
| 89463 | 89463 | 99299 | Significant Tree 6 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 1457 Willard St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 05/02/2012 12:00:00 AM | Permit Number 768720 | 5996809.7 | 2106270.3 | 37.763233506694 | -122.454210015753 | (37.763233506694, -122.454210015753) | |||
| 95092 | 95092 | 93874 | Significant Tree 6 | Pistacia chinensis :: Chinese Pistache 150 | 2614 Sacramento St | Front Yard : 25 | Tree 1 | Private 1 | 04/14/2010 12:00:00 AM | Permit Number 53370 | 6002291.0 | 2115777.0 | 37.789649322620896 | -122.43593231943599 | (37.7896493226209, -122.435932319436) | ||||
| 104145 | 104145 | 101810 | Significant Tree 6 | Tree(s) :: 17 | 38 Nebraska St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 11/22/2012 12:00:00 AM | Permit Number 769374 | 6009268.6 | 2097830.3 | 37.740765720819 | -122.41052261908999 | (37.740765720819, -122.41052261909) | |||
| 104638 | 104638 | 101202 | Significant Tree 6 | Tree(s) :: 17 | 7070 California St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769231 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.49337605842699 | (37.7850123376907, -122.493376058427) | |||
| 109889 | 109889 | 93903 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 546 Page St | Front Yard : 25 | Tree 1 | Private 1 | 6003947.0 | 2109752.0 | 37.773200107256606 | -122.42977281454901 | (37.7732001072566, -122.429772814549) | ||||||
| 110409 | 110409 | 98703 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 7070@ 32nd Ave California St | 4 | Front Yard : 25 | Tree 1 | Private 1 | 03/10/2012 12:00:00 AM | Permit Number 767466 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.49337605842699 | (37.7850123376907, -122.493376058427) | |||
| 116206 | 116206 | 103477 | Significant Tree 6 | Tree(s) :: 17 | 875 El Camino Del Mar | 1 | Front Yard : 25 | Tree 1 | Private 1 | 05/08/2013 12:00:00 AM | Permit Number 770113 | 5985641.7 | 2114972.5 | 37.7864805258078 | -122.493477079739 | (37.7864805258078, -122.493477079739) | |||
| 117221 | 117221 | 94066 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 161 | 548 Page St | Front Yard : 25 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | Permit Number 53460 | 6003937.0 | 2109751.0 | 37.7731967952272 | -122.429807334526 | (37.7731967952272, -122.429807334526) | ||||
| 122098 | 122098 | 101203 | Significant Tree 6 | Tree(s) :: 17 | 7070 California St | 2 | Front Yard : 25 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769231 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.49337605842699 | (37.7850123376907, -122.493376058427) | |||
| 126156 | 126156 | 98308 | Significant Tree 6 | Tree(s) :: 17 | 1490 Fairfax Ave | 1 | Front Yard : 25 | Tree 1 | Private 1 | 01/25/2012 12:00:00 AM | 3x3 | Permit Number 768575 | 6016246.6 | 2097899.9 | 37.7413455620636 | -122.386399955147 | (37.7413455620636, -122.386399955147) | ||
| 129210 | 129210 | 95985 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 577 Sanchez St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 6003673.0 | 2104901.0 | 37.7598649162805 | -122.430374442168 | (37.7598649162805, -122.430374442168) | |||||
| 159181 | 159181 | 98310 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 1499@Newhall Evans Ave | 2 | Front Yard : 25 | Tree 1 | Private 1 | 01/25/2012 12:00:00 AM | 4 | Permit Number 768575 | 6016248.7932 | 2098029.2738099997 | 37.7417009175609 | -122.38640138991501 | (37.7417009175609, -122.386401389915) | ||
| 44829 | 44829 | 94949 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 50 Pomona St | : Cutout 24 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 90667 | 90667 | 94951 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 50 Pomona St | : Cutout 24 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 107188 | 107188 | 94950 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 50 Pomona St | : Cutout 24 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 140734 | 140734 | 94945 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 1820X Palou Ave | : Cutout 24 | Tree 1 | Rec/Park 3 | FUF 1 | 04/04/2009 12:00:00 AM | 6013714.4 | 2096294.3 | 37.7367964240349 | -122.395043047708 | (37.7367964240349, -122.395043047708) | ||||
| 114979 | 114979 | 118322 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 720 BATTERY ST | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 6012486.0 | 2118560.0 | 37.7978646555778 | -122.400854041686 | (37.7978646555778, -122.400854041686) | |||||
| 3361 | 3361 | 253428 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3 Valletta Ct | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 6x10 | 5999319.0 | 2096479.0 | 37.736492551957895 | -122.44482735214198 | (37.7364925519579, -122.444827352142) | ||||
| 3549 | 3549 | 253470 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3 Valletta Ct | 2 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 6x10 | 5999319.0 | 2096479.0 | 37.736492551957895 | -122.44482735214198 | (37.7364925519579, -122.444827352142) | ||||
| 3557 | 3557 | 253471 | Significant Tree 6 | Sequoiadendron giganteum :: Sierra Redwood 212 | 17 Valletta Ct | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 6x10 | 5999337.0 | 2096545.0 | 37.7366747995559 | -122.444769861358 | (37.7366747995559, -122.444769861358) | ||||
| 4747 | 4747 | 253677 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 199X Kissling St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 5x10 | |||||||||
| 10010 | 10010 | 173778 | Significant Tree 6 | Tree(s) :: 17 | 99X Cleveland St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 3x3 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 1817 | 1817 | 251719 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Clayton St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5999055.0 | 2105304.0 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | |||||
| 2610 | 2610 | 253145 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 801X Santiago St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5990274.0 | 2099728.0 | 37.7448931297685 | -122.47633667765699 | (37.7448931297685, -122.476336677657) | |||||
| 5112 | 5112 | 253808 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 5144 | 5144 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Garfield St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x2 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 5161 | 5161 | 253809 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 9987 | 9987 | 173779 | Significant Tree 6 | Ficus macrophylla :: Morton Bay Fig 148 | 99X Cleveland St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 10000 | 10000 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 99X Cleveland St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 10004 | 10004 | 114140 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 13271 | 13271 | 187638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 13275 | 13275 | 187637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 86677 | 86677 | 121161 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 92297 | 92297 | 121163 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 92655 | 92655 | 121162 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 98898 | 98898 | 117252 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 2 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 100141 | 100141 | 121157 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 100583 | 100583 | 121159 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 108310 | 108310 | 121160 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 112260 | 112260 | 117251 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 1 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 123361 | 123361 | 117295 | Significant Tree 6 | Tree(s) :: 17 | 130 CAMBON DR | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5990450.0 | 2089482.0 | 37.7167704112637 | -122.47498033116501 | (37.7167704112637, -122.474980331165) | ||||
| 142324 | 142324 | 117253 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 3 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 145551 | 145551 | 121158 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 51543 | 51543 | 95372 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 180 Yukon St | Back Yard : Cutout 16 | Tree 1 | Private 1 | 15 | Permit Number 767755 | 6000174.3 | 2103956.9 | 37.7570738455347 | -122.44240692055901 | (37.7570738455347, -122.442406920559) | ||||
| 84223 | 84223 | 108244 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 46 | 150 Conrad St | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 20 | 6001768.8 | 2096480.0 | 37.7366348009068 | -122.43635744032801 | (37.7366348009068, -122.436357440328) | ||||
| 88523 | 88523 | 116864 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 3 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
| 96425 | 96425 | 116863 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 2 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
| 97425 | 97425 | 116862 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
| 105499 | 105499 | 121242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 701 16th Ave | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 36 | 5990933.0 | 2110561.0 | 37.7746758635803 | -122.474848566269 | (37.7746758635803, -122.474848566269) | ||||
| 112771 | 112771 | 109706 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 96 CRESTA VISTA DR | Back Yard : Cutout 16 | Tree 1 | Private 1 | 5995602.1 | 2096103.5 | 37.7352487002973 | -122.45765100803699 | (37.7352487002973, -122.457651008037) | ||||||
| 128022 | 128022 | 121414 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 150 Raccoon Dr | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 36 | 3x3 | 5998776.0 | 2103987.0 | 37.7570766935068 | -122.44724492231701 | (37.7570766935068, -122.447244922317) | |||
| 142025 | 142025 | 98491 | Significant Tree 6 | Robinia pseudoacacia :: Black Locust 169 | 55X Perine Pl | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | Permit Number 768655 | 6002130.5 | 2115544.8 | 37.7890026421633 | -122.436471006098 | (37.7890026421633, -122.436471006098) | ||||
| 1384 | 1384 | 251515 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99x Mountview Ct | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997620.0 | 2100449.0 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | ||||
| 1409 | 1409 | 251514 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99x Mountview Ct | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997620.0 | 2100449.0 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | ||||
| 1598 | 1598 | 251612 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 60R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999394.0 | 2100048.0 | 37.7462964530913 | -122.444824514752 | (37.7462964530913, -122.444824514752) | |||||
| 1603 | 1603 | 251636 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 22R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999148.0 | 2100052.0 | 37.74629339412971 | -122.44567543770901 | (37.7462933941297, -122.445675437709) | |||||
| 1604 | 1604 | 251632 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 14R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999202.0 | 2100044.0 | 37.746274510978395 | -122.445488137723 | (37.7462745109784, -122.445488137723) | |||||
| 1607 | 1607 | 251602 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 108 | 44R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999509.0 | 2100035.0 | 37.746267320465705 | -122.444425925791 | (37.7462673204657, -122.444425925791) | |||||
| 1608 | 1608 | 251603 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 44R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999509.0 | 2100035.0 | 37.746267320465705 | -122.444425925791 | (37.7462673204657, -122.444425925791) | |||||
| 1609 | 1609 | 251630 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 8R Amethyst Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999237.0 | 2100032.0 | 37.7462435599048 | -122.44536624972099 | (37.7462435599048, -122.445366249721) | |||||
| 1611 | 1611 | 251605 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 108 | 48R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999482.0 | 2100041.0 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | |||||
| 1615 | 1615 | 251604 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 48R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999482.0 | 2100041.0 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | |||||
| 1616 | 1616 | 251607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 52R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999455.0 | 2100046.0 | 37.7462944425817 | -122.44461344107401 | (37.7462944425817, -122.444613441074) | |||||
| 1623 | 1623 | 251613 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 60R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999394.0 | 2100048.0 | 37.7462964530913 | -122.444824514752 | (37.7462964530913, -122.444824514752) | |||||
| 1628 | 1628 | 251629 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 8R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999237.0 | 2100032.0 | 37.7462435599048 | -122.44536624972099 | (37.7462435599048, -122.445366249721) | |||||
| 1629 | 1629 | 251631 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 8R Amethyst Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999237.0 | 2100032.0 | 37.7462435599048 | -122.44536624972099 | (37.7462435599048, -122.445366249721) | |||||
| 1631 | 1631 | 251621 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 72R Amber Dr | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999318.0 | 2100030.0 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) | |||||
| 1632 | 1632 | 251628 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 2R Amethyst Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999263.0 | 2100016.0 | 37.746201111936706 | -122.44527519504999 | (37.7462011119367, -122.44527519505) | |||||
| 1637 | 1637 | 251619 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 72R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999318.0 | 2100030.0 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) | |||||
| 1645 | 1645 | 251626 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 2R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999263.0 | 2100016.0 | 37.746201111936706 | -122.44527519504999 | (37.7462011119367, -122.44527519505) | |||||
| 1646 | 1646 | 251633 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 14R Amethyst Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999202.0 | 2100044.0 | 37.746274510978395 | -122.445488137723 | (37.7462745109784, -122.445488137723) | |||||
| 1648 | 1648 | 251606 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 52R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999455.0 | 2100046.0 | 37.7462944425817 | -122.44461344107401 | (37.7462944425817, -122.444613441074) | |||||
| 1650 | 1650 | 251608 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 56R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999423.0 | 2100048.0 | 37.7462981080439 | -122.44472423658002 | (37.7462981080439, -122.44472423658) | |||||
| 1651 | 1651 | 251609 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 56R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999423.0 | 2100048.0 | 37.7462981080439 | -122.44472423658002 | (37.7462981080439, -122.44472423658) | |||||
| 1654 | 1654 | 251610 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 56R Amber Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999423.0 | 2100048.0 | 37.7462981080439 | -122.44472423658002 | (37.7462981080439, -122.44472423658) | |||||
| 4283 | 4283 | 253621 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 200x Montcalm St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010036.0 | 2099760.0 | 37.7461072494139 | -122.40800527847799 | (37.7461072494139, -122.408005278478) | ||||
| 4922 | 4922 | 253717 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | 4101 Balboa St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5982822.0 | 2110967.0 | 37.7753172554615 | -122.50293574331002 | (37.7753172554615, -122.50293574331) | |||||
| 10223 | 10223 | 173927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 240 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | |||||
| 13301 | 13301 | 187651 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 175 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998689.0 | 2104063.0 | 37.7572803991188 | -122.447551270828 | (37.7572803991188, -122.447551270828) | |||||
| 13315 | 13315 | 187668 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 100x OGDEN AVE | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6007659.0 | 2096105.0 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | |||||
| 19360 | 19360 | 105328 | Significant Tree 6 | Tree(s) :: 17 | 2051 03rd St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 771015 | 6015779.9 | 2106081.5 | 37.7637846705736 | -122.388584622631 | (37.7637846705736, -122.388584622631) | ||||
| 20974 | 20974 | 109568 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 95 Nordhoff St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 777169 | 6000348.8 | 2095645.6 | 37.734262946491704 | -122.44120712981501 | (37.7342629464917, -122.441207129815) | ||||
| 22866 | 22866 | 251139 | Significant Tree 6 | Tree(s) :: 17 | 621X Gough St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 03/10/2017 12:00:00 AM | 3 | Permit Number 779685 | |||||||
| 50494 | 50494 | 110477 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 131X Washington St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 6013427.21844 | 2117958.83498 | 37.796266453658795 | -122.397554954018 | (37.7962664536588, -122.397554954018) | |
| 52917 | 52917 | 116537 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754.0 | 2090179.0 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | |
| 53610 | 53610 | 104278 | Significant Tree 6 | Acacia spp :: Acacia Spp 176 | 2 Allston Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5994445.1 | 2098202.2 | 37.7409446783355 | -122.461803277974 | (37.7409446783355, -122.461803277974) | |||||
| 60806 | 60806 | 96274 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 55@ Alemany Trumbull St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6004001.3006 | 2094332.0064299998 | 37.7308634942567 | -122.428485665086 | (37.7308634942567, -122.428485665086) | ||||
| 78751 | 78751 | 117435 | Significant Tree 6 | Salix babylonica :: Weeping Willow 182 | 98X CLIPPER ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004559.0 | 2101087.0 | 37.749442713924296 | -122.427038546128 | (37.7494427139243, -122.427038546128) | |||||
| 81929 | 81929 | 98694 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 191@Clarendon Forest Knolls Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.754391095173794 | -122.455633951336 | (37.7543910951738, -122.455633951336) | |||
| 82211 | 82211 | 115446 | Significant Tree 6 | Tree(s) :: 17 | 546 FRANCONIA ST | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777844 | 6009931.0 | 2098208.0 | 37.7418399166086 | -122.40825891223801 | (37.7418399166086, -122.408258912238) |
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");