trees

261 rows where qSpecies_id = 177 sorted by TreeID descending

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

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)
142116 99931 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 801X Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2012 12:00:00 AM   3x3 Permit Number 768924 6003100.6 2103580.4 37.7562064244422 -122.432259777723 (37.7562064244422, -122.432259777723) 2 4 5 28862 22
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
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
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
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
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
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
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
119291 93577 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 2998 San Jose Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   09/13/2010 12:00:00 AM 6 3x3 Permit Number 53727 5995937.7 2087355.5 37.711248045329 -122.455858535778 (37.711248045329, -122.455858535778) 9 8 6 28861 24
108273 93575 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 2998 San Jose Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   09/13/2010 12:00:00 AM   3x3 Permit Number 53727 5995937.7 2087355.5 37.711248045329 -122.455858535778 (37.711248045329, -122.455858535778) 9 8 6 28861 24
60053 93574 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 2998 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   09/13/2010 12:00:00 AM   3x3 Permit Number 53727 5995937.7 2087355.5 37.711248045329 -122.455858535778 (37.711248045329, -122.455858535778) 9 8 6 28861 24
129328 92913 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 87 Ramona Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2009 12:00:00 AM 3 6x12 Permit Number 53113 6005252.7 2107310.7 37.7665707358936 -122.425082484344 (37.7665707358936, -122.425082484344) 8 4 5 28853 19
162432 92388 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 170 Park St   Sidewalk: Curb side : Cutout Tree Private 2   07/29/2009 12:00:00 AM   3x3 Permit Number 52791 6005986 2096352 37.7365220626686 -122.421767651977 (37.7365220626686, -122.421767651977) 2 7 7 28859 2
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
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
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
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
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
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
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
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
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
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
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
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
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
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
179281 76817 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1320 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2012 12:00:00 AM   3x3 Permit Number 768047 6006034.8249105 2120045.34367344 37.8015810844337 -122.423282592369 (37.8015810844337, -122.423282592369) 5 9 1 28858 32
85994 76813 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1320 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.8015810844337 -122.423282592369 (37.8015810844337, -122.423282592369) 5 9 1 28858 32
106404 76809 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1320 Lombard St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.8015810844337 -122.423282592369 (37.8015810844337, -122.423282592369) 5 9 1 28858 32
53958 76804 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1320 Lombard St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.8015810844337 -122.423282592369 (37.8015810844337, -122.423282592369) 5 9 1 28858 32
185355 76799 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1320 Lombard St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.8015810844337 -122.423282592369 (37.8015810844337, -122.423282592369) 5 9 1 28858 32
91598 76793 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1320 Lombard St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.8015810844337 -122.423282592369 (37.8015810844337, -122.423282592369) 5 9 1 28858 32
46430 76789 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1320 Lombard St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.8015810844337 -122.423282592369 (37.8015810844337, -122.423282592369) 5 9 1 28858 32
178606 76782 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1320 Lombard St 8 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.8015810844337 -122.423282592369 (37.8015810844337, -122.423282592369) 5 9 1 28858 32
12471 76775 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1320 Lombard St 9 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.8015810844337 -122.423282592369 (37.8015810844337, -122.423282592369) 5 9 1 28858 32
133250 76766 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1320 Lombard St 10 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.8015810844337 -122.423282592369 (37.8015810844337, -122.423282592369) 5 9 1 28858 32
51070 76761 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1320 Lombard St 11 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.8015810844337 -122.423282592369 (37.8015810844337, -122.423282592369) 5 9 1 28858 32
156289 76753 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1320 Lombard St 12 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.8015810844337 -122.423282592369 (37.8015810844337, -122.423282592369) 5 9 1 28858 32
158445 76746 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1320 Lombard St 13 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.8015810844337 -122.423282592369 (37.8015810844337, -122.423282592369) 5 9 1 28858 32
123948 75029 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 141X Arleta Ave 1 Sidewalk: Curb side : Cutout Tree PUC 8 FUF 02/24/2016 12:00:00 AM 3   This record is for lthe ot between 141-143 Arleta Ave. 6010470.01061258 2087860.00753073 37.7134566637798 -122.405666490875 (37.7134566637798, -122.405666490875) 9 7 8 309 39
132603 74892 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 141X Arleta Ave 2 Sidewalk: Curb side : Cutout Tree PUC 8 FUF 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.7134566637798 -122.405666490875 (37.7134566637798, -122.405666490875) 9 7 8 309 39
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
108474 63786 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 4035 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/02/2009 12:00:00 AM   3x3 Permit Number 52930 6003624.27213054 2101252.89355661 37.7498453184987 -122.43028269297 (37.7498453184987, -122.43028269297) 2 4 5 28862 22
134325 60027 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 41 South Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/18/2013 12:00:00 AM     Permit Number 769856 6014655.81368733 2112837.99803451 37.7822741509003 -122.392945269869 (37.7822741509003, -122.392945269869) 6 2 9 28856 6
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
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
145113 56806 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 806 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/1974 12:00:00 AM     Permit Number 14035 5999139.37670373 2107622.75358893 37.7670803223615 -122.446249761039 (37.7670803223615, -122.446249761039) 15 5 5 29492 9
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
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
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
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
141100 55048 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 3791 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2012 12:00:00 AM     Permit Number 768924 6003127.14535424 2103564.68904381 37.7561647909862 -122.432166852953 (37.7561647909862, -122.432166852953) 2 4 5 28862 22
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
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
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
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
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
132601 39630 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1568 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2010 12:00:00 AM   5x3 Permit Number 53204 5997924.75387781 2105264.0077583 37.7605343603066 -122.450280891235 (37.7605343603066, -122.450280891235) 15 5 11 29492 12
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
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
148366 30786 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 477 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2011 12:00:00 AM     Permit Number 768077 6013986.79222779 2112639.44439925 37.781691783585 -122.395245890478 (37.781691783585, -122.395245890478) 6 2 9 28856 6
175454 29909 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 515-519 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2016 07:29:00 AM 3 3x3   6009867.8709 2120537.6157 37.8031483182934 -122.410053228903 (37.8031483182934, -122.410053228903) 3 1 10 308 23
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                      
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
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
2745 260577 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 2301 San Jose Ave 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5 MTA 09/25/2019 12:00:00 AM 3 5x3 Permit Number 779319 5998691.65634515 2090728.63648601 37.72066757978 -122.446582741763 (37.72066757978, -122.446582741763) 9 7 6 28861 25
8356 260576 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 2301 San Jose Ave 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5 MTA 09/25/2019 12:00:00 AM 3 5x3 Permit Number 779319 5998691.65634515 2090728.63648601 37.72066757978 -122.446582741763 (37.72066757978, -122.446582741763) 9 7 6 28861 25
7157 260575 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 2301 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5 MTA 09/25/2019 12:00:00 AM 3 5x3 Permit Number 779319 5998691.65634515 2090728.63648601 37.72066757978 -122.446582741763 (37.72066757978, -122.446582741763) 9 7 6 28861 25
9505 260574 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 2301 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5 MTA 09/25/2019 12:00:00 AM 3 5x3 Permit Number 779319 5998691.65634515 2090728.63648601 37.72066757978 -122.446582741763 (37.72066757978, -122.446582741763) 9 7 6 28861 25
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                      
30538 258520 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 50 Hermann St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
49933 258519 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 50 Hermann St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
102904 258517 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 50 Hermann St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
30042 258516 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 50 Hermann St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
159702 258515 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 50 Hermann St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
94231 258514 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 50 Hermann St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
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
167690 256776 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 244 Ashton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/13/2018 12:00:00 AM 3 3x3 Permit Number 781951 5994190.23703 2091515.08881 37.7225688371899 -122.462199635944 (37.7225688371899, -122.462199635944) 9 8 4 28861 24
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
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
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
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                        
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                        
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                        
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                        
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
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
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
128647 255530 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 301 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6010757.6116 2120655.4263 37.8035216252403 -122.406982550515 (37.8035216252403, -122.406982550515) 3 1 10 308 23
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
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
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
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
94466 255395 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1385 Clay St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2018 12:00:00 AM 3 3x3   6008122.9402 2116875.02037 37.7929937885047 -122.415832123045 (37.7929937885047, -122.415832123045) 5 1 10 28858 21
128713 255394 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 1385 Clay St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2018 12:00:00 AM 3 3x3   6008122.9402 2116875.02037 37.7929937885047 -122.415832123045 (37.7929937885047, -122.415832123045) 5 1 10 28858 21
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
69900 254752 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 701 Lombard St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008942 2120384 37.8026745911634 -122.413246372322 (37.8026745911634, -122.413246372322) 3 1 10 308 23

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);