The following files are in ASCII comma delimited format... From kc02prmt.exe: FILE DEFINITION FOR FILE #1 ----------------------------------------------------------------------------- FILE ROOT NAME : kc02pmta.asc USER DISPLAY NAME : 2002 Permit/Operator ID (Part A) NUMBER OF RECORDS : 1138 ----------------------------------------------------------------------------- FLD FIELD FLD FLD DEC RELATES--TO NUM NAME TYPE LEN PTS FILE FIELD --- ----------- ---- --- --- ---- ----- 1 PERMIT NUM 7 0 2 EFFECT_DATE DAT 8 3 EXP_DATE DAT 8 4 PERMITTEE ASC 30 5 LASTNAME ASC 30 6 FIRSTNAME ASC 15 7 MAIL_ADDR ASC 30 8 MAIL_CITY ASC 30 9 MAIL_ST ASC 2 10 MAIL_ZIP ASC 10 11 PHONE ASC 13 FILE DEFINITION FOR FILE: 2 ----------------------------------------------------------------------------- FILE ROOT NAME : kc02pmtb.asc USER DISPLAY NAME : 2002 Permit/Operator Site ID (Part B) NUMBER OF RECORDS : 14616 ----------------------------------------------------------------------------- FLD FIELD FLD FLD DEC RELATES--TO NUM NAME TYPE LEN PTS FILE FIELD --- ----------- ---- --- --- ---- ----- 1 PERMIT ASC 7 1 1 2 LOCATION ASC 8 3 COMMODITY ASC 15 4 MERIDIAN ASC 1 5 TOWNSHIP ASC 3 6 RANGE ASC 3 7 SECTION NUM 2 0 8 QUANTITY NUM 11 2 9 UNITS ASC 1 FILE DEFINITION FOR FILE #3 ----------------------------------------------------------------------------- FILE ROOT NAME : kc02psta.asc USER DISPLAY NAME : 2002 Permit/Operator ID Pesticides NUMBER OF RECORDS : 8324 ----------------------------------------------------------------------------- FLD FIELD FLD FLD DEC RELATES--TO NUM NAME TYPE LEN PTS FILE FIELD --- ----------- ---- --- --- ---- ----- 1 PEST_CODE NUM 5 0 2 PERMIT ASC 7 1 1 3 FORMS ASC 1 4 METHOD ASC 2 5 APPLICATOR ASC 2 6 PESTS ASC 15 FILE DEFINITION FOR FILE #4 ----------------------------------------------------------------------------- FILE ROOT NAME : kc02pstb.asc USER DISPLAY NAME : 2002 Permit/Operator Site ID Pesticides NUMBER OF RECORDS : 67824 ----------------------------------------------------------------------------- FLD FIELD FLD FLD DEC RELATES--TO NUM NAME TYPE LEN PTS FILE FIELD --- ----------- ---- --- --- ---- ----- 1 PEST_CODE NUM 5 0 2 PERMIT ASC 7 2 1 3 LOCATION ASC 8 2 2 4 COMMODITY ASC 15 From kc02purs.exe: FILE DEFINITION LISTING FOR FILE #5 *************************************************** FILE ROOT NAME = KC02PURS.ASC USER DISPLAY NAME = Agricultural Production PUR - 2002 *************************************************** NUMBER OF RECORDS = 93969 *************************************************** FIELD FIELD FIELD DEC RELATES--TO NMBR LEN TYPE PTS FILE FIELD ----- ----- ----- --- ---- ----- 1 8 NUMERIC 0 0 0 REPORT# (Document Number) 2 1 ASCII 0 0 ACTIVITY (P=PCO,O or M=Grower) 3 1 ASCII 0 0 APPLMETH (A=air,G=ground,O=other) 4 7 ASCII 1 1 PERMIT 5 8 ASCII 2 2 LOCATION 6 15 ASCII 0 0 COMMODITY 7 11 NUMERIC 2 0 0 QUANTITY (Acres Planted) 8 1 ASCII 0 0 MERIDIAN 9 3 ASCII 0 0 TOWNSHIP 10 3 ASCII 0 0 RANGE 11 2 NUMERIC 0 0 0 SECTION 12 8 DATE 0 0 DATE_APPL 13 2 NUMERIC 0 0 MIL_HOUR_APPL 14 2 NUMERIC 0 0 MIL_HOUR_APPL 15 10 NUMERIC 2 0 0 QUAN_TREAT (Acres Treated) 16 7 NUMERIC 0 0 0 MFG_FIRMNO --| 17 5 NUMERIC 0 0 0 LABEL_SEQ_NO | The four components 18 2 ASCII 0 0 REVISION_NO | of EPA Reg Number 19 7 NUMERIC 0 0 0 REG_FIRMNO --| 20 40 ASCII 0 0 DNAME (Brand Name) 21 8 NUMERIC 2 0 0 AMT_USED 22 2 ASCII 0 0 AMT_UNITS