Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 560 | 560 | 131782 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2646 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | Permit Number 779549 | 6000337.27442 | 2118211.39807 | 37.7962223607332 | -122.442866875924 | (37.7962223607332, -122.442866875924) | ||
| 2783 | 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 | 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 | 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) | ||||
| 3762 | 3762 | 139362 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2869 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999793.3033 | 2114332.6333 | 37.7855412639984 | -122.44447021936199 | (37.7855412639984, -122.444470219362) | |||
| 4152 | 4152 | 216685 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 111 Ashton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:11:00 AM | 3 | Width 3ft | 5994133.1609 | 2090669.8719900001 | 37.720244788744104 | -122.46233566126101 | (37.7202447887441, -122.462335661261) | ||
| 4474 | 4474 | 162754 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 997x Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 11:43:00 AM | 3 | Width 0ft | 5995095.0 | 2090528.0 | 37.719910580533295 | -122.45900065774599 | (37.7199105805333, -122.459000657746) | ||
| 4501 | 4501 | 162764 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 919 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 10:56:00 AM | 3 | Width 0ft | 5995008.1104 | 2090049.4028900003 | 37.7185914714977 | -122.459266363268 | (37.7185914714977, -122.459266363268) | ||
| 5683 | 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) | ||
| 6283 | 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) | ||
| 6371 | 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) | ||
| 6621 | 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) | ||
| 7621 | 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) | ||
| 7645 | 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) | ||
| 8514 | 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) | ||
| 8564 | 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) | ||
| 9756 | 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) | |
| 9791 | 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) | ||
| 11726 | 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) |
| 12866 | 12866 | 108593 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 530 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | |||||
| 19726 | 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) | ||||
| 22867 | 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) | ||
| 34237 | 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) | |||
| 38625 | 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) | |
| 43549 | 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) |
| 50103 | 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) | |||
| 55368 | 55368 | 105009 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 11 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2013 12:00:00 AM | 7 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.785789717987704 | -122.455998396638 | (37.7857897179877, -122.455998396638) | ||
| 57286 | 57286 | 105011 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 11 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.785789717987704 | -122.455998396638 | (37.7857897179877, -122.455998396638) | ||
| 63991 | 63991 | 115203 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2056 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 3 | Permit Number 775522 | 6001029.7 | 2112838.5 | 37.781509225585104 | -122.44008548171301 | (37.7815092255851, -122.440085481713) | ||
| 66020 | 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) | ||||
| 66027 | 66027 | 115194 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 4150 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 777365 | 6002684.1 | 2104186.2 | 37.757846181761295 | -122.433743471638 | (37.7578461817613, -122.433743471638) | |||
| 66670 | 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) | |
| 78192 | 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) |
| 78461 | 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) | |||||
| 78961 | 78961 | 121107 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1391 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5993608.0 | 2106030.0 | 37.7623895873424 | -122.46526608917601 | (37.7623895873424, -122.465266089176) | ||
| 79092 | 79092 | 115287 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1526 12th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 776185 | 5992489.2 | 2105046.7 | 37.759625121297795 | -122.469064003389 | (37.7596251212978, -122.469064003389) | |||
| 79096 | 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) | ||
| 79381 | 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) | ||||
| 80109 | 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) | |||
| 80243 | 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) | |||
| 80757 | 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) | |||
| 80767 | 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) | ||
| 81022 | 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 | 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) | ||||
| 81377 | 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) | |
| 82486 | 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) | ||||
| 83317 | 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) | |||
| 84179 | 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) | ||
| 84703 | 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) | ||||
| 85128 | 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) | |
| 85348 | 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 | 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) | ||||
| 86820 | 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) | ||
| 86990 | 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) | |
| 87337 | 87337 | 117270 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 481 JERSEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6002050.0 | 2101440.0 | 37.750269772538296 | -122.435739974128 | (37.7502697725383, -122.435739974128) | |||
| 87526 | 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) | ||
| 88959 | 88959 | 115768 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 210 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775810 | 6001697.3 | 2086437.3 | 37.709055747846705 | -122.43588629224399 | (37.7090557478467, -122.435886292244) | ||
| 89140 | 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) | |
| 89798 | 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) | ||
| 89928 | 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) | ||
| 89979 | 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) | ||
| 90305 | 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) | ||||
| 90402 | 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) | |||
| 91320 | 91320 | 107140 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 250X Roosevelt Way | Median : Cutout 11 | Tree 1 | Private 1 | 08/01/2014 12:00:00 AM | 5x5 | Permit Number 773751 | 6000794.71275 | 2107196.95489 | 37.766005582708395 | -122.440493678393 | (37.7660055827084, -122.440493678393) | |||
| 91422 | 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) | |||
| 91935 | 91935 | 115289 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1425 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775512 | 5991747.8 | 2105705.5 | 37.761391146048496 | -122.47167612106001 | (37.7613911460485, -122.47167612106) | |||
| 92225 | 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) | ||
| 92554 | 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) | ||||
| 93425 | 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) | ||
| 93755 | 93755 | 115008 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 743 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | Permit Number 774445 | 5985969.5 | 2110831.9 | 37.775130796003204 | -122.49203801834601 | (37.7751307960032, -122.492038018346) | |||
| 94581 | 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) | |||||
| 94607 | 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) | ||
| 94824 | 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) | ||||
| 96543 | 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) | |||
| 96610 | 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) | ||||
| 97623 | 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) | |
| 97656 | 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) | ||
| 98226 | 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) | ||||
| 99223 | 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) | ||
| 100092 | 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) | ||||
| 100236 | 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) | |||
| 100241 | 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) | ||||
| 101213 | 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) | ||
| 101543 | 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) | ||
| 101908 | 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) | ||
| 102114 | 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 | 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) | ||||
| 103124 | 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) | ||
| 104602 | 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) | ||||
| 104629 | 104629 | 122520 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 250 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004004.54241313 | 2097731.78472111 | 37.740198698919 | -122.428716724311 | (37.740198698919, -122.428716724311) | ||||
| 105204 | 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) | ||
| 105773 | 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) | |
| 106475 | 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) | ||
| 107040 | 107040 | 119284 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 651 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2016 12:00:00 AM | 3 | 3x3 | 5987187.0 | 2111505.0 | 37.777050030999604 | -122.487875935939 | (37.7770500309996, -122.487875935939) | ||
| 107527 | 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) | ||
| 107711 | 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) | ||||
| 107993 | 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) | ||||
| 108113 | 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) | |
| 108192 | 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) | |
| 108555 | 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) |
JSON shape: default, array, newline-delimited
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");