trees
341 rows where qLegalStatus_id = 8 sorted by qAddress
This data as json, CSV (advanced)
PlantDate ✖
- - 208
- 01/05/2015 12:00:00 AM 12
- 01/27/2015 12:00:00 AM 3
- 04/25/2012 12:00:00 AM 3
- 08/19/2011 12:00:00 AM 2
- 02/08/2012 12:00:00 AM 1
- 02/08/2019 08:44:00 AM 1
- 02/08/2019 08:48:00 AM 1
- 02/08/2019 08:54:00 AM 1
- 02/08/2019 09:10:00 AM 1
- 02/08/2019 09:18:00 AM 1
- 02/08/2019 09:24:00 AM 1
- 04/16/2014 12:00:00 AM 1
- 07/25/2012 12:00:00 AM 1
- 10/28/2010 12:00:00 AM 1
- 11/28/2012 12:00:00 AM 1
- 12/18/2012 12:00:00 AM 1
- 12/19/2012 12:00:00 AM 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64109 | 97027 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
71527 | 97029 | Property Tree 8 | Rhamnus californica :: Coffeeberry Tree 320 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
91643 | 97034 | Property Tree 8 | :: 45 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
92080 | 97016 | Property Tree 8 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
104074 | 97028 | Property Tree 8 | Morus alba :: White Mulberry 246 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
116957 | 97032 | Property Tree 8 | Griselinia lucida :: Griselinia 242 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
120723 | 97043 | Property Tree 8 | Heteromeles arbutifolia :: Toyon 186 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
175126 | 97044 | Property Tree 8 | Heteromeles arbutifolia :: Toyon 186 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
175634 | 97037 | Property Tree 8 | Griselinia lucida :: Griselinia 242 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
176465 | 97038 | Property Tree 8 | Hakea suaveolens :: Sweet Hakea Tree 73 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
179653 | 97035 | Property Tree 8 | Casurina stricta :: Beefwood: Drooping She-Oak 173 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
189767 | 97036 | Property Tree 8 | Griselinia lucida :: Griselinia 242 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
192727 | 97026 | Property Tree 8 | Tilia cordata :: Littleleaf Linden 12 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
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 | ||
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 | ||||
75714 | 114950 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1X WOODACRE DR | 2 | unknown : Yard | Tree | DPW 1 | 30x100 | 5991187 | 2095315 | 37.7328290635508 | -122.472857998502 | (37.7328290635508, -122.472857998502) | 1 | 8 | 4 | 64 | 40 | ||||
133884 | 114949 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1X WOODACRE DR | 1 | unknown : Yard | Tree | DPW 1 | 30 | 30x100 | 5991187 | 2095315 | 37.7328290635508 | -122.472857998502 | (37.7328290635508, -122.472857998502) | 1 | 8 | 4 | 64 | 40 | |||
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 | ||||
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 | |||
124153 | 118318 | Property Tree 8 | Maytenus boaria :: Mayten 58 | 20 Norton St | 1 | Front Yard : Yard | Tree | MTA 3 | 6002015.68632 | 2092167.12899 | 37.7248066672809 | -122.435195459751 | (37.7248066672809, -122.435195459751) | 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 | |
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 | |
112077 | 253339 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 2019X 24th Ave | 1 | Sidewalk: Property side : Yard | Tree | PUC 8 | 3x3 | 5988853 | 2101569 | 37.7498655183494 | -122.481384971136 | (37.7498655183494, -122.481384971136) | 1 | 8 | 3 | 29491 | 35 | ||||
44517 | 251117 | Property Tree 8 | Sequoiadendron giganteum :: Sierra Redwood 240 | 2024 Castro St | 1 | Back Yard : Yard | Tree | Private 2 | 6002622 | 2099601 | 37.7452527853239 | -122.433630548541 | (37.7452527853239, -122.433630548541) | 2 | 7 | 5 | 63 | 22 | |||||
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 | |||||
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 | ||||
96282 | 117254 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 2067 33RD AVE | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5985987 | 2101171 | 37.7486056682842 | -122.491266304796 | (37.7486056682842, -122.491266304796) | 1 | 8 | 3 | 29491 | 35 | ||||
30200 | 98503 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 208 Glenview Dr | Back Yard : Yard | Tree | Private 2 | 5998871 | 2100779 | 37.7482737407191 | -122.446685565827 | (37.7482737407191, -122.446685565827) | 2 | 5 | 5 | 63 | 38 | ||||||
26011 | 100148 | Property Tree 8 | Tree(s) :: 17 | 209 Vicksburg St | Back Yard : Yard | Tree | Private 2 | 6004141 | 2102142 | 37.7523158521071 | -122.428559192815 | (37.7523158521071, -122.428559192815) | 2 | 4 | 5 | 28862 | 22 | ||||||
27177 | 101951 | Property Tree 8 | Tree(s) :: 17 | 21 Lyell St | unknown : Yard | Tree | Private 2 | 6003106 | 2094969 | 37.7325618289587 | -122.43162632292 | (37.7325618289587, -122.43162632292) | 9 | 7 | 5 | 28861 | 25 | ||||||
15601 | 99374 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 21 Panorama Dr | Back Yard : Yard | Tree | Private 2 | 24 | 5998009 | 2100230 | 37.7467170430405 | -122.449626769288 | (37.7467170430405, -122.449626769288) | 1 | 5 | 4 | 63 | 38 | |||||
90504 | 98893 | Property Tree 8 | Tree(s) :: 17 | 216 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998910 | 2100761 | 37.7482265448319 | -122.446549410607 | (37.7482265448319, -122.446549410607) | 2 | 5 | 5 | 63 | 38 | ||||||
89692 | 122453 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 217 San Marcos Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5993325.07095 | 2100296.14299 | 37.7466295758311 | -122.465827998209 | (37.7466295758311, -122.465827998209) | 1 | 8 | 4 | 29491 | 40 | ||||
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 | ||||
105747 | 98892 | Property Tree 8 | Tree(s) :: 17 | 220 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998935 | 2100753 | 37.7482060067302 | -122.44646238624 | (37.7482060067302, -122.44646238624) | 2 | 5 | 5 | 63 | 38 | ||||||
44661 | 102745 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 222 Moncada Way | 1 | Front Yard : Yard | Tree | Private 2 | 5992354 | 2093377.4 | 37.7275763858966 | -122.468682482409 | (37.7275763858966, -122.468682482409) | 9 | 8 | 4 | 59 | 40 | |||||
13832 | 259913 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 23 Cresta Vista Dr | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5995254 | 2096176 | 37.7354277647167 | -122.45885975654 | (37.7354277647167, -122.45885975654) | 9 | 7 | 4 | 59 | 40 | ||||
60302 | 187670 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 230 Victoria St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5993274 | 2088748 | 37.7149182807441 | -122.465165952001 | (37.7149182807441, -122.465165952001) | 9 | 8 | 6 | 64 | 24 | ||||
101831 | 120995 | Property Tree 8 | Private shrub :: Private Shrub 284 | 231 Delano Ave | 1 | Front Yard : Yard | Landscaping | Private 2 | 3x3 | 6000066 | 2092260 | 37.7249507611268 | -122.44194193564 | (37.7249507611268, -122.44194193564) | 9 | 7 | 6 | 28861 | 25 | ||||
137488 | 98501 | Property Tree 8 | Tree(s) :: 17 | 232 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5998998 | 2100740 | 37.7481739100487 | -122.446243600021 | (37.7481739100487, -122.446243600021) | 2 | 5 | 5 | 63 | 38 | ||||||
1694 | 100166 | Property Tree 8 | Salix spp :: Willow 203 | 2340 Twin Peaks Blvd | Front Yard : Yard | Tree | Private 2 | Permit Number 769026 | |||||||||||||||
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 | ||||
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 |
99841 | 98436 | Property Tree 8 | Tree(s) :: 17 | 238 Glenview Dr | Back Yard : Yard | Tree | Private 2 | 5999035 | 2100736 | 37.7481650400364 | -122.446115368035 | (37.7481650400364, -122.446115368035) | 2 | 5 | 5 | 63 | 38 | ||||||
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 | ||||
139843 | 108680 | Property Tree 8 | Juniperus chinensis :: Juniper 113 | 240 SANTA ANA AVE | 1 | Back Yard : Yard | Tree | Private 2 | 5992606.9 | 2095181.7 | 37.7325451527527 | -122.46793939449 | (37.7325451527527, -122.46793939449) | 9 | 8 | 4 | 59 | 40 | |||||
54211 | 98502 | Property Tree 8 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5999066 | 2100737 | 37.7481695560511 | -122.446008243376 | (37.7481695560511, -122.446008243376) | 2 | 5 | 5 | 63 | 38 | ||||||
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 | ||||||
137283 | 109242 | Property Tree 8 | Private shrub :: Private Shrub 284 | 2479 DIAMOND ST | Sidewalk: Curb side : Yard | Landscaping | Private 2 | 6002238.1 | 2097343.7 | 37.7390329760373 | -122.434796615916 | (37.7390329760373, -122.434796615916) | 2 | 7 | 5 | 63 | 7 | ||||||
23775 | 108576 | Property Tree 8 | :: 45 | 2479 Diamond St | 1 | Front Yard : Yard | Landscaping | Private 2 | 6002240 | 2097369 | 37.7391025518434 | -122.434791855338 | (37.7391025518434, -122.434791855338) | 2 | 7 | 5 | 63 | 7 | |||||
176836 | 102639 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 251 Dorado Ter | 1 | Back Yard : Yard | Tree | Private 2 | 5994312.1 | 2092840.7 | 37.7262156610351 | -122.461874461465 | (37.7262156610351, -122.461874461465) | 9 | 8 | 4 | 28861 | 40 | |||||
20664 | 121198 | Property Tree 8 | Cordyline australis :: Dracena Palm 64 | 2521 18th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 5990743 | 2098231 | 37.740809941753 | -122.47460574514 | (37.740809941753, -122.47460574514) | 1 | 8 | 4 | 29491 | 40 | |||
168913 | 114365 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 2546 28th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 35 | 5987735.7 | 2097954.4 | 37.7398757613896 | -122.484983441996 | (37.7398757613896, -122.484983441996) | 1 | 8 | 3 | 29491 | 35 | ||||
113384 | 98890 | Property Tree 8 | Tree(s) :: 17 | 256 Glenview Dr | Back Yard : Yard | Landscaping | Private 2 | 5999134 | 2100748 | 37.7482036421854 | -122.44577389345 | (37.7482036421854, -122.44577389345) | 2 | 5 | 5 | 63 | 38 | ||||||
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 | |||||
176195 | 102381 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 258 Molimo Dr | Back Yard : Yard | Tree | Private 2 | 5997615 | 2096604 | 37.7367383790998 | -122.450727783905 | (37.7367383790998, -122.450727783905) | 9 | 7 | 4 | 59 | 40 | ||||||
127263 | 98715 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 26 Vernon St | Back Yard : Yard | Tree | Private 2 | 5992459 | 2088068 | 37.713004133171 | -122.467933479353 | (37.713004133171, -122.467933479353) | 9 | 8 | 6 | 64 | 24 | ||||||
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 | |||
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 | ||||
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 | ||||||
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 | |||||
28314 | 256608 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 279 Oak Park Dr | 2 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5995764 | 2102990 | 37.7541666190925 | -122.457589367448 | (37.7541666190925, -122.457589367448) | 1 | 5 | 4 | 63 | 12 | ||||
87678 | 254111 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 279 Oak Park Dr | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5995764 | 2102990 | 37.7541666190925 | -122.457589367448 | (37.7541666190925, -122.457589367448) | 1 | 5 | 4 | 63 | 12 | ||||
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 | ||||||
33827 | 99268 | Property Tree 8 | Tree(s) :: 17 | 292 Whitney St | Front Yard : Cutout | Tree | Private 2 | 6004280 | 2096681 | 37.7373290690714 | -122.427689454915 | (37.7373290690714, -122.427689454915) | 2 | 7 | 5 | 63 | 7 | ||||||
80950 | 255115 | Property Tree 8 | Lophostemon confertus :: Brisbane Box 11 | 301X Chester Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10x10 | 5991786 | 2087190 | 37.7105544703116 | -122.470195673297 | (37.7105544703116, -122.470195673297) | 9 | 8 | 4 | 64 | 24 | ||||
104559 | 254162 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 301X Chester Ave | 1 | Back Yard : Cutout | Tree | Private 2 | 10x10 | 5991786 | 2087190 | 37.7105544703116 | -122.470195673297 | (37.7105544703116, -122.470195673297) | 9 | 8 | 4 | 64 | 24 | ||||
153614 | 255116 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 301X Chester Ave | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 10x10 | 5991786 | 2087190 | 37.7105544703116 | -122.470195673297 | (37.7105544703116, -122.470195673297) | 9 | 8 | 4 | 64 | 24 | ||||
75016 | 98140 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 315 San Marcos Ave | Front Yard : Yard | Tree | Private 2 | 5992920.8 | 2100212.1 | 37.7463754865467 | -122.467219803339 | (37.7463754865467, -122.467219803339) | 1 | 8 | 4 | 29491 | 40 | ||||||
22171 | 251481 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 32 Peralta Ave | 1 | Back Yard : Yard | Tree | DPW 1 | 3x3 | 6010779 | 2100499 | 37.7481779538542 | -122.405488104269 | (37.7481779538542, -122.405488104269) | 2 | 7 | 7 | 28859 | 2 | ||||
28928 | 116154 | Property Tree 8 | Pinus Spp :: Pine Spp 100 | 324 POPE ST | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6000502 | 2087202 | 37.7110874704678 | -122.440072212787 | (37.7110874704678, -122.440072212787) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | |||||
42570 | 224716 | Property Tree 8 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3255x 24th St | 5 | Front Yard : Cutout | Tree | MTA 3 | 13 | Width 3ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
50874 | 225889 | Property Tree 8 | Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 474 | 3255x 24th St | 7 | Back Yard : Cutout | Tree | MTA 3 | 18 | Width 8ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
68467 | 224715 | Property Tree 8 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3255x 24th St | 4 | Front Yard : Cutout | Tree | MTA 3 | 12 | Width 3ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
99978 | 234895 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3255x 24th St | 6 | Side Yard : Cutout | Tree | Private 2 | 40 | Width 10ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
111666 | 225888 | Property Tree 8 | Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 474 | 3255x 24th St | 1 | Front Yard : Cutout | Tree | MTA 3 | 32 | 6x6 | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
141413 | 224714 | Property Tree 8 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3255x 24th St | 3 | Front Yard : Cutout | Tree | MTA 3 | 11 | Width 3ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
154580 | 224422 | Property Tree 8 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3255x 24th St | 2 | Front Yard : Cutout | Tree | MTA 3 | 16 | Width 3ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
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 |
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) );