Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4437 | 4437 | 221480 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 05:03:00 AM | 1 | Width 3ft | 6005548.13055 | 2106148.7780400002 | 37.7633970583515 | -122.423978006683 | (37.7633970583515, -122.423978006683) | ||
6721 | 6721 | 8476 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1900 Geary Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 6001756.762999999 | 2113633.6072 | 37.783733752237 | -122.437627157513 | (37.783733752237, -122.437627157513) | |||
7700 | 7700 | 8586 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6000400.7068 | 2113377.2527 | 37.782952673809795 | -122.442300177437 | (37.7829526738098, -122.442300177437) | |||
13624 | 13624 | 6521 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 15 | 6017462.61912 | 2097188.96881 | 37.739460725233606 | -122.38214589961599 | (37.7394607252336, -122.382145899616) | |||
15940 | 15940 | 97233 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300X Newcomb Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 15x200 | 6016357.8982 | 2094854.1147 | 37.7329886101989 | -122.385802878589 | (37.7329886101989, -122.385802878589) | |||
16064 | 16064 | 29654 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500X La Salle Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015636.0426 | 2096086.4462 | 37.736332371666705 | -122.388384525603 | (37.7363323716667, -122.388384525603) | ||
17393 | 17393 | 16115 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 300X Monterey Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/24/1998 12:00:00 AM | 3 | 5 | 5999569.73094 | 2094680.4197799999 | 37.7315683792686 | -122.44383129178101 | (37.7315683792686, -122.443831291781) | ||
17498 | 17498 | 29269 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998912.29808 | 2100220.6513 | 37.7467430097923 | -122.44650259483 | (37.7467430097923, -122.44650259483) | ||
20354 | 20354 | 27346 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 100X Monterey Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4 | 6000818.28486 | 2094659.29899 | 37.731581524667504 | -122.43951329411301 | (37.7315815246675, -122.439513294113) | |||
20515 | 20515 | 29969 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991404.41199 | 2093617.36709 | 37.728180373200495 | -122.471982668172 | (37.7281803732005, -122.471982668172) | ||
20789 | 20789 | 29999 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 681X San Jose Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005890.72277 | 2099411.68829 | 37.7449179049514 | -122.422314391296 | (37.7449179049514, -122.422314391296) | ||
20900 | 20900 | 11781 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991290.20273 | 2091828.8846200001 | 37.7232630358375 | -122.472247172271 | (37.7232630358375, -122.472247172271) | ||
21687 | 21687 | 29292 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997896.0559 | 2099960.74838 | 37.745971281767105 | -122.449997914268 | (37.7459712817671, -122.449997914268) | ||
21843 | 21843 | 4977 | DPW Maintained 3 | Malus :: Crab Apple 235 | 5200X Diamond Heights Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6000986.47805 | 2099376.03086 | 37.744542137604206 | -122.43926977298099 | (37.7445421376042, -122.439269772981) | |||
21972 | 21972 | 29324 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3x3 | 5993923.66744 | 2097873.4843200003 | 37.7400120761835 | -122.463582334771 | (37.7400120761835, -122.463582334771) | ||
23244 | 23244 | 24275 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350X Winding Way | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 38 | 8 | 6000843.90644 | 2086792.8315400002 | 37.709983443260995 | -122.438861201091 | (37.709983443261, -122.438861201091) | |||
27159 | 27159 | 213778 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 401x Monterey Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 4ft | 5998914.18909 | 2094690.21596 | 37.7315578635039 | -122.446098323489 | (37.7315578635039, -122.446098323489) | |||
28906 | 28906 | 180049 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000848.655230001 | 2090751.2328 | 37.7208525973406 | -122.439128305154 | (37.7208525973406, -122.439128305154) | |||
31681 | 31681 | 180089 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 2ft | 5999997.23135 | 2089763.94995 | 37.7180932587717 | -122.442000582366 | (37.7180932587717, -122.442000582366) | |||
33738 | 33738 | 181254 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011072.17285 | 2087082.1734200001 | 37.711354542437 | -122.403530502643 | (37.711354542437, -122.403530502643) | |||
36608 | 36608 | 107488 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6011453.59321 | 2119920.31769 | 37.80154211772779 | -122.40452228489599 | (37.8015421177278, -122.404522284896) | ||||
40271 | 40271 | 176065 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 300x Mansell St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6010824.423280001 | 2090455.4956599998 | 37.7206031577782 | -122.404624109729 | (37.7206031577782, -122.404624109729) | |||
40906 | 40906 | 205764 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5999220.2422400005 | 2097585.41843 | 37.7395248774812 | -122.445248322956 | (37.7395248774812, -122.445248322956) | |||
42902 | 42902 | 221440 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6005447.60224 | 2108007.88033 | 37.7684960344855 | -122.424457946087 | (37.7684960344855, -122.424457946087) | |||
47891 | 47891 | 244336 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6005628.4661 | 2109884.4314 | 37.7736588046762 | -122.423965813403 | (37.7736588046762, -122.423965813403) | |||
53575 | 53575 | 244407 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 202x Octavia St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005584.4651 | 2110232.73 | 37.774612664125 | -122.424142794808 | (37.774612664125, -122.424142794808) | |||
55123 | 55123 | 198002 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 860x Jamestown Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 6014610.54339 | 2089241.6149400002 | 37.717480958049 | -122.39145176041 | (37.717480958049, -122.39145176041) | |||
56779 | 56779 | 180014 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 2ft | 5998072.24977 | 2088335.05478 | 37.7140599558874 | -122.44855153193599 | (37.7140599558874, -122.448551531936) | |||
57712 | 57712 | 204535 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 5999462.01157 | 2097038.1578 | 37.738036027335895 | -122.444373073979 | (37.7380360273359, -122.444373073979) | |||
58892 | 58892 | 200537 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6016177.7125 | 2095662.3283 | 37.735197829979 | -122.38648216691001 | (37.735197829979, -122.38648216691) | |||
59208 | 59208 | 222795 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6010312.60007 | 2100681.0451 | 37.748651720118296 | -122.40711373800801 | (37.7486517201183, -122.407113738008) | |||
60262 | 60262 | 219167 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5993768.02883 | 2100241.187 | 37.7465042226907 | -122.464292318936 | (37.7465042226907, -122.464292318936) | |||
60777 | 60777 | 181229 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012059.81705 | 2087859.8714700001 | 37.713545064337296 | -122.400171515023 | (37.7135450643373, -122.400171515023) | |||
62523 | 62523 | 220272 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500x 27th St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 4ft | 6002834.52979 | 2100065.9287400004 | 37.7465414276535 | -122.432928866369 | (37.7465414276535, -122.432928866369) | |||
66379 | 66379 | 211334 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 501x Ortega St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 5992524.38943 | 2103111.35014 | 37.7543131889121 | -122.468801469312 | (37.7543131889121, -122.468801469312) | |||
67186 | 67186 | 177683 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500x Mansell St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6010362.00483 | 2090329.22139 | 37.7202305794682 | -122.40621366053301 | (37.7202305794682, -122.406213660533) | |||
70179 | 70179 | 178454 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 700x Mansell St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6009463.675319999 | 2090037.3168799998 | 37.719378780282796 | -122.40929831179199 | (37.7193787802828, -122.409298311792) | |||
72205 | 72205 | 180298 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001864.37036 | 2093012.55553 | 37.727119423206396 | -122.43577900049999 | (37.7271194232064, -122.4357790005) | |||
74873 | 74873 | 211239 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 5993619.45361 | 2100368.2719799997 | 37.746844600813496 | -122.464815299002 | (37.7468446008135, -122.464815299002) | |||
80227 | 80227 | 6116 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
80400 | 80400 | 28651 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1600X Webster St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6003605.147696201 | 2114190.7261663 | 37.785368381567004 | -122.431272227533 | (37.785368381567, -122.431272227533) | |||
81526 | 81526 | 103927 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/05/2001 12:00:00 AM | 4x4 | 6014859.0 | 2117030.0 | 37.793795709183996 | -122.392535650186 | (37.793795709184, -122.392535650186) | |||
82547 | 82547 | 30021 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 710X San Jose Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005718.76576524 | 2099005.5772577 | 37.7437931149581 | -122.42288013057501 | (37.7437931149581, -122.422880130575) | ||
83897 | 83897 | 106386 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
85028 | 85028 | 18558 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.39122125893199 | (37.7333138733401, -122.391221258932) | |||
85707 | 85707 | 99130 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 13 | Median : Cutout 11 | Tree 1 | Private 1 | 18 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
86980 | 86980 | 454 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 740X 23rd Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8-HOA | 5988822.540159999 | 2110230.27386 | 37.7736452554339 | -122.482124750469 | (37.7736452554339, -122.482124750469) | |||
89822 | 89822 | 2298 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 800X Brotherhood Way | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
92004 | 92004 | 23601 | DPW Maintained 3 | Eucalyptus viminalis :: Manna Gum 356 | 200X Vasquez Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
92884 | 92884 | 119733 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104x Octavia St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
93719 | 93719 | 110771 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300X GUERRERO ST | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:10:00 AM | 3 | 3x3 | 6005492.0 | 2106949.0 | 37.7655911088206 | -122.424229059984 | (37.7655911088206, -122.424229059984) | ||
95638 | 95638 | 11841 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
95836 | 95836 | 29310 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
96286 | 96286 | 97389 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1400X Broadway | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6006851.0 | 2118099.6 | 37.7962845906619 | -122.420320069483 | (37.7962845906619, -122.420320069483) | |||||
96408 | 96408 | 6618 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400X Evans Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6016747.6410828 | 2097755.6169144 | 37.740977112201705 | -122.384657465748 | (37.7409771122017, -122.384657465748) | |||
97883 | 97883 | 24986 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 292 Dolores St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
99987 | 99987 | 2279 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 750X Brotherhood Way | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 14M | 5991074.042616099 | 2088106.2478104 | 37.71302907778821 | -122.47272309171998 | (37.7130290777882, -122.47272309172) | |||
100063 | 100063 | 110650 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400X GUERRERO ST | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 05:03:00 AM | 3 | 3x3 | 6005439.0 | 2106552.0 | 37.7644980484366 | -122.42438413571101 | (37.7644980484366, -122.424384135711) | ||
102538 | 102538 | 4996 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | ||||
103351 | 103351 | 25147 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1798X Dolores St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005303.475850901 | 2097774.014097 | 37.740388080432204 | -122.42422853472999 | (37.7403880804322, -122.42422853473) | |||
105202 | 105202 | 8625 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999387.1761445 | 2113256.6615953 | 37.7825637442266 | -122.44579788601101 | (37.7825637442266, -122.445797886011) | |||
105377 | 105377 | 114831 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
108127 | 108127 | 8347 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1300 Geary Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
109022 | 109022 | 29640 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1110X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991107.8990450995 | 2089843.5367701 | 37.717801208369 | -122.47273266668002 | (37.717801208369, -122.47273266668) | ||
112917 | 112917 | 29604 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 910X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991188.7321263 | 2091104.0152466998 | 37.7212668508959 | -122.472545111236 | (37.7212668508959, -122.472545111236) | ||
113487 | 113487 | 815 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 600X 39th Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
114822 | 114822 | 29347 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1500X Portola Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992236.5627249 | 2096694.9403025003 | 37.7366787380665 | -122.469329833584 | (37.7366787380665, -122.469329833584) | ||
117903 | 117903 | 30078 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
120772 | 120772 | 119778 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 204x Octavia St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
131039 | 131039 | 180275 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002868.91973 | 2094123.5924900002 | 37.7302270908082 | -122.432385606628 | (37.7302270908082, -122.432385606628) | |||
134823 | 134823 | 204329 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600x Portola Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 5992093.44259 | 2096556.1613599998 | 37.736289414430296 | -122.469814556494 | (37.7362894144303, -122.469814556494) | |||
135265 | 135265 | 180310 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6001633.36307 | 2092505.5566599998 | 37.725714194747894 | -122.436541315349 | (37.7257141947479, -122.436541315349) | |||
140720 | 140720 | 11681 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 710X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991310.6193982 | 2092985.7524279999 | 37.7264406890913 | -122.472260886614 | (37.7264406890913, -122.472260886614) | ||
141015 | 141015 | 110784 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:11:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
141110 | 141110 | 30159 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 410X Mansell St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
142252 | 142252 | 24972 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 198 Dolores St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.6555297 | 2107199.7616194002 | 37.766240805753604 | -122.426624291348 | (37.7662408057536, -122.426624291348) | |||
142339 | 142339 | 119695 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 4x Octavia St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109391.0 | 6005718.0 | 47.269987373868105 | -138.2836696503 | (47.2699873738681, -138.2836696503) | |||||
144043 | 144043 | 122884 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
144803 | 144803 | 8402 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1500 Geary Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6004544.7148816 | 2114057.9755695 | 37.785057082792605 | -122.428012143853 | (37.7850570827926, -122.428012143853) | |||
145656 | 145656 | 91448 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900X Portola Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 4x4 | 5996336.043197 | 2098916.600218 | 37.7430149203693 | -122.455316749086 | (37.7430149203693, -122.455316749086) | |||
147452 | 147452 | 178266 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 12x Canyon Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6002746.13562 | 2086151.65676 | 37.7083309587667 | -122.43224097763901 | (37.7083309587667, -122.432240977639) | |||
149405 | 149405 | 113507 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 200x Mansell St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6011128.47606 | 2090549.92676 | 37.720879434926 | -122.40357972973999 | (37.720879434926, -122.40357972974) | |||
150263 | 150263 | 221520 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1200x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005805.491090001 | 2101500.8171 | 37.7506493670819 | -122.422757545722 | (37.7506493670819, -122.422757545722) | |||
159086 | 159086 | 221493 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 500x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005583.08285 | 2105563.4275 | 37.7617917972666 | -122.42381549380801 | (37.7617917972666, -122.423815493808) | |||
162328 | 162328 | 218727 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600x Laguna Honda Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 5995464.78871 | 2099972.9303200003 | 37.745865311950205 | -122.45840573454299 | (37.7458653119502, -122.458405734543) | |||
163658 | 163658 | 180105 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 2ft | 5999329.24691 | 2089132.49374 | 37.7163213353465 | -122.44426415617599 | (37.7163213353465, -122.444264156176) | |||
178254 | 178254 | 221510 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1300x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005838.80296 | 2100921.0233299998 | 37.7490592658716 | -122.422601154533 | (37.7490592658716, -122.422601154533) | |||
182798 | 182798 | 221555 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005738.9106 | 2102712.57542 | 37.753972818908 | -122.423073906548 | (37.753972818908, -122.423073906548) | |||
184493 | 184493 | 176301 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 10x Mansell St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 6011617.09806 | 2090687.60598 | 37.7212847557703 | -122.40190037442899 | (37.7212847557703, -122.401900374429) | |||
187000 | 187000 | 211365 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1x Minerva St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5996056.33729 | 2089003.23942 | 37.715779161955396 | -122.45556751823601 | (37.7157791619554, -122.455567518236) |
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");