Environmental Cleanup

The "ECSI Data Files" link on this page is a self-extracting zip file that contains 32 tables of data from the Environmental Cleanup Site Information database. The tables are formatted as comma-delimited text, and include all data fields in ECSI that hold important site information. DEQ updates the files and posts them to this page on the first day of each month.

ECSI is a complex relational database with many interrelated data elements. Therefore, DEQ recommends that users understand the tables’ data types and interrelationships before downloading and using the data. Two documents on this page, ECSI Table Descriptions and Entity Relationship Diagram, provide this information.

ECSI Files

  • ECSI Data Files
    Note: Double quotes (“) within these comma-delimited files can cause columns to split into multiple columns unexpectedly. To prevent this, double quotes within Comments columns of tables in these zipped files have been replaced with <quot>. To return the original formatting, users need to employ a manual find-and-replace feature to replace <quot> with the double quote (“).

Documentation

Contact

For more information about ECSI call Gil Wistar at 503-229-5512