The information presented in the "File Naming and Storage Conventions" section of this README.TXT file discusses how to de-archive BRS data files. To effectively use this data you will need to understand how the data is structured and how the structures map to the data collection forms. The document "Instruction Manual For The Biennial Reporting System (BRS) NTIS Data Tape" presents the necessary structure and mapping information. This README.TXT file and the "Instruction Manual For The Biennial Reporting System (BRS) NTIS Data Tape" are included in the USOC_Y93.EXE archive. The file named USOUMY93.EXE is a self-extracting PKZIP archive containing the file USOUMY93.WP5. USOUMY93.WP5 is an electronic version of the data manual in WordPerfect 5.1/5.2 format. The document was designed to be printed using the CGTIMES and UNIVERSE fonts, provided with the Hewlett Packard LaserJet III series printers. About The Data ====================================================== Legislative Authority: Resource Conservation and Recovery Act of 1976 (RCRA) Sections 3002 and 3004. Hazardous and Solid Waste Amendments of 1984 (HSWA) Regulatory Authority: ===================== Code of Federal Regulations (CFR) Title 40 How Collected: ============== The data contained on these diskettes are the Preliminary Biennial Report (BR) data for reporting year 1993. Biennial Report data are collected by states from RCRA Treatment, Storage and Disposal (TSD) Facilities and RCRA Large Quantity Generators (LQGs). Collection, validation and verification of the BR data is the responsibility of RCRA authorized states. EPA does not modify the data reported by the states. Any questions regarding the information reported for a RCRA handler should be directed to the state agency responsible for the BR data collection. Reporting Universe ================== RCRA TSD and/or LQG information ONLY. EPA deletes from a state's BR data submission any handler that is not either a RCRA TSD or a RCRA LQG. This determination is made by examining the data values reported on form IC. Generator Status is reported on form IC, Section VI, Block A. Reporters having a generator status value of 1 are considered LQGs. RCRA TSD status is reported on form IC, Section VII, Block A (RCRA storage) and Block B (RCRA treatment). Reporters having either a RCRA storage status of 2, 3, 4, or 5, or a RCRA treatment status of 3 are considered TSDs. The RCRA generator status is found in field #11 in the S2 data file at column position 162. The RCRA storage status is found in field #17 in the S2 data file at column position 222. The RCRA treatment status is found in field #18 in the S2 data file at column position 223. Data Files and Structure ================================================================ One WordPerfect 5.2 formated file is provided. This file is the "Instruction Manual For The Biennial Reporting System (BRS) NTIS Data Tape" and presents the structure and mapping information necessary to read the data correctly. This file is named USOUMYyy.WP5 and is contained in the archive USOC_Yyy.ZIP(EXE) (yy = data year e.g., 89, 91 or 93). Thirty (30) ASCII data files are provided. Two of the data files contain information used to verify the integrity of the other thirty files. The first is the CONTROL (CL) file consisting of one record for each of the 28 data files. The control file provides record counts for each of the files containing reported data. The second is the FILE STATISTICS (FS) file which is a text file containing three reports with record frequencies by File-ID, by File-ID and State, and by State and File-ID. A new file the handler total (HT) file provides the following National Biennial Hazardous Waste Report quantity totals for each handler in the data files: RCRA Waste Generated, Received, Imported from other States, Managed on site, Received and Managed, Wastewater Managed, Non-Wastewater Managed, Shipped off site, and Waste Exported to other States. This file is provided with the USOS_Yyy.EXE archive. The twenty seven (27) remaining files contain the reported data. The reported data is organized in non-delimited ASCII files. These files are a relational representation of the data in third normal form. Each ASCII data file consists of fixed length records. The fields within each record are defined by their starting and ending column positions. The file layouts for these files are contained in the user manual described above. The BR ASCII data files are organized in groups based on the Forms used by the National Hazardous Waste Report as follows: Control File = File CL File Statistics = File FS Nat. Rpt. Quantity Totals = File HT Form IC = Files S1, S2, S3 and S5 Form GM = Files G1, G2, G3, G5, G6, G7, G8 and G9 Form WR = Files R1, R2, R3, R4 and R5 Form PS = Files T1, T2, T3 and T4 Form WM = Files M1, M2, M3, M5, M6, and M7 NOTE: The S4, G4, and M4 files are no longer used because the data is not reported after 1991. The files have not been re-numbered in order remain consistent with the standards and conventions used for 1989 and 1991 structures. File Naming and Storage Conventions ================================================================= File Groups Archived in a Single Compressed File =================================================== All files in each file set are stored in a single archive file using PKZIP. This will be either a self extracting (.EXE) file or a standard PKZIP (.ZIP) file depending on the storage medium. Diskette archives cannot be self-extracting because of the requirement to span multiple diskettes with a single archive file. Diskette Archives ================= BRS data file archives stored on diskette media will be standard PKZIP (.ZIP) archives. The PKUNZIP.EXE utility version 2.04g or later is required to open the archive. PKUNZIP.EXE is provided with diskette distributions of the data. The file names for the PKZIP standard (.ZIP) archives use the following naming conventions: USOx_Yyy.ZIP Where x = The first character of the File-ID (C, S, G, R, T, M) yy = The last two digits of the data year (e.g., 89, 91 or 93) Mass Storage Device Archives ============================ BRS flat files archives stored on mass storage devices will be self-extracting PKZIP (.EXE) archives. These archives are opened by typing the archive name, without the (.EXE) extension. The file names for the PKZIP self-extracting (.EXE) archives use the following naming conventions: USOx_Yyy.EXE where x = The first character of the File-ID (C, S, G, R, T, M) yy = The last two digits of the data year (e.g., 89, 91 or 93) Self Extracting Compressed Flat Files Within Each File Set Archive ================================================================= The individual flat files within a set are each stored in a PKZIP self-extracting archive. The file names for the PKZIP self-extracting (.EXE) archives use the following naming conventions: USOxxYyy.EXE Where xx = The File ID (UM, CL, FS, HT, S1-S5, G1-G9, R1-R5, T1-T4, M1-M7) yy = The last two digits of the data year (e.g., 89, 91 or 93) Uncompressed Flat Files ======================= The Uncompressed flat file names use the following naming conventions: USOxxYyy.BRS Where xx = The File ID (CL, FS, HT, S1-S5, G1-G9, R1-R5, T1-T4, M1-M7) yy = The last two digits of the data year (e.g., 91) USOUMYyy.WP5 is the "Instruction Manual For The Biennial Reporting System (BRS) NTIS Data Tape" and presents the necessary file structure and mapping information. Using PKUNZIP Utility ===================== PKUNZIP (R) FAST! Extract Utility Version 2.04g 02-01-93 Copr. 1989-1993 PKWARE Inc. All Rights Reserved. Shareware Version PKUNZIP Reg. U.S. Pat. and Tm. Off. Usage: PKUNZIP [options] zipfile [@list] [files...] -c[m] extract files to Console [with More] -d restore/create Directory structure stored in .ZIP file -e[c|d|e|n|p|r|s] Extract files. Sort by [CRC | Date | Extension | Name | Percentage | Reverse | Size] -f Freshen files in destination directory -j|J mask|don't mask files (def.=jhrs) -n extract only Newer files -o Overwrite previously existing files -p[a/b][c][#] extract to Printer [Asc mode,Bin mode,Com port] [port #] -q Enable ANSI comments -s[pwd] Decrypt with password [If no pwd is given, prompt for pwd] -t Test .ZIP file integrity -v[b][r][m][t] View .ZIP [Brief][Reverse][More][Technical] sort by [CRC| [c,d,e,n,o,p,s] Date|Extension|Name|natural Order(default)|Percentage|Size] -x eXclude file(s) from extraction -$ Restore volume label on destination drive -@listfile Generate list file -- TROUBLE SHOOTING OPTIONS -- If you experience difficulty with PKUNZIP, please consult your manual. If problems continue, please document the problem as well as possible and contact PKWARE technical support. 9025 North Deerwood Drive Brown Deer, WI 53223 Support BBS: 414-354-8670 Fax: 414-354-8559 -3 Disable 32-bit instruction usage on 80386 or higher CPU's -^ Echo the command line -+ Disable Expanded Memory (EMS) usage -- Disable UMB/HMA Memory (XMS) usage -) Disable 32 bit DPMI usage You can default any of these options with the PKUNZIP environment variable. Consult the file ADDENDUM.DOC for further information. If you use PKUNZIP on a regular basis you are strongly encouraged to register it. With a full registration of US $47.00 you will receive a comprehensive printed manual, the latest version of PKZIP, PKUNZIP & PKSFX software, and when available, the next version of the software. See the documentation for commercial and distribution licensing info. Send check or money order to: PKWARE, Inc. 9025 N. Deerwood Drive Brown Deer, WI 53223