Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10102 | 10102 | 121489 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2 Judah St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | |||||||||
| 12866 | 12866 | 108593 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 530 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | |||||
| 80767 | 80767 | 37127 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1501 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 2x2 | Permit Number 39712 | 5981856.07887628 | 2104857.97095308 | 37.7584868087664 | -122.50582403113998 | (37.7584868087664, -122.50582403114) | ||
| 143361 | 143361 | 37129 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1501 46th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 2x2 | Permit Number 39712 | 5981856.07887628 | 2104857.97095308 | 37.7584868087664 | -122.50582403113998 | (37.7584868087664, -122.50582403114) | ||
| 150717 | 150717 | 100949 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1561 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2012 12:00:00 AM | 1 | Permit Number 769342 | 5982149.6 | 2104456.5 | 37.7574017552939 | -122.504779173294 | (37.7574017552939, -122.504779173294) | |
| 11726 | 11726 | 54377 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1454 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774580 | 5984357.5042 | 2105265.8509 | 37.7597536454069 | -122.49720322400299 | (37.7597536454069, -122.497203224003) |
| 43549 | 43549 | 43627 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2230 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2016 12:00:00 AM | 0 | 3x3 | Permit Number 775700 | 5985470.85834553 | 2100027.42958295 | 37.7454355618475 | -122.49296686595899 | (37.7454355618475, -122.492966865959) |
| 80243 | 80243 | 56898 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1886 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775792 | 5985700.55899725 | 2102390.4838018003 | 37.751937297297395 | -122.492346587933 | (37.7519372972974, -122.492346587933) | |||
| 93755 | 93755 | 115008 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 743 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | Permit Number 774445 | 5985969.5 | 2110831.9 | 37.775130796003204 | -122.49203801834601 | (37.7751307960032, -122.492038018346) | |||
| 38625 | 38625 | 98846 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2400 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768753 | 5986497.5 | 2103053.8 | 37.753805142535 | -122.48963946401501 | (37.753805142535, -122.489639464015) | |
| 66670 | 66670 | 98847 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2400 Noriega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768753 | 5986497.5 | 2103053.8 | 37.753805142535 | -122.48963946401501 | (37.753805142535, -122.489639464015) | |
| 162255 | 162255 | 98845 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2400 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768753 | 5986497.5 | 2103053.8 | 37.753805142535 | -122.48963946401501 | (37.753805142535, -122.489639464015) | |
| 107040 | 107040 | 119284 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 651 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2016 12:00:00 AM | 3 | 3x3 | 5987187.0 | 2111505.0 | 37.777050030999604 | -122.487875935939 | (37.7770500309996, -122.487875935939) | ||
| 142331 | 142331 | 119283 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 651 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2016 12:00:00 AM | 3 | 3x3 | 5987187.0 | 2111505.0 | 37.777050030999604 | -122.487875935939 | (37.7770500309996, -122.487875935939) | ||
| 117505 | 117505 | 105053 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 501X 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2013 12:00:00 AM | 3x3 | Permit Number 770390 | 5987510.95423 | 2112219.6423299997 | 37.779031128568796 | -122.48680778308001 | (37.7790311285688, -122.48680778308) | ||
| 99422 | 99422 | 90510 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 555 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988112.407888 | 2112207.812683 | 37.7790336942222 | -122.48472626983101 | (37.7790336942222, -122.484726269831) | |
| 102101 | 102101 | 90511 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 569 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988115.7266919995 | 2112113.5102150002 | 37.7787749594642 | -122.48470786940099 | (37.7787749594642, -122.484707869401) | |
| 118636 | 118636 | 90471 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 534 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5988147.641992 | 2112343.937312 | 37.779409506079396 | -122.484614370085 | (37.7794095060794, -122.484614370085) | |
| 66010 | 66010 | 90469 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 578 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988158.072517 | 2112047.558198 | 37.778596339842 | -122.48455654153601 | (37.778596339842, -122.484556541536) | |
| 81377 | 81377 | 683 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2340X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53450 | 5988222.7193 | 2114685.44657 | 37.7858429996456 | -122.484526443804 | (37.7858429996456, -122.484526443804) | |
| 90847 | 90847 | 90526 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 705 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988149.756261 | 2111164.589328 | 37.7761714707406 | -122.484520528522 | (37.7761714707406, -122.484520528522) | |
| 4303 | 4303 | 9125 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 5827 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2017 11:55:00 AM | 3 | 3X3 | 5988965.7697498 | 2112572.6420628 | 37.780085075713295 | -122.481800911494 | (37.7800850757133, -122.481800911494) | ||
| 22647 | 22647 | 9116 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 5757 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/2015 12:00:00 AM | 3 | 3x3 | 5989143.6236 | 2112579.8502 | 37.7801152084298 | -122.48118616959499 | (37.7801152084298, -122.481186169595) | ||
| 103124 | 103124 | 97293 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2154 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2011 12:00:00 AM | 3x3 | Permit Number 768386 | 5989030.8 | 2106542.7 | 37.7635322996796 | -122.481134285356 | (37.7635322996796, -122.481134285356) | ||
| 117154 | 117154 | 9031 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 5351 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5990365.52035 | 2112599.40799 | 37.7802398682569 | -122.476960548186 | (37.7802398682569, -122.476960548186) | ||
| 91959 | 91959 | 8974 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 5045 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5991343.5266 | 2112609.97523 | 37.780325569878705 | -122.473577979119 | (37.7803255698787, -122.473577979119) | ||
| 91935 | 91935 | 115289 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1425 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775512 | 5991747.8 | 2105705.5 | 37.761391146048496 | -122.47167612106001 | (37.7613911460485, -122.47167612106) | |||
| 79092 | 79092 | 115287 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1526 12th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 776185 | 5992489.2 | 2105046.7 | 37.759625121297795 | -122.469064003389 | (37.7596251212978, -122.469064003389) | |||
| 124414 | 124414 | 115297 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775683 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | |||
| 9756 | 9756 | 55923 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 530 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1973 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | 5992693.0422579 | 2103919.63429657 | 37.7565422691319 | -122.468277027995 | (37.7565422691319, -122.468277027995) | |
| 122477 | 122477 | 112777 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1899X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | Permit Number 774327 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | |||
| 125123 | 125123 | 112779 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1899X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | Permit Number 774327 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | |||
| 122604 | 122604 | 116372 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1306 10TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x8 | 5993057.0 | 2106542.0 | 37.7637636140689 | -122.46720900630899 | (37.7637636140689, -122.467209006309) | ||||
| 99223 | 99223 | 55389 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1386 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1972 12:00:00 AM | 3x3 | Permit Number 11326 | 5993364.66899649 | 2106056.80614716 | 37.762449154491 | -122.466109621957 | (37.762449154491, -122.466109621957) | ||
| 78961 | 78961 | 121107 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1391 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5993608.0 | 2106030.0 | 37.7623895873424 | -122.46526608917601 | (37.7623895873424, -122.465266089176) | ||
| 110276 | 110276 | 121108 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1391 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5993608.0 | 2106030.0 | 37.7623895873424 | -122.46526608917601 | (37.7623895873424, -122.465266089176) | ||
| 140842 | 140842 | 54801 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1301X 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1982 12:00:00 AM | 3x3 | Permit Number 20098 | 5994223.60304226 | 2106594.5281626997 | 37.7639751162558 | -122.463177926852 | (37.7639751162558, -122.463177926852) | ||
| 94581 | 94581 | 95578 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 501@ 6th Ave Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994244.0 | 2106639.0 | 37.764098399310704 | -122.463110607355 | (37.7640983993107, -122.463110607355) | |||||
| 4152 | 4152 | 216685 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 111 Ashton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:11:00 AM | 3 | Width 3ft | 5994133.1609 | 2090669.8719900001 | 37.720244788744104 | -122.46233566126101 | (37.7202447887441, -122.462335661261) | ||
| 140431 | 140431 | 107849 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1300x ANZA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5994625.0 | 2112199.0 | 37.7793866324847 | -122.46219610899901 | (37.7793866324847, -122.462196108999) | |||
| 10105 | 10105 | 121488 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 750 Parnassus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5994725.7235199995 | 2106063.1570900003 | 37.762545022051796 | -122.461402729778 | (37.7625450220518, -122.461402729778) | ||||
| 97623 | 97623 | 100396 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 500X Oak Park Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/18/2012 12:00:00 AM | 3 | 3x9 | Permit Number 769101 | 5994983.3 | 2103652.8 | 37.755941622135296 | -122.460337221652 | (37.7559416221353, -122.460337221652) | |
| 107527 | 107527 | 1444 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 151X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2009 12:00:00 AM | 3 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | ||
| 4501 | 4501 | 162764 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 919 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 10:56:00 AM | 3 | Width 0ft | 5995008.1104 | 2090049.4028900003 | 37.7185914714977 | -122.459266363268 | (37.7185914714977, -122.459266363268) | ||
| 4474 | 4474 | 162754 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 997x Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 11:43:00 AM | 3 | Width 0ft | 5995095.0 | 2090528.0 | 37.719910580533295 | -122.45900065774599 | (37.7199105805333, -122.459000657746) | ||
| 108737 | 108737 | 50468 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 10 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 778534 | 5995312.36828974 | 2100223.18422456 | 37.7465436862786 | -122.45895089565501 | (37.7465436862786, -122.458950895655) | |
| 55368 | 55368 | 105009 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 11 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2013 12:00:00 AM | 7 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.785789717987704 | -122.455998396638 | (37.7857897179877, -122.455998396638) | ||
| 57286 | 57286 | 105011 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 11 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.785789717987704 | -122.455998396638 | (37.7857897179877, -122.455998396638) | ||
| 135481 | 135481 | 105010 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 11 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.785789717987704 | -122.455998396638 | (37.7857897179877, -122.455998396638) | ||
| 89979 | 89979 | 93574 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2998 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2010 12:00:00 AM | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | ||
| 101908 | 101908 | 93575 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2998 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2010 12:00:00 AM | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | ||
| 108192 | 108192 | 93577 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2998 San Jose Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | |
| 89140 | 89140 | 24659 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 3299X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772930 | 5997061.39714 | 2112911.4526400003 | 37.7814828219847 | -122.453819096525 | (37.7814828219847, -122.453819096525) | |
| 87526 | 87526 | 97446 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 200X Parker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 3x3 | Permit Number 772930 | 5997060.8 | 2112843.2 | 37.7812953839865 | -122.453816232036 | (37.7812953839865, -122.453816232036) | ||
| 101543 | 101543 | 53808 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 200X Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 3x3 | Permit Number 772930 | 5997126.8655565 | 2112925.05365722 | 37.7815239200353 | -122.45359359095801 | (37.7815239200353, -122.453593590958) | ||
| 121335 | 121335 | 115253 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 20 Edgar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 772988 | 5997135.3 | 2090888.7 | 37.7210180538388 | -122.451974094521 | (37.7210180538388, -122.451974094521) | |||
| 106475 | 106475 | 39630 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1568 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 5x3 | Permit Number 53204 | 5997924.75387781 | 2105264.0077583 | 37.7605343603066 | -122.45028089123501 | (37.7605343603066, -122.450280891235) | ||
| 120569 | 120569 | 113398 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 603 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998367.0 | 2108846.0 | 37.7703949048055 | -122.44900941031099 | (37.7703949048055, -122.449009410311) | ||||
| 143509 | 143509 | 113397 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 603 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998367.0 | 2108846.0 | 37.7703949048055 | -122.44900941031099 | (37.7703949048055, -122.449009410311) | ||||
| 114161 | 114161 | 56806 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 806 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | Permit Number 14035 | 5999139.37670373 | 2107622.75358893 | 37.7670803223615 | -122.44624976103901 | (37.7670803223615, -122.446249761039) | |||
| 94607 | 94607 | 102914 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2848 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2013 12:00:00 AM | 3x3 | Permit Number 770041 | 5999369.2 | 2118090.3 | 37.7958346193373 | -122.446207883579 | (37.7958346193373, -122.446207883579) | ||
| 123028 | 123028 | 18540 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 60 Quartz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 2x2 | Permit Number 778371 | 5999060.658518599 | 2099832.0947892 | 37.745684600557794 | -122.445961639207 | (37.7456846005578, -122.445961639207) | ||
| 3762 | 3762 | 139362 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2869 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999793.3033 | 2114332.6333 | 37.7855412639984 | -122.44447021936199 | (37.7855412639984, -122.444470219362) | |||
| 560 | 560 | 131782 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2646 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | Permit Number 779549 | 6000337.27442 | 2118211.39807 | 37.7962223607332 | -122.442866875924 | (37.7962223607332, -122.442866875924) | ||
| 91320 | 91320 | 107140 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 250X Roosevelt Way | Median : Cutout 11 | Tree 1 | Private 1 | 08/01/2014 12:00:00 AM | 5x5 | Permit Number 773751 | 6000794.71275 | 2107196.95489 | 37.766005582708395 | -122.440493678393 | (37.7660055827084, -122.440493678393) | |||
| 63991 | 63991 | 115203 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2056 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 3 | Permit Number 775522 | 6001029.7 | 2112838.5 | 37.781509225585104 | -122.44008548171301 | (37.7815092255851, -122.440085481713) | ||
| 86990 | 86990 | 58070 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 4530 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/1977 12:00:00 AM | 2 | 6x9 | Permit Number 17040 | 6000943.54601309 | 2105249.62912473 | 37.7606671794335 | -122.439839263811 | (37.7606671794335, -122.439839263811) | |
| 113056 | 113056 | 106547 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 4509A 25th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2014 12:00:00 AM | 3x3 | Permit Number 772697 | 6000984.2 | 2101089.3 | 37.749246236919106 | -122.439400435576 | (37.7492462369191, -122.439400435576) | |||
| 82441 | 82441 | 16816 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2105 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/13/2015 01:25:00 PM | 3 | 4x4 | 6001234.7809998 | 2113147.0836075 | 37.7823681904894 | -122.43939812802799 | (37.7823681904894, -122.439398128028) | ||
| 121701 | 121701 | 108636 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 68 Mangels Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774603 | 6000942.00546 | 2095224.20835 | 37.7331396755893 | -122.439126041581 | (37.7331396755893, -122.439126041581) | |
| 84179 | 84179 | 98330 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 147 Alhambra St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001593.9 | 2120254.3 | 37.801903193112004 | -122.438665159251 | (37.801903193112, -122.438665159251) | ||
| 79096 | 79096 | 84742 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 147 Alhambra St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001618.0 | 2120311.0 | 37.8020602472718 | -122.438585827087 | (37.8020602472718, -122.438585827087) | ||
| 145289 | 145289 | 25159 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2600X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2015 12:55:00 PM | 3 | 3X3 | 6001683.708124 | 2105708.1424058997 | 37.7619682491468 | -122.43731221388599 | (37.7619682491468, -122.437312213886) | ||
| 141591 | 141591 | 118312 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2410 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002301.0 | 2116562.0 | 37.7918052987456 | -122.435953913571 | (37.7918052987456, -122.435953913571) | ||||
| 88959 | 88959 | 115768 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 210 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775810 | 6001697.3 | 2086437.3 | 37.709055747846705 | -122.43588629224399 | (37.7090557478467, -122.435886292244) | ||
| 128131 | 128131 | 115769 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 210 Drake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775810 | 6001697.3 | 2086437.3 | 37.709055747846705 | -122.43588629224399 | (37.7090557478467, -122.435886292244) | ||
| 87337 | 87337 | 117270 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 481 JERSEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6002050.0 | 2101440.0 | 37.750269772538296 | -122.435739974128 | (37.7502697725383, -122.435739974128) | |||
| 7217 | 7217 | 17911 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2321 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2016 10:58:00 AM | 3 | 3X3 | 6002821.482999999 | 2115107.812 | 37.7878420242306 | -122.434049048426 | (37.7878420242306, -122.434049048426) | ||
| 66027 | 66027 | 115194 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 4150 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 777365 | 6002684.1 | 2104186.2 | 37.757846181761295 | -122.433743471638 | (37.7578461817613, -122.433743471638) | |||
| 105773 | 105773 | 102005 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1703 CASTRO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776283 | 6002624.0 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | |
| 120000 | 120000 | 102006 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1703 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776283 | 6002624.0 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | |
| 92225 | 92225 | 55721 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 62 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/1973 12:00:00 AM | 30 | Permit Number 11744 | 6003135.04861118 | 2107940.94065447 | 37.768181370821 | -122.432452080859 | (37.768181370821, -122.432452080859) | ||
| 84703 | 84703 | 100649 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 50 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003141.0 | 2108015.0 | 37.76838505717971 | -122.432436785894 | (37.7683850571797, -122.432436785894) | ||||
| 85128 | 85128 | 55718 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 53 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/1973 12:00:00 AM | 12 | 6x7 | Permit Number 11741 | 6003183.88384083 | 2107999.49897853 | 37.7683449267986 | -122.43228734753401 | (37.7683449267986, -122.432287347534) | |
| 112828 | 112828 | 99931 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 801X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2012 12:00:00 AM | 3x3 | Permit Number 768924 | 6003100.6 | 2103580.4 | 37.756206424442205 | -122.432259777723 | (37.7562064244422, -122.432259777723) | ||
| 111637 | 111637 | 55048 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 3791 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2012 12:00:00 AM | Permit Number 768924 | 6003127.14535424 | 2103564.68904381 | 37.756164790986205 | -122.43216685295299 | (37.7561647909862, -122.432166852953) | |||
| 4886 | 4886 | 17862 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2121 Pine St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/31/2017 11:37:00 AM | 3 | 3X3 | 6003706.1864 | 2115222.5689 | 37.7882072868246 | -122.43099633374901 | (37.7882072868246, -122.430996333749) | ||
| 97656 | 97656 | 63786 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 4035 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2009 12:00:00 AM | 3x3 | Permit Number 52930 | 6003624.27213054 | 2101252.89355661 | 37.7498453184987 | -122.43028269297 | (37.7498453184987, -122.43028269297) | ||
| 106272 | 106272 | 115004 | Private 5 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1050 MCALLISTER ST | 1 | Front Yard : Cutout 8 | Tree 1 | Office of Mayor 21 | DPW 4 | 01/19/2016 09:19:00 AM | 3 | 3x3 | 6004148.0 | 2111858.0 | 37.778994045300706 | -122.42922772691401 | (37.7789940453007, -122.429227726914) | |
| 104629 | 104629 | 122520 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 250 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004004.54241313 | 2097731.78472111 | 37.740198698919 | -122.428716724311 | (37.740198698919, -122.428716724311) | ||||
| 81022 | 81022 | 116243 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229x HAIGHT ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
| 81344 | 81344 | 116244 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229x HAIGHT ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
| 85348 | 85348 | 116248 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229 HAIGHT ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
| 86226 | 86226 | 116252 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229 HAIGHT ST | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
| 92554 | 92554 | 116250 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229 HAIGHT ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
| 100241 | 100241 | 116246 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229 HAIGHT ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
| 102114 | 102114 | 116238 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229x HAIGHT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
| 102168 | 102168 | 116240 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229x HAIGHT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
| 104602 | 104602 | 116251 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229 HAIGHT ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
| 107993 | 107993 | 116249 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229 HAIGHT ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) |
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");