Clean up the export step

tiernanmartin / home-and-hope

A data set of suitable sites for the development of affordable housing and/or early learning centers in King County, Washington

https://tiernanmartin.github.io/home-and-hope/2-communication/3-bookdown/_book/index.html

MIT License

3 stars 0 forks source link

Clean up the export step #41

Closed tiernanmartin closed 6 years ago

tiernanmartin commented 6 years ago

The export step have a single archive file output (.zip) which contains the following items:

inventory_suitable spatial objects
Tabular data for inventory and inventory_suitable in the appropriate tabular data file formats (.csv ,.xlsx, and .rda - for now)
data_dictionary.csv with information that is accurate for the most recent version of the dataset
- particularly: FIELD_NAME_USER, FIELD_DESCRIPTION, and DICTIONARY_VERSION

tiernanmartin commented 6 years ago

While the optimal file format for connecting to Tableau is probably the Tableau Data Extract (.tde), there isn't a stable way to write files in this format from R. See this Stackoverflow post for details.

The path forward appears to be writing tabular data to .rda and spatial data to .geojson (or .shp).