261 rows where qSpecies_id = 177

View and edit SQL

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)
63720 13009 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 378 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/09/2016 02:11:00 PM 3 4X4   6010539.0395 2120665.4782 37.8035369920045 -122.407739641802 (37.8035369920045, -122.407739641802) 3 1 10 308 23
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
66864 117270 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 481 JERSEY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6002050 2101440 37.7502697725383 -122.435739974128 (37.7502697725383, -122.435739974128) 2 4 5 28862 22
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
68237 13015 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 407 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2016 12:00:00 AM 12 3X3   6010332.686 2120602.2788 37.8033519082048 -122.408449280112 (37.8033519082048, -122.408449280112) 3 1 10 308 23
69531 116248 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 12 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
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
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
70827 13016 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 407 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/16/2016 02:31:00 PM 3 3X3   6010356.171 2120603.3463 37.8033561544514 -122.408368084374 (37.8033561544514, -122.408368084374) 3 1 10 308 23
72042 13024 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 445 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/04/2014 02:58:00 PM 3 3X3   6010214.1933 2120583.5975 37.8032939775537 -122.40885801149 (37.8032939775537, -122.40885801149) 3 1 10 308 23
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
72976 13010 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 396 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/28/2015 07:16:00 AM 3 3X3   6010502.3453 2120665.4782 37.8035349377887 -122.407866624342 (37.8035349377887, -122.407866624342) 3 1 10 308 23
74050 103596 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 10X Hermann St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
74249 116261 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 9 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
74355 115438 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 2500X Larkin St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2016 12:00:00 AM 3   Permit Number 777506 6006688.6 2119773.1 37.8008704472237 -122.421000888697 (37.8008704472237, -122.421000888697) 5 9 1 28858 32
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
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
76872 13011 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 396 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/28/2015 07:12:00 AM 3 3X3   6010476.6325 2120660.3892 37.8035195251148 -122.40795524598 (37.8035195251148, -122.40795524598) 3 1 10 308 23
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
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
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
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
77866 13055 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 570 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2016 08:41:00 AM 3 3x3   6009605.5749 2120542.0431 37.8031457701614 -122.410961227909 (37.8031457701614, -122.410961227909) 3 1 10 308 23
78246 143041 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 2000 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2017 12:00:00 AM 3 Width 0ft Permit Number 780933 6009568.471 2120534.3867 37.8031226669303 -122.411089086343 (37.8031226669303, -122.411089086343) 3 1 10 308 23
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
83725 13075 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 645X Lombard St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5   01/22/2015 12:00:00 AM 3 3X3 Permit Number 774508 6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156) 3 1 10 308 23
83740 116253 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
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
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
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
88961 252853 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 100X Langton St 2 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6010166 2110701 37.776156040571 -122.408327321329 (37.776156040571, -122.408327321329) 8 2 9 28853 34
90969 115004 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 1050 MCALLISTER ST 5 Front Yard : Cutout Tree Office of Mayor 9 DPW 01/19/2016 09:19:00 AM 3 3x3   6004148 2111858 37.7789940453007 -122.429227726914 (37.7789940453007, -122.429227726914) 7 9 11 29490 41
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
91501 12995 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 336 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6010707.244 2120695.2086 37.8036280390364 -122.407159656622 (37.8036280390364, -122.407159656622) 3 1 10 308 23
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
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
92392 116250 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 14 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
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
94001 143039 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 520 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   6009841.4502 2120571.1962 37.8032390411539 -122.410147031042 (37.8032390411539, -122.410147031042) 3 1 10 308 23
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
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
95489 103593 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 10X Hermann St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005031.0649 2108842.56611 37.7707643495235 -122.425958137982 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
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
101932 116717 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 690X 03RD ST 4 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2003 12:00:00 AM 5 3x3   6014548 2111604 37.7788798826953 -122.393231883862 (37.7788798826953, -122.393231883862) 6 2 9 28856 34
102162 216685 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 111 Ashton Ave 2 Sidewalk: Curb side : Yard Tree Private 2   10/06/2017 08:11:00 AM 3 Width 3ft   5994133.1609 2090669.87199 37.7202447887441 -122.462335661261 (37.7202447887441, -122.462335661261) 9 8 6 28861 24
102218 252854 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 100X Langton St 1 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6010166 2110701 37.776156040571 -122.408327321329 (37.776156040571, -122.408327321329) 8 2 9 28853 34
102477 116246 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 9 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
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
102780 116254 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 2 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 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
103816 116240 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229x HAIGHT ST 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
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
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
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
107470 112520 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 146x ARLETA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010471 2087928 37.7136434126305 -122.405667857285 (37.7136434126305, -122.405667857285) 9 7 8 309 39
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
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
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
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
111732 12989 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 325 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2017 12:00:00 AM 3 3X3 Permit Number 780097 6010757.6116 2120655.4263 37.8035216252403 -122.406982550515 (37.8035216252403, -122.406982550515) 3 1 10 308 23
113350 116238 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229x HAIGHT ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
114150 104604 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 10X Russell St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/21/2013 12:00:00 AM   2x3 Permit Number 770083 6007114.43488 2118959.67619 37.7986609851308 -122.419469576763 (37.7986609851308, -122.419469576763) 5 1 10 28858 32
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
114910 102005 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 1703 CASTRO ST 2 Sidewalk: Curb side : Cutout Tree Private 2   01/26/2016 12:00:00 AM 3 3x3 Permit Number 776283 6002624 2100623.7 37.7480609930318 -122.433696712327 (37.7480609930318, -122.433696712327) 2 4 5 63 22
114926 116249 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 13 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
115031 122520 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 250 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004004.54241313 2097731.78472111 37.740198698919 -122.428716724311 (37.740198698919, -122.428716724311) 2 7 5 63 7
116521 143019 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 410 LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6010368.5125 2120644.4743 37.8034697728784 -122.408328278578 (37.8034697728784, -122.408328278578) 3 1 10 308 23
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
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
120038 116245 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 8 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
120178 116251 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229 HAIGHT ST 15 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
120504 254750 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 701 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008942 2120384 37.8026745911634 -122.413246372322 (37.8026745911634, -122.413246372322) 3 1 10 308 23
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
123252 162764 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 919 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/13/2017 10:56:00 AM 3 Width 0ft   5995008.1104 2090049.40289 37.7185914714977 -122.459266363268 (37.7185914714977, -122.459266363268) 9 8 6 28861 24
123771 116260 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 8 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
123811 13034 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 490 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/16/2016 02:07:00 PM 3 3x3   6010037.8987 2120598.0598 37.8033238110836 -122.409469108899 (37.8033238110836, -122.409469108899) 3 1 10 308 23
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
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
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
125406 104605 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 10X Russell St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/21/2013 12:00:00 AM   2x3 Permit Number 770083 6007114.43488 2118959.67619 37.7986609851308 -122.419469576763 (37.7986609851308, -122.419469576763) 5 1 10 28858 32
126183 13014 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 408 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2016 02:25:00 PM 3 3X3   6010352 2120661 37.8035142236954 -122.408386587386 (37.8035142236954, -122.408386587386) 3 1 10 308 23
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
128671 13042 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 515-519 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2016 07:23:00 AM 3 3x3   6009844.8077 2120534.1734 37.8031375739168 -122.410132796901 (37.8031375739168, -122.410132796901) 3 1 10 308 23
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
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
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
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
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
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
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
135717 112521 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 146x ARLETA AVE 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010471 2087928 37.7136434126305 -122.405667857285 (37.7136434126305, -122.405667857285) 9 7 8 309 39
137875 13025 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 451 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2016 07:02:00 AM 3 3X3   6010198.7145 2120581.4625 37.8032872483458 -122.40891142592 (37.8032872483458, -122.40891142592) 3 1 10 308 23
137970 121488 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 750 Parnassus Ave 1 Median : Cutout Tree DPW 1       3x3   5994725.72352 2106063.15709 37.7625450220518 -122.461402729778 (37.7625450220518, -122.461402729778) 15 5 11 56 12
138508 13083 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 660 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/24/2015 11:06:00 AM 3 3X3   6009215.12 2120489.4566 37.8029794783612 -122.412308693696 (37.8029794783612, -122.412308693696) 3 1 10 308 23
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
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

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