trees
341 rows where qLegalStatus_id = 8 sorted by YCoord descending
This data as json, CSV (advanced)
DBH ✖
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26017 | 109376 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 3 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
64778 | 109377 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 4 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
84676 | 109375 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 2 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
137889 | 109378 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 5 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
155569 | 109374 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 1 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
173335 | 117644 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 1111X SANSOME ST | 1 | Back Yard : Yard | Tree | Private 2 | 3x30 | 6011937 | 2119613 | 37.8007253016149 | -122.402827843034 | (37.8007253016149, -122.402827843034) | 3 | 1 | 10 | 308 | 23 | ||||
141783 | 110320 | Property Tree 8 | :: 45 | 9 Imperial Aly | Back Yard : Yard | Landscaping | Private 2 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | 13 | 9 | 1 | 57 | 17 | ||||||
46823 | 103516 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 980 Green St | 1 | Back Yard : Yard | Tree | Private 2 | 6008298 | 2118971 | 37.7987586699451 | -122.415374854445 | (37.7987586699451, -122.415374854445) | 5 | 1 | 10 | 308 | 32 | |||||
113165 | 113482 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 2839 Pierce St | Back Yard : Yard | Tree | Private 2 | 6001345 | 2118077 | 37.7959107386074 | -122.439370308548 | (37.7959107386074, -122.439370308548) | 13 | 9 | 1 | 57 | 17 | ||||||
170932 | 102752 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 2452 Green St | Back Yard : Yard | Tree | Private 2 | 6001313 | 2117994 | 37.7956810212331 | -122.43947508164 | (37.7956810212331, -122.43947508164) | 13 | 9 | 1 | 57 | 17 | ||||||
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 | |
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 | |
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 | |
31670 | 104539 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 1101 Van Ness Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6006375.5 | 2114401.9 | 37.7861048214583 | -122.421702631224 | (37.7861048214583, -122.421702631224) | 13 | 9 | 11 | 28858 | 41 | |||||
49750 | 104540 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 1101 Van Ness Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6006375.5 | 2114401.9 | 37.7861048214583 | -122.421702631224 | (37.7861048214583, -122.421702631224) | 13 | 9 | 11 | 28858 | 41 | |||||
52825 | 104544 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 1101 Van Ness Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6006375.5 | 2114401.9 | 37.7861048214583 | -122.421702631224 | (37.7861048214583, -122.421702631224) | 13 | 9 | 11 | 28858 | 41 | |||||
86207 | 104538 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 1101 Van Ness Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6006375.5 | 2114401.9 | 37.7861048214583 | -122.421702631224 | (37.7861048214583, -122.421702631224) | 13 | 9 | 11 | 28858 | 41 | |||||
99497 | 104543 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 1101 Van Ness Ave | 7 | Front Yard : Yard | Tree | Private 2 | 6006375.5 | 2114401.9 | 37.7861048214583 | -122.421702631224 | (37.7861048214583, -122.421702631224) | 13 | 9 | 11 | 28858 | 41 | |||||
101786 | 104542 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 1101 Van Ness Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6006375.5 | 2114401.9 | 37.7861048214583 | -122.421702631224 | (37.7861048214583, -122.421702631224) | 13 | 9 | 11 | 28858 | 41 | |||||
181064 | 104568 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 1101 Van Ness Ave | 9 | Front Yard : Yard | Tree | Private 2 | 6006375.5 | 2114401.9 | 37.7861048214583 | -122.421702631224 | (37.7861048214583, -122.421702631224) | 13 | 9 | 11 | 28858 | 41 | |||||
182344 | 104541 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 1101 Van Ness Ave | 5 | Front Yard : Yard | Tree | Private 2 | 6006375.5 | 2114401.9 | 37.7861048214583 | -122.421702631224 | (37.7861048214583, -122.421702631224) | 13 | 9 | 11 | 28858 | 41 | |||||
136282 | 110181 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 2620 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 1.5x4 | 5999902.8272 | 2114053.62 | 37.7847814144727 | -122.444071244627 | (37.7847814144727, -122.444071244627) | 15 | 6 | 1 | 29490 | 31 | |||
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 | |||||
98201 | 106968 | Property Tree 8 | :: 45 | 351 26th Ave | Back Yard : Yard | Tree | Private 2 | 5987720.26121 | 2113604.44601 | 37.7828456076198 | -122.486185401226 | (37.7828456076198, -122.486185401226) | 11 | 6 | 2 | 55 | 26 | ||||||
193463 | 102056 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 332 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5990007.7 | 2113121.3 | 37.7816520743217 | -122.478236569715 | (37.7816520743217, -122.478236569715) | 11 | 6 | 2 | 55 | 26 | |||||
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 | ||||
67079 | 251294 | Property Tree 8 | :: 45 | 7126 Geary Blvd | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5984860 | 2112552 | 37.7797887789018 | -122.496002892522 | (37.7797887789018, -122.496002892522) | 11 | 6 | 2 | 55 | 26 | ||||
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 | |||||
105239 | 110843 | Property Tree 8 | Pseudotsuga menziesii :: Douglas Fir 285 | 2037 TURK BLVD | Front Yard : Yard | Tree | Private 2 | 15 | 6000252 | 2111948 | 37.7790198360362 | -122.442711981138 | (37.7790198360362, -122.442711981138) | 15 | 5 | 11 | 29490 | 16 | |||||
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 | ||||
96626 | 91109 | Property Tree 8 | Tree(s) :: 17 | 2650 Turk Blvd | 2 | Front Yard : Yard | Tree | Private 2 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | 15 | 6 | 2 | 29492 | 16 | ||||
109556 | 91108 | Property Tree 8 | Tree(s) :: 17 | 2650 Turk Blvd | 1 | Front Yard : Yard | Tree | Private 2 | On campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | 15 | 6 | 2 | 29492 | 16 | ||||
87602 | 253142 | Property Tree 8 | Juniperus silicicola :: Southern red cedar 429 | 735 29th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5986898 | 2110914 | 37.7754104499772 | -122.488832209773 | (37.7754104499772, -122.488832209773) | 11 | 6 | 2 | 55 | 26 | ||||
163643 | 253143 | Property Tree 8 | Juniperus silicicola :: Southern red cedar 429 | 735 29th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5986898 | 2110914 | 37.7754104499772 | -122.488832209773 | (37.7754104499772, -122.488832209773) | 11 | 6 | 2 | 55 | 26 | ||||
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 | ||||
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 | |||
123806 | 256658 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 7014 Fulton St | 1 | Back Yard : Cutout | Tree | Private 2 | 5981603 | 2109659 | 37.7716541501084 | -122.507055421099 | (37.7716541501084, -122.507055421099) | 11 | 6 | 2 | 55 | 26 | |||||
71797 | 256101 | Property Tree 8 | Populus spp :: Poplar Spp 262 | 1255 Oak St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 6001013 | 2109627 | 37.7726903083913 | -122.439912920243 | (37.7726903083913, -122.439912920243) | 15 | 5 | 11 | 29492 | 9 | ||||
30353 | 105684 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 1 | Front Yard : Pot | Tree | Private 2 | 10 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
33251 | 105685 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 2 | Front Yard : Pot | Tree | Private 2 | 8 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
145638 | 105686 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 3 | Front Yard : Pot | Tree | Private 2 | 6 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | ||||
18405 | 261011 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 170 Otis St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6006561 | 2108839 | 37.7708409033816 | -122.420665800575 | (37.7708409033816, -122.420665800575) | 8 | 2 | 9 | 28853 | 19 | ||||
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 | ||||
104699 | 114731 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 934 BRANNAN ST | Back Yard : Yard | Tree | Private 2 | Dept of Real Estate | 10x10 | 6010724 | 2108745 | 37.7708165471861 | -122.406259194073 | (37.7708165471861, -122.406259194073) | 14 | 2 | 9 | 28853 | 34 | ||||
183366 | 251343 | Property Tree 8 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 934 Brannan St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6010724 | 2108745 | 37.7708165471861 | -122.406259194073 | (37.7708165471861, -122.406259194073) | 14 | 2 | 9 | 28853 | 34 | ||||
189109 | 120533 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 951 Brannan St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 22 | 3x3 | 6010745 | 2108673 | 37.7706200263658 | -122.406181480785 | (37.7706200263658, -122.406181480785) | 14 | 2 | 9 | 28853 | 34 | |||
80203 | 253469 | Property Tree 8 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 701 Stanyan St | 5 | Side Yard : Yard | Tree | Private 2 | 5997178 | 2108423 | 37.7691653834469 | -122.453091601514 | (37.7691653834469, -122.453091601514) | 15 | 5 | 11 | 29492 | 9 | |||||
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 | |||||
179317 | 103673 | Property Tree 8 | :: 45 | 64 Henry St | Back Yard : Yard | Tree | Private 2 | 6003097 | 2107420 | 37.7667488371496 | -122.432546472662 | (37.7667488371496, -122.432546472662) | 15 | 5 | 5 | 28862 | 3 | ||||||
163139 | 112668 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 129 Henry St | Back Yard : Yard | Tree | Private 2 | 6002668 | 2107340.8 | 37.7665070360696 | -122.434024647923 | (37.7665070360696, -122.434024647923) | 15 | 5 | 5 | 28862 | 3 | ||||||
142995 | 108574 | Property Tree 8 | Tree(s) :: 17 | 1891 15th St | 1 | Back Yard : Yard | Tree | Private 2 | 7x8 | 6004884.86016 | 2107160.44126 | 37.7661373754728 | -122.426344078904 | (37.7661373754728, -122.426344078904) | 8 | 4 | 5 | 28853 | 19 | ||||
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 | |||||
121285 | 104318 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 22 Beaver St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6002763 | 2106816 | 37.765071454108 | -122.433658549479 | (37.765071454108, -122.433658549479) | 15 | 5 | 5 | 28862 | 3 | ||||
101829 | 257926 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 8 Hill Point Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5996384 | 2106804 | 37.7646744896132 | -122.455720942569 | (37.7646744896132, -122.455720942569) | 15 | 5 | 11 | 29492 | 12 | ||||
35596 | 254587 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 1270 24th Ave | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5988678 | 2106679 | 37.7638860263594 | -122.482364481098 | (37.7638860263594, -122.482364481098) | 1 | 8 | 3 | 56 | 35 | ||||
39751 | 96590 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
44908 | 96593 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
63210 | 96591 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
81530 | 96594 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
145479 | 96592 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
156111 | 96589 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
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 | ||
34431 | 256554 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 3 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:10:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
90011 | 256555 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 4 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:48:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
175776 | 256557 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 6 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:44:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
176971 | 256553 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 2 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:24:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
189291 | 256552 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 1 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:54:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
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 | ||||
56024 | 105231 | Property Tree 8 | Pinus Spp :: Pine Spp 100 | 460X ROOSEVELT WAY | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 6000051 | 2106345 | 37.7636239504047 | -122.443004833609 | (37.7636239504047, -122.443004833609) | 15 | 5 | 5 | 29492 | 3 | ||||
177432 | 102706 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 1342 Funston Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5992135.4 | 2106294.8 | 37.7630316255695 | -122.470378504645 | (37.7630316255695, -122.470378504645) | 1 | 8 | 11 | 56 | 12 | |||||
149052 | 105232 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 460X ROOSEVELT WAY | 2 | Front Yard : Yard | Tree | Private 2 | 17 | 5999944 | 2106286 | 37.7634558498539 | -122.443370673769 | (37.7634558498539, -122.443370673769) | 15 | 5 | 5 | 29492 | 3 | ||||
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 | |||||
19875 | 96597 | 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 | |||||
33788 | 96601 | 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 | |||||
35006 | 96602 | 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 | |||||
120469 | 96606 | 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 | |||||
136541 | 96599 | 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 | |||||
138264 | 96604 | 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 | |||||
142618 | 96600 | 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 | |||||
184992 | 96603 | 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 | |||||
186894 | 96605 | 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 | |||||
116904 | 105236 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 235X STATES ST | 1 | Back Yard : Yard | Tree | Private 2 | 30 | 6001213 | 2106258 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | 15 | 5 | 5 | 28862 | 3 | ||||
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 | |||||
13841 | 252837 | Property Tree 8 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 98 Prosper St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
103773 | 252839 | Property Tree 8 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 99 Pond St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
136363 | 252834 | Property Tree 8 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 98 Prosper St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
183841 | 252835 | Property Tree 8 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 98 Prosper St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
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 |
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) );