Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 517 | 517 | 248948 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1500x Galvez Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/10/2017 01:15:00 PM | 3 | 3x3 | 6016393.0 | 2097292.0 | 37.739684495027205 | -122.385851388433 | (37.7396844950272, -122.385851388433) | |
| 806 | 806 | 177713 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 3ft | 5991322.37032 | 2089056.90035 | 37.715653710133296 | -122.471934040933 | (37.7156537101333, -122.471934040933) | |||
| 2664 | 2664 | 37831 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003870.23097 | 2090403.3538799998 | 37.720068868758105 | -122.42865884842699 | (37.7200688687581, -122.428658848427) |
| 2699 | 2699 | 36646 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 2702 | 2702 | 175365 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5993296.25394 | 2087788.76232 | 37.712285726578 | -122.465019407322 | (37.712285726578, -122.465019407322) | |||
| 3136 | 3136 | 253320 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3837 | 3837 | 253550 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 18 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:43:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3918 | 3918 | 253108 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:41:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 4500 | 4500 | 253085 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2849X Alemany Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:40:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 4930 | 4930 | 197650 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 10:31:00 AM | 3 | Width 3ft | 6017512.77369 | 2098485.85809 | 37.7430244920913 | -122.38206267634399 | (37.7430244920913, -122.382062676344) | ||
| 4980 | 4980 | 83034 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:59:00 PM | 3 | 6018525.50747 | 2097831.43609 | 37.7412834585567 | -122.37851545254298 | (37.7412834585567, -122.378515452543) | |||
| 5617 | 5617 | 35204 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 5798 | 5798 | 8630 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999216.9073 | 2113207.365 | 37.7824186652585 | -122.44638339297501 | (37.7824186652585, -122.446383392975) | |||
| 5958 | 5958 | 98639 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 6002240.752780001 | 2120332.50299 | 37.8021546945469 | -122.436432348976 | (37.8021546945469, -122.436432348976) | ||
| 6580 | 6580 | 48234 | Permitted Site 1 | Tree(s) :: 17 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 6651 | 6651 | 16365 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 1306X Montgomery St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011450.07983 | 2119965.49195 | 37.8016659588815 | -122.40453762461901 | (37.8016659588815, -122.404537624619) | |||
| 6764 | 6764 | 13451 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2005 12:00:00 AM | 10 | 4X4 | 6013934.63842 | 2117075.49652 | 37.793869254911606 | -122.395737238577 | (37.7938692549116, -122.395737238577) | ||
| 7347 | 7347 | 19760 | DPW Maintained 3 | Malus :: Crab Apple 235 | 100 STAIRWAY15 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 7696 | 7696 | 19998 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY46 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
| 7875 | 7875 | 20330 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 101X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 7877 | 7877 | 19720 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 100 STAIRWAY13 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 8196 | 8196 | 20297 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 20X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 9129 | 9129 | 28844 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 201X Cashmere St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6016272.1162427 | 2096165.2075516998 | 37.73658386065979 | -122.386190822782 | (37.7365838606598, -122.386190822782) | |||
| 9464 | 9464 | 24167 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 110X Whitney Young Cir | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2011 12:00:00 AM | 2 | 3x3 | 6016346.0952597 | 2096044.1423308998 | 37.736255534298 | -122.38592660691401 | (37.736255534298, -122.385926606914) | ||
| 9594 | 9594 | 35445 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
| 9641 | 9641 | 114157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9649 | 9649 | 114125 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9945 | 9945 | 102971 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 5991413.8 | 2088806.6 | 37.714971736494 | -122.471599792301 | (37.714971736494, -122.471599792301) | |||
| 10021 | 10021 | 120935 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10273 | 10273 | 19834 | DPW Maintained 3 | Robinia pseudoacacia :: Black Locust 169 | 100 STAIRWAY25 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60X | ||||||||
| 10477 | 10477 | 20009 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY47 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 10628 | 10628 | 27211 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003731.93996 | 2093466.46517 | 37.7284716654181 | -122.429355189899 | (37.7284716654181, -122.429355189899) | ||
| 12275 | 12275 | 35186 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12372 | 12372 | 44557 | Permitted Site 1 | Tree(s) :: 17 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 12574 | 12574 | 27076 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 801 Silver Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4 | 6006769.89778 | 2093653.43798 | 37.7291565782964 | -122.418866047033 | (37.7291565782964, -122.418866047033) | |||
| 12830 | 12830 | 19619 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 12896 | 12896 | 19960 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY41 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 13311 | 13311 | 29591 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991298.8544 | 2091955.25413 | 37.7236105159064 | -122.47222647259899 | (37.7236105159064, -122.472226472599) | ||
| 14497 | 14497 | 45889 | Permitted Site 1 | Tree(s) :: 17 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 14535 | 14535 | 3713 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016679.4743 | 2099151.07612 | 37.7448049887681 | -122.384990362612 | (37.7448049887681, -122.384990362612) | |||
| 14545 | 14545 | 21876 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1997 12:00:00 AM | 3 | 3X3 | 6015645.96934 | 2106615.37755 | 37.7652431596794 | -122.389085130597 | (37.7652431596794, -122.389085130597) | ||
| 14573 | 14573 | 44845 | Permitted Site 1 | Tree(s) :: 17 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 14980 | 14980 | 12138 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400X La Salle Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1992 12:00:00 AM | 6 | 3X3 | 6016391.73401 | 2095386.5318599998 | 37.7344523935553 | -122.385722993521 | (37.7344523935553, -122.385722993521) | ||
| 15109 | 15109 | 6526 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/14/2006 12:00:00 AM | 3 | 15 | 6017409.27613 | 2097218.95029 | 37.7395401020909 | -122.382332423519 | (37.7395401020909, -122.382332423519) | ||
| 15160 | 15160 | 51107 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 18 | 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) | |||
| 15350 | 15350 | 78329 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014093.60126 | 2094328.91133 | 37.731420948908294 | -122.39359445903999 | (37.7314209489083, -122.39359445904) | |
| 15553 | 15553 | 20453 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 495X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 16196 | 16196 | 46309 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 16394 | 16394 | 20368 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
| 17544 | 17544 | 11701 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991290.41051 | 2092816.87452 | 37.725975822821205 | -122.47231844174 | (37.7259758228212, -122.47231844174) | ||
| 18501 | 18501 | 19595 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 100 STAIRWAY4 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | ||||||||
| 20621 | 20621 | 21114 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985004.6737667 | 2100227.1692458 | 37.745956718592794 | -122.494593556276 | (37.7459567185928, -122.494593556276) | |||
| 20640 | 20640 | 29609 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 900X Junipero Serra Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991172.14351 | 2091025.81173 | 37.7210511631493 | -122.472596754032 | (37.7210511631493, -122.472596754032) | ||
| 20835 | 20835 | 99 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6002314.25424 | 2107678.41928 | 37.767413973794795 | -122.43527234134501 | (37.7674139737948, -122.435272341345) | |||
| 21435 | 21435 | 29973 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 500X Junipero Serra Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991350.6997 | 2093700.47523 | 37.7284054591375 | -122.472174407226 | (37.7284054591375, -122.472174407226) | ||
| 21567 | 21567 | 29297 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997761.734019999 | 2099940.1995 | 37.7459071726754 | -122.45046089786501 | (37.7459071726754, -122.450460897865) | ||
| 21860 | 21860 | 29274 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998769.34241 | 2100187.82137 | 37.7466447003919 | -122.446994557273 | (37.7466447003919, -122.446994557273) | ||
| 23263 | 23263 | 3508 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 6017980.680269999 | 2098133.15007 | 37.7420818568975 | -122.380420257114 | (37.7420818568975, -122.380420257114) | |||
| 23421 | 23421 | 195972 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 4ft | 6015355.8319 | 2100319.8042599997 | 37.7479407691514 | -122.389648918288 | (37.7479407691514, -122.389648918288) | |||
| 23642 | 23642 | 176313 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 38 | Width 0ft | 6010259.13784 | 2090270.57035 | 37.7200637812891 | -122.40656510840799 | (37.7200637812891, -122.406565108408) | |||
| 23876 | 23876 | 218979 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 551 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991462.95986 | 2093729.88952 | 37.7284927194476 | -122.47178846497101 | (37.7284927194476, -122.471788464971) | |||
| 24067 | 24067 | 201949 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 18 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013468.57071 | 2092447.06427 | 37.7262190300648 | -122.395623522912 | (37.7262190300648, -122.395623522912) | |||
| 24866 | 24866 | 189991 | DPW Maintained 3 | Cercis occidentalis :: Western Redbud 246 | 1427x Innes Ave | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6016204.83732 | 2096710.6252 | 37.7380777432808 | -122.386461454743 | (37.7380777432808, -122.386461454743) | ||||
| 25182 | 25182 | 228738 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003718.932019999 | 2105984.99078 | 37.762843897062204 | -122.43029292379101 | (37.7628438970622, -122.430292923791) | |||
| 25341 | 25341 | 180280 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002728.35558 | 2094064.39346 | 37.730056572136704 | -122.432867327564 | (37.7300565721367, -122.432867327564) | |||
| 25911 | 25911 | 205719 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 141 Taraval St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993232.44961 | 2099151.4105700003 | 37.7434810877719 | -122.466065100337 | (37.7434810877719, -122.466065100337) | |||
| 25933 | 25933 | 207216 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Judson Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 1ft | 5997629.9182 | 2093521.5482700001 | 37.7282755556595 | -122.450454058505 | (37.7282755556595, -122.450454058505) | |||
| 26780 | 26780 | 206487 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5994954.72324 | 2099244.0614400003 | 37.7438346949325 | -122.46011666235 | (37.7438346949325, -122.46011666235) | |||
| 27163 | 27163 | 194824 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 502 Beale St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6015871.5156 | 2113965.50811 | 37.785437491981 | -122.38881818391701 | (37.785437491981, -122.388818183917) | |||
| 27550 | 27550 | 217457 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 5996170.11239 | 2089001.42717 | 37.7157807141869 | -122.455174130483 | (37.7157807141869, -122.455174130483) | |||
| 27717 | 27717 | 196349 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6011979.46515 | 2105146.30626 | 37.761005489419205 | -122.40166350647499 | (37.7610054894192, -122.401663506475) | ||||
| 29144 | 29144 | 205629 | Undocumented 2 | Betula pendula :: European White Birch 146 | 714 Detroit St | 18 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999458.60233 | 2095454.85434 | 37.7336884554611 | -122.444271115125 | (37.7336884554611, -122.444271115125) | ||||
| 29364 | 29364 | 180341 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900 San Jose Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999647.0193300005 | 2092191.3988599998 | 37.72473851394321 | -122.44338537463001 | (37.7247385139432, -122.44338537463) | |||
| 29858 | 29858 | 134656 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1201 Sacramento St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008969.94207 | 2116669.44448 | 37.7924769074366 | -122.412886899012 | (37.7924769074366, -122.412886899012) | |||
| 30288 | 30288 | 195777 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 6013688.74919 | 2110125.02195 | 37.774771170975704 | -122.396100718491 | (37.7747711709757, -122.396100718491) | |||
| 30666 | 30666 | 189167 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1300x De Haro St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012264.80612 | 2102152.7525400002 | 37.7528017667079 | -122.40046634965 | (37.7528017667079, -122.40046634965) | ||||
| 30845 | 30845 | 197201 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2001 Revere Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6012348.821330001 | 2096403.61302 | 37.737020542553395 | -122.399772154858 | (37.7370205425534, -122.399772154858) | ||||
| 31547 | 31547 | 187235 | Undocumented 2 | Tristania conferta :: 79 | 2401 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984966.2222 | 2098610.2885 | 37.7415149514197 | -122.494607336605 | (37.7415149514197, -122.494607336605) | |||
| 31669 | 31669 | 208210 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1600x Portola Dr | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5992185.15717 | 2096629.4643700002 | 37.736495986901396 | -122.469502798411 | (37.7364959869014, -122.469502798411) | |||
| 32065 | 32065 | 178289 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 18 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5988700.42615 | 2088712.0601 | 37.71455479883021 | -122.480971333587 | (37.7145547988302, -122.480971333587) | |||
| 32916 | 32916 | 192763 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1151 Fairfax Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017774.7904900005 | 2096379.9178799998 | 37.737256468918 | -122.381010303197 | (37.737256468918, -122.381010303197) | |||
| 33017 | 33017 | 218260 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400x Portola Dr | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5992795.95946 | 2097207.23373 | 37.738117677685 | -122.46743301504 | (37.738117677685, -122.46743301504) | ||||
| 33119 | 33119 | 222055 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Treat Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6009052.2117 | 2107911.2357400004 | 37.768433567573396 | -122.41198303719901 | (37.7684335675734, -122.411983037199) | ||||
| 33126 | 33126 | 195077 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1095 Indiana St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6015017.07999 | 2103863.26313 | 37.757651566782606 | -122.391067951324 | (37.7576515667826, -122.391067951324) | |||
| 33183 | 33183 | 209132 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6001073.50305 | 2095703.1639599998 | 37.7344622582302 | -122.438705728106 | (37.7344622582302, -122.438705728106) | |||
| 33391 | 33391 | 229290 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 420 Dolores St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6004880.38436 | 2105530.63009 | 37.7616620493947 | -122.426243514035 | (37.7616620493947, -122.426243514035) | |||
| 33398 | 33398 | 196014 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 212 Terry A Francois Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6015720.48392 | 2110692.27541 | 37.7764415573597 | -122.389112085054 | (37.7764415573597, -122.389112085054) | ||||
| 33541 | 33541 | 242192 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Castro St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002211.39696 | 2108163.69762 | 37.7687405871237 | -122.43566283237499 | (37.7687405871237, -122.435662832375) | |||
| 33776 | 33776 | 128430 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 555 California St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6011861.722680001 | 2116708.95786 | 37.792747296703 | -122.402883973743 | (37.792747296703, -122.402883973743) | |||
| 33911 | 33911 | 194608 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1701 19th St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6012624.29476 | 2105144.67 | 37.761036958503205 | -122.39943319231001 | (37.7610369585032, -122.39943319231) | |||
| 33969 | 33969 | 232135 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 4185 25th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003143.3737699995 | 2101224.11027 | 37.749739035528606 | -122.43194360511299 | (37.7497390355286, -122.431943605113) | |||
| 35449 | 35449 | 135357 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 40 Market St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6012950.96733 | 2116134.59975 | 37.7912310055603 | -122.399074782778 | (37.7912310055603, -122.399074782778) | |||
| 35905 | 35905 | 195913 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Ardath Ct | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017397.96951 | 2095379.8404599999 | 37.7344896488605 | -122.382243605578 | (37.7344896488605, -122.382243605578) | |||
| 36476 | 36476 | 195705 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 250 King St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014510.25989 | 2110973.8453599997 | 37.777147523372896 | -122.393318333896 | (37.7771475233729, -122.393318333896) | |||
| 36639 | 36639 | 185090 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2801 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 0ft | 5985010.2871 | 2096033.7617 | 37.7344430784325 | -122.494265109246 | (37.7344430784325, -122.494265109246) | |||
| 36763 | 36763 | 194034 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 24th St | 18 | : Yard 23 | Tree 1 | Private 1 | 25 | 6017329.2954 | 2102592.85695 | 37.754291333594395 | -122.382982871671 | (37.7542913335944, -122.382982871671) | ||||
| 37011 | 37011 | 187739 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6016069.71075 | 2096081.9732700002 | 37.736344111196 | -122.38688482859399 | (37.736344111196, -122.386884828594) | ||||
| 37110 | 37110 | 130134 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Franklin St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006314.38114 | 2112047.1343900003 | 37.77963576491629 | -122.421746768917 | (37.7796357649163, -122.421746768917) | |||
| 37869 | 37869 | 190854 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6014595.17181 | 2110600.5682900003 | 37.7761273054628 | -122.392998471116 | (37.7761273054628, -122.392998471116) | |||
| 37934 | 37934 | 249882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 27 | Width 0ft | 6011509.072430001 | 2120419.3733099997 | 37.8029155030083 | -122.40436544761499 | (37.8029155030083, -122.404365447615) |
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");