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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53479 | 53479 | 108406 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008120.84483 | 2112658.906 | 37.7814172463574 | -122.41554073723302 | (37.7814172463574, -122.415540737233) | |
88315 | 88315 | 108412 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
92393 | 92393 | 108411 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
107281 | 107281 | 108413 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
112409 | 112409 | 108414 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
135927 | 135927 | 108405 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008118.29339 | 2112682.65315 | 37.7814823069089 | -122.41555124581001 | (37.7814823069089, -122.41555124581) | |
151164 | 151164 | 108408 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008126.98045 | 2112612.39837 | 37.7812898924571 | -122.41551621722601 | (37.7812898924571, -122.415516217226) | |
170033 | 170033 | 108407 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008123.88182 | 2112634.14044 | 37.7813494167874 | -122.415528476779 | (37.7813494167874, -122.415528476779) | |
182575 | 182575 | 108410 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 10 | 3x3 | Permit Number 773269 | 6008131.8663 | 2112579.02445 | 37.781198530314995 | -122.41549695101801 | (37.781198530315, -122.415496951018) | |
184627 | 184627 | 108409 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 13 | 3x3 | Permit Number 773269 | 6008129.59407 | 2112591.6747 | 37.78123313714521 | -122.41550570771601 | (37.7812331371452, -122.415505707716) | |
9828 | 9828 | 121644 | Undocumented 2 | Tree(s) :: 17 | 362 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2016 12:00:00 AM | 3 | 2x4 | Permit Number 779268 | 5997955.0 | 2098188.0 | 37.741107118117 | -122.449666371295 | (37.741107118117, -122.449666371295) | |
2218 | 2218 | 114579 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3 | 3x3 | 6002950.36974 | 2121305.2817599997 | 37.8048659859314 | -122.43404631360701 | (37.8048659859314, -122.434046313607) | ||
6649 | 6649 | 114581 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3 | 3x3 | 6002967.5258 | 2121305.9196 | 37.8048687108976 | -122.433986988903 | (37.8048687108976, -122.433986988903) | ||
9808 | 9808 | 121557 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 421 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779269 | 6003622.0 | 2102696.0 | 37.7538076209017 | -122.430393500907 | (37.7538076209017, -122.430393500907) | |
127574 | 127574 | 113586 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X AUGUSTA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | 3x3 | 6011271.0 | 2095434.0 | 37.7342980459086 | -122.403430493306 | (37.7342980459086, -122.403430493306) | |||
9762 | 9762 | 120916 | Undocumented 2 | Tree(s) :: 17 | 1430 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778800 | 5990886.0 | 2105639.0 | 37.7611586563939 | -122.47465184359501 | (37.7611586563939, -122.474651843595) | |
9766 | 9766 | 120917 | Undocumented 2 | Tree(s) :: 17 | 1430 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778800 | 5990886.0 | 2105639.0 | 37.7611586563939 | -122.47465184359501 | (37.7611586563939, -122.474651843595) | |
67746 | 67746 | 83720 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 10 | 6015466.99985 | 2104808.44883 | 37.7602718009179 | -122.389577941994 | (37.7602718009179, -122.389577941994) | ||
103216 | 103216 | 83711 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3955 17TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/25/2005 12:00:00 AM | 12 | 3x3 | 6002562.7 | 2105843.1 | 37.7623887399353 | -122.434281776631 | (37.7623887399353, -122.434281776631) | ||
129530 | 129530 | 83758 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1640 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 11 | 6013046.15855 | 2104759.52511 | 37.7600029395994 | -122.39794712017598 | (37.7600029395994, -122.397947120176) | ||
96532 | 96532 | 102141 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 53 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2012 12:00:00 AM | 3 | 2x3 | Permit Number 769415 | 6002570.6 | 2095528.3 | 37.7340671770771 | -122.433517283514 | (37.7340671770771, -122.433517283514) | |
98112 | 98112 | 102142 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 53 Wilder St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2012 12:00:00 AM | 5 | 2x3 | Permit Number 769415 | 6002570.6 | 2095528.3 | 37.7340671770771 | -122.433517283514 | (37.7340671770771, -122.433517283514) | |
30576 | 30576 | 70371 | Undocumented 2 | Tree(s) :: 17 | 1470 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2015 12:00:00 AM | 7 | Permit Number 776609 | 5983120.8169 | 2105139.9902 | 37.759335513294396 | -122.50147093465598 | (37.7593355132944, -122.501470934656) | |
9730 | 9730 | 121694 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1225 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | 3x3 | 6011141.0 | 2102636.0 | 37.75406592216039 | -122.404386709259 | (37.7540659221604, -122.404386709259) | ||
15638 | 15638 | 121717 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | Permit Number 779222 | 6014431.9321099995 | 2103065.57675 | 37.755428803314295 | -122.39303583615101 | (37.7554288033143, -122.393035836151) | ||
15784 | 15784 | 121716 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779222 | 6014431.75751 | 2103081.25316 | 37.7554718376765 | -122.39303753677 | (37.7554718376765, -122.39303753677) | |
16736 | 16736 | 121715 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2016 12:00:00 AM | 3 | Permit Number 779222 | 6014429.69222 | 2103112.88568 | 37.7555585790683 | -122.39304689240299 | (37.7555585790683, -122.393046892403) | ||
93977 | 93977 | 96101 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 2780X 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773748 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | |
111930 | 111930 | 96108 | Undocumented 2 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 2780X 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773748 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | |
4705 | 4705 | 226129 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 468 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2016 12:00:00 AM | 9 | Width 3ft | 6002897.69632 | 2099218.5981799997 | 37.7442184383445 | -122.432649927259 | (37.7442184383445, -122.432649927259) | ||
9712 | 9712 | 121497 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 468 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2016 12:00:00 AM | 3 | 3x3 | 6002891.0 | 2099226.0 | 37.744238382256704 | -122.432673610292 | (37.7442383822567, -122.432673610292) | ||
9713 | 9713 | 121496 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 468 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2016 12:00:00 AM | 3 | 3x3 | 6002891.0 | 2099226.0 | 37.744238382256704 | -122.432673610292 | (37.7442383822567, -122.432673610292) | ||
187480 | 187480 | 71692 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 364 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 26 | 6x7 | 6006147.03421 | 2111101.3621799997 | 37.777029465781496 | -122.422258481339 | (37.7770294657815, -122.422258481339) | |
106342 | 106342 | 109952 | Undocumented 2 | Tree(s) :: 17 | 214 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2015 12:00:00 AM | 3x3 | Permit Number 777151 | 6000937.0 | 2106455.5 | 37.7639778318365 | -122.43994836828999 | (37.7639778318365, -122.43994836829) | ||
12916 | 12916 | 72155 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 260 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2014 12:00:00 AM | 3 | Permit Number 774096 | 6000883.4658699995 | 2093545.19578 | 37.7285261634496 | -122.43920812806499 | (37.7285261634496, -122.439208128065) | |
114954 | 114954 | 106805 | Undocumented 2 | Tree(s) :: 17 | 422 VICENTE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2014 12:00:00 AM | 3 | Permit Number 773237 | 5991611.7 | 2097778.6 | 37.7396180631534 | -122.47156917658701 | (37.7396180631534, -122.471569176587) | ||
129297 | 129297 | 107324 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 54 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774045 | 5993040.6 | 2097998.7 | 37.740304965710294 | -122.466644691653 | (37.7403049657103, -122.466644691653) | |
180738 | 180738 | 73681 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 659 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 7 | 5985344.08684 | 2111396.3012599996 | 37.7766439029573 | -122.494243039831 | (37.7766439029573, -122.494243039831) | ||
96099 | 96099 | 112179 | Undocumented 2 | Tree(s) :: 17 | 607 29TH AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2015 12:00:00 AM | 3x3 | Permit Number 777059 | 5986867.0 | 2111783.0 | 37.777794668927996 | -122.489003342792 | (37.777794668928, -122.489003342792) | ||
117626 | 117626 | 112178 | Undocumented 2 | Tree(s) :: 17 | 607 29TH AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2015 12:00:00 AM | 3x3 | Permit Number 777059 | 5986867.0 | 2111783.0 | 37.777794668927996 | -122.489003342792 | (37.777794668928, -122.489003342792) | ||
169469 | 169469 | 112177 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 607 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2015 12:00:00 AM | 9 | 3x3 | Permit Number 777059 | 5986882.7001 | 2111755.36791 | 37.777719715360206 | -122.488946999623 | (37.7777197153602, -122.488946999623) | |
129345 | 129345 | 107666 | Undocumented 2 | Quillaja saponaria :: Chilean Soapbark 343 | 140 STRATFORD DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 3 | Permit Number 774157 | 5990881.4 | 2091504.3 | 37.722348139716296 | -122.473636645054 | (37.7223481397163, -122.473636645054) | ||
14059 | 14059 | 73480 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 599x 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1994 12:00:00 AM | 14 | 3x3 | 6013522.7636400005 | 2111545.67763 | 37.7786627326451 | -122.39677451844601 | (37.7786627326451, -122.396774518446) | |
25178 | 25178 | 71050 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | 11 | 6011229.446 | 2095779.1610400002 | 37.735243464197296 | -122.403598436523 | (37.7352434641973, -122.403598436523) | ||
23822 | 23822 | 113961 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 1 | 3x3 | 6011664.51131 | 2107279.76743 | 37.7668459152285 | -122.40290285678101 | (37.7668459152285, -122.402902856781) | ||
42817 | 42817 | 113964 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 11 | 3x3 | 6011665.76024 | 2107233.19616 | 37.766718110767705 | -122.402895261101 | (37.7667181107677, -122.402895261101) | ||
169484 | 169484 | 113963 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 8 | 3x3 | 6011667.06303 | 2107250.9758099997 | 37.7667670024209 | -122.402892005557 | (37.7667670024209, -122.402892005557) | ||
27720 | 27720 | 72005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1963 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 5 | 5987221.7723 | 2101915.2958 | 37.7507213765199 | -122.487051188188 | (37.7507213765199, -122.487051188188) | ||
28693 | 28693 | 72007 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1919 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 9 | 5986594.8133 | 2102174.9289 | 37.7513976822301 | -122.489238323994 | (37.7513976822301, -122.489238323994) | ||
32765 | 32765 | 70201 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1811 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 10 | 5987499.4352 | 2102910.1581 | 37.7534691863201 | -122.486164042507 | (37.7534691863201, -122.486164042507) | ||
41336 | 41336 | 72223 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2059 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 5 | 5986929.1752 | 2101253.2415 | 37.7488864888631 | -122.48801435981899 | (37.7488864888631, -122.488014359819) | ||
41689 | 41689 | 73682 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2232 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 9 | 5987047.2593 | 2102366.6287 | 37.7519504378009 | -122.48768781507299 | (37.7519504378009, -122.487687815073) | ||
45590 | 45590 | 72004 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1923 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 6 | 5987214.1384 | 2102168.3069 | 37.7514156316864 | -122.487096166595 | (37.7514156316864, -122.487096166595) | ||
46952 | 46952 | 72003 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1991 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5987539.672 | 2101751.7111 | 37.75029074773129 | -122.48593987171101 | (37.7502907477313, -122.485939871711) | ||
51940 | 51940 | 74090 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2301 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 5 | 5986841.7666 | 2102304.3098 | 37.751767339194394 | -122.488393849306 | (37.7517673391944, -122.488393849306) | ||
55523 | 55523 | 72001 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1967 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 13 | 5987533.6739 | 2101901.6637 | 37.7507021277561 | -122.48597161886299 | (37.7507021277561, -122.485971618863) | ||
58187 | 58187 | 74854 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2345 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5986677.9867 | 2102297.122 | 37.751738046008704 | -122.48895968631001 | (37.7517380460087, -122.48895968631) | ||
64370 | 64370 | 72012 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2232 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 9 | 5987028.7741 | 2102367.0306 | 37.7519504631183 | -122.487751768225 | (37.7519504631183, -122.487751768225) | ||
73794 | 73794 | 73855 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2301 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 6 | 5986859.2227 | 2102304.8233 | 37.7517697676229 | -122.488333522296 | (37.7517697676229, -122.488333522296) | ||
130615 | 130615 | 71998 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1915 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 14 | 5987521.6777 | 2102219.5634 | 37.751574295748206 | -122.48603643497299 | (37.7515742957482, -122.486036434973) | ||
130987 | 130987 | 74552 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2345 Ortega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5986706.7381 | 2102298.6623 | 37.7517439532499 | -122.488860374683 | (37.7517439532499, -122.488860374683) | ||
133825 | 133825 | 72011 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2226 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 10 | 5987064.5388 | 2102366.6287 | 37.7519514456356 | -122.487628060872 | (37.7519514456356, -122.487628060872) | ||
137488 | 137488 | 71038 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1959 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 2 | 5987222.8629 | 2101938.1977 | 37.7507843225586 | -122.487049098627 | (37.7507843225586, -122.487049098627) | ||
151366 | 151366 | 74991 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2345 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5986666.6916 | 2102296.6086 | 37.751735977121704 | -122.488998708008 | (37.7517359771217, -122.488998708008) | ||
158141 | 158141 | 72008 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1935 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 9 | 5986597.8938 | 2102072.2457 | 37.7511159217998 | -122.48922012265899 | (37.7511159217998, -122.489220122659) | ||
159241 | 159241 | 72000 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1935 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 13 | 5987526.5853 | 2102096.8749 | 37.751237712137296 | -122.486010459184 | (37.7512377121373, -122.486010459184) | ||
159655 | 159655 | 72221 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1927 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 6 | 5987523.8589 | 2102155.7654 | 37.7513992507221 | -122.486024209623 | (37.7513992507221, -122.486024209623) | ||
162960 | 162960 | 71679 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2225 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 11 | 5987082.4527 | 2102313.0794 | 37.7518054585321 | -122.48756217943001 | (37.7518054585321, -122.48756217943) | ||
167162 | 167162 | 74706 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2345 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5986691.3356 | 2102298.6623 | 37.7517430543366 | -122.488913637871 | (37.7517430543366, -122.488913637871) | ||
171680 | 171680 | 71999 | Undocumented 2 | Tree(s) :: 17 | 1919 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5987523.8589 | 2102195.0257 | 37.7515070489426 | -122.486027091209 | (37.7515070489426, -122.486027091209) | ||
175552 | 175552 | 72009 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1954 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 7 | 5986645.6415 | 2101955.1867 | 37.7507972964546 | -122.489046403549 | (37.7507972964546, -122.489046403549) | ||
183539 | 183539 | 70108 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2059 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 14 | 5987239.8218 | 2101265.4744 | 37.7489381940905 | -122.486941055856 | (37.7489381940905, -122.486941055856) | ||
184983 | 184983 | 72002 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1987 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5987538.0362 | 2101772.9771 | 37.7503490431313 | -122.485947089116 | (37.7503490431313, -122.485947089116) | ||
185198 | 185198 | 72010 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1962 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 8 | 5986644.1013 | 2101904.8719 | 37.7506590557334 | -122.489048031087 | (37.7506590557334, -122.489048031087) | ||
123021 | 123021 | 109156 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 200 OCTAVIA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2015 01:49:00 PM | 3 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||
126440 | 126440 | 107219 | Undocumented 2 | Tree(s) :: 17 | 100 WINSTON DR | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2015 12:00:00 AM | 36 | Permit Number 776841 | 5990934.3 | 2093194.2 | 37.7269912477326 | -122.47357699184799 | (37.7269912477326, -122.473576991848) | ||
34835 | 34835 | 70020 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 6 | 5999648.4798 | 2110952.3759 | 37.7762516842269 | -122.44472821069598 | (37.7762516842269, -122.444728210696) | ||
47064 | 47064 | 75387 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 40 Vega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 6 | 5999425.0368 | 2112388.5534 | 37.7801823052034 | -122.445604458946 | (37.7801823052034, -122.445604458946) | ||
147629 | 147629 | 75134 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 40 Vega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 13 | 5999276.807999999 | 2112366.556 | 37.780113442326105 | -122.44611566553002 | (37.7801134423261, -122.44611566553) | ||
178976 | 178976 | 75310 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 40 Vega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 14 | 5999369.874 | 2112377.7239 | 37.7801494207177 | -122.445794512547 | (37.7801494207177, -122.445794512547) | ||
184695 | 184695 | 75215 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 40 Vega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 14 | 5999304.897000001 | 2112369.9402 | 37.7801243384858 | -122.44601873676399 | (37.7801243384858, -122.446018736764) | ||
10595 | 10595 | 78395 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 367 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768554 | 5999771.76948 | 2091747.9413700001 | 37.723527995008396 | -122.442922299331 | (37.7235279950084, -122.442922299331) |
82578 | 82578 | 80844 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3058 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768552 | 5996322.17074 | 2111497.48475 | 37.7775580303252 | -122.45627418036501 | (37.7775580303252, -122.456274180365) |
90130 | 90130 | 80264 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3112 Turk Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768551 | 5996040.11551 | 2111460.5044400003 | 37.7774402968929 | -122.45724722201099 | (37.7774402968929, -122.457247222011) |
127255 | 127255 | 81061 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3112 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768551 | 5996061.119469999 | 2111460.2787 | 37.7774408833677 | -122.45717454650601 | (37.7774408833677, -122.457174546506) |
163574 | 163574 | 73353 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2121 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1992 12:00:00 AM | 9 | 5988988.09253 | 2110533.92881 | 37.7744886354086 | -122.48157433024099 | (37.7744886354086, -122.481574330241) | ||
175192 | 175192 | 70089 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3226 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1992 12:00:00 AM | 8 | 5988610.07597 | 2111937.01448 | 37.778319129444604 | -122.482984802914 | (37.7783191294446, -122.482984802914) | ||
1284 | 1284 | 235428 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2869 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2016 12:00:00 AM | 3 | 3x3 | 6010306.81938 | 2100635.6894799997 | 37.74852686004171 | -122.40713053105101 | (37.7485268600417, -122.407130531051) | ||
1285 | 1285 | 234575 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2990 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2016 12:00:00 AM | 3 | Width 3ft | 6009677.1610900005 | 2100624.0529099996 | 37.7484596510092 | -122.409307067568 | (37.7484596510092, -122.409307067568) | ||
1315 | 1315 | 231172 | Undocumented 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2968 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2016 12:00:00 AM | 3 | Width 3ft | 6009727.404 | 2100624.8141099997 | 37.7484645559129 | -122.409133381503 | (37.7484645559129, -122.409133381503) | ||
29279 | 29279 | 71272 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2477 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 2 | 6000730.11 | 2114120.4408 | 37.785012045879 | -122.44121392136499 | (37.785012045879, -122.441213921365) | ||
34144 | 34144 | 71268 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1733 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 13 | 5999451.8492 | 2110818.1122 | 37.775871807627 | -122.445398751236 | (37.775871807627, -122.445398751236) | ||
77280 | 77280 | 71270 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1215 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 11 | 6001794.92 | 2112753.6259 | 37.7813197166319 | -122.437432113692 | (37.7813197166319, -122.437432113692) | ||
162200 | 162200 | 71273 | Undocumented 2 | Tristania conferta :: 79 | 2480 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 14 | 6000737.6791 | 2114169.5665 | 37.7851473635462 | -122.441191260636 | (37.7851473635462, -122.441191260636) | ||
180333 | 180333 | 71265 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1707 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 7 | 6000547.9611 | 2114579.8664 | 37.7862631325586 | -122.441877082784 | (37.7862631325586, -122.441877082784) | ||
185038 | 185038 | 73548 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1707 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 7 | 6000544.9075 | 2114594.6979 | 37.7863036820207 | -122.441888712315 | (37.7863036820207, -122.441888712315) | ||
159477 | 159477 | 79477 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3518 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/2001 12:00:00 AM | 4 | 5982515.1145 | 2100854.6307 | 37.7475335277544 | -122.503248420372 | (37.7475335277544, -122.503248420372) | ||
9036 | 9036 | 121627 | Undocumented 2 | Tree(s) :: 17 | 1706 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779124 | 6009277.0 | 2099394.0 | 37.7450597695073 | -122.41060397193199 | (37.7450597695073, -122.410603971932) | |
13940 | 13940 | 78887 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 701 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2015 12:00:00 AM | 3 | 6008828.13605 | 2110926.3802099996 | 37.7766998732463 | -122.412971309379 | (37.7766998732463, -122.412971309379) | |||
92839 | 92839 | 114449 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700X LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2015 12:00:00 AM | 3 | 3x3 | 6000096.0 | 2111366.0 | 37.7774129184899 | -122.44320983461999 | (37.7774129184899, -122.44320983462) |
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");