INSTRUCTIONS FOR PDP ALDICARB IN POTATOES SPECIAL SURVEY DATA DOWNLOAD

Description: Special survey for acute dietary risk assessment conducted 
             from Dec 1996 to Dec 1997. Aldicarb and its metabolites were
             analyzed in potato sample composites and then single-serving
             analyses were performed on those samples containing the 
             highest total combined aldicarb residue in that analytical set.

** Less than 1 MB (200KB) of free disk storage space is needed to hold the
   de-compressed Aldicarb in Potatoes Special Survey data.

Instructions:
1) Click on the Aldicarb in Potatoes Special Survey Data link and save the
   ALDIDATA.EXE file to your hard drive.
2) In Windows or DOS, launch the ALDIDATA.EXE file to extract 7 files. There
   will be 6 text files and 1 executable file (described below).
3) Print the Data Dictionary file (DATADIAL.TXT) to see file structures.
4) Create four tables that match the provided file structures using your
   own database software. Import the 4 ASCII text (.asc) files.
5) The reference lists for PDP codes stored in these special survey files
   are the same as those for the full PDP 1997 database, so if you have 
   already downloaded those (15 .txt) files, there is no need to extract
   them again by launching the 97REFS.EXE executable file.
6) If you have not downloaded the 15 .txt reference files as part of the
   1997 database download, you can extract them by launching the 97REFS.EXE
   executable file. Print the 15 PDP code reference (.txt) files.  You may 
   want to create database tables for these, remove the headings from the
   files, and import the codes/descriptions into look-up tables that can be
   linked to your data.

File descriptions:
  ALDISAMP.ASC  -  ASCII,fixed-length data file which holds 342 Sample
                    Information records for analyzed Potato samples.
  ALDIRECO.ASC  -  ASCII,fixed-length data file which holds 1,026
                    Analytical Results records for the Composite Potato
                    samples.
  ALDIRESS.ASC  -  ASCII,fixed-length data file which holds 450
                    Analytical Results records for the Single-Serving
                    Potato samples.
  ALDIPEST.ASC  -  ASCII,fixed-length data file which holds 3 Pesticide
                    Codes/Names for relational reference (join) with the
                    Analytical Results tables (link on Pest_Code).
  DATADIAL.TXT  -  Data Dictionary that provides the file structures for
                    the Sample Info data file (aldisamp.asc), the Composite 
                    Analytical Results file (aldireco.asc), and the 
                    Single-Serving Analytical Results file (aldiress.asc).
                    This is a text file that can be viewed/printed with any
                    text editor.
  READAL.ME   -    Text file containing these same instructions.
  97REFS.EXE  -    Self-extracting executable which de-compresses to the
                    15 PDP reference code/description files described below.

   
Fifteen ASCII text files that can be used to reference and interpret the
standard codes used in the PDP data:
  ANNOT97.TXT   -  valid PDP Annotation Codes & Descriptions
  CLAIM97.TXT   -  valid PDP Marketing Claim Codes & Descriptions
  CLASS97.TXT   -  valid PDP Test Class Codes & Descriptions
  CNTRY97.TXT   -  valid PDP Country Codes & Names for 1997 Imported Samples
  COLTYP97.TXT  -  valid PDP Collection Site Type Codes & Descriptions
  COMMOD97.TXT  -  valid PDP Commodity Codes & Descriptions for 1997 Samples
  CONFME97.TXT  -  valid PDP Confirmation Method Codes & Descriptions
  CTYPE97.TXT   -  valid PDP Commodity Type Codes & Descriptions
  DETERM97.TXT  -  valid PDP Determinative Method Codes & Descriptions
  EXTRAC97.TXT  -  valid PDP Extraction Method Codes & Descriptions
  LABS97.TXT    -  valid PDP Participating Laboratory Codes & Cities
  MEAN97.TXT    -  valid PDP Mean of Result Codes & Descriptions
  PEST97.TXT    -  valid PDP Pesticide Codes & Names reported in 1997
  QUANT97.TXT   -  valid PDP Quantitative Method Codes & Descriptions
  STATE97.TXT   -  valid State Postal Codes & Names for 50 states