Street_Tree_List

Data source: data.sfgov.org

191 rows where qSpecies = 80 sorted by YCoord

View and edit SQL

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 121489 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 2 Judah St 1 Median : Cutout 11 Tree 1 DPW 2       3x3            
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          
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 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)
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 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 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)
104270 75029 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 141X Arleta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13 FUF 1 02/24/2016 12:00:00 AM 3   This record is for lthe ot between 141-143 Arleta Ave. 6010470.01061258 2087860.00753073 37.713456663779795 -122.40566649087499 (37.7134566637798, -122.405666490875)
104340 74892 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 141X Arleta Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13 FUF 1 02/24/2016 12:00:00 AM 3   This is for the trees adjacent to the lot between 141-143 Arleta 6010470.01061258 2087860.00753073 37.713456663779795 -122.40566649087499 (37.7134566637798, -122.405666490875)
100092 112520 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 146x ARLETA AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6010471.0 2087928.0 37.7136434126305 -122.40566785728501 (37.7136434126305, -122.405667857285)
111595 112521 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 146x ARLETA AVE 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6010471.0 2087928.0 37.7136434126305 -122.40566785728501 (37.7136434126305, -122.405667857285)
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 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)
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)
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)
124233 114680 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 54 Colby St 1 Front Yard : Cutout 8 Tree 1 Private 1   12/01/2015 12:00:00 AM     Permit Number 774571 6007954.9 2093861.0 37.729793151999395 -122.414784067206 (37.7297931519994, -122.414784067206)
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)
120239 92388 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 170 Park St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/29/2009 12:00:00 AM   3x3 Permit Number 52791 6005986.0 2096352.0 37.7365220626686 -122.421767651977 (37.7365220626686, -122.421767651977)
43784 83046 Private 5 Olea europaea 'Fruitless' :: Fruitless Olive 80 100X Cargo Way 6 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/04/2006 12:00:00 AM 1     6018811.25128 2097616.11187 37.740707968002 -122.37751250161399 (37.740707968002, -122.377512501614)
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)
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)
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)
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)
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)
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 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)
110148 92047 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 2323 Cesar Chavez St   Sidewalk: Property side : Yard 9 Tree 1 DPW 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
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)
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)
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)
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)
93425 100044 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1250 De Haro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/27/2012 12:00:00 AM   3x3 Permit Number 768984 6012201.0 2102568.4 37.7539394855375 -122.400716201774 (37.7539394855375, -122.400716201774)
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 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 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)
78461 113802 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 806 SHOTWELL ST 4 Front Yard : Yard 7 Tree 1 Private 1           6007931.0 2103220.0 37.755489548438 -122.41552904166201 (37.755489548438, -122.415529041662)
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)
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)
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)
128798 116471 Section 143 8 Olea europaea 'Fruitless' :: Fruitless Olive 80 882 Carolina St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/04/2016 12:00:00 AM 3 3x3   6012399.9 2103853.8 37.757480004392 -122.40011862143601 (37.757480004392, -122.400118621436)
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)
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)
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)
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 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)
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)
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)
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)
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)
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)
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)
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 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)
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)
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)
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)
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)
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 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)
78192 109745 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 2730 16th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/03/2015 12:00:00 AM 3 3x3 Permit Number 769296 6008568.6 2106948.2 37.7657621501348 -122.413587690705 (37.7657621501348, -122.413587690705)
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)
108113 92913 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 87 Ramona Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/18/2009 12:00:00 AM 3 6x12 Permit Number 53113 6005252.7 2107310.7 37.7665707358936 -122.425082484344 (37.7665707358936, -122.425082484344)
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)
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)
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)
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)
89798 103596 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 10X Hermann St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005031.0649 2108842.56611 37.7707643495235 -122.42595813798201 (37.7707643495235, -122.425958137982)
101213 103593 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 10X Hermann St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005031.0649 2108842.56611 37.7707643495235 -122.42595813798201 (37.7707643495235, -122.425958137982)
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 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)
121859 103584 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 55X Laguna St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
142728 103585 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 55X Laguna St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
143605 103586 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 55X Laguna St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
19726 116259 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 155 LAGUNA ST 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
66020 116255 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 155 LAGUNA ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
90305 116261 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 155 LAGUNA ST 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
96610 116253 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 155 LAGUNA ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
98226 116254 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 155 LAGUNA ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
107711 116260 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 155 LAGUNA ST 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
142521 116257 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 155 LAGUNA ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
142800 116256 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 155 LAGUNA ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
143334 116258 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 155 LAGUNA ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
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 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 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 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 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 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 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 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 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 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)
108883 116245 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 229 HAIGHT ST 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
113421 116242 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 229x HAIGHT ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
114164 116239 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 229x HAIGHT ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
119717 116247 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 229 HAIGHT ST 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
126761 116241 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 229x HAIGHT ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
138577 103085 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 99 Colton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     2x3 See 55 Brady St; trees planted at same time with permits/FUF 6006671.4 2109566.7 37.7728452155106 -122.42033558182301 (37.7728452155106, -122.420335581823)
141309 103086 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 99 Colton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     2x3 See 55 Brady St; trees planted at same time with permits/FUF 6006671.4 2109566.7 37.7728452155106 -122.42033558182301 (37.7728452155106, -122.420335581823)
2783 252852 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 100X Langton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       2.5x4   6010166.0 2110701.0 37.776156040570996 -122.408327321329 (37.776156040571, -122.408327321329)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 70.499ms · Data source: data.sfgov.org