Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1636 | 1636 | 139812 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1624 EDDY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1997 12:00:00 AM | 32 | Width 0ft | 6002737.4248 | 2112708.2774 | 37.7812487388446 | -122.434168269296 | (37.7812487388446, -122.434168269296) | ||
| 1649 | 1649 | 251584 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2679 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1997 12:00:00 AM | 3x3 | 5997280.0 | 2088608.0 | 37.714764069005604 | -122.45130950851002 | (37.7147640690056, -122.45130950851) | |||
| 1678 | 1678 | 25510 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1845 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005220.005340001 | 2116049.4982 | 37.7905634882709 | -122.42581765535401 | (37.7905634882709, -122.425817655354) | |||
| 1685 | 1685 | 251478 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2x Virginia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/21/2004 12:00:00 AM | 3x3 | 6006146.0 | 2098692.0 | 37.7429562000135 | -122.42138058886101 | (37.7429562000135, -122.421380588861) | ||
| 1692 | 1692 | 2957 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2045 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004590.8896 | 2115694.3359 | 37.7895527302687 | -122.427969040021 | (37.7895527302687, -122.427969040021) | |||
| 1721 | 1721 | 23308 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1998 12:00:00 AM | 5 | 3X3 | 6006538.20918 | 2114040.94612 | 37.785122904641796 | -122.42111406077 | (37.7851229046418, -122.42111406077) | ||
| 1725 | 1725 | 24940 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2733 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1996 12:00:00 AM | 6 | 3X3 | 5998612.3168 | 2113129.3587 | 37.782169931054604 | -122.44846938258301 | (37.7821699310546, -122.448469382583) | ||
| 1747 | 1747 | 114639 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 2211 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2x2 | 6001584.0 | 2113871.0 | 37.784375747905706 | -122.43824186327299 | (37.7843757479057, -122.438241863273) | |||
| 1750 | 1750 | 114640 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 2211 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 2x2 | 6001584.0 | 2113871.0 | 37.784375747905706 | -122.43824186327299 | (37.7843757479057, -122.438241863273) | |||
| 1816 | 1816 | 20201 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1300X Steiner St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6002775.658 | 2112980.5073 | 37.7819983835402 | -122.43405546728 | (37.7819983835402, -122.43405546728) | ||
| 1824 | 1824 | 251724 | Permitted Site 1 | :: 54 | 1630 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2017 12:00:00 AM | 3 | 3x3 | 6006933.88533 | 2116748.92044 | 37.792580631742204 | -122.419937373279 | (37.7925806317422, -122.419937373279) | ||
| 1832 | 1832 | 24314 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006601.99404 | 2112547.97273 | 37.781027160014204 | -122.420787355977 | (37.7810271600142, -122.420787355977) | |||
| 1834 | 1834 | 13113 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1611 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6004587.0591 | 2119767.9005 | 37.8007374842012 | -122.428272736084 | (37.8007374842012, -122.428272736084) | |||
| 1846 | 1846 | 251738 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) | ||||
| 1899 | 1899 | 25838 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013225.308119999 | 2119220.74162 | 37.7997201038678 | -122.39834219506099 | (37.7997201038678, -122.398342195061) | ||
| 1900 | 1900 | 8769 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3416 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1992 12:00:00 AM | 3 | 3X3 | 5996444.0483 | 2112944.9189 | 37.78153929807 | -122.455957233363 | (37.78153929807, -122.455957233363) | ||
| 1909 | 1909 | 125218 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101 Washington St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 13 | Width 4ft | 6005090.35688 | 2116771.11072 | 37.7925375271472 | -122.42631763077499 | (37.7925375271472, -122.426317630775) | |||
| 1910 | 1910 | 18873 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2299 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003870.98343 | 2115955.49438 | 37.790229051088 | -122.430478480014 | (37.790229051088, -122.430478480014) | |||
| 1925 | 1925 | 2958 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2055 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004523.0139999995 | 2115687.6045 | 37.7895304073237 | -122.428203402517 | (37.7895304073237, -122.428203402517) | |||
| 1951 | 1951 | 9609 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1386 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002986.18 | 2112056.6484 | 37.779473644014104 | -122.433261123937 | (37.7794736440141, -122.433261123937) | |||
| 1960 | 1960 | 18692 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 Richardson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999079.26803 | 2119858.05546 | 37.800671840202796 | -122.447338395052 | (37.8006718402028, -122.447338395052) | |||
| 1965 | 1965 | 123761 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 201 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994919.422180001 | 2110746.11008 | 37.7754143312074 | -122.461072248502 | (37.7754143312074, -122.461072248502) | |||
| 1980 | 1980 | 11144 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2553X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006934.8566 | 2121129.59308 | 37.8046089111446 | -122.42024506476801 | (37.8046089111446, -122.420245064768) | |||
| 1987 | 1987 | 123759 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 201 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2016 12:00:00 AM | 18 | Width 5ft | 5994972.5884300005 | 2110752.02511 | 37.775433631632296 | -122.46088876401501 | (37.7754336316323, -122.460888764015) | ||
| 1989 | 1989 | 133618 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 150 Richardson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5999272.2292 | 2119684.41545 | 37.8002060956892 | -122.446658172159 | (37.8002060956892, -122.446658172159) | |||
| 1991 | 1991 | 123758 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 201 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5994989.32477 | 2110751.87532 | 37.7754341833406 | -122.46083085861 | (37.7754341833406, -122.46083085861) | |||
| 2001 | 2001 | 141165 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1901 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 1 | Width 0ft | 6002136.302999999 | 2113271.8343 | 37.7827619879541 | -122.436288194942 | (37.7827619879541, -122.436288194942) | ||
| 2005 | 2005 | 7164 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 733 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003503.3323 | 2110918.6468 | 37.7763782981407 | -122.43139081647399 | (37.7763782981407, -122.431390816474) | |||
| 2016 | 2016 | 13112 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1601 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6004666.807 | 2119779.6281 | 37.800774197193796 | -122.42799761136001 | (37.8007741971938, -122.42799761136) | |||
| 2021 | 2021 | 7975 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2003 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005570.14471 | 2116971.5183099997 | 37.793114904479296 | -122.42467181028 | (37.7931149044793, -122.42467181028) | |||
| 2024 | 2024 | 139198 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | Width 0ft | 6001803.3539 | 2113704.6103 | 37.783931357581395 | -122.437471057097 | (37.7839313575814, -122.437471057097) | |||
| 2027 | 2027 | 25628 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014034.02503 | 2117986.25531 | 37.796375512586 | -122.39545718430401 | (37.796375512586, -122.395457184304) | ||
| 2033 | 2033 | 139199 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 19 | Width 0ft | 6001773.0984 | 2113703.8723 | 37.7839276110688 | -122.437575676931 | (37.7839276110688, -122.437575676931) | |||
| 2038 | 2038 | 23713 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 709 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4X4 | 6003942.7402 | 2111225.1787 | 37.7772448524761 | -122.429892651683 | (37.7772448524761, -122.429892651683) | |||
| 2062 | 2062 | 8436 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1730 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/1997 12:00:00 AM | 11 | 3X3 | 6003412.8094 | 2113950.8814 | 37.784698926436796 | -122.431920527552 | (37.7846989264368, -122.431920527552) | ||
| 2073 | 2073 | 252864 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1660 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000023.0 | 2106990.0 | 37.7653933634599 | -122.443148003218 | (37.7653933634599, -122.443148003218) | ||||
| 2078 | 2078 | 12419 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1691 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 3 | 4X4 | 6004453.7544 | 2114557.5752 | 37.786423711867705 | -122.42836245915599 | (37.7864237118677, -122.428362459156) | ||
| 2088 | 2088 | 3013 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2450 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002627.84431 | 2115492.11411 | 37.7888862283618 | -122.43474649336599 | (37.7888862283618, -122.434746493366) | |||
| 2090 | 2090 | 25842 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013279.137069999 | 2119139.97441 | 37.799501334781795 | -122.398150256355 | (37.7995013347818, -122.398150256355) | ||
| 2113 | 2113 | 2684 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2100 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6003399.8502 | 2114890.5748 | 37.787278352566105 | -122.432032487909 | (37.7872783525661, -122.432032487909) | |||
| 2116 | 2116 | 11044 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1550 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | 6007464.945230001 | 2117711.8455 | 37.795254489665 | -122.418168182118 | (37.795254489665, -122.418168182118) | |||
| 2127 | 2127 | 252902 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2375 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3x3 | 5992177.0 | 2094185.0 | 37.7297836282973 | -122.469353126495 | (37.7297836282973, -122.469353126495) | |||
| 2132 | 2132 | 13212 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2190 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6001925.0681 | 2119471.9545 | 37.7997739121356 | -122.437463108341 | (37.7997739121356, -122.437463108341) | |||
| 2136 | 2136 | 24780 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 5982810.69991 | 2112498.67348 | 37.779522119266204 | -122.503088254558 | (37.7795221192662, -122.503088254558) | |||
| 2161 | 2161 | 127894 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6010099.45524 | 2119176.61212 | 37.7994243150494 | -122.40915572694999 | (37.7994243150494, -122.40915572695) | |||
| 2167 | 2167 | 3158 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3410 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998012.98689 | 2114846.6357400003 | 37.7868508368504 | -122.45066663485201 | (37.7868508368504, -122.450666634852) | |||
| 2178 | 2178 | 18161 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005286.1585 | 2114461.6714 | 37.7862074506483 | -122.425475720608 | (37.7862074506483, -122.425475720608) | |||
| 2194 | 2194 | 23455 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2240 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6005973.83981 | 2118127.35599 | 37.796311335142995 | -122.423357203778 | (37.796311335143, -122.423357203778) | |||
| 2197 | 2197 | 24571 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2252 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1996 12:00:00 AM | 5 | 3X3 | 6002831.271980001 | 2116073.36845 | 37.7904937512412 | -122.434084229923 | (37.7904937512412, -122.434084229923) | ||
| 2202 | 2202 | 139878 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 870 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6005025.9501 | 2111995.4887 | 37.779421217898204 | -122.426200333481 | (37.7794212178982, -122.426200333481) | |||
| 2205 | 2205 | 123677 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4308 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994223.96504 | 2114319.57116 | 37.7851860492976 | -122.46373740171002 | (37.7851860492976, -122.46373740171) | |||
| 2241 | 2241 | 193105 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1649 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 10/28/1996 12:00:00 AM | 10 | Width 5ft | 6014582.89152 | 2095437.7386599998 | 37.734492738953 | -122.39198038730301 | (37.734492738953, -122.391980387303) | ||
| 2250 | 2250 | 200335 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 7 | : 4 | Tree 1 | Purchasing Dept 15 | 4 | Width 2ft | 6015505.4551 | 2098329.2709 | 37.7424834725483 | -122.388992567847 | (37.7424834725483, -122.388992567847) | |||
| 2256 | 2256 | 200334 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 4 | : 4 | Tree 1 | Purchasing Dept 15 | 11/15/1992 12:00:00 AM | 8 | Width 3ft | 6015528.91481 | 2098358.82009 | 37.742565908900204 | -122.388913512973 | (37.7425659089002, -122.388913512973) | ||
| 2266 | 2266 | 253000 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2267 | 2267 | 27407 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2172 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5997059.3832 | 2109492.2362 | 37.772094431296104 | -122.453579103335 | (37.7720944312961, -122.453579103335) | ||
| 2270 | 2270 | 253008 | Permitted Site 1 | :: 54 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 11x477 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | ||
| 2272 | 2272 | 253002 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2273 | 2273 | 252995 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2274 | 2274 | 253006 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 1201 Tennessee St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2275 | 2275 | 253003 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2276 | 2276 | 252994 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2278 | 2278 | 252992 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2279 | 2279 | 9454 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005489.5152 | 2112411.3558 | 37.7805892777689 | -122.424626255587 | (37.7805892777689, -122.424626255587) | ||
| 2281 | 2281 | 252998 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2283 | 2283 | 7972 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1950 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005640.29534 | 2116816.4309400003 | 37.7926930351995 | -122.424418048575 | (37.7926930351995, -122.424418048575) | |||
| 2288 | 2288 | 252996 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2289 | 2289 | 252993 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2290 | 2290 | 252997 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2293 | 2293 | 253004 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 1201 Tennessee St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2294 | 2294 | 252999 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2295 | 2295 | 253005 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 1201 Tennessee St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2296 | 2296 | 253001 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2301 | 2301 | 22734 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1560 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1990 12:00:00 AM | 18 | 3X3 | 6002510.1745 | 2112337.5363 | 37.780217876703794 | -122.434927920426 | (37.7802178767038, -122.434927920426) | ||
| 2320 | 2320 | 1739 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 6010211.1306 | 2121614.8438 | 37.8061253525476 | -122.408941413862 | (37.8061253525476, -122.408941413862) | |||
| 2322 | 2322 | 103821 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1032 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006936.4893 | 2114526.0013 | 37.786477191411294 | -122.419770562808 | (37.7864771914113, -122.419770562808) | ||
| 2346 | 2346 | 14522 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 616 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5999189.6891 | 2110673.8503 | 37.7754607324086 | -122.446295246866 | (37.7754607324086, -122.446295246866) | |||
| 2354 | 2354 | 18870 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2269 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003913.0 | 2115924.0 | 37.790144955549394 | -122.430330857904 | (37.7901449555494, -122.430330857904) | |||
| 2361 | 2361 | 12987 | Permitted Site 1 | Tristania conferta :: 79 | 318 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 3X3 | 6010766.7048 | 2120702.1725 | 37.8036504876245 | -122.406954379692 | (37.8036504876245, -122.406954379692) | ||
| 2369 | 2369 | 201815 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021129.2467 | 2093308.19399 | 37.7290066829092 | -122.369200102111 | (37.7290066829092, -122.369200102111) | ||
| 2379 | 2379 | 17840 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2017 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004165.4355 | 2115291.4590000003 | 37.7884224532463 | -122.429412324105 | (37.7884224532463, -122.429412324105) | |||
| 2388 | 2388 | 12913 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Asian Arts Commission 16 | 50 | 3X3 | 6007759.03449 | 2112296.07509 | 37.7804006563122 | -122.416766716427 | (37.7804006563122, -122.416766716427) | |||
| 2391 | 2391 | 201814 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021112.10587 | 2093285.4865 | 37.728943392223 | -122.36925779181699 | (37.728943392223, -122.369257791817) | ||
| 2392 | 2392 | 253051 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2397 | 2397 | 253052 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2401 | 2401 | 140740 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2057X O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6001431.032000001 | 2113174.7073 | 37.7824552046492 | -122.438721167537 | (37.7824552046492, -122.438721167537) | |||
| 2405 | 2405 | 201816 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021143.08428 | 2093327.21502 | 37.729059670062206 | -122.36915357747299 | (37.7290596700622, -122.369153577473) | ||
| 2407 | 2407 | 9490 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 871 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2002 12:00:00 AM | 3 | 3X3 | 6005401.3681 | 2112340.2476 | 37.7803890535333 | -122.42492613811301 | (37.7803890535333, -122.424926138113) | ||
| 2413 | 2413 | 253048 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2414 | 2414 | 253049 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2425 | 2425 | 7814 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 700X Franklin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2015 12:00:00 AM | 4 | 4X4 | 6006210.87703 | 2112746.5205200003 | 37.7815502713788 | -122.422154535912 | (37.7815502713788, -122.422154535912) | ||
| 2427 | 2427 | 23895 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1581 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6003532.7108 | 2114115.4269999997 | 37.7851575236987 | -122.431517459739 | (37.7851575236987, -122.431517459739) | ||
| 2448 | 2448 | 253050 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2451 | 2451 | 2187 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1040 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6000917.5615 | 2112301.3252 | 37.7800278959817 | -122.440434888409 | (37.7800278959817, -122.440434888409) | |||
| 2464 | 2464 | 253053 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2466 | 2466 | 201813 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021086.18405 | 2093254.37787 | 37.728856551886395 | -122.369345258092 | (37.7288565518864, -122.369345258092) | ||
| 2471 | 2471 | 7042 | Permitted Site 1 | Tristania conferta :: 79 | 1300 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2009 12:00:00 AM | 3 | 3X3 | 6001153.5455 | 2110065.6201 | 37.7739026486508 | -122.43945820683099 | (37.7739026486508, -122.439458206831) | ||
| 2503 | 2503 | 253120 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 815 Buena Vista Ave West | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x100 | 6000071.60031 | 2108311.04493 | 37.769023393565604 | -122.44307478834801 | (37.7690233935656, -122.443074788348) | ||||
| 2515 | 2515 | 124752 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2478 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | 9 | Width 5ft | 6002956.6534 | 2115870.86114 | 37.7899448329366 | -122.433635939447 | (37.7899448329366, -122.433635939447) | ||
| 2543 | 2543 | 141333 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1205 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1992 12:00:00 AM | 14 | Width 0ft | 6002078.0816 | 2110492.0692 | 37.7751261444639 | -122.43629061453998 | (37.7751261444639, -122.43629061454) |
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");