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) Flat
Files" presents the necessary structure and mapping information.
This README.TXT file and the "Instruction Manual For The
Biennial Reporting System (BRS) Flat Files" are included in
the USOCY95.EXE archive. The file named FFMANUAL.EXE is a
self-extracting PKZIP archive containing the file FFMANUAL.PDF.
FFMANUAL.PDF is an electronic version of the data manual in
Adobe Acrobat format, and you must view it using the Adobe Acrobat
reader.
Adobe Acrobat readers are available through Adobe's Web site at -
http://www.adobe.com/prodindex/acrobat/readstep.html
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 in these files are the Biennial
Report (BR) data for reporting year 1995. 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 Adobe Acrobat PDF formated file is provided. This file is
the "Instruction Manual For The Biennial Reporting System (BRS)
Flat Files" and presents the structure and mapping information necessary
to read the data correctly. This file is named FFMANUAL.PDF and is
contained in the archive FFMANUAL.EXE)
Thirty (30) ASCII data files are provided. Two of the
data files contain information used to verify the integrity of
the other twenty-eight 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.
The file USOHT95.BRS handler total (HT) file provides 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 USOSY95.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
to 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 a self extracting (.EXE)
file.
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:
USOxY95.EXE
where x = The first character of the File-ID
(C, S, G, R, T, M)
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:
USOxxY95.EXE
Where xx = The File ID (UM, CL, FS, HT, S1-S5,
G1-G9, R1-R5, T1-T4, M1-M7)
Uncompressed Flat Files
=======================
The Uncompressed flat file names use the following naming
conventions:
USOxxY95.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)
FFMANUAL.PDF is the "Instruction Manual For The Biennial
Reporting System (BRS) NTIS Flat Files" and presents the necessary
file structure and mapping information.