Extract, Transform, Load
- Paul McCullough (Unlicensed)
Owned by Paul McCullough (Unlicensed)
EAS has a somewhat elaborate extract, transform, load (ETL) process that we built with python and Feature Manipulation Engine. To read about this in some detail take a look at this page. The ETL runs every week night, and we respond to any problems first thing in the morning. If a parcel or street has been retired since the last ETL, addresses associated with the parcel or street must be reviewed and will likely be retired as a result.
This picture gives a general sense of how the data flows between the various agencies.
