Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1854 | 1854 | 58389 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1364 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3 | Permit Number 776620 | 6006427.83864 | 2119405.514 | 37.799846446913705 | -122.42187710853999 | (37.7998464469137, -122.42187710854) | ||
| 3486 | 3486 | 39483 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 4949 | 4949 | 83043 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:49:00 PM | 3 | 6018760.2720099995 | 2097656.0724299997 | 37.7408148829885 | -122.377691543139 | (37.7408148829885, -122.377691543139) | |||
| 6083 | 6083 | 108032 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 145X Capra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774212 | 6001036.4090599995 | 2120513.75887 | 37.802583868119896 | -122.440612955426 | (37.8025838681199, -122.440612955426) | ||
| 6162 | 6162 | 35284 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 6472 | 6472 | 39482 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 8073 | 8073 | 108033 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 145X Capra Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774212 | 6001051.57629 | 2120515.71183 | 37.802590094109604 | -122.440560609499 | (37.8025900941096, -122.440560609499) | ||
| 8735 | 8735 | 35281 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 8890 | 8890 | 108034 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 145X Capra Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774212 | 6001070.0116 | 2120518.4067 | 37.8025985432527 | -122.440497007638 | (37.8025985432527, -122.440497007638) | ||
| 8964 | 8964 | 115754 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3157 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772142 | 5999354.88302 | 2119687.6663900004 | 37.8002197429071 | -122.446372392773 | (37.8002197429071, -122.446372392773) | ||
| 11312 | 11312 | 35280 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 11662 | 11662 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 0 Diaz Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.8197400002 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | ||
| 11822 | 11822 | 117429 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 418 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 777101 | 6000919.46363 | 2092339.69207 | 37.72521817457061 | -122.43899732339099 | (37.7252181745706, -122.438997323391) | ||
| 12722 | 12722 | 117443 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 134 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778577 | 6004618.40487 | 2092601.87765 | 37.72614784693 | -122.42622910508601 | (37.72614784693, -122.426229105086) | ||
| 13138 | 13138 | 117433 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 157 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776957 | 6000554.87359 | 2091671.7956400001 | 37.72336353237829 | -122.440209797466 | (37.7233635323783, -122.440209797466) | ||
| 13487 | 13487 | 108687 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1076 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 773107 | 6012169.21632 | 2103384.1046599997 | 37.756177459246295 | -122.400883423742 | (37.7561774592463, -122.400883423742) | |
| 13538 | 13538 | 42043 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 13680 | 13680 | 39555 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 15 | Permit Number 40979 | 6013094.503190001 | 2106943.24687 | 37.766001649682 | -122.397933106026 | (37.766001649682, -122.397933106026) | ||
| 13846 | 13846 | 35283 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 14104 | 14104 | 39557 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 10 | Permit Number 40979 | 6013095.63903 | 2106895.18187 | 37.7658697371335 | -122.39792580534599 | (37.7658697371335, -122.397925805346) | ||
| 14684 | 14684 | 39553 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013090.35036 | 2107006.086 | 37.7661739606766 | -122.39795187847601 | (37.7661739606766, -122.397951878476) | ||
| 15055 | 15055 | 113527 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6013095.17315 | 2106916.8102 | 37.7659290977746 | -122.39792893408001 | (37.7659290977746, -122.39792893408) | ||||
| 15266 | 15266 | 39554 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013090.01553 | 2106989.57845 | 37.7661286159676 | -122.397951878486 | (37.7661286159676, -122.397951878486) | ||
| 15269 | 15269 | 39556 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013089.54039 | 2107025.61956 | 37.7662275503778 | -122.397956050431 | (37.7662275503778, -122.397956050431) | ||
| 15519 | 15519 | 38776 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 660 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/2017 12:00:00 AM | 3 | Permit Number 779488 | 6014510.81012 | 2111730.04342 | 37.7792239033058 | -122.39336936232999 | (37.7792239033058, -122.39336936233) | |
| 15904 | 15904 | 42044 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16213 | 16213 | 35285 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 16322 | 16322 | 42042 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16500 | 16500 | 42041 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16775 | 16775 | 110930 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6013101.5791 | 2106846.11839 | 37.7657353505351 | -122.397901817734 | (37.7657353505351, -122.397901817734) | ||||
| 16886 | 16886 | 39481 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 18005 | 18005 | 29702 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1488X Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005878.4786 | 2100373.84581 | 37.747559079794996 | -122.42242508166099 | (37.747559079795, -122.422425081661) | |||
| 18147 | 18147 | 56051 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 49 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1973 12:00:00 AM | 36 | Permit Number 12140 | 6003182.54972715 | 2108023.57751638 | 37.768410964941104 | -122.43229368198 | (37.7684109649411, -122.43229368198) | ||
| 18149 | 18149 | 60477 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1343 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | Permit Number 20072 | 6002221.27409585 | 2113110.91985101 | 37.7823249851452 | -122.435982713361 | (37.7823249851452, -122.435982713361) | ||
| 18794 | 18794 | 46753 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 378 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44855 | 5993270.29922187 | 2089695.37971007 | 37.717519344442294 | -122.465247516931 | (37.7175193444423, -122.465247516931) | ||
| 18915 | 18915 | 45453 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 191 Corona St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/2001 12:00:00 AM | Permit Number 44237 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | ||
| 19265 | 19265 | 29699 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1488X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005882.22155 | 2100316.32182 | 37.747401343192 | -122.42240805210399 | (37.747401343192, -122.422408052104) | |||
| 19496 | 19496 | 34866 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 579 Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | ||
| 19497 | 19497 | 39128 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 755 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40809 | 6007359.12700155 | 2102919.00118427 | 37.7546309134503 | -122.41748542832899 | (37.7546309134503, -122.417485428329) | ||
| 19552 | 19552 | 50938 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4752 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | Permit Number 48543 | 5998450.03825367 | 2105698.06494287 | 37.7617562199837 | -122.44849544098601 | (37.7617562199837, -122.448495440986) | ||
| 19586 | 19586 | 29705 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1488X Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005872.46136 | 2100440.5238200002 | 37.747741822942 | -122.422450626014 | (37.747741822942, -122.422450626014) | |||
| 19601 | 19601 | 64294 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 369 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1988 12:00:00 AM | 11 | Permit Number 25100 | 6004186.81103281 | 2098943.74928531 | 37.743536789999396 | -122.428172863442 | (37.7435367899994, -122.428172863442) | |
| 21199 | 21199 | 97237 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) | |||
| 22295 | 22295 | 41955 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2636 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 5 | Permit Number 42312 | 5995181.79826 | 2110315.10722 | 37.7742460062216 | -122.460133402127 | (37.7742460062216, -122.460133402127) | |
| 22842 | 22842 | 37547 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 830 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 12 | Permit Number 39987 | 6008602.44706 | 2115263.43418 | 37.788595711371 | -122.414058934193 | (37.788595711371, -122.414058934193) | |
| 22988 | 22988 | 70383 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1465 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 7 | 5982453.54 | 2105161.4635 | 37.759355260686 | -122.503780254641 | (37.759355260686, -122.503780254641) | ||
| 23002 | 23002 | 10268 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 215X Haight St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 6005053.18335 | 2109512.97249 | 37.772606373329396 | -122.42592935924601 | (37.7726063733294, -122.425929359246) | ||||
| 23209 | 23209 | 83033 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018894.74802 | 2097554.01331 | 37.7405420574702 | -122.377219490814 | (37.7405420574702, -122.377219490814) | |||
| 23287 | 23287 | 22457 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 6150X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 6013494.5908 | 2091319.1743 | 37.7231235191025 | -122.395454590098 | (37.7231235191025, -122.395454590098) | ||||
| 24041 | 24041 | 37545 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 830 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | 7 | Permit Number 39987 | 6008632.80064 | 2115264.4241 | 37.788600134235 | -122.413953985086 | (37.788600134235, -122.413953985086) | |
| 24225 | 24225 | 50246 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1287 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 0 | Permit Number 46951 | 5985199.39967199 | 2106457.48369728 | 37.7630748403476 | -122.49437940567101 | (37.7630748403476, -122.494379405671) | |
| 24362 | 24362 | 73557 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 734 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 15 | 5982628.313080001 | 2110748.29603 | 37.774705372511704 | -122.50358954053301 | (37.7747053725117, -122.503589540533) | ||
| 24471 | 24471 | 42601 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2554 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42671 | 6005368.83302 | 2118821.0293400004 | 37.798181821601894 | -122.425500047192 | (37.7981818216019, -122.425500047192) | |
| 24666 | 24666 | 32343 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2885 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36904 | 5999249.30586492 | 2118007.60671846 | 37.7956007178544 | -122.446616785481 | (37.7956007178544, -122.446616785481) | |||
| 24979 | 24979 | 177920 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Juan Bautista Cir | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989764.376630001 | 2089755.55448 | 37.7174817656499 | -122.477370148614 | (37.7174817656499, -122.477370148614) | ||||
| 25292 | 25292 | 177947 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989601.96089 | 2090504.09134 | 37.7195276360688 | -122.477986231896 | (37.7195276360688, -122.477986231896) | ||||
| 26122 | 26122 | 70370 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1462 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 5983119.2114 | 2105188.9573 | 37.7594698688276 | -122.50148010954901 | (37.7594698688276, -122.501480109549) | ||
| 27072 | 27072 | 56279 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 315 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 13 | Permit Number 12405 | 5992132.31983 | 2113284.5962099996 | 37.7822235433325 | -122.470898359757 | (37.7822235433325, -122.470898359757) | ||
| 27126 | 27126 | 177939 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Garces Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989472.35628 | 2089125.29207 | 37.7157342731997 | -122.478333458321 | (37.7157342731997, -122.478333458321) | ||||
| 27324 | 27324 | 50494 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 821 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2014 12:00:00 AM | 1 | Permit Number 772457 | 6003014.84349 | 2089242.8830799998 | 37.7168340244398 | -122.43153282718201 | (37.7168340244398, -122.431532827182) | |
| 27428 | 27428 | 42837 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1258 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2000 12:00:00 AM | 14 | Permit Number 42769 | 6005846.592759999 | 2120362.4898099997 | 37.8024412617221 | -122.423956527271 | (37.8024412617221, -122.423956527271) | ||
| 27488 | 27488 | 56319 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 255 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 11 | Permit Number 12454 | 5993047.12459 | 2113743.61417 | 37.7835367452404 | -122.467766966515 | (37.7835367452404, -122.467766966515) | ||
| 28219 | 28219 | 37594 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 654 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 7 | Permit Number 40022 | 5992572.16946 | 2111004.39481 | 37.77598815854871 | -122.46921067863701 | (37.7759881585487, -122.469210678637) | |
| 28439 | 28439 | 54494 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 555 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/1972 12:00:00 AM | 7 | Permit Number 10286 | 5983770.26355 | 2112042.83675 | 37.7783268785645 | -122.49973506639401 | (37.7783268785645, -122.499735066394) | ||
| 28481 | 28481 | 48583 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1172 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | 6 | Permit Number 45898 | 6008021.61269 | 2118241.60717 | 37.7967404007911 | -122.41627955815599 | (37.7967404007911, -122.416279558156) | |
| 28601 | 28601 | 232469 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6003464.52997 | 2095634.55653 | 37.7344096119087 | -122.43043426935301 | (37.7344096119087, -122.430434269353) | ||||
| 28604 | 28604 | 68272 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 507 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 15 | Permit Number 32079 | 6008804.98345 | 2093624.18713 | 37.7291906419342 | -122.41182849499901 | (37.7291906419342, -122.411828494999) | |
| 29115 | 29115 | 68565 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 599 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 7 | Permit Number 32455 | 5981915.91303 | 2111733.97216 | 37.777369840379 | -122.50612693446101 | (37.777369840379, -122.506126934461) | |
| 29240 | 29240 | 177953 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Grijalva Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5989426.93386 | 2089569.48868 | 37.7169512897353 | -122.47852292122101 | (37.7169512897353, -122.478522921221) | ||||
| 29269 | 29269 | 233076 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4379 Cesar Chavez St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6001425.33603 | 2100252.18871 | 37.7469728234536 | -122.437815034154 | (37.7469728234536, -122.437815034154) | ||||
| 29723 | 29723 | 177927 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Bucareli Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5988959.91996 | 2089504.3338 | 37.716745265857 | -122.48013237763 | (37.716745265857, -122.48013237763) | ||||
| 29822 | 29822 | 64295 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1455 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1988 12:00:00 AM | 7 | Permit Number 25101 | 5988654.3825 | 2105412.3927 | 37.7604068931784 | -122.482353357176 | (37.7604068931784, -122.482353357176) | ||
| 29988 | 29988 | 43145 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 236 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 42958 | 6005927.09779 | 2092636.0306099998 | 37.7263155084296 | -122.421707446054 | (37.7263155084296, -122.421707446054) | |
| 30250 | 30250 | 56321 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 262 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 11 | Permit Number 12457 | 5993094.0414 | 2113717.68989 | 37.7834682731836 | -122.467602767937 | (37.7834682731836, -122.467602767937) | ||
| 31488 | 31488 | 56281 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 318 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 10 | Permit Number 12407 | 5992177.94818 | 2113286.2023099996 | 37.782230591981 | -122.470740624571 | (37.782230591981, -122.470740624571) | ||
| 31837 | 31837 | 56316 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 240 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1973 12:00:00 AM | 12 | Permit Number 12450 | 5993089.74905 | 2113862.1439400003 | 37.7838646567214 | -122.467628126482 | (37.7838646567214, -122.467628126482) | ||
| 31841 | 31841 | 178002 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 214 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6004671.81576 | 2092168.4342200002 | 37.724960725638795 | -122.42601362482701 | (37.7249607256388, -122.426013624827) | ||||
| 32005 | 32005 | 71215 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2143 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 7 | 5988194.3764 | 2100717.2109 | 37.747488416956394 | -122.483600053104 | (37.7474884169564, -122.483600053104) | ||
| 32054 | 32054 | 42625 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1844 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42683 | 6004409.1039 | 2115238.2303 | 37.7882900931927 | -122.42856547432 | (37.7882900931927, -122.42856547432) | |
| 32094 | 32094 | 177949 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Fuente Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989559.04866 | 2090448.7873900002 | 37.7193732944219 | -122.47813052091101 | (37.7193732944219, -122.478130520911) | ||||
| 32223 | 32223 | 66427 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 95 Carr St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/1991 12:00:00 AM | 8 | Permit Number 29569 | 6012980.7106099995 | 2090558.71757 | 37.721006862564295 | -122.397177686318 | (37.7210068625643, -122.397177686318) | ||
| 32285 | 32285 | 43048 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2159 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 8 | Permit Number 42902 | 5983545.7781 | 2100465.2765 | 37.7465249999307 | -122.499655734442 | (37.7465249999307, -122.499655734442) | |
| 32464 | 32464 | 66152 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 524 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/1990 12:00:00 AM | 1 | Permit Number 29222 | 6013567.57589 | 2114946.80542 | 37.7880039412658 | -122.396858007884 | (37.7880039412658, -122.396858007884) | ||
| 32735 | 32735 | 43177 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 350 Pioche St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 10 | Permit Number 42983 | 6005845.02194 | 2093325.28285 | 37.72820341563 | -122.422040121459 | (37.72820341563, -122.422040121459) | |
| 32796 | 32796 | 114752 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1633 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777131 | 6006558.502230001 | 2092052.0855400001 | 37.7247477068349 | -122.41948329761101 | (37.7247477068349, -122.419483297611) | ||
| 32839 | 32839 | 68698 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 160 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 3 | Permit Number 32610 | 5991831.2696 | 2114389.80438 | 37.7852407247155 | -122.47202042920401 | (37.7852407247155, -122.472020429204) | |
| 32896 | 32896 | 232460 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6003616.28584 | 2095734.4889200001 | 37.734692598886 | -122.429916725697 | (37.734692598886, -122.429916725697) | ||||
| 33616 | 33616 | 69029 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1423 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 8 | Permit Number 33035 | 5984615.7707 | 2105488.0931 | 37.7603789927974 | -122.49632641947399 | (37.7603789927974, -122.496326419474) | |
| 33763 | 33763 | 194216 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1121 Jamestown Ave | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6013384.67345 | 2090050.6938099999 | 37.719634411689206 | -122.39574571828399 | (37.7196344116892, -122.395745718284) | ||||
| 33891 | 33891 | 177966 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1703 San Jose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6001621.06552 | 2094170.26367 | 37.730284401888206 | -122.436702936114 | (37.7302844018882, -122.436702936114) | ||||
| 33895 | 33895 | 44072 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2736 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2000 12:00:00 AM | 6 | Permit Number 43595 | 5996480.258280001 | 2111297.81133 | 37.7770188532203 | -122.45571286895701 | (37.7770188532203, -122.455712868957) | ||
| 34398 | 34398 | 47890 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1360 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2002 12:00:00 AM | 3 | Permit Number 45634 | 5982786.5099 | 2105823.423 | 37.7611923862045 | -122.502677699679 | (37.7611923862045, -122.502677699679) | |
| 34430 | 34430 | 194169 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 760 San Bruno Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010966.1557599995 | 2104754.45059 | 37.7598729443885 | -122.40514052741699 | (37.7598729443885, -122.405140527417) | ||||
| 34673 | 34673 | 232461 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1300 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003612.68018 | 2095726.39764 | 37.7346701778724 | -122.42992861471501 | (37.7346701778724, -122.429928614715) | ||||
| 34890 | 34890 | 233078 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4379 Cesar Chavez St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6001429.57501 | 2100250.5048599998 | 37.7469684410418 | -122.437800255583 | (37.7469684410418, -122.437800255583) | ||||
| 34894 | 34894 | 38426 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 126 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1999 12:00:00 AM | Permit Number 41732 | 6001233.109597 | 2094965.61225629 | 37.7324461904854 | -122.43810110094299 | (37.7324461904854, -122.438101100943) | ||
| 35319 | 35319 | 178005 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 214 Athens St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6004661.22391 | 2092172.31663 | 37.7249707872555 | -122.42605051593901 | (37.7249707872555, -122.426050515939) | ||||
| 35431 | 35431 | 42872 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2571 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 5 | Permit Number 42796 | 5986433.5303 | 2097767.9425 | 37.739287865011605 | -122.48947203167299 | (37.7392878650116, -122.489472031673) | |
| 35575 | 35575 | 178004 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 214 Athens St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6004666.19434 | 2092181.37563 | 37.7249959421932 | -122.4260339783 | (37.7249959421932, -122.4260339783) | ||||
| 35629 | 35629 | 70375 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1590 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5983148.8552 | 2104320.0131 | 37.757085733924 | -122.501313312685 | (37.757085733924, -122.501313312685) |
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");