Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34305 | 34305 | 20466 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | |||
| 54999 | 54999 | 75092 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 288 Eddy St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/16/1989 12:00:00 AM | 16 | 6009056.34359 | 2113588.95965 | 37.7840234906369 | -122.41237011169201 | (37.7840234906369, -122.412370111692) | |||
| 80523 | 80523 | 20465 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | |||
| 100327 | 100327 | 20463 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | |||
| 105704 | 105704 | 20464 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/05/1997 12:00:00 AM | 3 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | ||
| 106691 | 106691 | 25411 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 895X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | |||
| 108952 | 108952 | 13376 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000X Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 109944 | 109944 | 13381 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000X Mansell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 110546 | 110546 | 25416 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 895X Mansell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | |||
| 112414 | 112414 | 110047 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 290 Eddy St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009037.88726419 | 2113590.00375699 | 37.7840253217877 | -122.412434037929 | (37.7840253217877, -122.412434037929) | |||||
| 112463 | 112463 | 20462 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | |||
| 112727 | 112727 | 25417 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 895X Mansell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | |||
| 113947 | 113947 | 13383 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000X Mansell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 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 | ||||||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 123341 | 123341 | 117622 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 890x VERMONT ST | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 6011292.0 | 2104239.0 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | |||||
| 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) | |||
| 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) | |||
| 31 | 31 | 22614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.781365013820206 | -122.424863625752 | (37.7813650138202, -122.424863625752) | |||
| 85 | 85 | 22613 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005358.7073 | 2112686.5825 | 37.7813375942673 | -122.42509837168001 | (37.7813375942673, -122.42509837168) | |||
| 1909 | 1909 | 125218 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101 Washington St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 13 | Width 4ft | 6005090.35688 | 2116771.11072 | 37.7925375271472 | -122.42631763077499 | (37.7925375271472, -122.426317630775) | |||
| 8575 | 8575 | 22617 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/25/1997 12:00:00 AM | 6 | 3x5 | 6005634.7978 | 2112724.8918 | 37.781458374599794 | -122.424145957729 | (37.7814583745998, -122.424145957729) | ||
| 10993 | 10993 | 764 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.76418358274471 | -122.496433785178 | (37.7641835827447, -122.496433785178) | |||
| 79616 | 79616 | 24935 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 82591 | 82591 | 24927 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 36 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 83248 | 83248 | 24932 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/22/1996 12:00:00 AM | 18 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 88695 | 88695 | 104451 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2490X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
| 88826 | 88826 | 22610 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
| 91930 | 91930 | 113799 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 695x SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4x4 | 6008062.0 | 2103972.0 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | ||||
| 92561 | 92561 | 104449 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2490X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
| 93328 | 93328 | 24934 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/28/1999 12:00:00 AM | 24 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 95715 | 95715 | 20475 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1203X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 97092 | 97092 | 5467 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 600X Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||||
| 98214 | 98214 | 113797 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 695x SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4x4 | 6008062.0 | 2103972.0 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | ||||
| 101610 | 101610 | 20510 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1211X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 107042 | 107042 | 24929 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 113430 | 113430 | 24924 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2199X Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6001667.079621499 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | |||
| 117968 | 117968 | 5435 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004896.4850004995 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | |||
| 120636 | 120636 | 22615 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
| 121073 | 121073 | 113798 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 695x SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4x4 | 6008062.0 | 2103972.0 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | ||||
| 122322 | 122322 | 105909 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1864X 14TH AVE | 1 | Median : Yard 3 | Tree 1 | Rec/Park 3 | 14 | 5991829.0 | 2102804.0 | 37.7534290869332 | -122.47118388851999 | (37.7534290869332, -122.47118388852) | ||||
| 123025 | 123025 | 20477 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1203X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 126289 | 126289 | 22618 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
| 141366 | 141366 | 24933 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 142153 | 142153 | 113800 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 695x SHOTWELL ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4x4 | 6008062.0 | 2103972.0 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | ||||
| 87911 | 87911 | 29065 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1001X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138356997 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | ||
| 113978 | 113978 | 29066 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1001X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138356997 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | ||
| 123177 | 123177 | 6288 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | ||
| 6201 | 6201 | 87987 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 300x Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/23/2015 03:33:00 PM | 3 | 3x3 | Permit Number 51027 | 6008990.567000001 | 2113714.34992 | 37.7843640908799 | -122.41260654257201 | (37.7843640908799, -122.412606542572) | |
| 6217 | 6217 | 83680 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/23/2015 03:26:00 PM | 3 | 6008994.04445 | 2113694.03545 | 37.784308507385504 | -122.412593075226 | (37.7843085073855, -122.412593075226) | |||
| 18569 | 18569 | 9792 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 36 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 19639 | 19639 | 9777 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
| 50158 | 50158 | 20507 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1211X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 78103 | 78103 | 22400 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5 | 4X4 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | |||
| 78217 | 78217 | 22401 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | |||
| 83331 | 83331 | 9776 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
| 85752 | 85752 | 20509 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1211X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 88734 | 88734 | 26148 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | |||
| 93843 | 93843 | 26146 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | |||
| 95897 | 95897 | 20508 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1211X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 96327 | 96327 | 9794 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 26 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 98448 | 98448 | 26147 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | |||
| 99178 | 99178 | 9800 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | ||
| 105542 | 105542 | 9791 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 105626 | 105626 | 22399 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | |||
| 106297 | 106297 | 9775 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 40 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
| 106561 | 106561 | 9778 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
| 108052 | 108052 | 101312 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 4244X 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 4x4 | 6001912.0 | 2104709.0 | 37.7592378221466 | -122.43645112889901 | (37.7592378221466, -122.436451128899) | |||
| 108709 | 108709 | 6291 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1700X Ellis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/04/2008 12:00:00 AM | 3 | 4x4 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | ||
| 109267 | 109267 | 26145 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | |||
| 109810 | 109810 | 9782 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/25/1997 12:00:00 AM | 12 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | ||
| 110369 | 110369 | 9799 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/30/2006 12:00:00 AM | 30 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | ||
| 111357 | 111357 | 96617 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ Valencia 19th St | 251 | Sidewalk: Property side : 26 | Tree 1 | Rec/Park 3 | Permit Number 771218 | 6006277.0 | 2104934.0 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | ||||
| 112097 | 112097 | 26150 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Oakdale Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | |||
| 114182 | 114182 | 9793 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 40 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 114266 | 114266 | 9773 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/25/1997 12:00:00 AM | 18 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | ||
| 117126 | 117126 | 9781 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
| 117973 | 117973 | 9795 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 26 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 123639 | 123639 | 9780 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | |||
| 124786 | 124786 | 22398 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | |||
| 126377 | 126377 | 9774 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/26/1992 12:00:00 AM | 34 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | ||
| 128126 | 128126 | 9796 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/08/2006 12:00:00 AM | 3X3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 129343 | 129343 | 9783 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) |
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");