Introduction

FGDC-STD-016-2011The EAS Flat File Export is a compressed CSV file that is written to the DT Secure FTP Server and contains every address data transaction that has ever occurred in the EAS. This data product is best suited for those consumers who need access to the entire history of address data transactions that are in the EAS, for example all of the address creations and retirements, and all of the parcel-link creations and retirements that have ever occurred in the EAS.

Please send an email to the DT-EAS-Support email distribution group if you are interested in learning how to consume the EAS Flat File Export.

Schedule

The EAS Flat File Export nightly job is initiated on Monday through Friday at 6:00 PM, and takes less than three minutes to post these data to the DT Secure FTP Server.

Email Notification

An email is sent to the email distribution group DT-EAS-Flat-File-Export when the flat file export has successfully completed. This same email distribution group is also used to notify subscribers when the DT Secure FTP Server is undergoing maintenance.

Schema

This is the schema of the EAS Flat File Export:

...

SELECT *
FROM   eas_flat_file_export
WHERE  (base_address_create_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
       OR (base_address_retire_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
       OR (unit_address_create_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
       OR (unit_address_retire_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
       OR (parcel_date_map_drop > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
       OR (address_x_parcel_create_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'))
       OR (address_x_parcel_retire_tms > (CURRENT_TIMESTAMP - INTERVAL '7 days'));

...