Street_Tree_List

Data source: data.sfgov.org

191 rows where qSpecies = 80 sorted by Longitude descending

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
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)
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)
9791 116717 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 690X 03RD ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/22/2003 12:00:00 AM 5 3x3   6014548.0 2111604.0 37.7788798826953 -122.393231883862 (37.7788798826953, -122.393231883862)
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)
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)
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)
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)
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)
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)
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)
2784 252854 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 100X Langton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       2.5x4   6010166.0 2110701.0 37.776156040570996 -122.408327321329 (37.776156040571, -122.408327321329)
2788 252853 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 100X Langton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       2.5x4   6010166.0 2110701.0 37.776156040570996 -122.408327321329 (37.776156040571, -122.408327321329)
34237 143019 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 410 LOMBARD ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 0ft   6010368.5125 2120644.4743 37.8034697728784 -122.408328278578 (37.8034697728784, -122.408328278578)
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)
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)
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)
86820 104607 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 1839 Stockton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/21/2013 12:00:00 AM   3x3 Permit Number 770939 6009882.8 2120354.0 37.80264499181129 -122.409988596173 (37.8026449918113, -122.409988596173)
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)
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)
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)
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)
79381 114695 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 799x TAYLOR ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6009121.0 2115613.0 37.7895846457112 -122.41228952949498 (37.7895846457112, -122.412289529495)
82486 114696 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 799x TAYLOR ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6009121.0 2115613.0 37.7895846457112 -122.41228952949498 (37.7895846457112, -122.412289529495)
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)
22867 143011 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 650-654 LOMBARD ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/11/2017 12:26:00 PM 3 Width 0ft   6009188.4253 2120483.2963 37.8029610657241 -122.41240063587601 (37.8029610657241, -122.412400635876)
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)
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)
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)
140547 104606 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 30 Russell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/21/2013 12:00:00 AM   2x3 Permit Number 770083 6007173.0 2118980.0 37.798720087677104 -122.419268364856 (37.7987200876771, -122.419268364856)
105204 104605 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 10X Russell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/21/2013 12:00:00 AM   2x3 Permit Number 770083 6007114.434880001 2118959.67619 37.798660985130795 -122.419469576763 (37.7986609851308, -122.419469576763)
108555 104604 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 10X Russell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/21/2013 12:00:00 AM   2x3 Permit Number 770083 6007114.434880001 2118959.67619 37.798660985130795 -122.419469576763 (37.7986609851308, -122.419469576763)
120598 104603 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 10X Russell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/21/2013 12:00:00 AM   2x3 Permit Number 770083 6007114.434880001 2118959.67619 37.798660985130795 -122.419469576763 (37.7986609851308, -122.419469576763)
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)
89928 115438 Permitted Site 1 Olea europaea 'Fruitless' :: Fruitless Olive 80 2500X Larkin St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/01/2016 12:00:00 AM 3   Permit Number 777506 6006688.6 2119773.1 37.8008704472237 -122.421000888697 (37.8008704472237, -122.421000888697)
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)
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)
94824 111178 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 2109 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006363.0 2118096.0 37.7962471953974 -122.42200839754801 (37.7962471953974, -122.422008397548)
141724 121042 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 2101 Polk St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6006363.0 2118098.0 37.7962526868942 -122.422008539697 (37.7962526868942, -122.422008539697)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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