trees
261 rows where qSpecies_id = 177 sorted by Fire Prevention Districts
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1346 | 260123 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3195X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2019 12:00:00 AM | 3 | 3x3 | ||||||||||||
2551 | 256191 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
4868 | 256192 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
6907 | 108593 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 530 Moraga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | ||||||||||
9500 | 256189 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
15675 | 256190 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
16520 | 121489 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Judah St | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | ||||||||||||||
17536 | 264654 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 999 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:51:00 PM | 3x3 | |||||||||||||
5376 | 203267 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Garcia Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781591 | 5995210.8831 | 2099639.94271 | 37.7449364165845 | -122.45925958957 | (37.7449364165845, -122.45925958957) | 1 | 8 | 4 | 59 | 40 | |
6587 | 261546 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1955 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2020 12:00:00 AM | 3 | 3X3 | Permit Number 783144 | 5985360.77923 | 2101907.46183 | 37.750591180724 | -122.493485992107 | (37.750591180724, -122.493485992107) | 1 | 8 | 3 | 29491 | 35 | |
10940 | 92249 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1382 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 52698 | 5985580.0638 | 2105823.8988 | 37.7613574627672 | -122.493016162233 | (37.7613574627672, -122.493016162233) | 1 | 8 | 3 | 56 | 35 | |
11531 | 203268 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Garcia Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781591 | 5995209.06254 | 2099610.1708 | 37.7448545656781 | -122.459263729153 | (37.7448545656781, -122.459263729153) | 1 | 8 | 4 | 59 | 40 | |
14369 | 203266 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Garcia Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781591 | 5995196 | 2099610 | 37.7448533456978 | -122.459308884303 | (37.7448533456978, -122.459308884303) | 1 | 8 | 4 | 59 | 40 | |
20330 | 115297 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775683 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | 1 | 8 | 4 | 29491 | 40 | |||
44103 | 115287 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1526 12th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776185 | 5992489.2 | 2105046.7 | 37.7596251212978 | -122.469064003389 | (37.7596251212978, -122.469064003389) | 1 | 8 | 4 | 56 | 12 | |||
45994 | 56898 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1886 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775792 | 5985700.55899725 | 2102390.4838018 | 37.7519372972974 | -122.492346587933 | (37.7519372972974, -122.492346587933) | 1 | 8 | 3 | 56 | 35 | |||
51392 | 37127 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1501 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 2x2 | Permit Number 39712 | 5981856.07887628 | 2104857.97095308 | 37.7584868087664 | -122.50582403114 | (37.7584868087664, -122.50582403114) | 1 | 8 | 3 | 56 | 35 | ||
53752 | 121107 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1391 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5993608 | 2106030 | 37.7623895873424 | -122.465266089176 | (37.7623895873424, -122.465266089176) | 1 | 8 | 11 | 56 | 12 | ||
66436 | 98847 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2400 Noriega St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768753 | 5986497.5 | 2103053.8 | 37.753805142535 | -122.489639464015 | (37.753805142535, -122.489639464015) | 1 | 8 | 3 | 56 | 35 | |
77118 | 100396 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 500X Oak Park Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/18/2012 12:00:00 AM | 3 | 3x9 | Permit Number 769101 | 5994983.3 | 2103652.8 | 37.7559416221353 | -122.460337221652 | (37.7559416221353, -122.460337221652) | 1 | 5 | 4 | 63 | 12 | |
77723 | 55923 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 530 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1973 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | 5992693.0422579 | 2103919.63429657 | 37.7565422691319 | -122.468277027995 | (37.7565422691319, -122.468277027995) | 1 | 8 | 4 | 56 | 12 | |
77781 | 115289 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1425 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775512 | 5991747.8 | 2105705.5 | 37.7613911460485 | -122.47167612106 | (37.7613911460485, -122.47167612106) | 1 | 8 | 4 | 56 | 12 | |||
88367 | 95578 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 501@ 6th Ave Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994244 | 2106639 | 37.7640983993107 | -122.463110607355 | (37.7640983993107, -122.463110607355) | 1 | 5 | 11 | 56 | 12 | |||||
105519 | 97293 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2154 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2011 12:00:00 AM | 3x3 | Permit Number 768386 | 5989030.8 | 2106542.7 | 37.7635322996796 | -122.481134285356 | (37.7635322996796, -122.481134285356) | 1 | 8 | 3 | 56 | 35 | ||
109612 | 55389 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1386 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1972 12:00:00 AM | 3x3 | Permit Number 11326 | 5993364.66899649 | 2106056.80614716 | 37.762449154491 | -122.466109621957 | (37.762449154491, -122.466109621957) | 1 | 8 | 11 | 56 | 12 | ||
114886 | 50468 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2016 12:00:00 AM | 3 | Permit Number 778534 | 5995312.36828974 | 2100223.18422456 | 37.7465436862786 | -122.458950895655 | (37.7465436862786, -122.458950895655) | 1 | 8 | 4 | 59 | 40 | |
116618 | 43627 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2230 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2016 12:00:00 AM | 0 | 3x3 | Permit Number 775700 | 5985470.85834553 | 2100027.42958295 | 37.7454355618475 | -122.492966865959 | (37.7454355618475, -122.492966865959) | 1 | 8 | 3 | 29491 | 35 |
143392 | 100949 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1561 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2012 12:00:00 AM | 1 | Permit Number 769342 | 5982149.6 | 2104456.5 | 37.7574017552939 | -122.504779173294 | (37.7574017552939, -122.504779173294) | 1 | 8 | 3 | 56 | 35 | |
143629 | 98845 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2400 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768753 | 5986497.5 | 2103053.8 | 37.753805142535 | -122.489639464015 | (37.753805142535, -122.489639464015) | 1 | 8 | 3 | 56 | 35 | |
147693 | 121108 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1391 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5993608 | 2106030 | 37.7623895873424 | -122.465266089176 | (37.7623895873424, -122.465266089176) | 1 | 8 | 11 | 56 | 12 | ||
163779 | 116372 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1306 10TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 5993057 | 2106542 | 37.7637636140689 | -122.467209006309 | (37.7637636140689, -122.467209006309) | 1 | 8 | 11 | 56 | 12 | ||||
170941 | 98846 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2400 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768753 | 5986497.5 | 2103053.8 | 37.753805142535 | -122.489639464015 | (37.753805142535, -122.489639464015) | 1 | 8 | 3 | 56 | 35 | |
171538 | 54801 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1301X 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1982 12:00:00 AM | 3x3 | Permit Number 20098 | 5994223.60304226 | 2106594.5281627 | 37.7639751162558 | -122.463177926852 | (37.7639751162558, -122.463177926852) | 1 | 5 | 11 | 56 | 12 | ||
175464 | 54377 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1454 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774580 | 5984357.5042 | 2105265.8509 | 37.7597536454069 | -122.497203224003 | (37.7597536454069, -122.497203224003) | 1 | 8 | 3 | 56 | 35 |
176540 | 37129 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1501 46th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 2x2 | Permit Number 39712 | 5981856.07887628 | 2104857.97095308 | 37.7584868087664 | -122.50582403114 | (37.7584868087664, -122.50582403114) | 1 | 8 | 3 | 56 | 35 | ||
2233 | 256484 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1047 Hollister Ave | 2 | unknown : Yard | Tree | Private 2 | Width 0ft | 6014610.748 | 2089844.7127 | 37.7191369573176 | -122.391493192738 | (37.7191369573176, -122.391493192738) | 10 | 3 | 8 | 58 | 1 | ||||
14797 | 264653 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 982 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:50:00 PM | 3x3 | 6014279.95597 | 2089795.48577 | 37.71898342396 | -122.39263318135 | (37.71898342396, -122.39263318135) | 10 | 3 | 8 | 58 | 1 | |||
18840 | 83046 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 1 | 6018811.25128 | 2097616.11187 | 37.740707968002 | -122.377512501614 | (37.740707968002, -122.377512501614) | 10 | 3 | 8 | 58 | 1 | ||||
34396 | 116471 | Section 143 10 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 882 Carolina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | 6012399.9 | 2103853.8 | 37.757480004392 | -122.400118621436 | (37.757480004392, -122.400118621436) | 10 | 3 | 8 | 28856 | 29 | |||
77303 | 100044 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1250 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2012 12:00:00 AM | 3x3 | Permit Number 768984 | 6012201 | 2102568.4 | 37.7539394855375 | -122.400716201774 | (37.7539394855375, -122.400716201774) | 10 | 3 | 8 | 28856 | 29 | ||
146054 | 92047 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2323 Cesar Chavez St | Sidewalk: Property side : Yard | Tree | DPW 1 | 05/16/2009 12:00:00 AM | 6012395.863444 | 2100936.77011 | 37.7494702500338 | -122.399927744224 | (37.7494702500338, -122.399927744224) | 10 | 3 | 8 | 58 | 1 | |||||
167508 | 256485 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1047 Hollister Ave | 3 | unknown : Yard | Tree | Private 2 | Width 0ft | 6014610.748 | 2089844.7127 | 37.7191369573176 | -122.391493192738 | (37.7191369573176, -122.391493192738) | 10 | 3 | 8 | 58 | 1 | ||||
13429 | 105011 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 11 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.7857897179877 | -122.455998396638 | (37.7857897179877, -122.455998396638) | 11 | 6 | 1 | 54 | 31 | ||
13736 | 90469 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 578 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988158.072517 | 2112047.558198 | 37.778596339842 | -122.484556541536 | (37.778596339842, -122.484556541536) | 11 | 6 | 2 | 55 | 26 | |
17835 | 146870 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 747 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:07:00 PM | 0 | Width 3ft | 5983198.23429 | 2110712.37785 | 37.7746402422966 | -122.501615441996 | (37.7746402422966, -122.501615441996) | 11 | 6 | 2 | 55 | 26 | ||
25056 | 105010 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 11 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.7857897179877 | -122.455998396638 | (37.7857897179877, -122.455998396638) | 11 | 6 | 1 | 54 | 31 | ||
35798 | 210473 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 855 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2016 12:00:00 AM | 14 | Width 3ft | Permit Number 41828 | 5993066.85825 | 2107284.57434 | 37.765803096459 | -122.467228905809 | (37.765803096459, -122.467228905809) | 11 | 8 | 11 | 56 | 12 | |
45539 | 683 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2340X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53450 | 5988222.7193 | 2114685.44657 | 37.7858429996456 | -122.484526443804 | (37.7858429996456, -122.484526443804) | 11 | 6 | 1 | 55 | 33 | |
57341 | 105009 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 11 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2013 12:00:00 AM | 7 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.7857897179877 | -122.455998396638 | (37.7857897179877, -122.455998396638) | 11 | 6 | 1 | 54 | 31 | ||
62962 | 97446 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 200X Parker Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2014 12:00:00 AM | 3x3 | Permit Number 772930 | 5997060.8 | 2112843.2 | 37.7812953839865 | -122.453816232036 | (37.7812953839865, -122.453816232036) | 11 | 6 | 2 | 54 | 16 | ||
68114 | 8974 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5045 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5991343.5266 | 2112609.97523 | 37.7803255698787 | -122.473577979119 | (37.7803255698787, -122.473577979119) | 11 | 6 | 2 | 54 | 26 | ||
72719 | 90526 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 705 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988149.756261 | 2111164.589328 | 37.7761714707406 | -122.484520528522 | (37.7761714707406, -122.484520528522) | 11 | 6 | 2 | 55 | 26 | |
76277 | 24659 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3299X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772930 | 5997061.39714 | 2112911.45264 | 37.7814828219847 | -122.453819096525 | (37.7814828219847, -122.453819096525) | 11 | 6 | 2 | 54 | 16 | |
99264 | 90510 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 555 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988112.407888 | 2112207.812683 | 37.7790336942222 | -122.484726269831 | (37.7790336942222, -122.484726269831) | 11 | 6 | 2 | 55 | 26 | |
100244 | 115008 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 743 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | Permit Number 774445 | 5985969.5 | 2110831.9 | 37.7751307960032 | -122.492038018346 | (37.7751307960032, -122.492038018346) | 11 | 6 | 2 | 55 | 26 | |||
104430 | 53808 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 200X Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2014 12:00:00 AM | 3x3 | Permit Number 772930 | 5997126.8655565 | 2112925.05365722 | 37.7815239200353 | -122.453593590958 | (37.7815239200353, -122.453593590958) | 11 | 6 | 2 | 54 | 16 | ||
109870 | 112779 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1899X Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774327 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | 11 | 6 | 2 | 54 | 11 | |||
110398 | 90511 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 569 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988115.726692 | 2112113.510215 | 37.7787749594642 | -122.484707869401 | (37.7787749594642, -122.484707869401) | 11 | 6 | 2 | 55 | 26 | |
124246 | 1444 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 151X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2009 12:00:00 AM | 3 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | 11 | 6 | 1 | 54 | 11 | ||
131941 | 9116 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5757 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/2015 12:00:00 AM | 3 | 3x3 | 5989143.6236 | 2112579.8502 | 37.7801152084298 | -122.481186169595 | (37.7801152084298, -122.481186169595) | 11 | 6 | 2 | 55 | 26 | ||
153634 | 90471 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 534 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5988147.641992 | 2112343.937312 | 37.7794095060794 | -122.484614370085 | (37.7794095060794, -122.484614370085) | 11 | 6 | 2 | 55 | 26 | |
159293 | 9031 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5351 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5990365.52035 | 2112599.40799 | 37.7802398682569 | -122.476960548186 | (37.7802398682569, -122.476960548186) | 11 | 6 | 2 | 55 | 26 | ||
160746 | 105053 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 501X 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2013 12:00:00 AM | 3x3 | Permit Number 770390 | 5987510.95423 | 2112219.64233 | 37.7790311285688 | -122.48680778308 | (37.7790311285688, -122.48680778308) | 11 | 6 | 2 | 55 | 26 | ||
170987 | 9125 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5827 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2017 11:55:00 AM | 3 | 3X3 | 5988965.7697498 | 2112572.6420628 | 37.7800850757133 | -122.481800911494 | (37.7800850757133, -122.481800911494) | 11 | 6 | 2 | 55 | 26 | ||
177143 | 140885 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 112 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/04/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781739 | 5996566.0494 | 2113683.186 | 37.7835733852629 | -122.455588548359 | (37.7835733852629, -122.455588548359) | 11 | 6 | 1 | 54 | 31 | |
178223 | 256896 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 470 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780643 | 5985651.17942 | 2112710.44444 | 37.7802701294342 | -122.493277571063 | (37.7802701294342, -122.493277571063) | 11 | 6 | 2 | 55 | 26 | |
178780 | 112777 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1899X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774327 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | 11 | 6 | 2 | 54 | 11 | |||
185404 | 107849 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1300x ANZA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5994625 | 2112199 | 37.7793866324847 | -122.462196108999 | (37.7793866324847, -122.462196108999) | 11 | 6 | 2 | 54 | 11 | |||
3302 | 256186 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
4989 | 256185 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
6215 | 256187 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
11136 | 131782 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2646 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 779549 | 6000337.27442 | 2118211.39807 | 37.7962223607332 | -122.442866875924 | (37.7962223607332, -122.442866875924) | 13 | 9 | 1 | 57 | 17 | ||
16011 | 131781 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2758 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | Width 3ft | 5999580.2108 | 2118368.89391 | 37.7966116124855 | -122.445497792185 | (37.7966116124855, -122.445497792185) | 13 | 9 | 1 | 57 | 17 | ||
18862 | 256188 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
31119 | 255523 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
36912 | 46881 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2300@Green Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2012 12:00:00 AM | Permit Number 768822 | 6006358.85800747 | 2118685.04678939 | 37.7978643358127 | -122.422064597009 | (37.7978643358127, -122.422064597009) | 13 | 9 | 10 | 28858 | 32 | |||
38919 | 84742 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 147 Alhambra St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001618 | 2120311 | 37.8020602472718 | -122.438585827087 | (37.8020602472718, -122.438585827087) | 13 | 9 | 1 | 57 | 17 | ||
54873 | 98330 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 147 Alhambra St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001593.9 | 2120254.3 | 37.801903193112 | -122.438665159251 | (37.801903193112, -122.438665159251) | 13 | 9 | 1 | 57 | 17 | ||
70345 | 255525 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
74650 | 84929 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1500@Polk Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49344 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||
77164 | 17862 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2121 Pine St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2017 11:37:00 AM | 3 | 3X3 | 6003706.1864 | 2115222.5689 | 37.7882072868246 | -122.430996333749 | (37.7882072868246, -122.430996333749) | 13 | 9 | 11 | 29490 | 27 | ||
80914 | 255524 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
91107 | 102914 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2848 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2013 12:00:00 AM | 3x3 | Permit Number 770041 | 5999369.2 | 2118090.3 | 37.7958346193373 | -122.446207883579 | (37.7958346193373, -122.446207883579) | 13 | 9 | 1 | 57 | 17 | ||
93318 | 111178 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2109 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118096 | 37.7962471953974 | -122.422008397548 | (37.7962471953974, -122.422008397548) | 13 | 9 | 10 | 28858 | 32 | ||||
102669 | 255526 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
120674 | 124797 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2898 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780062 | 5999308.846 | 2118065.45598 | 37.7957629573367 | -122.446414930702 | (37.7957629573367, -122.446414930702) | 13 | 9 | 1 | 57 | 17 | |
124462 | 17911 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2321 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2016 10:58:00 AM | 3 | 3X3 | 6002821.483 | 2115107.812 | 37.7878420242306 | -122.434049048426 | (37.7878420242306, -122.434049048426) | 13 | 9 | 11 | 29490 | 27 | ||
125035 | 255253 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2178 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2018 12:00:00 AM | 3 | 3x3 | 6003537 | 2115267 | 37.7883196953611 | -122.43158486312 | (37.7883196953611, -122.43158486312) | 13 | 9 | 1 | 29490 | 27 | ||
170762 | 256228 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||||
172881 | 121042 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2101 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
181198 | 118312 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2410 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002301 | 2116562 | 37.7918052987456 | -122.435953913571 | (37.7918052987456, -122.435953913571) | 13 | 9 | 1 | 29490 | 27 | ||||
191012 | 137900 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2191 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/19/2013 12:00:00 AM | 11 | Width 0ft | 6003458.0512 | 2115193.5788 | 37.7881136242314 | -122.431852768372 | (37.7881136242314, -122.431852768372) | 13 | 9 | 11 | 29490 | 27 | ||
10503 | 233771 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 35 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2019 03:11:00 PM | 3 | Width 3ft | 6003168.16978 | 2108097.17278 | 37.7686122241979 | -122.432348677773 | (37.7686122241979, -122.432348677773) | 15 | 5 | 5 | 28862 | 3 | ||
54561 | 16816 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2105 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/13/2015 01:25:00 PM | 3 | 4x4 | 6001234.7809998 | 2113147.0836075 | 37.7823681904894 | -122.439398128028 | (37.7823681904894, -122.439398128028) | 15 | 5 | 11 | 29490 | 41 | ||
55911 | 100649 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003141 | 2108015 | 37.7683850571797 | -122.432436785894 | (37.7683850571797, -122.432436785894) | 15 | 5 | 5 | 28862 | 3 | ||||
57461 | 55718 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 53 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1973 12:00:00 AM | 12 | 6x7 | Permit Number 11741 | 6003183.88384083 | 2107999.49897853 | 37.7683449267986 | -122.432287347534 | (37.7683449267986, -122.432287347534) | 15 | 5 | 5 | 28862 | 3 | |
58624 | 58070 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 4530 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/1977 12:00:00 AM | 2 | 6x9 | Permit Number 17040 | 6000943.54601309 | 2105249.62912473 | 37.7606671794335 | -122.439839263811 | (37.7606671794335, -122.439839263811) | 15 | 4 | 5 | 28862 | 3 | |
61488 | 254585 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1236 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995818 | 2107128 | 37.7655316119834 | -122.457702020035 | (37.7655316119834, -122.457702020035) | 15 | 5 | 11 | 29492 | 12 | ||||
87120 | 107140 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 250X Roosevelt Way | Median : Cutout | Tree | Private 2 | 08/01/2014 12:00:00 AM | 5x5 | Permit Number 773751 | 6000794.71275 | 2107196.95489 | 37.7660055827084 | -122.440493678393 | (37.7660055827084, -122.440493678393) | 15 | 5 | 5 | 29492 | 3 | |||
92159 | 55721 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 62 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1973 12:00:00 AM | 30 | Permit Number 11744 | 6003135.04861118 | 2107940.94065447 | 37.768181370821 | -122.432452080859 | (37.768181370821, -122.432452080859) | 15 | 5 | 5 | 28862 | 3 |
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) );