Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187427 | 187427 | 109470 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | Permit Number 773752 | 6013467.61268 | 2109523.16527 | 37.77310630195289 | -122.39682347663299 | (37.7731063019529, -122.396823476633) | ||
| 182061 | 182061 | 115977 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011639.0005 | 2091249.90123 | 37.722829925953896 | -122.40186416949 | (37.7228299259539, -122.40186416949) | |||
| 180408 | 180408 | 112198 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 2570 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771994 | 6001873.5131 | 2116702.41623 | 37.7921665513862 | -122.43744307455401 | (37.7921665513862, -122.437443074554) | |
| 179588 | 179588 | 115097 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 537 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010133.894719999 | 2111910.59383 | 37.779475503918 | -122.408523727481 | (37.779475503918, -122.408523727481) | |
| 179137 | 179137 | 121507 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 300 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6012241.512 | 2112714.7441 | 37.781801322796895 | -122.401289065763 | (37.7818013227969, -122.401289065763) | |||
| 175630 | 175630 | 109464 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | Permit Number 773752 | 6013338.99753 | 2109402.3629400004 | 37.772767446381394 | -122.39725990323 | (37.7727674463814, -122.39725990323) | ||
| 172623 | 172623 | 115978 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011623.9012 | 2091244.95295 | 37.7228154963084 | -122.40191601721001 | (37.7228154963084, -122.40191601721) | |||
| 171742 | 171742 | 115979 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011610.19593 | 2091240.25279 | 37.722801825729604 | -122.401963063449 | (37.7228018257296, -122.401963063449) | |||
| 171614 | 171614 | 109469 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | Permit Number 773752 | 6013484.3589 | 2109540.27035 | 37.7731542007368 | -122.3967667483 | (37.7731542007368, -122.3967667483) | ||
| 166306 | 166306 | 109458 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x4 | Permit Number 773752 | 6013450.121119999 | 2109506.07563 | 37.7730584040491 | -122.396882784219 | (37.7730584040491, -122.396882784219) | ||
| 165797 | 165797 | 121508 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 300 Folsom St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 3x3 | 6012258.9126 | 2112729.3972 | 37.78184252759429 | -122.401229897449 | (37.7818425275943, -122.401229897449) | |||
| 159239 | 159239 | 109461 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 773752 | 6013397.072509999 | 2109454.07559 | 37.7729126707161 | -122.397062640549 | (37.7729126707161, -122.397062640549) | ||
| 158157 | 158157 | 166259 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2880 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | 6008980.17665 | 2103937.78959 | 37.757519353838795 | -122.41195137385 | (37.7575193538388, -122.41195137385) | |||
| 157784 | 157784 | 113241 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 329 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3 | 3x4 | Permit Number 770912 | 6014742.36618 | 2112476.99378 | 37.7812877223957 | -122.39262057328999 | (37.7812877223957, -122.39262057329) | |
| 155460 | 155460 | 115559 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2539 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6001373.79142 | 2117611.09107 | 37.7946331129763 | -122.439237274207 | (37.7946331129763, -122.439237274207) | |||
| 152424 | 152424 | 109459 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 773752 | 6013430.92674 | 2109487.72122 | 37.7730069385559 | -122.39694789334101 | (37.7730069385559, -122.396947893341) | ||
| 151818 | 151818 | 109462 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 773752 | 6013376.015 | 2109435.75899 | 37.7728612052211 | -122.39713419690001 | (37.7728612052211, -122.3971341969) | ||
| 151686 | 151686 | 121503 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014412.49464 | 2115075.87435 | 37.7884053276005 | -122.39394375569401 | (37.7884053276005, -122.393943755694) | |||
| 151629 | 151629 | 116966 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 480 Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6010311.678719999 | 2106089.82191 | 37.7635029625087 | -122.407498202703 | (37.7635029625087, -122.407498202703) | |||
| 151101 | 151101 | 39246 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3524 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 1 | Permit Number 772836 | 5997390.1418 | 2116079.3582900004 | 37.7901998932662 | -122.452910535096 | (37.7901998932662, -122.452910535096) | ||
| 149675 | 149675 | 115096 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 537 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010119.08101 | 2111896.4319 | 37.7794357889593 | -122.408573975335 | (37.7794357889593, -122.408573975335) | |
| 147831 | 147831 | 109460 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 4x4 | Permit Number 773752 | 6013412.32492 | 2109471.0252 | 37.7729600595772 | -122.39701106892099 | (37.7729600595772, -122.397011068921) | ||
| 145746 | 145746 | 122700 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 2895 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.7679400002 | 37.7253343641976 | -122.40256910729201 | (37.7253343641976, -122.402569107292) | ||
| 145677 | 145677 | 108030 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 601 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2014 12:00:00 AM | 3 | 3x3 | 6002630.6 | 2098839.9 | 37.743163470374895 | -122.43354642924999 | (37.7431634703749, -122.43354642925) | ||
| 145619 | 145619 | 44013 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 2701X 17th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 145519 | 145519 | 121534 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 145478 | 145478 | 121524 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 280 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 145461 | 145461 | 111714 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 3038 CLEMENT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051.0 | 2113265.0 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | |
| 145330 | 145330 | 15235 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008256.52807 | 2110680.03106 | 37.7759913537931 | -122.414931236282 | (37.7759913537931, -122.414931236282) | |
| 145095 | 145095 | 121462 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 415 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778984 | 6006773.54328 | 2092061.7240000002 | 37.7247862819155 | -122.418740608563 | (37.7247862819155, -122.418740608563) | |
| 144900 | 144900 | 121509 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 144636 | 144636 | 121541 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 144469 | 144469 | 121529 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 143793 | 143793 | 44012 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 405X Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 143786 | 143786 | 115490 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 280 BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259.0 | 2091739.0 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | |
| 143480 | 143480 | 117482 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
| 143476 | 143476 | 122686 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 3474 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6005720.0 | 2106109.0 | 37.7632975389877 | -122.423380737252 | (37.7632975389877, -122.423380737252) | |||
| 143274 | 143274 | 122379 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 466 Vernon St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/26/2016 12:00:00 AM | 3 | 3x3 | 5992521.0 | 2090937.0 | 37.7208852925782 | -122.46792773796801 | (37.7208852925782, -122.467927737968) | ||
| 143265 | 143265 | 44004 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 2701X 17th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 142926 | 142926 | 114793 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 10 Linares Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x10 | Permit Number 777094 | 5993887.4 | 2102332.1 | 37.7522522176371 | -122.464031307011 | (37.7522522176371, -122.464031307011) | |||
| 142598 | 142598 | 121520 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 142431 | 142431 | 121538 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 142253 | 142253 | 122428 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
| 142150 | 142150 | 115536 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 141889 | 141889 | 118360 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.765380001 | 2115716.99395 | 37.789681792424105 | -122.42387802240101 | (37.7896817924241, -122.423878022401) | ||
| 141801 | 141801 | 122698 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 98 Woolsey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.9927199995 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | ||
| 141647 | 141647 | 122627 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 34 Country Club Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/15/2016 12:00:00 AM | 3 | 3x4 | Permit Number 775279 | 5984731.0 | 2094410.0 | 37.729968312905505 | -122.49511098534401 | (37.7299683129055, -122.495110985344) | |
| 140646 | 140646 | 121962 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 20 16th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 5x10 | Permit Number 778592 | 5990850.71184 | 2114913.60159 | 37.78662213560371 | -122.47545108088 | (37.7866221356037, -122.47545108088) | |
| 140623 | 140623 | 117481 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
| 140570 | 140570 | 121537 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 140550 | 140550 | 116849 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 83 Panorama Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | |||
| 139787 | 139787 | 68987 | Planning Code 138.1 required 4 | Cordyline australis :: Dracena Palm 141 | 767 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 775182 | 5999291.63198947 | 2121477.34728573 | 37.8051301110493 | -122.44672010757 | (37.8051301110493, -122.44672010757) | |
| 139668 | 139668 | 121535 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 139186 | 139186 | 122423 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
| 139016 | 139016 | 115674 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1433 48th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774098 | 5981190.2 | 2105303.4 | 37.7596706142775 | -122.508159957785 | (37.7596706142775, -122.508159957785) | ||
| 138808 | 138808 | 121536 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 138648 | 138648 | 122626 | Planning Code 138.1 required 4 | Cordyline australis :: Dracena Palm 141 | 330 Country Club Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/15/2016 12:00:00 AM | 3 | 3x5 | Permit Number 774975 | 5984613.0 | 2095517.0 | 37.73300093168071 | -122.495600537949 | (37.7330009316807, -122.495600537949) | |
| 138370 | 138370 | 23050 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1058 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006261.27662 | 2103419.73409 | 37.7559439767922 | -122.421317651992 | (37.7559439767922, -122.421317651992) | |
| 133773 | 133773 | 101942 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 537 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010108.2937199995 | 2111885.47528 | 37.7794051005107 | -122.408610520167 | (37.7794051005107, -122.408610520167) | |
| 129716 | 129716 | 113329 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 329 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770912 | 6014656.6559 | 2112395.64308 | 37.781059591367296 | -122.39291139783701 | (37.7810595913673, -122.392911397837) | |
| 129261 | 129261 | 115492 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 280 BRIGHTON AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259.0 | 2091739.0 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | |
| 129011 | 129011 | 121540 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 128992 | 128992 | 121466 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 79 Harrington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778952 | 6001819.85633 | 2092538.60283 | 37.7258155279415 | -122.43589898702801 | (37.7258155279415, -122.435898987028) | |
| 128502 | 128502 | 66394 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 504 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2016 12:00:00 AM | 3 | 3x4 | Permit Number 772815 | 6007447.25872729 | 2096493.62336554 | 37.7369932248849 | -122.41672547553001 | (37.7369932248849, -122.41672547553) | |
| 128042 | 128042 | 117483 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
| 128007 | 128007 | 122701 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 2895 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.7679400002 | 37.7253343641976 | -122.40256910729201 | (37.7253343641976, -122.402569107292) | ||
| 127953 | 127953 | 119285 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 4x4 | 6005873.0 | 2111410.0 | 37.777861449140204 | -122.423228396467 | (37.7778614491402, -122.423228396467) | ||
| 127737 | 127737 | 112972 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | |
| 127734 | 127734 | 113338 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X STANFORD ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727.0 | 2112481.0 | 37.781297869167396 | -122.392674013487 | (37.7812978691674, -122.392674013487) | ||
| 127155 | 127155 | 121523 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 280 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 126990 | 126990 | 115495 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1199X OCEAN AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259.0 | 2091739.0 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | |
| 126691 | 126691 | 121528 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 126630 | 126630 | 115885 | Planning Code 138.1 required 4 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | 10x10 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | |
| 126477 | 126477 | 119256 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 195 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2016 12:00:00 AM | 3 | 3x3 | 6010242.0 | 2098801.0 | 37.7434855758555 | -122.407225363197 | (37.7434855758555, -122.407225363197) | ||
| 126380 | 126380 | 117510 | Planning Code 138.1 required 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 23x BRIGHT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2016 12:00:00 AM | 3 | 3x3 | 5993679.0 | 2087403.0 | 37.711248577137496 | -122.463668552658 | (37.7112485771375, -122.463668552658) | ||
| 126350 | 126350 | 115887 | Planning Code 138.1 required 4 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 134 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | 2x4 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | |
| 126027 | 126027 | 121544 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 125829 | 125829 | 119287 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 4x4 | 6005873.0 | 2111410.0 | 37.777861449140204 | -122.423228396467 | (37.7778614491402, -122.423228396467) | ||
| 125501 | 125501 | 122796 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 306 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2016 12:00:00 AM | 3 | 3x3 | 6009497.08014 | 2088289.5150400002 | 37.7145815488228 | -122.40905958389999 | (37.7145815488228, -122.4090595839) | ||
| 125393 | 125393 | 121465 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 218 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778899 | 5994755.067290001 | 2090055.4837 | 37.7185936165551 | -122.46014146415101 | (37.7185936165551, -122.460141464151) | |
| 124504 | 124504 | 44001 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 2701X 17th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 124502 | 124502 | 113651 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 122654 | 122654 | 116267 | Planning Code 138.1 required 4 | Acer japonicum :: Japanese Maple 183 | 717 PARIS ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6001138.0 | 2089523.0 | 37.717496606347495 | -122.438040195581 | (37.7174966063475, -122.438040195581) | ||||
| 121865 | 121865 | 121530 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 121738 | 121738 | 107645 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.765380001 | 2115716.99395 | 37.789681792424105 | -122.42387802240101 | (37.7896817924241, -122.423878022401) | ||
| 121482 | 121482 | 121532 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 120763 | 120763 | 117479 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
| 120641 | 120641 | 115504 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2901 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777487 | 6010040.72394239 | 2101604.72592715 | 37.751172725188106 | -122.408119020981 | (37.7511727251881, -122.408119020981) | |
| 120517 | 120517 | 113648 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 120364 | 120364 | 115538 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 120162 | 120162 | 114792 | Planning Code 138.1 required 4 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Linares Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x10 | 5993887.4 | 2102332.1 | 37.7522522176371 | -122.464031307011 | (37.7522522176371, -122.464031307011) | ||||
| 119948 | 119948 | 113645 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 119781 | 119781 | 113337 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X STANFORD ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727.0 | 2112481.0 | 37.781297869167396 | -122.392674013487 | (37.7812978691674, -122.392674013487) | ||
| 119670 | 119670 | 122424 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
| 118836 | 118836 | 121519 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 117679 | 117679 | 117480 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
| 117231 | 117231 | 116850 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 83 Panorama Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | |||
| 116994 | 116994 | 114980 | Planning Code 138.1 required 4 | Callistemon citrinus :: Lemon Bottlebrush 28 | 281 32ND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 5985853.0 | 2114037.0 | 37.7839242715215 | -122.492677119536 | (37.7839242715215, -122.492677119536) | ||||
| 116647 | 116647 | 81972 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1822 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | 3 | 3x6 | Permit Number 774361 | 5989407.90008391 | 2102936.76390687 | 37.7536532824256 | -122.47956618379699 | (37.7536532824256, -122.479566183797) | |
| 116577 | 116577 | 106315 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1199X OCEAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259.0 | 2091739.0 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) |
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");