Street_Tree_List

Data source: data.sfgov.org

191 rows where qSpecies = 80 sorted by TreeID

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
81377 683 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 2340X Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/2010 12:00:00 AM 0 3X3 Permit Number 53450 5988222.7193 2114685.44657 37.7858429996456 -122.484526443804 (37.7858429996456, -122.484526443804)
107527 1444 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 151X Arguello Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/17/2009 12:00:00 AM 3 3X5   5995492.27499 2115135.20138 37.7874985527143 -122.459408560713 (37.7874985527143, -122.459408560713)
91959 8974 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 5045 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/12/2011 12:00:00 AM 3 3x3   5991343.5266 2112609.97523 37.780325569878705 -122.473577979119 (37.7803255698787, -122.473577979119)
117154 9031 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 5351 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/12/2011 12:00:00 AM 3 3x3   5990365.52035 2112599.40799 37.7802398682569 -122.476960548186 (37.7802398682569, -122.476960548186)
22647 9116 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 5757 Geary Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/23/2015 12:00:00 AM 3 3x3   5989143.6236 2112579.8502 37.7801152084298 -122.48118616959499 (37.7801152084298, -122.481186169595)
4303 9125 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 5827 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/2017 11:55:00 AM 3 3X3   5988965.7697498 2112572.6420628 37.780085075713295 -122.481800911494 (37.7800850757133, -122.481800911494)
4321 12988 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 324 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/12/2016 06:56:00 AM 3 3X3   6010748.7594 2120699.4941 37.803642129208605 -122.407016292062 (37.8036421292086, -122.407016292062)
4295 12999 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 349 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/10/2017 09:03:00 AM 3 3X3   6010644.3554 2120634.1907 37.803456979280796 -122.407372982577 (37.8034569792808, -122.407372982577)
397 13004 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 368 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/12/2016 06:38:00 AM 3 4X4   6010562.3418 2120670.5672 37.8035522695821 -122.407659361785 (37.8035522695821, -122.407659361785)
5600 13009 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 378 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/09/2016 02:11:00 PM 3 4X4   6010539.0395 2120665.4782 37.8035369920045 -122.40773964180201 (37.8035369920045, -122.407739641802)
5543 13010 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 396 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/28/2015 07:16:00 AM 3 3X3   6010502.3453 2120665.4782 37.803534937788704 -122.407866624342 (37.8035349377887, -122.407866624342)
5910 13011 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 396 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/28/2015 07:12:00 AM 3 3X3   6010476.6325 2120660.3892 37.8035195251148 -122.40795524597999 (37.8035195251148, -122.40795524598)
1599 13014 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 412 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2016 02:25:00 PM 3 3X3   6010343.163 2120639.8328 37.803455608926704 -122.408415674405 (37.8034556089267, -122.408415674405)
8564 13015 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 407 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/27/2016 12:00:00 AM 12 3X3   6010332.686000001 2120602.2788 37.803351908204796 -122.408449280112 (37.8033519082048, -122.408449280112)
5406 13016 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 407 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/16/2016 02:31:00 PM 3 3X3   6010356.171 2120603.3463 37.8033561544514 -122.408368084374 (37.8033561544514, -122.408368084374)
8514 13017 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 416 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/29/2016 12:00:00 AM 3 3X3   6010320.6699 2120636.9765 37.8034465065935 -122.408493311466 (37.8034465065935, -122.408493311466)
128494 13022 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 431 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/28/2015 07:20:00 AM 3 3X3   6010276.62799 2120585.425 37.803302492372396 -122.408642082138 (37.8033024923724, -122.408642082138)
5794 13024 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 445 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/04/2014 02:58:00 PM 3 3X3   6010214.1933 2120583.5975 37.8032939775537 -122.40885801148998 (37.8032939775537, -122.40885801149)
7645 13025 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 451 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/12/2016 07:02:00 AM 3 3X3   6010198.7145 2120581.4625 37.8032872483458 -122.40891142592 (37.8032872483458, -122.40891142592)
6943 13034 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 490 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/16/2016 02:07:00 PM 3 3x3   6010037.8987 2120598.0598 37.8033238110836 -122.409469108899 (37.8033238110836, -122.409469108899)
6621 13040 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 515-519 Lombard St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/06/2016 07:26:00 AM 3 3X3   6009890.5899 2120540.3695 37.8031571528751 -122.409974803368 (37.8031571528751, -122.409974803368)
5683 13042 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 515-519 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/06/2016 07:23:00 AM 3 3x3   6009844.8077 2120534.1734 37.8031375739168 -122.410132796901 (37.8031375739168, -122.410132796901)
6371 13043 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 526 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/21/2016 11:51:00 AM 3 3x3   6009812.0026 2120568.2515 37.803229305132604 -122.41024872778401 (37.8032293051326, -122.410248727784)
6283 13055 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 570 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/24/2016 08:41:00 AM 3 3x3   6009605.5749 2120542.0431 37.8031457701614 -122.410961227909 (37.8031457701614, -122.410961227909)
50090 13071 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 645X Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   09/27/2006 12:00:00 AM 3 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
125041 13072 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 645X Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   09/27/2008 12:00:00 AM 3 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
96845 13075 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 645X Lombard St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   01/22/2015 12:00:00 AM 3 3X3 Permit Number 774508 6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
122317 13082 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 650 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/2016 10:37:00 AM 3 3x3   6009219.60633 2120572.31429 37.803207236671604 -122.41229902844101 (37.8032072366716, -122.412299028441)
9819 13083 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 660 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/24/2015 11:06:00 AM 3 3X3   6009215.12 2120489.4566 37.8029794783612 -122.412308693696 (37.8029794783612, -122.412308693696)
82441 16816 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 2105 O'Farrell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/13/2015 01:25:00 PM 3 4x4   6001234.7809998 2113147.0836075 37.7823681904894 -122.43939812802799 (37.7823681904894, -122.439398128028)
4886 17862 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 2121 Pine St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/31/2017 11:37:00 AM 3 3X3   6003706.1864 2115222.5689 37.7882072868246 -122.43099633374901 (37.7882072868246, -122.430996333749)
7217 17911 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 2321 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/12/2016 10:58:00 AM 3 3X3   6002821.482999999 2115107.812 37.7878420242306 -122.434049048426 (37.7878420242306, -122.434049048426)
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)
89140 24659 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 3299X Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/2014 12:00:00 AM 3 3x3 Permit Number 772930 5997061.39714 2112911.4526400003 37.7814828219847 -122.453819096525 (37.7814828219847, -122.453819096525)
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)
7621 29909 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 515-519 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/06/2016 07:29:00 AM 3 3x3   6009867.8709 2120537.6157 37.8031483182934 -122.41005322890301 (37.8031483182934, -122.410053228903)
112897 30786 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 477 Bryant St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/02/2011 12:00:00 AM     Permit Number 768077 6013986.79222779 2112639.44439925 37.781691783585 -122.395245890478 (37.781691783585, -122.395245890478)
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)
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)
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)
128947 46881 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 2300@Green Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/23/2012 12:00:00 AM     Permit Number 768822 6006358.85800747 2118685.04678939 37.797864335812704 -122.422064597009 (37.7978643358127, -122.422064597009)
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)
101543 53808 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 200X Parker Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/2014 12:00:00 AM   3x3 Permit Number 772930 5997126.8655565 2112925.05365722 37.7815239200353 -122.45359359095801 (37.7815239200353, -122.453593590958)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
111851 60027 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 41 South Park 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/18/2013 12:00:00 AM     Permit Number 769856 6014655.81368733 2112837.99803451 37.7822741509003 -122.392945269869 (37.7822741509003, -122.392945269869)
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)
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)
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)
118834 76746 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1320 Lombard St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
119048 76753 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1320 Lombard St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
83317 76761 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1320 Lombard St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
114097 76766 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1320 Lombard St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
50103 76775 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1320 Lombard St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
143278 76782 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1320 Lombard St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
80757 76789 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1320 Lombard St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
91422 76793 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1320 Lombard St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
142546 76799 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1320 Lombard St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
80109 76804 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1320 Lombard St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
100236 76809 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1320 Lombard St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
96543 76813 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1320 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
140392 76817 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1320 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2012 12:00:00 AM   3x3 Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
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)
79096 84742 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 147 Alhambra St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   03/27/2007 12:00:00 AM   4x6 Permit Number 49255 6001618.0 2120311.0 37.8020602472718 -122.438585827087 (37.8020602472718, -122.438585827087)
90402 84929 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1500@Polk Broadway 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/06/2007 12:00:00 AM     Permit Number 49344 6006413.8 2117997.6 37.795979878671 -122.421825625767 (37.795979878671, -122.421825625767)
66010 90469 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 578 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 03/17/2008 12:00:00 AM 3 3x3   5988158.072517 2112047.558198 37.778596339842 -122.48455654153601 (37.778596339842, -122.484556541536)
118636 90471 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 534 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 03/20/2008 12:00:00 AM 3 3x3   5988147.641992 2112343.937312 37.779409506079396 -122.484614370085 (37.7794095060794, -122.484614370085)
99422 90510 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 555 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 03/19/2008 12:00:00 AM 3 3x3   5988112.407888 2112207.812683 37.7790336942222 -122.48472626983101 (37.7790336942222, -122.484726269831)
102101 90511 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 569 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 03/19/2008 12:00:00 AM 3 3x3   5988115.7266919995 2112113.5102150002 37.7787749594642 -122.48470786940099 (37.7787749594642, -122.484707869401)
90847 90526 DPW Maintained 3 Olea europaea 'Fruitless' :: Fruitless Olive 80 705 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 03/18/2008 12:00:00 AM 3 3x3   5988149.756261 2111164.589328 37.7761714707406 -122.484520528522 (37.7761714707406, -122.484520528522)
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)
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)
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)
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)
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)
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)
87526 97446 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 200X Parker Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/2014 12:00:00 AM   3x3 Permit Number 772930 5997060.8 2112843.2 37.7812953839865 -122.453816232036 (37.7812953839865, -122.453816232036)
84179 98330 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 147 Alhambra St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   03/27/2007 12:00:00 AM   4x6 Permit Number 49255 6001593.9 2120254.3 37.801903193112004 -122.438665159251 (37.801903193112, -122.438665159251)
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)
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)
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)
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)
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)
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)
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)
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)
94607 102914 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 2848 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/12/2013 12:00:00 AM   3x3 Permit Number 770041 5999369.2 2118090.3 37.7958346193373 -122.446207883579 (37.7958346193373, -122.446207883579)

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 75.65ms · Data source: data.sfgov.org