trees
341 rows where qLegalStatus_id = 8 sorted by PermitNotes descending
This data as json, CSV (advanced)
Zip Codes ✖
PlantType ✖
- Tree 327
- Landscaping 13
- tree 1
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24750 | 94468 | Property Tree 8 | Cupressus sempervirens :: Italian Cypress 204 | 4128 17th St | Sidewalk: Property side : Pot | Tree | Private 2 | in landscaped area | 6001502 | 2105859 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | 15 | 5 | 5 | 28862 | 3 | |||||
71699 | 94469 | Property Tree 8 | Cupressus sempervirens :: Italian Cypress 204 | 4128 17th St | Sidewalk: Property side : Pot | Tree | Private 2 | in landscaped area | 6001502 | 2105859 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | 15 | 5 | 5 | 28862 | 3 | |||||
104809 | 94487 | Property Tree 8 | Cupressus sempervirens :: Italian Cypress 204 | 4128 17th St | Sidewalk: Property side : Pot | Tree | Private 2 | in landscaped area | 6001502 | 2105859 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | 15 | 5 | 5 | 28862 | 3 | |||||
150502 | 97162 | Property Tree 8 | Malus :: Crab Apple 82 | 478 10th Ave | Back Yard : Yard | Tree | Private 2 | Tree in backyard on private property; not significant. | 5992861.5 | 2112216.7 | 37.7793335349967 | -122.468298031686 | (37.7793335349967, -122.468298031686) | 11 | 6 | 2 | 54 | 11 | |||||
34602 | 97033 | Property Tree 8 | Afrocarpus gracilior :: Fern Pine 89 | 61 Vicksburg St | Back Yard : Yard | Tree | Private 2 | Possible significant tree; Nellie RoW; rear yard | 6004120 | 2102703 | 37.753855038047 | -122.428671801406 | (37.753855038047, -122.428671801406) | 2 | 4 | 5 | 28862 | 22 | |||||
33684 | 97290 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 55 Hiliritas Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 778896 | 6001461.7 | 2096833.2 | 37.7375871516219 | -122.437444499981 | (37.7375871516219, -122.437444499981) | 2 | 7 | 5 | 63 | 7 | |||||
30075 | 100070 | Property Tree 8 | Tree(s) :: 17 | 331 Serrano Dr | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 777990 | 5990400 | 2090718 | 37.7201612636948 | -122.475243338807 | (37.7201612636948, -122.475243338807) | 1 | 8 | 4 | 64 | 40 | ||||
48396 | 109097 | Property Tree 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 601 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774331 | 6002630.6 | 2098839.9 | 37.7431634703749 | -122.43354642925 | (37.7431634703749, -122.43354642925) | 2 | 7 | 5 | 63 | 7 |
90477 | 109091 | Property Tree 8 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 | 4235 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773805 | 6001611.4 | 2102294.1 | 37.7525900037408 | -122.43731782876 | (37.7525900037408, -122.43731782876) | 2 | 4 | 5 | 28862 | 22 |
106981 | 109092 | Property Tree 8 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 237 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773766 | 6004335.1 | 2099509.2 | 37.7450977767532 | -122.427700396282 | (37.7450977767532, -122.427700396282) | 2 | 7 | 5 | 63 | 22 |
194103 | 109076 | Property Tree 8 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1137 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 772744 | 6001554.7 | 2087011.6 | 37.7106245477128 | -122.436420213894 | (37.7106245477128, -122.436420213894) | 9 | 7 | 6 | 28861 | 5 | ||
129765 | 105353 | Property Tree 8 | Tree(s) :: 17 | 1979 SAN JOSE AVE | 2 | Front Yard : Yard | Tree | Private 2 | 04/16/2014 12:00:00 AM | 27 | Permit Number 772405 | 5999886.5 | 2092393.4 | 37.7253068164695 | -122.442572018552 | (37.7253068164695, -122.442572018552) | 9 | 7 | 6 | 28861 | 25 | ||
22174 | 33799 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |
27877 | 33781 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 200x misson st | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6013804.30364325 | 2116217.11127164 | 37.7915050790356 | -122.396128026757 | (37.7915050790356, -122.396128026757) | 12 | 2 | 9 | 28855 | 6 | |
31871 | 33776 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |
43580 | 33793 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |
54368 | 33775 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |
62239 | 33794 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |
71205 | 33789 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |
91079 | 33787 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |
140802 | 33786 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |
163103 | 33791 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |
167692 | 33790 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |
185435 | 33788 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |
166769 | 102079 | Property Tree 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 76 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769729 | 6008162.3 | 2099676.4 | 37.7457726186307 | -122.414478397936 | (37.7457726186307, -122.414478397936) | 2 | 7 | 7 | 28859 | 2 | |
124062 | 102101 | Property Tree 8 | Cordyline australis :: Dracena Palm 64 | 331 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769722 | 5992434.3 | 2090067.3 | 37.7184923011832 | -122.468164197766 | (37.7184923011832, -122.468164197766) | 9 | 8 | 6 | 64 | 24 |
12060 | 101900 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100 Ocean Ave | 1 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
54121 | 101901 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100 Ocean Ave | 2 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
128219 | 101903 | Property Tree 8 | Washingtonia robusta :: Mexican Fan Palm 72 | 1100 Ocean Ave | 4 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
144842 | 101905 | Property Tree 8 | Washingtonia robusta :: Mexican Fan Palm 72 | 1100 Ocean Ave | 6 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
191552 | 101904 | Property Tree 8 | Washingtonia robusta :: Mexican Fan Palm 72 | 1100 Ocean Ave | 5 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
120621 | 101625 | Property Tree 8 | Fagus sylvatica :: European Beech 272 | 64 Levant St | 1 | Front Yard : Cutout | Tree | Private 2 | Permit Number 769362 | 6000275.9 | 2106473.5 | 37.7639895997076 | -122.442236202383 | (37.7639895997076, -122.442236202383) | 15 | 5 | 5 | 28862 | 3 | ||||
58309 | 100046 | Property Tree 8 | Tree(s) :: 17 | 562 28th St | Front Yard : Yard | Tree | Private 2 | 11/28/2012 12:00:00 AM | 17 | Permit Number 769057 | 6002262 | 2099459 | 37.7448424535299 | -122.434865213189 | (37.7448424535299, -122.434865213189) | 2 | 7 | 5 | 63 | 22 | |||
1694 | 100166 | Property Tree 8 | Salix spp :: Willow 203 | 2340 Twin Peaks Blvd | Front Yard : Yard | Tree | Private 2 | Permit Number 769026 | |||||||||||||||
95526 | 100139 | Property Tree 8 | Tree(s) :: 17 | 155 05th St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.7821253339557 | -122.405491786923 | (37.7821253339557, -122.405491786923) | 12 | 2 | 9 | 28853 | 34 | ||||
68497 | 99961 | Property Tree 8 | Callistemon citrinus :: Lemon Bottlebrush 67 | 537 Valley St | 1 | Front Yard : Yard | Tree | Private 2 | 07/25/2012 12:00:00 AM | Permit Number 768880 | 6002459 | 2099152 | 37.7440106863694 | -122.434162082356 | (37.7440106863694, -122.434162082356) | 2 | 7 | 5 | 63 | 22 | |||
20715 | 99276 | Property Tree 8 | Tree(s) :: 17 | 85X 10th St | 2 | Front Yard : Yard | Tree | Private 2 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | 8 | 2 | 9 | 28853 | 34 | |||
89589 | 99277 | Property Tree 8 | Tree(s) :: 17 | 85X 10th St | 3 | Front Yard : Yard | Tree | Private 2 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | 8 | 2 | 9 | 28853 | 34 | |||
103261 | 99275 | Property Tree 8 | Tree(s) :: 17 | 85X 10th St | 1 | Front Yard : Yard | Tree | Private 2 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | 8 | 2 | 9 | 28853 | 34 | |||
124823 | 98405 | Property Tree 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 84 Richland Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2012 12:00:00 AM | Permit Number 768549 | 6005038.1 | 2096133 | 37.735867237922 | -122.425029371072 | (37.735867237922, -122.425029371072) | 2 | 7 | 5 | 28859 | 2 | ||||
53202 | 102251 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 125X Powhattan Ave | 4 | Front Yard : Yard | Tree | Private 2 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606 | 2098071 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | 2 | 7 | 7 | 28859 | 2 | |||
101616 | 102250 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125X Powhattan Ave | 3 | Front Yard : Yard | Tree | Private 2 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606 | 2098071 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | 2 | 7 | 7 | 28859 | 2 | |||
108303 | 102249 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125X Powhattan Ave | 2 | Front Yard : Yard | Tree | Private 2 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606 | 2098071 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | 2 | 7 | 7 | 28859 | 2 | |||
117229 | 102248 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125X Powhattan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606 | 2098071 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | 2 | 7 | 7 | 28859 | 2 | |||
122314 | 97023 | Property Tree 8 | Jacaranda mimosifolia :: Jacaranda 50 | 1443 Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768190 | 6009347.4 | 2100788.9 | 37.7488938036461 | -122.410459018192 | (37.7488938036461, -122.410459018192) | 2 | 4 | 7 | 28859 | 19 | ||||
94159 | 97024 | Property Tree 8 | Jacaranda mimosifolia :: Jacaranda 50 | 1455 Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768189 | 6009349 | 2100759.5 | 37.7488131674601 | -122.410451409671 | (37.7488131674601, -122.410451409671) | 2 | 4 | 7 | 28859 | 19 | ||||
39203 | 97052 | Property Tree 8 | Pyrus spp :: Pear Tree 281 | 795 Wisconsin St | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.398775590174 | (37.7574425906128, -122.398775590174) | 10 | 3 | 8 | 28856 | 29 | |||
51341 | 97051 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 795 Wisconsin St | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.398775590174 | (37.7574425906128, -122.398775590174) | 10 | 3 | 8 | 28856 | 29 | |||
7701 | 97237 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125 Excelsior Ave | Sidewalk: Property side : Yard | Tree | SFUSD 4 | FUF | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911 | 2092621.3 | 37.7261045201699 | -122.432132888294 | (37.7261045201699, -122.432132888294) | 9 | 7 | 6 | 28861 | 5 | |||
21821 | 97236 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 125 Excelsior Ave | Sidewalk: Property side : Yard | Tree | SFUSD 4 | FUF | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911 | 2092621.3 | 37.7261045201699 | -122.432132888294 | (37.7261045201699, -122.432132888294) | 9 | 7 | 6 | 28861 | 5 | |||
106561 | 97238 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125 Excelsior Ave | 1 | Sidewalk: Property side : Yard | Tree | SFUSD 4 | FUF | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767513 | 6002911 | 2092621.3 | 37.7261045201699 | -122.432132888294 | (37.7261045201699, -122.432132888294) | 9 | 7 | 6 | 28861 | 5 |
53937 | 94690 | Property Tree 8 | Brachychiton populneus :: Bottle Tree 348 | 749 Congo St | Front Yard : Yard | Tree | Private 2 | 10/28/2010 12:00:00 AM | Permit Number 53820 | 6000274 | 2096023 | 37.735294937499 | -122.441492809367 | (37.735294937499, -122.441492809367) | 9 | 7 | 4 | 63 | 40 | ||||
162706 | 94228 | Property Tree 8 | Acer palmatum :: Japanese Maple 216 | 1097 Church St | Front Yard : Yard | Tree | Private 2 | 06/25/2010 12:00:00 AM | Permit Number 53567 | 6004455 | 2102510 | 37.7533440588084 | -122.427499544702 | (37.7533440588084, -122.427499544702) | 2 | 4 | 5 | 28862 | 22 | ||||
120627 | 100045 | Property Tree 8 | Acacia decurrens :: Acacia: Silver Wattle 111 | 556 28th St | Front Yard : Yard | Tree | Private 2 | Not sure which property tree is located on. | 6002301 | 2099461 | 37.7448501592716 | -122.434730501666 | (37.7448501592716, -122.434730501666) | 2 | 7 | 5 | 63 | 22 | |||||
92154 | 97177 | Property Tree 8 | Tree(s) :: 17 | 257 Roosevelt Way | Back Yard : Yard | Tree | Private 2 | Monterey cypress tree in backyard on private property; not a Significant tree | 6000848.1 | 2107127.9 | 37.7658190148973 | -122.440304070451 | (37.7658190148973, -122.440304070451) | 15 | 5 | 5 | 28862 | 3 | |||||
141124 | 100244 | Property Tree 8 | Persea americana :: Avocado 34 | 71 Sanchez St | Back Yard : Yard | Tree | Private 2 | Interior courtyard | 6003507 | 2107903 | 37.7680982797144 | -122.431162830878 | (37.7680982797144, -122.431162830878) | 7 | 9 | 5 | 28862 | 3 | |||||
19898 | 98265 | Property Tree 8 | Pinus pinea :: Italian Stone Pine 63 | 755 O'Farrell St | Back Yard : Yard | Tree | Private 2 | Backyard tree; not significant | 6007700 | 2113968.3 | 37.7849888609023 | -122.417089467607 | (37.7849888609023, -122.417089467607) | 7 | 10 | 9 | 28858 | 36 | |||||
155860 | 96938 | Property Tree 8 | Tree(s) :: 17 | 1306 Cole St | Back Yard : Yard | Tree | Private 2 | Backyard tree on private property | 5998246 | 2105961 | 37.7624665052811 | -122.449220068104 | (37.7624665052811, -122.449220068104) | 15 | 5 | 11 | 29492 | 9 | |||||
34 | 262408 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 66X Edgehill Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5994840 | 2098758 | 37.7424934921887 | -122.46047813267 | (37.7424934921887, -122.46047813267) | 1 | 8 | 4 | 59 | 40 | ||||
170 | 108637 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 15 TUCKER AVE | Back Yard : Yard | Tree | Private 2 | 6011049.2 | 2088423.2 | 37.7150354478954 | -122.403704200211 | (37.7150354478954, -122.403704200211) | 9 | 7 | 8 | 309 | 39 | ||||||
227 | 102275 | Property Tree 8 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard | Landscaping | Private 2 | 6001225.6 | 2097744.2 | 37.7400751189117 | -122.438326054857 | (37.7400751189117, -122.438326054857) | 2 | 7 | 5 | 63 | 7 | ||||||
342 | 115652 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 18 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
364 | 255980 | Property Tree 8 | Tree(s) :: 17 | 541 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000551 | 2110847 | 37.7760138103106 | -122.441598590487 | (37.7760138103106, -122.441598590487) | 15 | 5 | 11 | 29492 | 16 | ||||
390 | 255918 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 80 Molimo Dr | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5998634.42423 | 2096706.77911 | 37.7370788872961 | -122.447210599537 | (37.7370788872961, -122.447210599537) | 9 | 7 | 4 | 59 | 40 | ||||
533 | 257925 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 274 Staples Ave | Back Yard : Yard | Tree | Private 2 | 10x10 | 5998272.17919 | 2093819.44967 | 37.7291302611298 | -122.448255187535 | (37.7291302611298, -122.448255187535) | 9 | 7 | 4 | 28861 | 40 | |||||
628 | 256542 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 133 Olympia Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5996852 | 2101844 | 37.7510824274474 | -122.453744067192 | (37.7510824274474, -122.453744067192) | 1 | 5 | 4 | 63 | 38 | ||||
1189 | 261265 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 5 | Median : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
2059 | 264900 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 35X Parkridge Dr | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5999060 | 2101975 | 37.7515684597407 | -122.446118026985 | (37.7515684597407, -122.446118026985) | 2 | 5 | 5 | 63 | 38 | ||||
2474 | 256556 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 5 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:18:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
2998 | 261600 | Property Tree 8 | Acer macrophyllum :: Big Leaf Maple 180 | 451X Jersey St | 1 | Back Yard : Yard | Tree | Public Library 12 | 3x3 | 6002237 | 2101405 | 37.7501842910814 | -122.435090813874 | (37.7501842910814, -122.435090813874) | 2 | 4 | 5 | 28862 | 22 | ||||
3020 | 260513 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1990 41st Ave | 1 | Back Yard : Yard | Tree | Health Dept 13 | 10x10 | 5983703 | 2101544 | 37.7494961014415 | -122.499191781388 | (37.7494961014415, -122.499191781388) | 1 | 8 | 3 | 29491 | 35 | ||||
3739 | 261012 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 170 Otis St | 2 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6006561 | 2108839 | 37.7708409033816 | -122.420665800575 | (37.7708409033816, -122.420665800575) | 8 | 2 | 9 | 28853 | 19 | ||||
4239 | 258982 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 239 Panorama Dr | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997275 | 2101153 | 37.7492093542443 | -122.452231443092 | (37.7492093542443, -122.452231443092) | 1 | 5 | 4 | 63 | 38 | ||||
4401 | 258690 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100x Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
5288 | 260453 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 4 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
5745 | 193934 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | Width 3ft | 6016623.26344 | 2095403.70542 | 37.7345123576517 | -122.384923708478 | (37.7345123576517, -122.384923708478) | 10 | 3 | 8 | 58 | 1 | |||
5758 | 262529 | Property Tree 8 | Pinus pinea :: Italian Stone Pine 63 | 555 Portola Dr | 8 | Front Yard : Yard | Tree | SFUSD 4 | 10x10 | 5997546 | 2099815 | 37.7455510557903 | -122.451197845188 | (37.7455510557903, -122.451197845188) | 2 | 7 | 5 | 63 | 7 | ||||
5987 | 262213 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 66 Clarendon Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5997837 | 2104660 | 37.7588708842054 | -122.450540844653 | (37.7588708842054, -122.450540844653) | 15 | 5 | 11 | 28862 | 12 | ||||
6335 | 262305 | Property Tree 8 | Casuarina cunninghamiana :: Horsetail pine 112 | 100 Saint Elmo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994960 | 2094889 | 37.7318770738882 | -122.459783023889 | (37.7318770738882, -122.459783023889) | 9 | 8 | 4 | 59 | 40 | ||||
6585 | 260539 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1230 Twin Peaks Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997905 | 2100119 | 37.7464063138276 | -122.449978390477 | (37.7464063138276, -122.449978390477) | 2 | 5 | 4 | 63 | 38 | ||||
6943 | 262154 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 519 22nd Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5989039 | 2111772 | 37.7778909946523 | -122.481488924787 | (37.7778909946523, -122.481488924787) | 11 | 6 | 2 | 55 | 26 | ||||
7179 | 260247 | Property Tree 8 | Magnolia spp :: Magnolia 224 | 568 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998297.39121 | 2088148.96817 | 37.7135618752392 | -122.447759972312 | (37.7135618752392, -122.447759972312) | 9 | 7 | 6 | 28861 | 25 | |||||
7677 | 258687 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 9 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
7863 | 260451 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 2 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
8082 | 96598 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
8587 | 260455 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 6 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
9009 | 258692 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 100x Whitney Young Cir | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | |||||
9029 | 258675 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 60 Laidley St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003232 | 2097949 | 37.7407513687421 | -122.431403364879 | (37.7407513687421, -122.431403364879) | 2 | 7 | 5 | 63 | 7 | ||||
9214 | 264784 | Property Tree 8 | Pinus halepensis :: Allepo Pine 330 | 67 Rosenkranz St | 3 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6009267 | 2098344 | 37.7421761391661 | -122.410564417702 | (37.7421761391661, -122.410564417702) | 10 | 7 | 7 | 28859 | 2 | ||||
9668 | 264919 | Property Tree 8 | Olea Majestic Beauty :: 183 | 1833 Page St | 1 | Sidewalk: Property side : Yard | Tree | Public Library 12 | 3x3 | 5997789 | 2108763 | 37.7701339345343 | -122.451002717521 | (37.7701339345343, -122.451002717521) | 15 | 5 | 11 | 29492 | 9 | ||||
10153 | 262205 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 2 Lois Ln | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6012244 | 2087959 | 37.7138275196569 | -122.39954186434 | (37.7138275196569, -122.39954186434) | 10 | 3 | 8 | 309 | 1 | ||||
10450 | 114373 | Property Tree 8 | Liquidambar styraciflua :: American Sweet Gum 37 | 805 GONZALEZ DR | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 5988302 | 2089566 | 37.7168763353695 | -122.482410970247 | (37.7168763353695, -122.482410970247) | 1 | 8 | 4 | 64 | 14 | ||||
10460 | 258772 | Property Tree 8 | Cupressus spp :: Cypress species 337 | 20 Crestline Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 5999139 | 2101332 | 37.7498074496931 | -122.445798597569 | (37.7498074496931, -122.445798597569) | 2 | 5 | 5 | 63 | 38 | |||
11932 | 252833 | Property Tree 8 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 98 Prosper St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
12066 | 258686 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 8 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
12415 | 258693 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 100 Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
12648 | 260457 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 8 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
13075 | 261490 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 4 | Median : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
13403 | 261178 | Property Tree 8 | Phoenix canariensis :: Canary Island Date Palm 160 | 205 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009827 | 2087549 | 37.7125667222905 | -122.407867055005 | (37.7125667222905, -122.407867055005) | 9 | 7 | 8 | 309 | 39 | ||||
13614 | 258670 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 152 Kensington Way | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994743 | 2098651 | 37.7421941161526 | -122.460805774677 | (37.7421941161526, -122.460805774677) | 1 | 8 | 4 | 59 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );