It is even simpler in that it cuts out Excel altogether - Safe FME helps read the government data files directly from the internet repository - furthering our aim to create as easy and simple to use as possible, whilst preserving data integrity and fostering sound data management principles.
The resulting workflow uses Extract - Transform - Load (ETL) at its simplest:
|click to enlarge|
The rest of the workflow is pretty much the same, and is detailed in the Mind the Map companion blog. A business-oriented synopsis will be published by PPDM Foundations in its Q3 issue.
STOP PRESSES: Safe Software just published a new eBook, that guides you through publishing and accessing this sort of data through ArcGIS Online and other services. Stay tuned for further parts of this exercise...
|click here to access|