Appendix D Formats This appendix provides the full sediment data in eight linkable tables in three
formats (see appendix A for list of tables). The Microsoft® Access format presents the eight tables under a
single database (pont_db.mdb). In Microsoft® Excel (spreadsheet) format the eight
tables are available as tabbed sheets within "pont_db.xls". The tab-delimited version is presented as eight
text files in a single directory, sed_data/db_txt. A ninth table has been added in
each format for reference use only and lists the Chemical Abstracts
Service (CAS) Registry numbers. Users with the appropriate software may
click on the linked file names below and open the data directly into the application. Quality Control and Methodology Differences Note that all data are given as presented in raw form by original sources (see also Disclaimer). As discussed in the database structure section, this database is not normalized. Qualifier and descriptive fields are in the same tables with analytical data fields, rather than placing them in separate tables. This is partly designed to avoid the separation of critical background information and quality designations from analytical data. Redundancy is permitted where this offers a template to permit data entry in original format. For example, both state plane coordinate and latitude/longitude fields are provided. Preserving data in original form and units is a critical element of this database and minimizes the need for secondary users to refer to obscure original sources. Database in MS Access 97 format zipped (524 KB) Database in MS Access 97 format (3966 KB) Database in MS Excel format zipped (701 KB) Database in MS Excel format (3287 KB) Database in tab-delimited format (10 files totaling 2113 KB) Quality Control Notes and Abbreviations in MS Word format (54 KB) Tips
|