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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52 | 52 | 233897 | Undocumented 2 | Araucaria heterophylla :: Norfolk Island Pine 24 | 1021 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003182.0050800005 | 2102290.73647 | 37.75266992967379 | -122.43188616810801 | (37.7526699296738, -122.431886168108) | |||
| 83 | 83 | 130626 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3660 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | Permit Number 779583 | 5996802.12344 | 2115996.768 | 37.789939408212206 | -122.454939052208 | (37.7899394082122, -122.454939052208) | ||
| 354 | 354 | 93479 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 113X Leroy Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 1.5x3 | Tree 4 on Leroy | 6008317.250990001 | 2116630.80353 | 37.792334150853 | -122.415142500331 | (37.792334150853, -122.415142500331) | ||
| 407 | 407 | 248462 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | Permit Number 779787 | 5997458.097999999 | 2107812.3026 | 37.767504613553 | -122.45207869525 | (37.767504613553, -122.45207869525) | ||
| 428 | 428 | 14314 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4X4 | 6003589.1349 | 2107204.4091 | 37.766184772649495 | -122.430828874247 | (37.7661847726495, -122.430828874247) | |||
| 447 | 447 | 27524 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3201 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 5999021.2149 | 2114925.4479 | 37.787124893549795 | -122.447184087894 | (37.7871248935498, -122.447184087894) | |||
| 557 | 557 | 194124 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 3 | Sidewalk: Curb side : Hanging Pot 15 | Tree 1 | Private 1 | 9 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 572 | 572 | 194125 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 601 | 601 | 225172 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 248 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2002 12:00:00 AM | 9 | Width 3ft | Permit Number 46150 | 6006535.621280001 | 2098220.1400900004 | 37.7416825381227 | -122.419999905071 | (37.7416825381227, -122.419999905071) | |
| 715 | 715 | 246970 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 2 | : 4 | Tree 1 | DPW 2 | 9 | Width 4ft | 6002947.4073 | 2106634.57369 | 37.764583763244794 | -122.43300776749099 | (37.7645837632448, -122.433007767491) | |||
| 719 | 719 | 246969 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 1 | : 4 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 9 | Width 4ft | Permit Number 778955 | 6002937.11929 | 2106633.84457 | 37.7645811776972 | -122.433043298823 | (37.7645811776972, -122.433043298823) | |
| 756 | 756 | 231006 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 660 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 9 | Width 3ft | Permit Number 46247 | 6008972.79201 | 2105110.692 | 37.760739462776606 | -122.41205980151199 | (37.7607394627766, -122.412059801512) | |
| 765 | 765 | 231003 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 660 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 9 | Width 3ft | Permit Number 46247 | 6008977.98805 | 2105043.06556 | 37.760554067537704 | -122.412037051387 | (37.7605540675377, -122.412037051387) | |
| 981 | 981 | 191653 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 149 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6012146.38303 | 2114300.35662 | 37.786149737060796 | -122.40172965521799 | (37.7861497370608, -122.401729655218) | |||
| 998 | 998 | 106624 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 156 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x6 | Permit Number 778450 | 5996579.9247 | 2113340.3647 | 37.78263288517989 | -122.455515759177 | (37.7826328851799, -122.455515759177) | ||
| 1017 | 1017 | 6253 | Permitted Site 1 | Tristania conferta :: 79 | 1315 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2004 12:00:00 AM | 9 | 3X3 | 6004522.7205 | 2113262.2432 | 37.782870955582794 | -122.428031512738 | (37.7828709555828, -122.428031512738) | ||
| 1075 | 1075 | 245468 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3290 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2004 12:00:00 AM | 9 | Width 0ft | 6006293.2609 | 2099139.2598 | 37.7441925761806 | -122.420903147917 | (37.7441925761806, -122.420903147917) | ||
| 1087 | 1087 | 236728 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1616 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002564.10416 | 2100703.66645 | 37.7482771632622 | -122.433909544687 | (37.7482771632622, -122.433909544687) | |||
| 1382 | 1382 | 43084 | Permitted Site 1 | Grevillea robusta :: Silk Oak Tree 145 | 240 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 9 | Permit Number 42924 | 6009033.5618199995 | 2113426.61378 | 37.783576449329296 | -122.412437449347 | (37.7835764493293, -122.412437449347) | |
| 1706 | 1706 | 192430 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 340 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | DPW for City Agency 2 | 9 | Width 3ft | 6011111.5516 | 2111334.7393 | 37.7779490450386 | -122.405101020214 | (37.7779490450386, -122.405101020214) | ||
| 1762 | 1762 | 200860 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1131 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | Width 0ft | 6008794.0112 | 2112059.0249 | 37.779807931141 | -122.413169468366 | (37.779807931141, -122.413169468366) | |||
| 1829 | 1829 | 9893 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1700 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6005337.6793 | 2115599.8801599997 | 37.7893355988943 | -122.425378500212 | (37.7893355988943, -122.425378500212) | |||
| 2101 | 2101 | 143399 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1150 MARKET ST | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | Width 0ft | 6008612.8747 | 2111976.4646 | 37.779571069624 | -122.413790259796 | (37.779571069624, -122.413790259796) | |||
| 2231 | 2231 | 122750 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 6011285.1392 | 2105241.4016400003 | 37.761227830607204 | -122.40407158333299 | (37.7612278306072, -122.404071583333) | |||
| 2253 | 2253 | 185120 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2865 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x9 | 5985842.0 | 2096048.0 | 37.734530809359605 | -122.491390692258 | (37.7345308093596, -122.491390692258) | |||
| 2324 | 2324 | 195018 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | Permit Number 778941 | 6013610.320719999 | 2113989.12597 | 37.7853767544813 | -122.39664295660499 | (37.7853767544813, -122.396642956605) | ||
| 2344 | 2344 | 122435 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x4 | Permit Number 778941 | 6013667.0494 | 2114164.8134 | 37.785862308640105 | -122.396459010111 | (37.7858623086401, -122.396459010111) | ||
| 2345 | 2345 | 138905 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 739 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004125.2186 | 2110775.3704 | 37.776020121780206 | -122.42922931872499 | (37.7760201217802, -122.429229318725) | |||
| 2485 | 2485 | 241979 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 501 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4.5x9 | 6007964.4907599995 | 2096517.14345 | 37.7370868837581 | -122.41493883176202 | (37.7370868837581, -122.414938831762) | |||
| 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) | ||
| 2519 | 2519 | 246843 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 5 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001198.912769999 | 2109877.26909 | 37.7733880658265 | -122.439287771129 | (37.7733880658265, -122.439287771129) | |||
| 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) | |||
| 2533 | 2533 | 246849 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Broderick St | 11 | : 4 | Tree 1 | DPW for City Agency 10 | 9 | Width 3ft | 6001216.8657599995 | 2109748.1446700003 | 37.7730345441487 | -122.439216412614 | (37.7730345441487, -122.439216412614) | |||
| 2584 | 2584 | 178485 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 277 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003684.78158 | 2092034.78148 | 37.724537911193295 | -122.429416163945 | (37.7245379111933, -122.429416163945) | |||
| 2684 | 2684 | 233816 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 41 Brady St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006595.43726 | 2109656.08938 | 37.7730863765667 | -122.420604692871 | (37.7730863765667, -122.420604692871) | |||
| 2710 | 2710 | 141992 | DPW Maintained 3 | Tristania conferta :: 79 | 818 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2005 12:00:00 AM | 9 | Width 0ft | 6003994.291 | 2111559.6951 | 37.778166271074205 | -122.429738185966 | (37.7781662710742, -122.429738185966) | ||
| 2718 | 2718 | 141991 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 818 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004002.4362 | 2111527.1662 | 37.7780774159831 | -122.429707688099 | (37.7780774159831, -122.429707688099) | |||
| 2818 | 2818 | 229986 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 599 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1984 12:00:00 AM | 9 | Width 2ft | Permit Number 21284 | 6003081.800919999 | 2095704.053 | 37.734578745606704 | -122.431762448377 | (37.7345787456067, -122.431762448377) | |
| 2909 | 2909 | 140144 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2077 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997892.6775 | 2109904.5645 | 37.7732743123753 | -122.450726418895 | (37.7732743123753, -122.450726418895) | |||
| 2923 | 2923 | 140143 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2077 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1981 12:00:00 AM | 9 | Width 0ft | Permit Number 19125 | 5997871.2148 | 2109901.8816 | 37.7732657172386 | -122.45080046745001 | (37.7732657172386, -122.45080046745) | |
| 2966 | 2966 | 137576 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1095 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | Width 0ft | 6002354.5808 | 2112241.3971 | 37.7799450671147 | -122.435459310364 | (37.7799450671147, -122.435459310364) | |||
| 2973 | 2973 | 248423 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997213.1093 | 2108080.0035 | 37.7682256152375 | -122.45294539950399 | (37.7682256152375, -122.452945399504) | |||
| 3058 | 3058 | 223293 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 101X Downey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998863.8718 | 2107567.85033 | 37.7669138338245 | -122.44719873483601 | (37.7669138338245, -122.447198734836) | |||
| 3188 | 3188 | 213685 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 428 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/2002 12:00:00 AM | 9 | Width 2ft | Permit Number 45997 | 6000116.1968 | 2095121.7561599999 | 37.7328113412593 | -122.44197372410801 | (37.7328113412593, -122.441973724108) | |
| 3231 | 3231 | 188482 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1580 Burke Ave | 3 | : 4 | Tree 1 | DPW 2 | 03/30/1990 12:00:00 AM | 9 | Width 4ft | 6016171.38717 | 2099220.37618 | 37.7449671554124 | -122.386752079638 | (37.7449671554124, -122.386752079638) | ||
| 3320 | 3320 | 56733 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1583 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Permit Number 780681 | 6015469.0433 | 2095825.5988 | 37.7356068823061 | -122.388943710821 | (37.7356068823061, -122.388943710821) | |||
| 3377 | 3377 | 194746 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 500 Hampshire St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010050.23596 | 2105797.64874 | 37.7626860840206 | -122.408381844163 | (37.7626860840206, -122.408381844163) | |||
| 3410 | 3410 | 55823 | Permitted Site 1 | Pittosporum eugenioides :: Tarata 110 | 107 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1973 12:00:00 AM | 9 | Permit Number 11871 | 5992391.10091 | 2114722.33212 | 37.7861861336889 | -122.470107824331 | (37.7861861336889, -122.470107824331) | ||
| 3449 | 3449 | 71297 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1943 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1987 12:00:00 AM | 9 | 3x3 | 6000711.2858 | 2112029.2136 | 37.7792689994665 | -122.441128958799 | (37.7792689994665, -122.441128958799) | ||
| 3472 | 3472 | 47233 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 260 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 9 | 3x3 | Permit Number 45176 | 6009527.90676 | 2093167.0180900001 | 37.7279758826708 | -122.40929702843701 | (37.7279758826708, -122.409297028437) |
| 3480 | 3480 | 23466 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2307 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6005840.38038 | 2118370.08378 | 37.796970271119 | -122.42383626993 | (37.796970271119, -122.42383626993) | |||
| 3513 | 3513 | 247938 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 29 Joy St | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | |||
| 3514 | 3514 | 21564 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1450 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4X4 | dead | 6005645.68769 | 2114853.19648 | 37.787302788433706 | -122.424259698627 | (37.7873027884337, -122.424259698627) | ||
| 3630 | 3630 | 246504 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 255 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 01/05/1989 12:00:00 AM | 9 | Width 3ft | Permit Number 25818 | 6004850.160540001 | 2099861.56096 | 37.7460944007479 | -122.425944484052 | (37.7460944007479, -122.425944484052) | |
| 3736 | 3736 | 223410 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 898 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1993 12:00:00 AM | 9 | Width 4ft | Permit Number 32344 | 6010171.02881 | 2104045.21453 | 37.7578810584907 | -122.407840483778 | (37.7578810584907, -122.407840483778) | |
| 3782 | 3782 | 182315 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 2724 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2001 12:00:00 AM | 9 | Width 0ft | Permit Number 43905 | 5986428.3511 | 2105069.3949 | 37.759335376640294 | -122.490026834722 | (37.7593353766403, -122.490026834722) | |
| 3784 | 3784 | 242020 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3154 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007751.06691 | 2106208.47613 | 37.7636851003982 | -122.41636297119 | (37.7636851003982, -122.41636297119) | |||
| 3793 | 3793 | 39226 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 770 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 9 | Permit Number 40869 | 5984798.64138 | 2110605.0729799997 | 37.774439483359 | -122.49607147975 | (37.774439483359, -122.49607147975) | ||
| 3874 | 3874 | 239439 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x9 | 6004683.2193 | 2097236.31541 | 37.7388766398495 | -122.426334864463 | (37.7388766398495, -122.426334864463) | |||
| 3885 | 3885 | 227809 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 930 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1979 12:00:00 AM | 9 | Width 3ft | Permit Number 17590 | 5999239.85444 | 2106888.20822 | 37.765069183133 | -122.445849391156 | (37.765069183133, -122.445849391156) | |
| 3947 | 3947 | 93478 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 113X Leroy Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 1.5x3 | Tree 3 on Leroy | 6008314.47624 | 2116646.88711 | 37.792378156480396 | -122.415153240053 | (37.7923781564804, -122.415153240053) | ||
| 4107 | 4107 | 98607 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6002988.210519999 | 2116859.68166 | 37.792661671341705 | -122.43359745208599 | (37.7926616713417, -122.433597452086) | ||
| 4173 | 4173 | 9876 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1505 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x4 | 6005371.567000001 | 2114888.4319 | 37.7873840540746 | -122.425210607423 | (37.7873840540746, -122.425210607423) | |||
| 4518 | 4518 | 225796 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008035.828509999 | 2103884.08468 | 37.7573188652869 | -122.415213517995 | (37.7573188652869, -122.415213517995) | |||
| 4571 | 4571 | 142549 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 9 | Width 0ft | 6009666.9453 | 2121202.0395 | 37.8049613971858 | -122.41079549257799 | (37.8049613971858, -122.410795492578) | |||
| 4580 | 4580 | 142832 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1553 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 9 | Width 0ft | 6006643.2439 | 2116275.8765 | 37.791265392276 | -122.420909404242 | (37.791265392276, -122.420909404242) | ||
| 4604 | 4604 | 142833 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1549 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 9 | Width 0ft | 6006645.4552 | 2116252.8795 | 37.7912023728705 | -122.42090011974501 | (37.7912023728705, -122.420900119745) | ||
| 4657 | 4657 | 24332 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1999 12:00:00 AM | 9 | 6006393.27479 | 2112527.98365 | 37.7809605085733 | -122.421508000714 | (37.7809605085733, -122.421508000714) | |||
| 4705 | 4705 | 226129 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 468 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2016 12:00:00 AM | 9 | Width 3ft | 6002897.69632 | 2099218.5981799997 | 37.7442184383445 | -122.432649927259 | (37.7442184383445, -122.432649927259) | ||
| 4729 | 4729 | 123750 | Undocumented 2 | Prunus laurocerasus :: English laurel 227 | 2 Cabrillo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5995617.0 | 2110854.0 | 37.775750686051005 | -122.458666990683 | (37.775750686051, -122.458666990683) | |||
| 4820 | 4820 | 244057 | Undocumented 2 | Olea Majestic Beauty :: 192 | 408 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998433.3367 | 2109162.2622 | 37.7712670737259 | -122.448802736045 | (37.7712670737259, -122.448802736045) | |||
| 4830 | 4830 | 244041 | Undocumented 2 | Olea Majestic Beauty :: 192 | 400 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998430.346 | 2109186.6154 | 37.7713337703654 | -122.44881483539 | (37.7713337703654, -122.44881483539) | |||
| 4868 | 4868 | 225613 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 235 Laussat St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003605.0 | 2109124.0 | 37.77145640087421 | -122.430911009882 | (37.7714564008742, -122.430911009882) | |||
| 4918 | 4918 | 43245 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 150 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 9 | Permit Number 43034 | 6010460.0 | 2093774.0 | 37.729694705520004 | -122.40611748494 | (37.72969470552, -122.40611748494) | |
| 5233 | 5233 | 178380 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 3353 19th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990552.58641 | 2094153.60433 | 37.729603417265295 | -122.47496655757601 | (37.7296034172653, -122.474966557576) | |||
| 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) | |||
| 5584 | 5584 | 2623 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1810 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1997 12:00:00 AM | 9 | 3X3 | 6004694.7357 | 2115072.9947 | 37.787852557835706 | -122.42756545836599 | (37.7878525578357, -122.427565458366) | ||
| 5608 | 5608 | 106622 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 156 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x6 | Permit Number 778450 | 5996579.2478 | 2113322.09 | 37.78258266885771 | -122.455516779687 | (37.7825826688577, -122.455516779687) | ||
| 5710 | 5710 | 9929 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2221 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1990 12:00:00 AM | 9 | 3X3 | 6005046.52749 | 2117287.74508 | 37.79395359692471 | -122.426506085481 | (37.7939535969247, -122.426506085481) | ||
| 6641 | 6641 | 5949 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1445 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1990 12:00:00 AM | 9 | 3x3 | 6003539.6454 | 2112776.7434 | 37.7814822273864 | -122.431397871768 | (37.7814822273864, -122.431397871768) | ||
| 6757 | 6757 | 7971 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1950 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6005647.3062 | 2116796.9112400003 | 37.7926398349056 | -122.42439240168999 | (37.7926398349056, -122.42439240169) | |||
| 6793 | 6793 | 106875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2014 12:00:00 AM | 9 | 3x3 | Permit Number 772880 | 5999376.012619999 | 2115702.7008599997 | 37.7892792923525 | -122.446012495778 | (37.7892792923525, -122.446012495778) | |
| 7260 | 7260 | 9879 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1515 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6005356.5169 | 2115030.8291 | 37.7877741910602 | -122.42527281445 | (37.7877741910602, -122.42527281445) | |||
| 7261 | 7261 | 98606 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 4.5x4.5 | 6003043.17178 | 2116866.41104 | 37.7926832667819 | -122.43340776527398 | (37.7926832667819, -122.433407765274) | ||
| 7476 | 7476 | 98608 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6002968.64851 | 2116857.31006 | 37.7926540495901 | -122.433664967757 | (37.7926540495901, -122.433664967757) | ||
| 7506 | 7506 | 14836 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1300 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 10/22/2008 12:00:00 AM | 9 | 3X3 | 6002892.8097 | 2111692.1261 | 37.7784674596438 | -122.43355807318501 | (37.7784674596438, -122.433558073185) | |
| 7511 | 7511 | 17938 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2432 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4x4 | 6002059.6562 | 2115054.4543 | 37.7876522528246 | -122.436681002358 | (37.7876522528246, -122.436681002358) | |||
| 7587 | 7587 | 98602 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6003137.34298 | 2116882.04608 | 37.792731538790704 | -122.433083047059 | (37.7927315387907, -122.433083047059) | ||
| 7664 | 7664 | 5305 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6001119.0716 | 2113939.9503 | 37.7845386138352 | -122.439855295582 | (37.7845386138352, -122.439855295582) | |||
| 7724 | 7724 | 98603 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6003120.0075900005 | 2116875.00163 | 37.7927112131931 | -122.433142524628 | (37.7927112131931, -122.433142524628) | ||
| 7755 | 7755 | 9901 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1800 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6005290.73846 | 2115881.1175599997 | 37.790105154185795 | -122.42556093401001 | (37.7901051541858, -122.42556093401) | |||
| 7789 | 7789 | 27523 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3201 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 5998989.0649 | 2114921.3868 | 37.787111905807706 | -122.447295026999 | (37.7871119058077, -122.447295026999) | |||
| 7814 | 7814 | 98604 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6003077.63265 | 2116870.32542 | 37.792695969686 | -122.43328880923401 | (37.792695969686, -122.433288809234) | ||
| 7876 | 7876 | 2697 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2117 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6003239.8117 | 2114811.7937 | 37.787052965257296 | -122.43258055733999 | (37.7870529652573, -122.43258055734) | |||
| 7879 | 7879 | 8388 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400 Geary Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1993 12:00:00 AM | 9 | 3X3 | 6004657.4473 | 2114104.6074 | 37.7851914993754 | -122.427625448631 | (37.7851914993754, -122.427625448631) | ||
| 7903 | 7903 | 23532 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2750 Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1991 12:00:00 AM | 9 | 3x3 | 6005730.01613 | 2119881.88283 | 37.8011150557677 | -122.42432573765801 | (37.8011150557677, -122.424325737658) | ||
| 7951 | 7951 | 105122 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 721 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2014 12:00:00 AM | 9 | 3x3 | Permit Number 770889 | 6006721.514169999 | 2121829.13806 | 37.806517659224795 | -122.42103305794399 | (37.8065176592248, -122.421033057944) | |
| 8145 | 8145 | 27525 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3201 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 5999054.0419 | 2114926.8015 | 37.7871304857824 | -122.447070611568 | (37.7871304857824, -122.447070611568) | |||
| 8164 | 8164 | 17738 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1335 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1992 12:00:00 AM | 9 | 3X3 | 6002216.6 | 2113193.3325 | 37.7825510038819 | -122.43600478260001 | (37.7825510038819, -122.4360047826) | ||
| 8225 | 8225 | 13168 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1920 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6003163.0836 | 2119646.9456 | 37.8003246983453 | -122.43319163061001 | (37.8003246983453, -122.43319163061) |
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");