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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 113 | 113 | 183695 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1341 42nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983048.7244 | 2105854.1384 | 37.7612921278024 | -122.50177309900499 | (37.7612921278024, -122.501773099005) | |||
| 201 | 201 | 138367 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 0ft | 6002691.6152 | 2114444.3582 | 37.7860129777854 | -122.434450912019 | (37.7860129777854, -122.434450912019) | |||
| 287 | 287 | 173824 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
| 402 | 402 | 251283 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 06/06/1997 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 507 | 507 | 251288 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1335 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/18/2017 01:58:00 PM | 3 | 3x3 | 6016828.0 | 2097292.0 | 37.7397085577181 | -122.38434732981199 | (37.7397085577181, -122.384347329812) | |
| 666 | 666 | 237028 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Octavia St | 9 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:55:00 PM | 3 | Width 6ft | 6005756.39315 | 2109517.28856 | 37.7726579404383 | -122.423497186858 | (37.7726579404383, -122.423497186858) | ||
| 718 | 718 | 99173 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003311.25259 | 2116120.54401 | 37.790650512059 | -122.432426898975 | (37.790650512059, -122.432426898975) | ||
| 737 | 737 | 221436 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:05:00 AM | 1 | Width 3ft | 6005440.21619 | 2108132.10005 | 37.768836694985396 | -122.424492330751 | (37.7688366949854, -122.424492330751) | ||
| 807 | 807 | 208295 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 720 Bosworth St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/1994 12:00:00 AM | 7 | Width 3ft | 6001977.00756 | 2095485.3679900002 | 37.7339155990291 | -122.435566443955 | (37.7339155990291, -122.435566443955) | ||
| 821 | 821 | 251392 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Bosworth St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Width 3ft | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 834 | 834 | 140247 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Ashbury St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998760.3863 | 2110325.7376 | 37.77448037673879 | -122.447755234881 | (37.7744803767388, -122.447755234881) | |||
| 835 | 835 | 175376 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 80X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 2 | Width 3ft | 5991381.99613 | 2088828.6732599998 | 37.715030504233 | -122.471711326531 | (37.715030504233, -122.471711326531) | ||
| 927 | 927 | 140951 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 942 | 942 | 139350 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400 GEARY BLVD | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6004774.9676 | 2114125.1051 | 37.785254427644404 | -122.427220325156 | (37.7852544276444, -122.427220325156) | |||
| 1086 | 1086 | 48227 | Permitted Site 1 | Tree(s) :: 17 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1106 | 1106 | 251445 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Beale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6014884.877230001 | 2114997.01321 | 37.7882150346369 | -122.39230385636002 | (37.7882150346369, -122.39230385636) | ||||
| 1119 | 1119 | 38280 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 651 Texas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 12 | Permit Number 40367 | 6013876.1493 | 2104054.9950099997 | 37.758114643000795 | -122.395027213942 | (37.7581146430008, -122.395027213942) | ||
| 1202 | 1202 | 119754 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1206 | 1206 | 119801 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1211 | 1211 | 119836 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1257 | 1257 | 197452 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 668 Natoma St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6009185.76341 | 2111038.87777 | 37.7770288335587 | -122.41174211691799 | (37.7770288335587, -122.411742116918) | |||
| 1364 | 1364 | 251507 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1371 | 1371 | 251505 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011658.68026 | 2112523.0235200003 | 37.781242368680296 | -122.403291911611 | (37.7812423686803, -122.403291911611) | ||||
| 1387 | 1387 | 250572 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/15/2017 12:00:00 AM | 3 | Permit Number 779711 | 5997267.39343 | 2111112.94332 | 37.7765563945078 | -122.45297659119 | (37.7765563945078, -122.45297659119) | ||
| 1484 | 1484 | 233542 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 660 Clipper St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779879 | 6001023.66433 | 2100904.7757200003 | 37.748741823193 | -122.439250743354 | (37.748741823193, -122.439250743354) | |
| 1548 | 1548 | 8472 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1900 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6002074.2026 | 2113678.2789 | 37.7838744530021 | -122.436532136471 | (37.7838744530021, -122.436532136471) | |||
| 1596 | 1596 | 14066 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1390 Market St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007645.4688 | 2111067.7331 | 37.7770215357502 | -122.41707253353701 | (37.7770215357502, -122.417072533537) | |||
| 1789 | 1789 | 251698 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 700 Jamestown Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6015296.9798 | 2088405.4002 | 37.71522295028 | -122.389020693471 | (37.71522295028, -122.389020693471) | ||||
| 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) | ||
| 1933 | 1933 | 252830 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 2028 | 2028 | 137540 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1510 Steiner St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002670.5536 | 2113409.7602 | 37.7831710382055 | -122.434449780345 | (37.7831710382055, -122.434449780345) | |||
| 2128 | 2128 | 114975 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 Point Lobos Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 5982783.76519 | 2112486.06679 | 37.7794859217892 | -122.50318049806101 | (37.7794859217892, -122.503180498061) | |||
| 2150 | 2150 | 196171 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 150 Loomis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Width 4ft | 6010696.4368900005 | 2097532.57901 | 37.7400281875625 | -122.405564708871 | (37.7400281875625, -122.405564708871) | ||
| 2233 | 2233 | 122749 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 6011285.506709999 | 2105214.92948 | 37.761155164510605 | -122.404068449214 | (37.7611551645106, -122.404068449214) | |||
| 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) | |||
| 2352 | 2352 | 195026 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6013748.5801800005 | 2113848.78027 | 37.7849990913834 | -122.39615477762301 | (37.7849990913834, -122.396154777623) | |||
| 2360 | 2360 | 122439 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x4 | Permit Number 778941 | 6013610.4957 | 2114107.2315 | 37.7857010547146 | -122.39665063354099 | (37.7857010547146, -122.396650633541) | ||
| 2511 | 2511 | 246852 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 300 Broderick St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6001238.428669999 | 2109976.67902 | 37.7736632691848 | -122.43915820668998 | (37.7736632691848, -122.43915820669) | |||
| 2532 | 2532 | 246847 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 9 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001212.96216 | 2109784.10249 | 37.773133053181404 | -122.43923249339198 | (37.7731330531814, -122.439232493392) | |||
| 2540 | 2540 | 141909 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 900 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004576.1236 | 2111931.0419 | 37.779218827498205 | -122.427751880486 | (37.7792188274982, -122.427751880486) | |||
| 2654 | 2654 | 37821 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 450X Moscow St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003927.902969999 | 2090495.79555 | 37.720325957053596 | -122.428466081444 | (37.7203259570536, -122.428466081444) |
| 2724 | 2724 | 141999 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 WEBSTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003970.657000001 | 2111746.2039 | 37.778677039760794 | -122.429833251248 | (37.7786770397608, -122.429833251248) | |||
| 2737 | 2737 | 253186 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
| 3141 | 3141 | 253311 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3168 | 3168 | 33093 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 3196 | 3196 | 9420 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6005985.41292 | 2112474.4888400002 | 37.780790619431706 | -122.422915195091 | (37.7807906194317, -122.422915195091) | |||
| 3348 | 3348 | 140430 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1499 TURK ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 05/18/1992 12:00:00 AM | 5 | Width 0ft | 6003115.3712 | 2112373.8844 | 37.7803520228236 | -122.432836866316 | (37.7803520228236, -122.432836866316) | ||
| 3483 | 3483 | 9453 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005504.6787 | 2112415.6882 | 37.7806020298362 | -122.42457410603201 | (37.7806020298362, -122.424574106032) | ||
| 3533 | 3533 | 253491 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3699 | 3699 | 253406 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3780 | 3780 | 228286 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036X 15th St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | |||
| 3884 | 3884 | 20320 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 3899 | 3899 | 253541 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1000 Cayuga Ave | 9 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/03/2017 03:59:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3930 | 3930 | 160066 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Cayuga Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:19:00 AM | 3 | Width 0ft | 6000393.82803 | 2090707.46812 | 37.7207065384449 | -122.44069736308501 | (37.7207065384449, -122.440697363085) | ||
| 3989 | 3989 | 22582 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006498.64773 | 2112839.17836 | 37.7818209142342 | -122.421165566743 | (37.7818209142342, -122.421165566743) | |||
| 4215 | 4215 | 118354 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100X Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:05:00 AM | 3 | ||||||||
| 4331 | 4331 | 87404 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 6003683.0746 | 2113412.9921 | 37.783237334948105 | -122.43094709822701 | (37.7832373349481, -122.430947098227) | ||
| 4334 | 4334 | 221464 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 300x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/19/2015 10:25:00 AM | 2 | Width 3ft | 6005509.872909999 | 2106837.4843200003 | 37.7652859224425 | -122.42415931 | (37.7652859224425, -122.42415931) | ||
| 4336 | 4336 | 221476 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 400x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/29/2015 09:37:00 AM | 1 | Width 3ft | 6005539.0927099995 | 2106307.4884599997 | 37.7638323293302 | -122.42402055271799 | (37.7638323293302, -122.424020552718) | ||
| 4348 | 4348 | 221447 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 200x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/09/2016 12:33:00 PM | 1 | Width 3ft | 6005477.00515 | 2107432.0079200002 | 37.7669164868187 | -122.424315280345 | (37.7669164868187, -122.424315280345) | ||
| 4463 | 4463 | 14823 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1234 McAllister St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2001 12:00:00 AM | 3 | 4X4 | 6003134.879 | 2111723.2201 | 37.778566567554 | -122.432722886511 | (37.778566567554, -122.432722886511) | ||
| 4481 | 4481 | 221502 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 600x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/21/2015 11:07:00 PM | 2 | Width 3ft | 6005607.7078 | 2105081.85863 | 37.760470912626296 | -122.42369608451 | (37.7604709126263, -122.42369608451) | ||
| 4483 | 4483 | 253079 | DPW Maintained 3 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 2849X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 11:57:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 4516 | 4516 | 28647 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003547.8453 | 2114380.4001 | 37.785885930849204 | -122.431484021877 | (37.7858859308492, -122.431484021877) | |||
| 4554 | 4554 | 18291 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2000 Post St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 6 | 4X4 | 6002309.6948 | 2114045.1862 | 37.7848952663203 | -122.435743681544 | (37.7848952663203, -122.435743681544) | ||
| 4570 | 4570 | 142547 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301 FRANCISCO ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 20 | Width 0ft | 6009612.5597 | 2121193.6724 | 37.804935373675605 | -122.41098310943799 | (37.8049353736756, -122.410983109438) | |||
| 4614 | 4614 | 129652 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009798.02273 | 2121850.3999900003 | 37.80674898193529 | -122.41038769114401 | (37.8067489819353, -122.410387691144) | |||
| 4816 | 4816 | 188474 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6007923.258880001 | 2109012.80714 | 37.7713948192467 | -122.41596601311599 | (37.7713948192467, -122.415966013116) | |||
| 4932 | 4932 | 253743 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4943 | 4943 | 25845 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013327.75405 | 2119068.43707 | 37.799307618121 | -122.397977001961 | (37.799307618121, -122.397977001961) | ||
| 4949 | 4949 | 83043 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:49:00 PM | 3 | 6018760.2720099995 | 2097656.0724299997 | 37.7408148829885 | -122.377691543139 | (37.7408148829885, -122.377691543139) | |||
| 5001 | 5001 | 17864 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2121 Pine St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003749.9172 | 2115228.4651 | 37.78822595410529 | -122.430845453567 | (37.7882259541053, -122.430845453567) | |||
| 5025 | 5025 | 9541 | Permitted Site 1 | Tree(s) :: 17 | 1100X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 3 | 3X3 | Permit Number 771276 | 6003998.856000001 | 2112198.1457 | 37.7799195567604 | -122.429767943463 | (37.7799195567604, -122.429767943463) | |
| 5029 | 5029 | 251680 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5060 | 5060 | 197214 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017373.601009999 | 2098611.9970400003 | 37.743363156981104 | -122.382552677381 | (37.7433631569811, -122.382552677381) | |||
| 5069 | 5069 | 3704 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 401X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 11:42:00 AM | 3 | 3X3 | 6016525.97731 | 2099264.3298 | 37.7451074685343 | -122.38552902236401 | (37.7451074685343, -122.385529022364) | ||
| 5118 | 5118 | 152420 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 700x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 3ft | 6005641.8915099995 | 2104501.69931 | 37.7588798608311 | -122.42353661133998 | (37.7588798608311, -122.42353661134) | |||
| 5184 | 5184 | 188751 | Undocumented 2 | Tree(s) :: 17 | 150 Executive Park Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780488 | 6014156.58166 | 2086969.04913 | 37.7112157302901 | -122.39286200619301 | (37.7112157302901, -122.392862006193) | |
| 5213 | 5213 | 180235 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3353 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990554.425319999 | 2094179.3629700001 | 37.7296742505655 | -122.47496207986099 | (37.7296742505655, -122.474962079861) | |||
| 5287 | 5287 | 2823 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6008783.893069999 | 2116347.56178 | 37.7915826512753 | -122.41350786111401 | (37.7915826512753, -122.413507861114) | |||
| 5321 | 5321 | 36650 | Permitted Site 1 | Tree(s) :: 17 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 5344 | 5344 | 5307 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6001124.6062 | 2113907.9724 | 37.7844511257674 | -122.43983385427099 | (37.7844511257674, -122.439833854271) | |||
| 5464 | 5464 | 18230 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1737-1795 Post St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2004 12:00:00 AM | 3 | 3X3 | 6003859.0712 | 2114201.8624 | 37.7854133456405 | -122.430394523724 | (37.7854133456405, -122.430394523724) | ||
| 5555 | 5555 | 8527 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002529.8149 | 2113677.2092 | 37.7838973955703 | -122.434955812258 | (37.7838973955703, -122.434955812258) | |||
| 5580 | 5580 | 19952 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY39 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 5776 | 5776 | 18968 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2900X Sacramento St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X5 | 6000810.83314 | 2115575.0283 | 37.789010565033294 | -122.44103903711901 | (37.7890105650333, -122.441039037119) | |||
| 5788 | 5788 | 19610 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 5882 | 5882 | 109553 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006853.14044 | 2111821.07903 | 37.7790454382325 | -122.41986691873801 | (37.7790454382325, -122.419866918738) | |||
| 5905 | 5905 | 19989 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY46 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40 | ||||||||
| 5949 | 5949 | 19787 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 100 STAIRWAY19 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 50ST | ||||||||
| 5959 | 5959 | 23753 | DPW Maintained 3 | Tristania conferta :: 79 | 900X Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1992 12:00:00 AM | 25 | 4x4 | 6003923.4316 | 2112087.5817 | 37.7796117041387 | -122.43002098071501 | (37.7796117041387, -122.430020980715) | ||
| 6143 | 6143 | 35050 | Permitted Site 1 | Tree(s) :: 17 | 700 Peninsula Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1998 12:00:00 AM | Permit Number 38613 | ||||||||
| 6165 | 6165 | 14421 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 3X3 | 5998843.9665 | 2113055.4136 | 37.7819801389805 | -122.44766265742399 | (37.7819801389805, -122.447662657424) | |||
| 6168 | 6168 | 14501 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 401X Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/04/1999 12:00:00 AM | 6 | 8 | 5999062.4864 | 2111159.5057 | 37.776786951926105 | -122.446770221959 | (37.7767869519261, -122.446770221959) | ||
| 6406 | 6406 | 19586 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 100 STAIRWAY4 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
| 6510 | 6510 | 8398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1500 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6003997.2859 | 2113948.4347 | 37.784725324941604 | -122.429898258777 | (37.7847253249416, -122.429898258777) | |||
| 6511 | 6511 | 19865 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY30 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 100ST | ||||||||
| 6543 | 6543 | 137954 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1615 SUTTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004801.2336 | 2114685.8103 | 37.7867954695312 | -122.427169405594 | (37.7867954695312, -122.427169405594) | ||||
| 6592 | 6592 | 98837 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1101X Portola Dr | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 6782 | 6782 | 42639 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1651 Union St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/2014 12:00:00 AM | 8 | 3x3 | Permit Number 42688 | 6005258.416780001 | 2118846.41372 | 37.798245281357204 | -122.425883928195 | (37.7982452813572, -122.425883928195) |
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");