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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3048 | 3048 | 253287 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 1237 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780510 | 6016839.12241 | 2092718.7941400001 | 37.727152059320204 | -122.383990506478 | (37.7271520593202, -122.383990506478) | |
| 9964 | 9964 | 173762 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1405 Van Dyke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773007 | 6015436.02818 | 2092717.7192900002 | 37.727071439337 | -122.388840955894 | (37.727071439337, -122.388840955894) | |
| 9965 | 9965 | 173761 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1405 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773007 | 6015436.02818 | 2092717.7192900002 | 37.727071439337 | -122.388840955894 | (37.727071439337, -122.388840955894) | |
| 15001 | 15001 | 105275 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 64 Townsend St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015531.53579 | 2112438.89481 | 37.7812269075454 | -122.389887748547 | (37.7812269075454, -122.389887748547) | |
| 13567 | 13567 | 105276 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 64 Townsend St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015520.229280001 | 2112423.42174 | 37.7811837949483 | -122.38992578265699 | (37.7811837949483, -122.389925782657) | |
| 15264 | 15264 | 105277 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 64 Townsend St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015510.23316 | 2112419.2864900003 | 37.781171886114706 | -122.38996007562 | (37.7811718861147, -122.38996007562) | |
| 9622 | 9622 | 122597 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9623 | 9623 | 75842 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9625 | 9625 | 122599 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9627 | 9627 | 122596 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9628 | 9628 | 122598 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9630 | 9630 | 72480 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9633 | 9633 | 75872 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9761 | 9761 | 122592 | Planning Code 138.1 required 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 72 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9764 | 9764 | 122593 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 72 Townsend St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9765 | 9765 | 122594 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 72 Townsend St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 138 | 138 | 72565 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/16/1996 12:00:00 AM | 3 | 4x4 | Permit Number 770847 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |
| 139 | 139 | 116640 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
| 81075 | 81075 | 121531 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 82070 | 82070 | 121539 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 83676 | 83676 | 121526 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 101224 | 101224 | 121527 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 101696 | 101696 | 121525 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | |||
| 101714 | 101714 | 121533 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 78470 | 78470 | 121547 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 79273 | 79273 | 121543 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 90872 | 90872 | 121545 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 106586 | 106586 | 121542 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 115120 | 115120 | 121546 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 13744 | 13744 | 115348 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014915.48611 | 2114547.7853200003 | 37.7869832575075 | -122.39216652446001 | (37.7869832575075, -122.39216652446) | |
| 16266 | 16266 | 115349 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014896.08459 | 2114567.05321 | 37.787035085459706 | -122.392234997951 | (37.7870350854597, -122.392234997951) | |
| 15102 | 15102 | 115350 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014880.23802 | 2114582.9179 | 37.7870777663613 | -122.39229093398599 | (37.7870777663613, -122.392290933986) | |
| 16337 | 16337 | 115351 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014858.418740001 | 2114606.67601 | 37.7871417890985 | -122.39236808681801 | (37.7871417890985, -122.392368086818) | |
| 9788 | 9788 | 115347 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 398X HARRISON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 773314 | 6014854.0 | 2114630.0 | 37.7872055860551 | -122.392385006805 | (37.7872055860551, -122.392385006805) | |
| 9806 | 9806 | 115346 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 398X HARRISON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 773314 | 6014854.0 | 2114630.0 | 37.7872055860551 | -122.392385006805 | (37.7872055860551, -122.392385006805) | |
| 14382 | 14382 | 115352 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014845.33617 | 2114621.37484 | 37.7871814222392 | -122.392414378515 | (37.7871814222392, -122.392414378515) | |
| 13917 | 13917 | 115353 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014819.91687 | 2114646.3157900004 | 37.787248492781295 | -122.39250406973 | (37.7872484927813, -122.39250406973) | |
| 15478 | 15478 | 115354 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014804.627730001 | 2114662.16926 | 37.7872911737029 | -122.39255807669 | (37.7872911737029, -122.39255807669) | |
| 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) | |
| 14429 | 14429 | 115355 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014786.34664 | 2114681.69198 | 37.7873437633547 | -122.392622692086 | (37.7873437633547, -122.392622692086) | |
| 69564 | 69564 | 113240 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 329 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 2 | 3x4 | Permit Number 770912 | 6014728.70394 | 2112464.7296599997 | 37.7812532891345 | -122.392666980121 | (37.7812532891345, -122.392666980121) | |
| 109588 | 109588 | 113335 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X STANFORD ST | 1 | 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) | ||
| 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) | ||
| 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) | ||
| 13813 | 13813 | 115356 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014763.69701 | 2114705.74438 | 37.7874085478076 | -122.39270273893801 | (37.7874085478076, -122.392702738938) | |
| 83448 | 83448 | 121513 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 87909 | 87909 | 121515 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 89423 | 89423 | 121518 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 91523 | 91523 | 121514 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 91964 | 91964 | 121522 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 280 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 97096 | 97096 | 121521 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 99977 | 99977 | 121510 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 100921 | 100921 | 121512 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 101034 | 101034 | 121516 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 101133 | 101133 | 121511 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 112546 | 112546 | 121517 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 26030 | 26030 | 118375 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4x6 | 6014712.487269999 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | |||
| 3289 | 3289 | 253392 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 3293 | 3293 | 253393 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 3316 | 3316 | 253394 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 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) | |
| 14383 | 14383 | 118374 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x6 | 6014693.17098 | 2114681.8097099997 | 37.787338911495 | -122.392945071183 | (37.787338911495, -122.392945071183) | |||
| 78293 | 78293 | 118379 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 83570 | 83570 | 118377 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 86944 | 86944 | 118378 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 89450 | 89450 | 118380 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 109208 | 109208 | 118376 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 60824 | 60824 | 121501 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014441.60375 | 2115047.86993 | 37.7883300516388 | -122.39384108102101 | (37.7883300516388, -122.393841081021) | |||
| 35251 | 35251 | 121502 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | |||
| 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) | |||
| 38160 | 38160 | 121504 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014396.4001 | 2115093.29031 | 37.7884522533286 | -122.39400066032499 | (37.7884522533286, -122.394000660325) | |||
| 46572 | 46572 | 121505 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014377.50413 | 2115113.61118 | 37.7885069995398 | -122.394067461056 | (37.7885069995398, -122.394067461056) | |||
| 20380 | 20380 | 112084 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 104211 | 104211 | 112085 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 22937 | 22937 | 109463 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2017 12:00:00 AM | 3 | 4x4 | Permit Number 773752 | 6013357.96458 | 2109418.68041 | 37.7728133064148 | -122.39719543803899 | (37.7728133064148, -122.397195438039) | |
| 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) |
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");