Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2503 | 2503 | 253120 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 815 Buena Vista Ave West | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x100 | 6000071.60031 | 2108311.04493 | 37.769023393565604 | -122.44307478834801 | (37.7690233935656, -122.443074788348) | ||||
| 8128 | 8128 | 87100 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 700 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 50056 | ||||||||
| 9593 | 9593 | 94859 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53932 | |||||||||
| 13319 | 13319 | 93075 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1230 Twin Peaks Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 14837 | 14837 | 94862 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53932 | |||||||||
| 20076 | 20076 | 98360 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 807 Francisco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Permit Number 768654 | 6007370.5 | 2120864.5 | 37.8039055703948 | -122.418718664572 | (37.8039055703948, -122.418718664572) | ||||
| 34344 | 34344 | 55599 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 642 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1973 12:00:00 AM | 12 | Permit Number 11573 | 5982597.2205300005 | 2111395.81021 | 37.776481429538705 | -122.503745058688 | (37.7764814295387, -122.503745058688) | ||
| 40007 | 40007 | 95885 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Ocean Sloat Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 42964 | 42964 | 95883 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Everglade Sloat Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 65540 | 65540 | 100177 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 252 States St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768965 | 6000636.0 | 2106677.4 | 37.764569975148895 | -122.44100535545 | (37.7645699751489, -122.44100535545) | ||||
| 66024 | 66024 | 87113 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 66190 | 66190 | 20482 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 42 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 67566 | 67566 | 87917 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 160 Gardenside Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50940 | 5999367.0 | 2102115.0 | 37.751970392561496 | -122.445066449965 | (37.7519703925615, -122.445066449965) | ||
| 74227 | 74227 | 96113 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 229 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767768 | 5982054.02521 | 2112599.84865 | 37.779755411650704 | -122.505713372558 | (37.7797554116507, -122.505713372558) |
| 78201 | 78201 | 20481 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 79736 | 79736 | 95880 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Clearfield Sloat Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
| 80410 | 80410 | 20503 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 80533 | 80533 | 87918 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 160 Gardenside Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50940 | 5999367.0 | 2102115.0 | 37.751970392561496 | -122.445066449965 | (37.7519703925615, -122.445066449965) | ||
| 80577 | 80577 | 85020 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 299 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994525.0 | 2094707.0 | 37.7313523209144 | -122.46127371080699 | (37.7313523209144, -122.461273710807) | |||||
| 81556 | 81556 | 99518 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Clearfield Sloat Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | |||
| 82329 | 82329 | 57589 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 93 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50021 | 6001851.03848289 | 2096750.6660448 | 37.7373826596428 | -122.436092469726 | (37.7373826596428, -122.436092469726) | ||
| 82693 | 82693 | 20498 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 83538 | 83538 | 92871 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 3600 Jackson St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53088 | 5997031.0 | 2116025.0 | 37.790030052590105 | -122.454149203806 | (37.7900300525901, -122.454149203806) | ||||
| 85342 | 85342 | 99520 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Clearfield Sloat Blvd | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | |||
| 87086 | 87086 | 20486 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 36 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 88950 | 88950 | 86946 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 495 Pacheco St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11/20/2007 12:00:00 AM | 3x3 | Permit Number 51051 | 5993544.7 | 2101797.8 | 37.750765410178 | -122.465177603148 | (37.750765410178, -122.465177603148) | ||
| 89237 | 89237 | 87112 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 90425 | 90425 | 20506 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1211X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 90768 | 90768 | 38768 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2086 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 40635 | 5993219.31121709 | 2101288.86117635 | 37.7493492253318 | -122.46626583425699 | (37.7493492253318, -122.466265834257) | ||||
| 90956 | 90956 | 99523 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Ocean Sloat Blvd | 33 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | |||
| 91956 | 91956 | 85282 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1283 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49571 | 6006751.0 | 2119761.0 | 37.8008407409326 | -122.42078409851001 | (37.8008407409326, -122.42078409851) | ||||
| 92814 | 92814 | 113055 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 815 Buena Vista West Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999858.0 | 2108239.0 | 37.76881339508 | -122.44380843942301 | (37.76881339508, -122.443808439423) | |||||
| 93592 | 93592 | 97535 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 300 Winfield St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6006649.9 | 2098038.3 | 37.7411896837785 | -122.41959186825599 | (37.7411896837785, -122.419591868256) | |||||
| 94528 | 94528 | 85283 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1283 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49571 | 6006751.0 | 2119761.0 | 37.8008407409326 | -122.42078409851001 | (37.8008407409326, -122.42078409851) | ||||
| 94706 | 94706 | 52776 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 451@ CASTRO Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48822 | 6002227.28068346 | 2101467.46194579 | 37.750355244869105 | -122.43512889078501 | (37.7503552448691, -122.435128890785) | ||||
| 99272 | 99272 | 20491 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 36 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 99897 | 99897 | 20497 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 102283 | 102283 | 20490 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 103272 | 103272 | 50960 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 65 Montclair Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47453 | 6007264.23528351 | 2120370.2610527 | 37.8025425319574 | -122.41905132385 | (37.8025425319574, -122.41905132385) | ||||
| 103309 | 103309 | 87916 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 160 Gardenside Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50940 | 5999367.0 | 2102115.0 | 37.751970392561496 | -122.445066449965 | (37.7519703925615, -122.445066449965) | ||
| 103757 | 103757 | 40487 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1955 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1999 12:00:00 AM | Permit Number 41566 | 5993136.04980647 | 2102175.12230653 | 37.7517778666293 | -122.466618163119 | (37.7517778666293, -122.466618163119) | |||
| 104110 | 104110 | 20487 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 104414 | 104414 | 54892 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 171 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2008 12:00:00 AM | Permit Number 50283 | 5997476.90745851 | 2107071.75606077 | 37.7654723391322 | -122.45196020293601 | (37.7654723391322, -122.451960202936) | |||
| 104532 | 104532 | 20502 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 105140 | 105140 | 20485 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 36 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 105238 | 105238 | 20492 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 105836 | 105836 | 40618 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 201 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | Permit Number 41624 | 6005148.26696606 | 2109558.58269734 | 37.7727369810284 | -122.425603701556 | (37.7727369810284, -122.425603701556) | ||
| 106366 | 106366 | 108368 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 36 KNOLLVIEW WAY | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Permit Number 774549 | 5997629.0 | 2101321.0 | 37.7496909137477 | -122.451019424553 | (37.7496909137477, -122.451019424553) | |||
| 106956 | 106956 | 97537 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 300 Winfield St | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6006649.9 | 2098038.3 | 37.7411896837785 | -122.41959186825599 | (37.7411896837785, -122.419591868256) | |||||
| 107034 | 107034 | 20493 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 107496 | 107496 | 96868 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2100X San Jose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | |||||
| 108958 | 108958 | 99522 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Ocean Sloat Blvd | 26 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | |||
| 109590 | 109590 | 41376 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 491 Buena Vista East Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 42013 | 6000280.5585881 | 2107138.11157559 | 37.7658147234719 | -122.442267803649 | (37.7658147234719, -122.442267803649) | ||||
| 110442 | 110442 | 9647 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 420X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5999128.38767 | 2111347.91542 | 37.77730804103229 | -122.446555809153 | (37.7773080410323, -122.446555809153) | |||
| 112435 | 112435 | 108367 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 36 KNOLLVIEW WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Permit Number 774549 | 5997629.0 | 2101321.0 | 37.7496909137477 | -122.451019424553 | (37.7496909137477, -122.451019424553) | |||
| 113460 | 113460 | 20494 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 114131 | 114131 | 96875 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2100X San Jose Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | |||||
| 114357 | 114357 | 85057 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 114 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | Permit Number 49394 | 6004707.0 | 2103005.0 | 37.754717463060395 | -122.426663322428 | (37.7547174630604, -122.426663322428) | |||
| 114374 | 114374 | 95881 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Ocean Sloat Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 114437 | 114437 | 96866 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2100X San Jose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | |||||
| 115747 | 115747 | 97403 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2 STANFORD HEIGHTS AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5997807.0 | 2095590.8 | 37.7339673631019 | -122.449990957178 | (37.7339673631019, -122.449990957178) | |||||
| 115936 | 115936 | 20480 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 116169 | 116169 | 87111 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 118061 | 118061 | 99521 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Clearfield Sloat Blvd | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | |||
| 118959 | 118959 | 41377 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 491 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 42013 | 6000280.5585881 | 2107138.11157559 | 37.7658147234719 | -122.442267803649 | (37.7658147234719, -122.442267803649) | ||||
| 119828 | 119828 | 20484 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 36 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 120101 | 120101 | 97404 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2@Melrose Stanford Heights Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5997807.0 | 2095590.8 | 37.7339673631019 | -122.449990957178 | (37.7339673631019, -122.449990957178) | |||||
| 120944 | 120944 | 85217 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1913 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002690.1 | 2099961.9 | 37.746247596031296 | -122.43342085572901 | (37.7462475960313, -122.433420855729) | |||||
| 121001 | 121001 | 20500 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 122040 | 122040 | 95884 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Everglade Sloat Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
| 122306 | 122306 | 52778 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 451@ CASTRO Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48822 | 6002227.28068346 | 2101467.46194579 | 37.750355244869105 | -122.43512889078501 | (37.7503552448691, -122.435128890785) | ||||
| 122730 | 122730 | 52420 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 60@ 29TH ST Zircon Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48540 | 6002312.55382502 | 2098717.30876937 | 37.7428088130721 | -122.434637382981 | (37.7428088130721, -122.434637382981) | ||||
| 122754 | 122754 | 99519 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Clearfield Sloat Blvd | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | |||
| 122763 | 122763 | 86746 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 41 Nevada St | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 49711 | 6009063.0 | 2098235.0 | 37.7418654099413 | -122.411262090685 | (37.7418654099413, -122.411262090685) | |||||
| 126238 | 126238 | 52742 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 432@ NOE 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48791 | 6003090.32224136 | 2099513.72726182 | 37.7450397163723 | -122.4320049394 | (37.7450397163723, -122.4320049394) | |||
| 126874 | 126874 | 95334 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 466 Gonzalez Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2011 12:00:00 AM | 75 | Permit Number 767212 | 5989603.4 | 2089229.6 | 37.7160282834266 | -122.477888136934 | (37.7160282834266, -122.477888136934) | ||
| 128377 | 128377 | 79685 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2008 12:00:00 AM | 3x3 | Permit Number 50355 | 6007801.88811391 | 2088315.49386025 | 37.7145577712837 | -122.414920709681 | (37.7145577712837, -122.414920709681) | ||
| 138913 | 138913 | 113080 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 89 Castenada Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x2 | Permit Number 776239 | 5994496.1 | 2101295.2 | 37.7494402154084 | -122.461851162221 | (37.7494402154084, -122.461851162221) | |||
| 139137 | 139137 | 20489 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 139210 | 139210 | 100069 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 619 Gonzalez Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2012 12:00:00 AM | Permit Number 769006 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||
| 139433 | 139433 | 53183 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 125 HERNANDEZ Vasquez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49101 | 5995111.76133889 | 2099617.2866261 | 37.7448685093949 | -122.45960069150699 | (37.7448685093949, -122.459600691507) | ||||
| 140992 | 140992 | 94636 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 170X Crestmont Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/24/2010 12:00:00 AM | Permit Number 53783 | 5995178.5 | 2103444.0 | 37.7553795372421 | -122.45964703776801 | (37.7553795372421, -122.459647037768) | |||
| 141981 | 141981 | 87114 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 143327 | 143327 | 87115 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 144308 | 144308 | 97536 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 300 Winfield St | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | Permit Number 768224 | 6006649.9 | 2098038.3 | 37.7411896837785 | -122.41959186825599 | (37.7411896837785, -122.419591868256) | ||||
| 144564 | 144564 | 95882 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Clearfield Sloat Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 144600 | 144600 | 20499 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 144816 | 144816 | 99524 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Everglade Sloat Blvd | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | |||
| 145163 | 145163 | 94637 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 170X Crestmont Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/24/2010 12:00:00 AM | Permit Number 53783 | 5995178.5 | 2103444.0 | 37.7553795372421 | -122.45964703776801 | (37.7553795372421, -122.459647037768) | |||
| 145766 | 145766 | 51721 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1335 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2005 12:00:00 AM | Permit Number 47991 | 6001394.735632 | 2099881.41998428 | 37.7459530403724 | -122.437894295142 | (37.7459530403724, -122.437894295142) | |||
| 145924 | 145924 | 87273 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 4 Miraloma Dr | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 03/12/2008 12:00:00 AM | Permit Number 50295 | 5995203.0 | 2097905.0 | 37.7401722415629 | -122.45916124145 | (37.7401722415629, -122.45916124145) | |||
| 149391 | 149391 | 63257 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 465 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/1987 12:00:00 AM | 38 | Permit Number 23810 | 5984679.75149 | 2112668.94882 | 37.780099327718794 | -122.49663507465799 | (37.7800993277188, -122.496635074658) | ||
| 184966 | 184966 | 54835 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 117 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 15 | Permit Number 10689 | 5998722.2979 | 2110262.8651 | 37.7743055679817 | -122.447882461981 | (37.7743055679817, -122.447882461981) | ||
| 162 | 162 | 251231 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 164 Serrano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989598.0 | 2090848.0 | 37.7204716934452 | -122.478025052476 | (37.7204716934452, -122.478025052476) | ||||
| 818 | 818 | 251389 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 202x Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999774.0 | 2095231.0 | 37.7330917931436 | -122.44316462438499 | (37.7330917931436, -122.443164624385) | ||||
| 934 | 934 | 251409 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 95x Andover St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6007642.0 | 2098274.0 | 37.741892697320296 | -122.41617822056101 | (37.7418926973203, -122.416178220561) | ||||
| 1034 | 1034 | 251427 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5028 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999606.0 | 2100130.0 | 37.7465337016449 | -122.44409733772801 | (37.7465337016449, -122.444097337728) | ||||
| 1620 | 1620 | 251543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard 17 | Tree 1 | Private 1 | |||||||||||
| 1772 | 1772 | 173895 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 326x Dellbrook Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 3x3 | 5997295.0 | 2102064.0 | 37.7517118802849 | -122.452228008054 | (37.7517118802849, -122.452228008054) | |||
| 2100 | 2100 | 178279 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 4 | Width 0ft | 5987917.15522 | 2088760.91322 | 37.714643374877895 | -122.48368218070499 | (37.7146433748779, -122.483682180705) |
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");