For a birthday present for my father-in-law, I want to get historical shoreline data viewable in Google Earth into a format I can read into R and use with the sf package, specifically table T-00267, that I will incorporate into a map of his neighborhood.
The KMZ file can be downloaded here, https://shoreline.noaa.gov/data/datasheets/t-sheets.html
I download shoreline extract for table T-00267, and get a Microsoft database file called ec10a01.mdb
I'm using Ubuntu, so I downloaded mdbtools. I run in the location the file is saved...
mdb-tables ec10a01.mdb
and see there are files t00267line_SHAPE_Index t00267line in the database. I then try to save the file like
mdb-export ec10a01.mdb t00267line > t00267line.csv
And I get a corrupted file that seems like it has some shape data in it that I'm not accessing right. If there are other ways to get this data besides through Google Earth, I'm open to alternative solutions.
The historical data for MD was also used in the creation of these shoreline erosion datasets found here http://www.mgs.md.gov/coastal_geology/shoreline%20change.html