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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 799 | 799 | 175049 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 80X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 1 | Width 3ft | 5991326.81361 | 2089039.5683900001 | 37.715606377909495 | -122.47191742058 | (37.7156063779095, -122.47191742058) | ||
| 1221 | 1221 | 19739 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY14 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 1263 | 1263 | 138399 | DPW Maintained 3 | Tristania conferta :: 79 | 2445 PINE ST | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6002411.2137 | 2115044.4135 | 37.7876446559027 | -122.435463964972 | (37.7876446559027, -122.435463964972) | |||
| 3097 | 3097 | 1165 | DPW Maintained 3 | Escallonia bifida :: White escallonia 200 | 2849X Alemany Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | |||
| 3130 | 3130 | 253319 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3806 | 3806 | 177110 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 6 | Width 5ft | 5998978.57855 | 2091518.5364400002 | 37.722852847868 | -122.445647719081 | (37.722852847868, -122.445647719081) | |||
| 3841 | 3841 | 253549 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 17 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:46:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3949 | 3949 | 160074 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:38:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 4581 | 4581 | 142526 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | Width 0ft | 6009810.3798 | 2121222.957 | 37.8050268727325 | -122.410300597206 | (37.8050268727325, -122.410300597206) | |||
| 4684 | 4684 | 253645 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
| 4979 | 4979 | 8629 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999229.0905 | 2113208.3802 | 37.78242214856029 | -122.44634131765899 | (37.7824221485603, -122.446341317659) | |||
| 5038 | 5038 | 83035 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:50:00 AM | 3 | 6018541.89406 | 2097818.9676900003 | 37.741250126083706 | -122.37845792741501 | (37.7412501260837, -122.378457927415) | |||
| 5386 | 5386 | 44855 | Permitted Site 1 | Tree(s) :: 17 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 5863 | 5863 | 9461 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005331.3816 | 2112388.6106 | 37.780517893039395 | -122.425171696602 | (37.7805178930394, -122.425171696602) | ||
| 6115 | 6115 | 20296 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 6779 | 6779 | 46294 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 6835 | 6835 | 35197 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 7111 | 7111 | 13449 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6013948.95434 | 2117105.18569 | 37.793951570762296 | -122.39568978495001 | (37.7939515707623, -122.39568978495) | |||
| 7332 | 7332 | 13489 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Market St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6013490.62846 | 2116671.2522 | 37.7927345856821 | -122.397245205595 | (37.7927345856821, -122.397245205595) | |||
| 8078 | 8078 | 20329 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 9145 | 9145 | 3860 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 201X Cashmere St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1996 12:00:00 AM | 12 | 3X3 | 6016272.1162427 | 2096165.2075516998 | 37.73658386065979 | -122.386190822782 | (37.7365838606598, -122.386190822782) | ||
| 9335 | 9335 | 3814 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101X Cashmere St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1996 12:00:00 AM | 6 | 3X3 | 6017067.4579304 | 2095837.0108628003 | 37.7357266870687 | -122.383418119044 | (37.7357266870687, -122.383418119044) | ||
| 9600 | 9600 | 20367 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 9651 | 9651 | 114156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9658 | 9658 | 114124 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 10279 | 10279 | 45897 | Permitted Site 1 | Tree(s) :: 17 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 10701 | 10701 | 20452 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 495X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 10741 | 10741 | 27075 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 801 Silver Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4 | 6006793.50583 | 2093649.9353599998 | 37.7291482901427 | -122.418784183564 | (37.7291482901427, -122.418784183564) | |||
| 11080 | 11080 | 48233 | Permitted Site 1 | Tree(s) :: 17 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 11230 | 11230 | 27210 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2000 12:00:00 AM | 3 | 3X3 | 6003698.299930001 | 2093465.5644 | 37.728467287514206 | -122.42947142096901 | (37.7284672875142, -122.429471420969) | ||
| 11584 | 11584 | 19594 | DPW Maintained 3 | Acacia spp :: Acacia Spp 176 | 100 STAIRWAY4 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 11610 | 11610 | 35704 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 12581 | 12581 | 1281 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992683.69403 | 2087456.96265 | 37.7113393439098 | -122.46711247059099 | (37.7113393439098, -122.467112470591) | |||
| 13219 | 13219 | 24279 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 350X Winding Way | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000809.6312 | 2086798.35513 | 37.709996659695 | -122.43898005820299 | (37.709996659695, -122.438980058203) | |||
| 13431 | 13431 | 11527 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018609.30332 | 2096848.22468 | 37.738588373848295 | -122.378157476493 | (37.7385883738483, -122.378157476493) | |||
| 13536 | 13536 | 78330 | DPW Maintained 3 | Celtis australis :: European Hackberry 282 | 50 Pomona St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014096.48223 | 2094344.10726 | 37.7314628339206 | -122.39358556204999 | (37.7314628339206, -122.39358556205) | |
| 13547 | 13547 | 36637 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 13632 | 13632 | 19618 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 13785 | 13785 | 12137 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400X La Salle Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2016 09:03:00 AM | 3 | 3X3 | 6016395.84509 | 2095364.00428 | 37.7343907648187 | -122.385707210442 | (37.7343907648187, -122.385707210442) | ||
| 14315 | 14315 | 19833 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 100 STAIRWAY25 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60X | ||||||||
| 14341 | 14341 | 35444 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 14604 | 14604 | 19885 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 100 STAIRWAY33 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 14612 | 14612 | 19719 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY13 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40ST | ||||||||
| 14712 | 14712 | 19997 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY46 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
| 15124 | 15124 | 35187 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 15189 | 15189 | 3712 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016661.27341 | 2099164.52322 | 37.7448409049843 | -122.385054235166 | (37.7448409049843, -122.385054235166) | |||
| 15309 | 15309 | 6525 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/14/2006 12:00:00 AM | 3 | 15 | 6017423.67126 | 2097218.66072 | 37.7395401020993 | -122.382282630765 | (37.7395401020993, -122.382282630765) | ||
| 15643 | 15643 | 19759 | DPW Maintained 3 | Malus :: Crab Apple 235 | 100 STAIRWAY15 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 16291 | 16291 | 21875 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1900 03rd St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015645.87724 | 2106637.96445 | 37.7653051733068 | -122.38908702634701 | (37.7653051733068, -122.389087026347) | ||
| 16726 | 16726 | 51106 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 16873 | 16873 | 44558 | Permitted Site 1 | Tree(s) :: 17 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 17215 | 17215 | 29296 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997789.65443 | 2099947.6050400003 | 37.745929104439796 | -122.450364887145 | (37.7459291044398, -122.450364887145) | ||
| 17717 | 17717 | 98 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002352.6347900005 | 2107680.7629400003 | 37.7674225884029 | -122.435139756108 | (37.7674225884029, -122.435139756108) | |||
| 17990 | 17990 | 21036 | DPW Maintained 3 | Ulmus americana :: American Elm 119 | 2101X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.49472533299699 | (37.7478054765444, -122.494725332997) | |||
| 18063 | 18063 | 11685 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991290.62257 | 2092826.93511 | 37.726003458970105 | -122.472318441739 | (37.7260034589701, -122.472318441739) | ||
| 18314 | 18314 | 122661 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 18901 | 18901 | 29590 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991297.67299 | 2091930.7639 | 37.723543203431504 | -122.47222877213301 | (37.7235432034315, -122.472228772133) | ||
| 19650 | 19650 | 29875 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1900X Evans Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6014068.912189701 | 2099730.7814701 | 37.746251993267 | -122.394057835868 | (37.746251993267, -122.394057835868) | ||
| 19688 | 19688 | 29608 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991185.36807 | 2091033.22274 | 37.721072277433 | -122.472551581098 | (37.721072277433, -122.472551581098) | ||
| 19693 | 19693 | 45729 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 235 02nd St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2001 12:00:00 AM | Permit Number 44392 | 6013350.5591251 | 2114341.46161867 | 37.7863297261158 | -122.397566379799 | (37.7863297261158, -122.397566379799) | |||
| 20382 | 20382 | 53127 | Permitted Site 1 | Tree(s) :: 17 | 601@ NOE ST Duboce Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2006 12:00:00 AM | Permit Number 49066 | 6002808.44176413 | 2108284.12633652 | 37.7691051487822 | -122.43360630927201 | (37.7691051487822, -122.433606309272) | |||
| 20786 | 20786 | 29273 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998795.79674 | 2100195.7409 | 37.746667956864705 | -122.446903651091 | (37.7466679568647, -122.446903651091) | ||
| 20904 | 20904 | 12016 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1230X La Salle Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1992 12:00:00 AM | 6 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | ||
| 20983 | 20983 | 38398 | Permitted Site 1 | Tree(s) :: 17 | 1000 Van Ness Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1998 12:00:00 AM | Permit Number 40450 | 6006538.75328643 | 2113902.05144478 | 37.7847415646224 | -122.421102312622 | (37.7847415646224, -122.421102312622) | |||
| 21414 | 21414 | 29328 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5993805.9299800005 | 2097861.77346 | 37.7399731364485 | -122.463988569318 | (37.7399731364485, -122.463988569318) | ||
| 21937 | 21937 | 29584 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 3 | 3X3 | 5991345.88941 | 2093701.3780900002 | 37.728407659786 | -122.47219110225299 | (37.728407659786, -122.472191102253) | ||
| 22663 | 22663 | 26770 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006197.69813 | 2115570.77894 | 37.789304245831 | -122.42240086201099 | (37.789304245831, -122.422400862011) | |||
| 23067 | 23067 | 3507 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 201X Cargo Way | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6017965.040030001 | 2098144.3870599996 | 37.7421118483876 | -122.380475117526 | (37.7421118483876, -122.380475117526) | |||
| 23080 | 23080 | 18562 | DPW Maintained 3 | Prunus persica :: Peach 330 | 1700X Quesada Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | 19 | 6014525.2512300005 | 2095171.8151599998 | 37.7337593670062 | -122.392161079069 | (37.7337593670062, -122.392161079069) | |||
| 23747 | 23747 | 186497 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 17 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980894.6551 | 2105244.501 | 37.7594914745751 | -122.509177708249 | (37.7594914745751, -122.509177708249) | |||
| 23941 | 23941 | 250276 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6008392.62375 | 2112125.224 | 37.7799671560941 | -122.414562734397 | (37.7799671560941, -122.414562734397) | |||
| 24175 | 24175 | 221317 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3500x Cesar Chavez St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 10ft | 6005983.198059999 | 2100540.62132 | 37.74802291412821 | -122.422074813715 | (37.7480229141282, -122.422074813715) | |||
| 24381 | 24381 | 205069 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 851 Junipero Serra Blvd | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5991341.17231 | 2091818.7337900002 | 37.723238113832004 | -122.472070242354 | (37.723238113832, -122.472070242354) | |||
| 24581 | 24581 | 191958 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1322 Hudson Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6017653.96329 | 2094797.5572 | 37.732904949909994 | -122.381318065575 | (37.73290494991, -122.381318065575) | |||
| 25133 | 25133 | 198661 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6013934.2668 | 2107404.04412 | 37.7673136301584 | -122.39506079103 | (37.7673136301584, -122.39506079103) | |||
| 25787 | 25787 | 189282 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1310 Indiana St | 17 | : Yard 23 | Tree 1 | Private 1 | 2 | 6015006.25242 | 2102364.64044 | 37.753536067647 | -122.39100065687 | (37.753536067647, -122.39100065687) | ||||
| 25934 | 25934 | 202590 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 625 King St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 6012160.02147 | 2108668.06589 | 37.7706855257355 | -122.401286527748 | (37.7706855257355, -122.401286527748) | |||
| 26664 | 26664 | 207878 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5992430.64291 | 2104640.28912 | 37.75850584000379 | -122.469236940844 | (37.7585058400038, -122.469236940844) | |||
| 26897 | 26897 | 249733 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 17 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6000186.12585 | 2117239.7585400003 | 37.7935458766883 | -122.4433200551 | (37.7935458766883, -122.4433200551) | |||
| 27098 | 27098 | 249881 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 230 Greenwich St | 17 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 0ft | 6011514.20842 | 2120460.74576 | 37.803029388647104 | -122.404350588107 | (37.8030293886471, -122.404350588107) | |||
| 27106 | 27106 | 195241 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400x Evans Ave | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6016370.1217 | 2098002.92096 | 37.7416352733631 | -122.38598003597299 | (37.7416352733631, -122.385980035973) | ||||
| 27414 | 27414 | 186546 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 17 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5984749.2128 | 2104853.9681 | 37.758645678551105 | -122.495818134238 | (37.7586456785511, -122.495818134238) | |||
| 27616 | 27616 | 239170 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1400 Potrero Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010748.55016 | 2100997.3935 | 37.749544730724296 | -122.405628497759 | (37.7495447307243, -122.405628497759) | |||
| 27904 | 27904 | 210220 | DPW Maintained 3 | Melaleuca styphelliodes :: Paperbark Tree 239 | 198x San Anselmo Ave | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993632.14987 | 2096264.78649 | 37.7355781918881 | -122.464473499973 | (37.7355781918881, -122.464473499973) | ||||
| 28711 | 28711 | 141635 | Undocumented 2 | Rhaphiolepis indica :: India Hawthorn 144 | 1801 GROVE ST | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999100.4781 | 2110425.5241 | 37.7747737968525 | -122.44658597745399 | (37.7747737968525, -122.446585977454) | |||
| 28752 | 28752 | 222686 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1201 San Jose Ave | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004284.84781 | 2095906.59844 | 37.735203011805204 | -122.427617536921 | (37.7352030118052, -122.427617536921) | ||||
| 28786 | 28786 | 214229 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 17 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5999467.99685 | 2095449.76583 | 37.7336750195872 | -122.444238270085 | (37.7336750195872, -122.444238270085) | ||||
| 29046 | 29046 | 194625 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 131 Shipley St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6011983.78945 | 2112208.25417 | 37.7803962370307 | -122.402145051162 | (37.7803962370307, -122.402145051162) | |||
| 29316 | 29316 | 189392 | Undocumented 2 | Corylus colurna :: Hazel: Turkish 368 | 800 19th St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6014986.11495 | 2105335.88571 | 37.7616933529833 | -122.391277980795 | (37.7616933529833, -122.391277980795) | |||
| 29719 | 29719 | 128586 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Washington St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6013211.38418 | 2117897.25259 | 37.796085342709496 | -122.39829746727 | (37.7960853427095, -122.39829746727) | |||
| 30039 | 30039 | 129910 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3101 Van Ness Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005467.679169999 | 2121063.89893 | 37.804345751526704 | -122.425317698873 | (37.8043457515267, -122.425317698873) | |||
| 30157 | 30157 | 194823 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 502 Beale St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6015860.261580001 | 2113977.77101 | 37.7854705393653 | -122.388857976238 | (37.7854705393653, -122.388857976238) | |||
| 30235 | 30235 | 193977 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Keith St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6017598.84707 | 2096624.78326 | 37.737919107391896 | -122.381635651288 | (37.7379191073919, -122.381635651288) | |||
| 30245 | 30245 | 200301 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 300 Spear St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015414.78725 | 2115487.52698 | 37.7895912833718 | -122.39050472932101 | (37.7895912833718, -122.390504729321) | ||||
| 30458 | 30458 | 179736 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6004921.59693 | 2094359.59302 | 37.730991277113795 | -122.425306011263 | (37.7309912771138, -122.425306011263) | |||
| 30962 | 30962 | 229293 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6004930.67222 | 2104696.88853 | 37.7593756346006 | -122.42601023528 | (37.7593756346006, -122.42601023528) | |||
| 31795 | 31795 | 202089 | Undocumented 2 | Prunus armeniaca :: Apricot 259 | 1 Gould St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6012847.10312 | 2091145.2908299998 | 37.722610035407904 | -122.39768065196199 | (37.7226100354079, -122.397680651962) | ||||
| 33389 | 33389 | 250592 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 7ft | 5998381.460969999 | 2111351.09812 | 37.7772740876697 | -122.44913988818999 | (37.7772740876697, -122.44913988819) | |||
| 33704 | 33704 | 238799 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3100 Harrison St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008984.92439 | 2101131.84931 | 37.7498151388585 | -122.411736693099 | (37.7498151388585, -122.411736693099) | |||
| 33971 | 33971 | 213165 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 951 Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5991289.23593 | 2091020.58342 | 37.721043584566495 | -122.47219162297199 | (37.7210435845665, -122.472191622972) |
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");