Portland Harbor Pre-RD. 2019
Abstract:
The EQuIS standard Analytical Results 11 (AR11) report format is the basis for the data contained in the Expanded Database Export (EDE). The AR11 report output is an MS Excel file which is imported into an Access DB file to facilitate querying and review of large data sets. The Access file contains three tables as follows: 1. Data Elements table. This table holds a definition of each data element (column) in the export. 2. Expand Database Export table. This is the table that stores the content of the AR11 export. In Access Design View, the data types and an abbreviated version of the data element definitions can be found as well. 3. Reference Values table. This table decodes the shortened IDs contained in some of the columns (data fields) of the Expanded Database Export table, providing a more complete definition for the data code. The first column identifies the relevant export data field(s), the second column provides a listing of all the IDs relevant to that data field, and the third column provides a more complete description associated with the short ID/ reference value. See the readme.pdf file formore detail.
Files for this document are shown below. Click on the file name to download the file. The 'Search' box can be used to filter the list of files, and clicking on a column header will re-order the list.
Title | Filename | Size (kB) | Document Type |
---|---|---|---|
Portland Harbor PDI-BL Sample Database | 284,128 | Data File | |
Lab and Data Validation Reports for PDI Database | 1,168,591 | Data File | |
Readme with additional information from EPA Region 10 | 113 | Data File | |
Data Element Table | 91 | Report Tables | |
Reference Values | 201 | Report Tables |