Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlotSize, PermitNotes
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17563 | 17563 | 687 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1299X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 3X3 | 6010636.022580001 | 2101844.6913400004 | 37.75186493122229 | -122.40607730804199 | (37.7518649312223, -122.406077308042) | |||
| 144769 | 144769 | 689 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1299X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 92348 | 92348 | 690 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1299X Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 3X3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 83618 | 83618 | 693 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1299X Potrero Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 91816 | 91816 | 694 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1299X Potrero Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 10993 | 10993 | 764 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.76418358274471 | -122.496433785178 | (37.7641835827447, -122.496433785178) | |||
| 104399 | 104399 | 765 | Permitted Site 1 | Acacia spp :: Acacia Spp 176 | 1200X 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3 | 5984609.996333099 | 2107018.7644647 | 37.764581448379396 | -122.496459340328 | (37.7645814483794, -122.496459340328) | |||
| 81054 | 81054 | 2804 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 115677 | 115677 | 2805 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 65 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 109159 | 109159 | 2806 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 126954 | 126954 | 2807 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 88529 | 88529 | 2808 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3x3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 139043 | 139043 | 2809 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 35 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 7851 | 7851 | 4658 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 34 | 5X5 | 6009795.4348 | 2119557.2423 | 37.8004523952872 | -122.410234638074 | (37.8004523952872, -122.410234638074) | |||
| 4255 | 4255 | 4659 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009780.1976 | 2119571.0943 | 37.800489575353104 | -122.410288343699 | (37.8004895753531, -122.410288343699) | |||
| 7939 | 7939 | 4660 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 125 | 5X5 | 6009761.7282 | 2119587.7167 | 37.8005341810425 | -122.410353429867 | (37.8005341810425, -122.410353429867) | |||
| 6968 | 6968 | 4661 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009739.5649 | 2119605.2627 | 37.8005811155969 | -122.41043136381901 | (37.8005811155969, -122.410431363819) | |||
| 8289 | 8289 | 4662 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 5X5 | 6009727.0981 | 2119617.2678 | 37.8006133797513 | -122.41047535239099 | (37.8006133797513, -122.410475352391) | |||
| 7037 | 7037 | 4663 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 60 | 5X5 | 6009710.0139 | 2119634.3519 | 37.8006593307081 | -122.41053567802 | (37.8006593307081, -122.41053567802) | |||
| 5145 | 5145 | 4664 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009692.467999999 | 2119649.5892 | 37.8007001848924 | -122.410597470914 | (37.8007001848924, -122.410597470914) | |||
| 3904 | 3904 | 4665 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 5X5 | 6009675.3838 | 2119664.5956 | 37.8007404309352 | -122.410657649881 | (37.8007404309352, -122.410657649881) | |||
| 21461 | 21461 | 5433 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 500X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/27/2008 12:00:00 AM | 3 | 6 | 6004888.034519999 | 2105376.13123 | 37.76123826456529 | -122.42620605546301 | (37.7612382645653, -122.426206055463) | ||
| 20166 | 20166 | 5434 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 500X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/14/2009 12:00:00 AM | 3 | 6 | 6004889.66204 | 2105352.28361 | 37.7611728766429 | -122.426198728713 | (37.7611728766429, -122.426198728713) | ||
| 117968 | 117968 | 5435 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004896.4850004995 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | |||
| 18744 | 18744 | 5437 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 25 | 6 | 6004897.82208 | 2105221.96635 | 37.760815517531206 | -122.426161228775 | (37.7608155175312, -122.426161228775) | |||
| 20609 | 20609 | 5438 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/19/1992 12:00:00 AM | 20 | 6 | 6004899.41142 | 2105199.1804 | 37.7607530425379 | -122.426154109737 | (37.7607530425379, -122.426154109737) | ||
| 19361 | 19361 | 5439 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 500X Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/01/1990 12:00:00 AM | 45 | 6 | 6004897.2550099995 | 2105174.4218599997 | 37.7606849395651 | -122.426159805147 | (37.7606849395651, -122.426159805147) | ||
| 18991 | 18991 | 5440 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004903.17124 | 2105121.8240799997 | 37.7605408528978 | -122.426135598976 | (37.7605408528978, -122.426135598976) | |||
| 20901 | 20901 | 5441 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004905.78091 | 2105098.60706 | 37.76047725195271 | -122.426124920443 | (37.7604772519527, -122.426124920443) | |||
| 17712 | 17712 | 5442 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 6 | 6004907.01705 | 2105068.65381 | 37.7603950772802 | -122.426118512771 | (37.7603950772802, -122.426118512771) | |||
| 20994 | 20994 | 5443 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/19/1992 12:00:00 AM | 80 | 6 | 6004908.86181 | 2105038.27798 | 37.7603117767003 | -122.426109970095 | (37.7603117767003, -122.426109970095) | ||
| 19884 | 19884 | 5444 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 6 | 6004913.15076 | 2105006.62195 | 37.760225099135795 | -122.426092882994 | (37.7602250991358, -122.426092882994) | |||
| 19227 | 19227 | 5445 | Permitted Site 1 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 500X Dolores St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/20/1990 12:00:00 AM | 8 | 6 | 6004913.51654 | 2104964.38719 | 37.76010915314279 | -122.426088611215 | (37.7601091531428, -122.426088611215) | ||
| 21952 | 21952 | 5447 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004926.667780001 | 2104747.1594700003 | 37.7595134404185 | -122.42602766326401 | (37.7595134404185, -122.426027663264) | |||
| 100994 | 100994 | 5461 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/11/2006 12:00:00 AM | 3 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
| 141306 | 141306 | 5462 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/02/1992 12:00:00 AM | 25 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
| 105022 | 105022 | 5464 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | |||
| 115430 | 115430 | 5466 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/20/1990 12:00:00 AM | 25 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
| 97092 | 97092 | 5467 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 600X Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||||
| 111960 | 111960 | 5468 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/01/1990 12:00:00 AM | 25 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
| 91762 | 91762 | 5469 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/02/1992 12:00:00 AM | 25 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
| 115857 | 115857 | 5470 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/10/2006 12:00:00 AM | 3 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
| 85991 | 85991 | 5471 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/02/1992 12:00:00 AM | 25 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
| 88029 | 88029 | 5481 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 700X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 99318 | 99318 | 5483 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 700X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/28/2008 12:00:00 AM | 6 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | ||
| 95365 | 95365 | 5484 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 700X Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 35 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 101187 | 101187 | 5485 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 88492 | 88492 | 5486 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 700X Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/28/2008 12:00:00 AM | 12 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | ||
| 116727 | 116727 | 5487 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 700X Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 142678 | 142678 | 5488 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 700X Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 123177 | 123177 | 6288 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | ||
| 119159 | 119159 | 6290 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1700X Ellis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/06/2015 12:00:00 AM | 4x4 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | ||
| 108709 | 108709 | 6291 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1700X Ellis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/04/2008 12:00:00 AM | 3 | 4x4 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | ||
| 43333 | 43333 | 6292 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1700X Ellis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 24 | 3X4 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | |
| 15454 | 15454 | 7377 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010910.3764 | 2111530.9317 | 37.7784764953194 | -122.405810783213 | (37.7784764953194, -122.405810783213) | |||
| 15693 | 15693 | 7378 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010884.8623 | 2111505.4176 | 37.7784050126686 | -122.40589724881 | (37.7784050126686, -122.40589724881) | |||
| 16764 | 16764 | 7379 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010870.4412 | 2111489.3325 | 37.7783600402028 | -122.40594600363998 | (37.7783600402028, -122.40594600364) | |||
| 14183 | 14183 | 7380 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010853.2469 | 2111475.4662 | 37.7783210049209 | -122.40600450833401 | (37.7783210049209, -122.406004508334) | |||
| 15604 | 15604 | 7382 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 60 | 3X3 | 6010814.6984 | 2111439.6909 | 37.7782206182135 | -122.406135341461 | (37.7782206182135, -122.406135341461) | |||
| 128189 | 128189 | 8478 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 124222 | 124222 | 8479 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 139564 | 139564 | 8480 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 89154 | 89154 | 8481 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 88707 | 88707 | 8482 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 139473 | 139473 | 8483 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 122255 | 122255 | 8484 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 105973 | 105973 | 8485 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 145655 | 145655 | 8486 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1900X Geary Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | ||
| 7635 | 7635 | 8487 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002304.7836 | 2113777.2973 | 37.7841594324943 | -122.43574149958401 | (37.7841594324943, -122.435741499584) | |||
| 116461 | 116461 | 8488 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 6893 | 6893 | 8489 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002220.6585 | 2113766.2282 | 37.7841242607304 | -122.436031749589 | (37.7841242607304, -122.436031749589) | |||
| 90660 | 90660 | 8490 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 79428 | 79428 | 8492 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 114003 | 114003 | 8493 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 85228 | 85228 | 8494 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 115535 | 115535 | 8495 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 121289 | 121289 | 8496 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 110591 | 110591 | 8497 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 82553 | 82553 | 8498 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 98915 | 98915 | 8499 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 82040 | 82040 | 8500 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 77594 | 77594 | 8501 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 87002 | 87002 | 8502 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 145985 | 145985 | 8503 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 103189 | 103189 | 8504 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 94964 | 94964 | 8519 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | |||
| 84016 | 84016 | 8521 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/30/2005 12:00:00 AM | 3 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | ||
| 80827 | 80827 | 8522 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | |||
| 141074 | 141074 | 8523 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | |||
| 129090 | 129090 | 8524 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | |||
| 8794 | 8794 | 8525 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002439.1587 | 2113663.3402 | 37.7838541670365 | -122.43526845642201 | (37.7838541670365, -122.435268456422) | |||
| 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) | |||
| 87286 | 87286 | 8528 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | |||
| 7740 | 7740 | 9445 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/01/1994 12:00:00 AM | 12 | 3X3 | 6005680.1419 | 2112439.5166 | 37.780677364386705 | -122.423968789396 | (37.7806773643867, -122.423968789396) | ||
| 7171 | 7171 | 9447 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 3 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005622.1957 | 2112431.3933 | 37.780651788182794 | -122.424168675479 | (37.7806517881828, -122.424168675479) | |||
| 7570 | 7570 | 9448 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 4 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 05/18/1992 12:00:00 AM | 12 | 3X3 | 6005590.2441 | 2112426.5193 | 37.78063660125729 | -122.424278864743 | (37.7806366012573, -122.424278864743) | ||
| 8920 | 8920 | 9449 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 5 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005556.1262 | 2112420.5622 | 37.780618317973 | -122.424396471178 | (37.780618317973, -122.424396471178) | |||
| 7676 | 7676 | 9450 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 6 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005543.6705 | 2112420.5622 | 37.780617614602896 | -122.424439561439 | (37.7806176146029, -122.424439561439) | |||
| 6304 | 6304 | 9451 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005532.2979 | 2112418.9375 | 37.7806125113537 | -122.424478789137 | (37.7806125113537, -122.424478789137) | ||
| 6101 | 6101 | 9452 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/17/1998 12:00:00 AM | 3 | 3X3 | 6005518.2175 | 2112416.7713 | 37.780605768348295 | -122.424527345883 | (37.7806057683483, -122.424527345883) |
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");