OVERVIEW
n F
R C R A FACILITIES
A N D
SUPERFUND ( C E R C L A ) SITES
NATIONAL SYSTEMS
^
tf
\
LJJ
OFFICE OF INFORHATIUN RESOURCES MANAGEMENT
APRIL, 1985
-------
ON A NATIONAL LEVEL DATA FROM ALL TEN REGIONS HAS BEEN
MERGED CREATING A SINGLE LARGE DATA BASE TO SIMPLIFY
NATIONAL RETRIEVALS AND QUERIES. THE HWDMS REGIONAL AND
NATIONAL DATA BASES ARE ALSO USED TO CREATE AUTOMATED
GRAPHS- THE MOST FREQUENTLY USED GRAPHICS SOFTWARE HAS
BEEN TELL-A-GRAF AND GEOMAP.
SEE FIGURES 8, 9 AND 10 FOR A SAMPLE STANDARD LISTING,
LINE CHART (TELL-A-GRAF) AND MAP (GEOMAP).
-------
CERCLIS ABSTRACT
COVERAGE
STATUTE
PROGRAM OFFICE
CONTACT
ADP TECHNICAL OFFICE
CONTACT
HARDWARE
SUPERFUND SITE INVENTORY
EVENT AND FINANCIAL TRACKING
COMPREHENSIVE EMERGENCY
RESPONSE,, COMPENSATION AND
LIABILITY ACT (1980)
OFFICE OF EMERGENCY AND
REMEDIAL RESPONSE (OERR)
BRUCE ENGELBERT
FTS 382-2441
OFFICE OF INFORMATION
RESOURCES MANAGEMENT (OIRM)
CONSTANCE DREW
FTS 382-2410
POP 11/70 (DATA ENTRY)
NCC IBM 3081 (UPDATE, RETRIEVAL)
SOFTWARE
USERS
NO- OF SITES
USER DOCUMENTATION
RETRIEVALS
- INFORM (DATA ENTRY)
SYSTEM 2000 (UPDATE, RETRIEVAL)
- OERR (EPA HQ)
REGIONAL SUPERFUND OFFICES
NEIC (DENVER)
- 20,000
- CERCLA USER'S GUIDE,
VOLUMES I AND II
- RETRIEVAL MENU ACCESSABLE ON
NCC IBM TO AUTHORIZED USERS ~
STANDARD AND AD~HOC RETRIEVALS-
-------
CERCLIS DESCRIPTION
THE COMPREHENSIVE EMERGENCY RESPONSE, COMPENSATION
AND LIABILITY INFORMATION SYSTEM (CERCLIS) is AN AUTOMATED
INVENTORY OF SITES UNDER THE PURVIEW OF THE CERCLA PROGRAM,
ADMINISTERED BY THE OFFICE OF EMERGENCY AND REMEDIAL RESPONSE
(OERR). CERCLIS DEVELOPMENT AND MAINTENANCE is MANAGED BY
THE OFFICE OF INFORMATION RESOURCES MANAGEMENT (SEE FIGURE 1).
DATA
CERCLIS CONTAINS THESE MAJOR TYPES OF DATA:
0 SITE IDENTIFICATION, LOCATION AND DESCRIPTION
0 PROGRAM (REMEDIAL, REMOVAL, ENFORCEMENT) IDENTIFICATION
AND DESCRIPTION
0 EVENT IDENTIFICATION, DESCRIPTION AND SCHEDULE
0 FINANCIAL OBLIGATIONS AND EXPENDITURES
0 TASK IDENTIFICATION, DESCRIPTION, SCHEDULE AND
EXPENDITURES
0 MONTHLY TASK PLANS
0 SITE ALIAS NAMES AND LOCATIONS
0 REGIONAL COMMENTS
0 REGIONAL UTILITY RECORDS
(SEE FIGURE 2 FOR A DETAILED DATA BASE STRUCTURE CHART.)
OPERATIONS
CERCLIS DATA ENTRY, EXCEPT FOR FINANCIAL DATA, IS
PERFORMED IN THE REGIONS USING INPUT SCREENS DEVELOPED ON
THE PDP 11/70 IN INFORM- FINANCIAL DATA is ENTERED BY OERR
AT EPA HEADQUARTERS. THE DATA is SENT TO TRANSACTION FILES
ON THE NCC IBM- THESE FILES ARE USED EVERY THURSDAY NIGHT
TO UPDATE THE CERCLIS DATA BASE- UPDATE REPORTS ARE ROUTED
TO THE REGIONS, AND TO EPA HEADQUARTERS WHEN THE HEADQUARTERS
(FINANCIAL) UPDATE is RUN-
MENU-DRIVEN ACCESS TO STANDARD REPORTS AND AD-HOC
QUERY CAPABILITY IS PROVIDED ON THE NCC~IBM. USERS CAN
ALSO CREATE THEIR OWN RETRIEVALS- AUTOMATED GRAPHS CAN BE
CREATED- THE MOST COMMONLY USED GRAPHICS SOFTWARE HAS BEEN
TELL-A-GRAF AND GEOMAP-
SEE FIGURES 3, 4, 5 AND 6 FOR A SAMPLE STANDARD LISTING,
BAR CHART (TELL-A-GRAF) AND MAPS (GEOMAP).
-------
o
a
a
a.
Q
g
o
LU
O
o
Q.
O
O
i
oc
LU
CO
O
UJ
c
(D
(D
D)
CO
C
CO
CO
O)
O
OC
U
o
LU
LU tO
1 Z
to o
3E to
LU
ace:
_i >-
^3 (_)
CO Z
LU
li (^
O a:
LU
LU S
ULU
LL Q
LL z
CD <
Q
tr
0
s\
\
LL Q
LL _
CD <
LU
LL tO
O <
LU
O Q
ocS
to
O 0
to o
t to
i-. UJ CO
QJ LMM (HUM
Qiini £^) f*^]
o
h-
» V
LU LU
£. ^ 1
LU O
£S i^2
_.PQ
Figure 1
-------
UJ LLJ UJ
CD I- E
< < M
a Q t-
I- Q
z o
o o
OOOOOCaOOOOOO'-^'-^OOOOO
r a
O LU LU
o in (- o i
Z CX LU Z
o iu z o i
E CD o sr i
o
O D;
O
1-
r: cc
S :*
< <
or ir uj z
i to D
I LU X
X U
o to
CL uj
D M
< ct
Q UJ
JZ
o
13
2: -J. 3!
O 2 CJ
tO LCi < C9
: o
. O OJ uj uj _ , _ . . . .
K z K CL CK n -i < ;: u r~ < x
U O O uj < oc -" T) O < O [>: LU
>-r:>-£tjuj<- ^
O CJ
Z. O-
UJ u)
z _>
O <:
(- a
O uj
UJ 21
o a <
a:
a. g -J
-i < o
Z U
yj 2; uj
E uj
ZOO
O o:
Ct uj
10 UJ
o
Z) M
7.
O
U
O
(-
M
to
D
UJ
(-
QJ
Oj
D.
3
:r
LB
K O LU
E S OJ O UJ
< O tn aj i
o: 3 >- o -ii
UJ to Z 3 UJ z o I
ttj z o Q; o* r3 i
s: o < i- LJ a t-
LU
CD
o
t
ZZ
o O
r< to >
o in -i
-> 1- 3
UJ I/I O
Z
O
H
o:
LJ
CO
r:
3
u. h-
O UJ
x O a: ci
I- O <
to D. D:
O l-c I-
i. to
o ti 7: CD
U i-
< l-l O
> o »-
o;
X LU UJ
t-O CX
T. D. EL
O I;
to "
D: ;'::
Uj CO
i; tr
CE tO O L .
LU >- O Lv: c:; a.
!> II UJ u- * O J uj 21 '<
o-"t-iu-»-~>-u.-j;cj
ry <£ Q: uj dj ^H -^ c, ^; <
tJ5£3_UJ~)tD^H-IJtJt
< UJ
i-c 3:
o <
LU Z
a
LO UJ
H-
* 10
O LU
l-l O
Lu UJ
tn to
u:
<
cr
cu
O
D-
tn
O
LU
CD O
to z
< <
to
tr
uj to
-" ^:
o a:
II uj
-
Q ^ a: uj M
z uj LU >- 13 in
< LU t- Z I- <
-Ja:i-oztn>o
u < o r> jr -J <
< o < to D:
<
OZ
no
> o:
-i
CJU-
o- o
in
DO
U_ M
UJCL-
cef-o.
oji
~
uuLu
KK
M <
to M
o
LU o
< _J
O O t-(
1-1 1 LU
Q: LU o
LU I-* i'
nu. <
< -J
tr
u. M n_
o<3
o
Z
< _i
3rt-4o:o
to u_ o z
ii Q
to < (/>
Z UJ -
UJ 3; Z
tO Q 3
O O O
-i o: or
aj aj co
uj
.
o>-
2-J
: o
O
in <
H o
re t-
_j to
CL LU Ct'
H UJ
o i-i r:
Z in D:
M UJ O
KJ I D. O
to to
Z >-« *~f m
o a -
i- uj or
or ^ to uj
E in in «-i
^J JJJ to D-
< o: uj r:
c. CL ar to
cc >-
-J rt -H z E
tn z> w LU n;
tn o j: O h- <
uj Ct' uj L_
_J Q ^" J I
z -i CJ n;
< >~ to " (?- CD O Cv' CT I?" C*- O"- O^ O' C- C*' C^ O C?' O C"1 C1' [7" O* C^ C^ O r^ C3 C1' O C*' C*
OOQOOOOQOOOOOQOQOQOCjGCJCTjLTinotTjQO c~i ni~if~ir^r^. p^f~if~inr^r^f>
ttliQ.Q.D.LXD.LXD-Q-D-n.Q-tlJO-LXCXLXC.L.Q.LL^C.Li-tj.Ci.CJ-Q.L^tXB.t^U.D^LtattaCfcCLL.L^E..
c; c*-
^; o
-------
Dl
o
o
O
O
O
Figure 4
-------
o
4
K
HO.
O
"~^ ^K ^
OLLi^i
O'-'J O
OK^^
o
UNTY
CREEK
y^
n.
UNTY
Z'NC
ISf.igS-SzK.
sl^SS^f **
!lP,l|sl,.,
<<^f|S2og
_ 1
i
.CIS
> Q(K
CKO
mo.
Figure 5
-------
w
/ N-
w
GO
+j
r
'"V ^H .
K Q ^
w -^ *
^ SH "^
^ ^ 2
^15^
cC
00
I
PS
a,
Figure 6
-------
UJ
oc
o
c
(A
IU
en
<
CD
in?
?£**
i-. -(>o . ,? .-
K i' i," S a cj C ^ !?
? ^:": ; < | ? ? '; 5
r --
f i' c J ^ 3; '' F H ? s 3 i. i ""' i :':,''
Jo!uu,mlf;^i-l'i-i<5555li'nluKttino"*^'VP'?^0^
f('i5*. ff«ini5;)nnor>iuuj?tti(Ef-(ittftft.«uit « tiviii>o^5aas5s
:m
.m
I!
I!
I
-------
111
U)
ill!
s i .
s*sJ
is
5 I >l
la«Il^si|
HWIf
s Illllllli
iii!i3lil^Ii!I!5ilii!!
i i J
iiili
iil^ir
Jf
S3
:ls^
1
I
ON-CHMMENTS
K
ijj
. k s ri ?
CJ-
z
!s
S3
I's
tell
.'SJSitEfiE't.. *Z|;;. iii
:;n^5'rnS:: . -:aji;-;^l
iiitllllil'; ?ilii^??i
Ji.xxs;:;; ssss'. -.-;«? .-. ;J;x
z
i
j
«
i
i
o
g
!
IS
II
ll
III
r. r. £
' '. *
S -; in.
^
?
z
rs
s
sli
|o!i
I h
ii ss= s
*-Q> t-t-^y)W
; ; :; # "; "i 5 5
ITTTT17XIT
H
b
-------
HAZARDOUS WASTE DATA MANAGEMENT SYSTEM
(HWDMS)
-------
HWDMS ABSTRACT
COVERAGE
STATUTE
PROGRAM OFFICE
CONTACT
ADP TECHNICAL OFFICE
CONTACT
HARDWARE
SOFTWARE
USERS
NO. OF FACILITIES
USER DOCUMENTATION
RETRIEVALS
- FACILITY IDENTIFICATION,
LOCATION, SIC CODES, OWNER
AND OPERATOR INFORMATION
WASTE INFORMATION
PERMIT TRACKING
COMPLIANCE AND ENFORCEMENT
TRACKING
- RESOURCE CONSERVATION AND
RECOVERY ACT (1980)
- OFFICE OF SOLID WASTE (OSW)
- STEVE LEVY
FTS 382-4697
- OFFICE OF INFORMATION
RESOURCES MANAGEMENT (OIRM)
- CONSTANCE DREW
FTS 382-2410
- PDP 11/70 (DATA ENTRY)
NCC IBM 3081 (UPDATE, RETRIEVAL)
- INFORM (DATA ENTRY)
SYSTEM 2000 (UPDATE, RETRIEVAL)
- OSW AND OWPE (EPA HQ)
REGIONAL RCRA OFFICES
STATES
- 105,000
- HWDMS SCREEN ENTRY MANUAL
HWDMS FUNCTION DRIVER MANUAL
- RETRIEVAL MENU ACCESSABLE ON
NCC IBM TO AUTHORIZED USERS -
STANDARD AND AD-HOC RETRIEVALS-
-------
HWIJHS DESCRIPTION
THE HAZARDOUS WASTE DATA MANAGEMENT SYSTEM is AN
AUTOMATED SYSTEM FOR MANAGING FACILITIES REGULATED UNDER THE
RESOURCE CONSERVATION AND RECOVERY ACT (RCRA), WHICH REGULATES
GENERATORS, TRANSPORTERS, TREATERS, STORERS, AND DISPOSERS
OF HAZARDOUS WASTE- RCRA IS ADMINISTERED BY THE OFFICE OF
SOLID WASTE (OSW) WHICH is MAJOR FUNCTIONAL USER OF HWDMS.
HWDMS ADP DEVELOPMENT AND MAINTENANCE IS MANAGED BY THE
OFFICE OF INFORMATION RESOURCES MANAGEMENT (SEE FIGURE 1).
DATA
HWDMS CONTAINS THESE MAJOR TYPES OF DATA:
0 FACILITY LEVEL DATA INCLUDING FACILITY LOCATION,
MAILING, OWNER AND OPERATOR NAMES AND ADDRESSES;
GEOGRAPHIC INFORMATION ON THE LOCATION OF THE
FACILITY; SIC CODES-
0 WASTE PROCESS DESIGN TYPE AND CAPACITY AVAILABLE
AT THE FACILITY, AND THE TYPES OF WASTES ACTUALLY
PROCESSED AS REPORTED BY FACILITIES ON THEIR RCRA
NOTIFICATION FORMS AND PART A, PERMIT APPLICATIONS.
0 ACTION-EVENTS IN THE PART B PERMITTING PROCESS;
FINANCIAL MANAGEMENT DATA; CLOSURE/POST-CLOSURE
ACTIONS; AND GROUND WATER MONITORING ACTIONS-
0 COMPLIANCE AND ENFORCEMENT DATA RELATED TO COMPLIANCE
MONITORING AND ENFORCEMENT ACTIONS THAT DO NOT INVOLVE
LITIGATION. (ACTIONS INVOLVING LITIGATION ARE TRACKED
WHEN THEY ARE FILED AND COMPLETED; CIVIL AND CRIMINAL
ACTIONS ARE TRACKED IN MORE DETAIL IN A SYSTEM
CALLED DOCKET).
(SEE FIGURE 7 FOR A DETAILED DATA BASE STRUCTURE CHART-)
OPERATIONS
HWDMS DATA ENTRY IS PERFORMED IN THE REGIONS AND IN
SOME STATES USING INPUT SCREENS DEVELOPED ON THE PDP 11/70
IN INFORM. HWDF1S DATA RESIDES IN TEN REGIONAL DATA BASES
ON THE NCC IBF1- EACH REGION HAS A DATA BASE ADMINISTRATOR
WHO IS RESPONSIBLE FOR UPDATING AND MAINTAINING THEIR
REGIONAL DATA BASE. UPDATES ARE RUN ON THE NCC IBM AND
THE UPDATE REPORTS ARE RECEIVED BACK IN THE REGION-
HWDMS PROVIDES MENU-DRIVEN ACCESS
AND AN AD-HOC QUERY CAPABILITY. USERS
OWN RETRIEVALS-
TO STANDARD REPORTS
CAN ALSO CREATE THEIR
-------
IH 10 13 ID (9
CD
<
O.
f~
a-
o
LJ1
U-
o
in
H-
(/>
H
X
KI
o
o.
3
in
<
3
a.
a:
£
g
_J
CO
U
Z
g
in
o
a:
a.
_l Q
M O
O p;
< CL
U.
UJ
K 19
UJ
Ul
OJ
r-
-
t-
tr
in
<
3
CD
cc
)
Z
U
M
CK
u
z
UJ
in >
in M
UJ h-
a: u
o uj
a i-
< O
QL
a o-
o i^
I- Z r~
< o M
o: t-i
uj V) x
Q. M O
O U OJ
UJ
o o o o
o o o co
CM O CM Ifl
z
CD
in
UJ
o
(f)
CO
O
Ifl
O
CM
I
r-.
CO
cO
o
CO
o
u
I-
z
CL
O
<
M
or
or
a.
o
in
W <
a M
u
CC
o
LJ
O: a o cj
a z in i
o *H f*i r*
< CM CO
O cO
a: u x x
UJ M O 0s
z a m z o
3 < co
00 -3
I- O T
UJ Q. Z
3 <
D- IB in
or o -<
iu > r-.
CD Ifl .O
r oo
3 o- o
z oo
a o
o: B:
o. a.
a: Z
O O O -H
CO CO CO CO
X X X X
*j- r-^ t> \f\
** o ** *«
X X X X
CO « ~<
in a Q o a a
< D uj uj uj uj uj
(- >- > CD > U> O
< < M O M Q O
Q K- UJ UJ HJ UJ UJ
in u -t u -J -J
Z UJ 3 UJ 3 3
O t- oc O a: O O
< CK O U
CO « -O O CJ
O
U
O
u. t- a: ce
M < < <
f- o a. a.
o M
z u.
eg
CO
f-
in
o:
D.
O
z
X
o
oooooooo
Q
o
X
Ul
z
o
a
z
<
sx.
o
o
Z
Z)
O
LJ
o:
in co
in i:
UJ
o: *
O UJ
a
< uj
irt
CD O
O r-- Q;
z 1*1 uj
< E
- Z < > 3
< < OJ 0- O O
n HI < Z H
: M o
3 Z
< a.
cc
o K
z o
< t-
-i «t
DC
z uj
< D-
M O
Q X
V)
UJ
O
O Kl
O
*O
z z a:
UJ UJ 3
Q a t-
It) LJI it j nt UJ
»-t-l t t-)
OOOOOOO-4
oooooooo
QQQu_u_U-U.u_
LU " ' " ' ' 111 111 in
oaoaanao
ooaooooo
uuuuuuuu
o o
u u
Figure 3
-------
c
o
o
o
o:
o
00
"o
&
Figure 9
-------
Figure 10
-------
FACILITY INDEX SYSTEM
(FINDS)
-------
FINDS ABSTRACT
COVERAGE
STATUTE
PROGRAM OFFICE
CONTACT
ADP TECHNICAL OFFICE
CONTACT
HARDWARE
SOFTWARE
USERS
NO. OF SITES/FACILITIES
USER DOCUMENTATION
RETRIEVALS
- FACILITIES AND SITES REGULATED
UNDER THE VARIOUS EPA PROGRAMS
- N/A
- OFFICE OF INFORMATION
RESOURCES MANAGEMENT (OIRM)
- DANIEL CIRELLI
FTS 382-2416
- OIRM
- CONSTANCE DREW
FTS 382-2410
- NCC IBM 30R1
- ADABAS
- HQ AND REGIONAL PROGRAM OFFICES
REGIONAL FINDS STAFFS
OIRM
- 171,000
- FINDS USER'S GUIDE
- RETRIEVAL MENU ACCESSABLE TO
AUTHORIZED USERS FOR ON~LINE
REVIEW OF FACILITY/SITE
RECORDS, OR FOR STANDARD
BATCH RETRIEVALS. AD-HOC
RETRIEVALS ARE PROVIDED BY
A CENTRALIZED USER SUPPORT
GROUP.
NOTE: ALTHOUGH FINDS is MANAGED FROM A FUNCTIONAL AND TECHNICAL
STANDPOINT BY OIRM, IT HAS BEEN INCLUDED IN THIS BROCHURE
BECAUSE IT IS A NATIONAL ADP SYSTEM SUPPORTING OSWER AS
WELL AS OTHER PROGRAM OFFICES-
-------
FINDS DESCRIPTION
THE FACILITY INDEX SYSTEM (FINDS) is AN AUTOMATED
INVENTORY OF FACILITIES AND SITES REGULATED BY EPA. FINDS
SUPPORTS THE ASSIGNMENT OF THE STANDARD EPA ID NUMBER, A
UNIQUE NUMBER ASSIGNED TO THE FACILITIES OR SITES THAT FALL
UNDER THE JURISDICTION OF THE VARIOUS EPA ADMINISTERED
LEGISLATION AND REGULATIONS. EACH FINDS RECORD INDICATES
THE EPA PROGRAM/MEDIA ADP SYSTEMS THAT CONTAIN MORE
INFORMATION ABOUT THE FACILITY OR SITE. FINDS THEREBY
PROVIDES EPA WITH A CROSS - PROGRAM/MED IA PERSPECTIVE ON A
FACILITY AND IDENTIFIES THOSE PROGRAMS FROM WHICH MORE
DETAILED, PROGRAM-SPECIFIC INFORMATION ABOUT THE FACILITY
OR SITE CAN BE RETRIEVED. FIGURE 11 SHOWS THE VARIOUS EPA
PROGRAMS AND SYSTEMS WHICH ARF INDEXED BY FINDS-
DATA
FINDS CONTAINS THE FOLLOWING TYPES OF DATA ;
0 EPA IDENTIFICATION NUMBER, FACILITY/SITE NAME AND
ADDRESSES
0 OWNER AND OPERATORS' NAMES AND ADDRESSES
0 LATITUDE, LONGITUDE AND OTHER LOCATION INFORMATION
(E.G., CONGRESSIONAL DISTRICT CODE, RIVER BASIN
CODE, AQCR)
0 SOURCE RECORDS CONTAINING INDICATORS THAT DENOTE
WHICH EPA PROGRAM SYSTEMS MAINTAIN INFORMATION ABOUT
THE FACILITY OR SITE
° ALIAS NAMES AND ID NUMBERS BY WHICH THE FACILITY IS
KNOWN IN PROGRAM-SPECIFIC SYSTEMS
0 IDENTIFICATION OF AN EXISTING ENVIRONMENTAL PERMIT(S)
ISSUED TO THE FACILITY
0 REGIONAL UTILITY RECORD
0 REGIONAL COMMENTS
(SEE FIGURE 12 FOR A STRUCTURE CHART AND DATA ELEMENT
LIST. )
-------
OPERATIONS
FINDS IS AN ON-LINE INTERACTIVE SYSTEM USING THE NCC
IBM. DATA ENTRY is PERFORMED BY THE REGIONS THROUGH 3270-
TYPE TERMINALS USING THE ON~LINE SCREEN ENTRY PACKAGE, WHICH
EDITS, UPDATES AND RETRIEVES DATA- A RETRIEVAL MENU IS
ACCESSABLE TO AUTHORIZED USERS FOR ON~LINE REVIEW OF
FACILITY/SITE RECORDS, OR FOR STANDARD BATCH RETRIEVALS-
AD-HOC RETRIEVALS ARE PROVIDED BY A CENTRALIZED USER
SUPPORT GROUP-
AUTOMATED GRAPHS AND MAPS CAN BE CREATED- THE MOST
FREQUENTLY USED GRAPHICS PACKAGES HAVE BEEN TELL^A-QRAF
AND GEOMAP.
SEE FIGURES 13, 14 AND 15 FOR A SAMPLE STANDARD LISTING,
BAR CHART (TELL-A-GRAF) AND MAP (GEOMAP).
-------
o
H
QC
o
jli « !
' s s e I s *
3
rS?"
*§52
\
52
o
THE
EWCALSW
OMUEMCE
Z O
1
I
10
V
OFFICE
OF
i SUBSTANCE
V
X
a
^
i
/
_i
<
0
t
Q
Q
<
<0°
^^^ /
Q> /
UJ
Z* 8
UJ
iT* L
"-w
Q
>
O
cc
a.
X
o
^iM
i is
LJJ 9 UJ ^ £
a £ ; 5 frotll
o "SS S 55
\ ! f /
i \ I
O * K *" u)
O III UJ
s / 1
/ A
/ -- \
_J O LL. . U>
s sip sil
£ z ° <
\ 2 /
\ it /
\ /
V /7
\, /
\ *\ V /
sV \ / //
\i \ s/
"o \ / *,
V*B \ ?'/
\% / "/
/ x \
/ M*L 2 Z t \
W a 0<25
Q 5 g ua \- o S
u>-S o., U.WOCO<
E 3" ° 223
\ * -"* 1
\ J
/! J ^ \
'$ Jf, \ ^\
-------
FACILITY INDEX SYSTEM
FINDS
FILE STRUCTURE
FINDS-SOURCE
RECORD-TYPE
EPA-ID-NUMBER
FINDS-REGIONAL
RECORD-TYPE
EPA-ID-NUMBER
FINDS-LOCATION
RECORD-TYPE
EPA-ID-NUMBER
FINDS-COWOTS
RECORD-TYPE
EPA-ID-NUMBER
FINDS-HISTORY
RECORD-TYPE
EPA-ID-NUMBER
TKE RELATIONSHIPS DEPICTED HERE ARE THOSE SUPPORTED BY THE FINDS
SCREEN PACKAGE.
Fiyure 12
Sheet '. : -;
-------
FINDS-LOCATION RECORDS COMPRISE;
EPA-ID-NUMBER
DE RECORD-TYPE
HE LAST-UPDATE
UE REGION-CODE
DE FACILITY-OWNER-TYPE
PE ADDRESSES, WHICH COMPRISES:
ADDRESS-TYPE
NAME
STREET
CITY
STATE
ZIP-CODE
INACTIVE-DATE
ADDRESS-COMMENT
MU(b) PREVIOUS-SITE-ID
COUNTY-CODE
COUNTY-NAME
AQCR
RIVER-BASIN-CODE
USGS-CATALOGUING-UNIT
CONG-DIST-CODE
PLACE-CODE
LL-SOURCE
LATITUDE, WHICH COMPRISES:
LAT-DEGREES
LAT-MINUTES
LAT-SECONDS
LONGITUDE, WHICH COMPRISES:
LONG-DEGREES
LONG-MINUTES
LONG-SECONDS
INDIAN-LAND-IND
DE SUPERLS, STATE CODE OF THE EPA-ID-NUMRER
DE SUPERID, WHICH COMPRISES:
EPA-ID-NUMBER
RECORD-TYPE = L
DE SUPERIE, WHICH COMPRISES:
RECORD-TYPE = L
REGION-CODE
'inure 12
-------
FINDS-SOURCE RECORDS COMPRISE:
EPA-ID-NUMBER
DE RECORD-TYPE
DE LAST-UPDATE
DE REGION-CODE
FINDS-ENTRY-DATE
DE SOURCE-INDICATOR
DE SOURCE-ID-NUMBER
DE PERMIT-INDICATOR
DE SOURCE-ATRR1
SOURCE-ATTR2
SOURCE-FACILITY-NAME
SOURCE-FACILITY-STREET
SOURCE-FACILITY-CITY
SOURCE-FACILITY-STATE
SOURCE-FACILITY-ZIP
SOURCE-FACILITY-DATE
SOURCE-FREE-FIELD
UPDATE-INDICATOR
PERMIT-NUMBER
DE SUPERID, WHICH COMPRISES:
EPA-ID-NUMBER
RECORD-TYPE = S
DE SUPERIE, WHICH COMPRISES:
RECORD-TYPE - S
REGION-CODE
FINDS-REGIONAL RECORDS COMPRISE
EPA-ID-NUMBER
DE RECORD-TYPE
DE LAST-UPDATE
DE REGION-CODE
PARENT-EPA-ID
PARENT-COMPANY-NAME
CONTACT-NAME
CONTACT-TELEPHONE
LAST-RESEARCH-DATE
MU(4) SIC-CODES
REGIONAL-ELEMENT-01
REGIONAL-ELEMENTS
REGIONAL-ELEMENT-03
REGIONAL-ELEMENT-04
REGIONAL-ELEMENI-05
REGIONAL-ELEMENT-06
REGIONAL-ELEMF.NT-07
REGIONAL-ELEMENT-08
REGIONAL-ELEMENT-09
REGIONAL-ELEMENT-10
DE SUPERID, WHICH COMPRISES:
EPA-ID-NUMBER
RECORD-TYPE = R
DE SUPERIE, WHICH COMPRISES:
RECORD-TYPE = R
REGION-CODE
Figure 12
Sheet 3 of 4
-------
FINDS-COMMENTS RECORDS COMPRISE:
EPA-ID-NUMBER
DE RECORD-TYPE
DE LAST-UPDATE
DE REGION-CODE
COMMENT-NUMBERS
MU COMMENT-DATA
DE SUPERID, WHICH COMPRISES:
EPA-ID-NUMBER
RECORD-TYPE = C
DE SUPERIE, WHICH COMPRISES:
RECORD-TYPE = C
REGION-CODE
FINDS-HISTORY RECORDS COMPRISE;
EPA-ID-NUMBER
DE RECORD-TYPE
DE LAST-UPDATE
DE REGION-CODE
DE FACILITY-OWNER-TYPE
PE ADDRESSES, WHICH COMPRISES:
ADDRESS-TYPE
NAME
STREET
CITY
STATE
ZIP-CODE
INACTIVE-DATE
ADDRESS-COMMENT
MU(6) PREVIOUS-SITE-ID
COUNTY-CODE
COUNTY-NAME
AQCR
RIVER-BASIN-CODE
USGS-CATALOGUING-UNIT
CONG-DIST-CODE
PLACE-CODE
LL-SOURCE
LATITUDE, WHICH COMPRISES:
LAT-DEGREES
LAT-MINUTES
LAT-SECONDS
LONGITUDE, WHICH COMPRISES:
LONG-DEGREES
LONG-MINUTES
LONG-SECONDS
INDIAN-LAND-IND
DE SUPERLS, STATE CODE OF THE EPA-ID-NUMBER
DE SUPERID, WHICH COMPRISES:
EPA-ID-NUMBER
RECORD-TYPE = H
DE SUPERIE, WHICH COMPRISES:
RECORD-TYPE = H
REGION-CODE
Figure 12
Sheet 4 of 4
-------
U1 "1
CO O
v.
r-« o
o* irt
N «
-J *
U ut
o
U
O H fl O
as i/> H z
aj >- z o
U1 UU ^|
« N
M M
>) x -J a
LITY LOCAIIOM
LITY COUKTIf H.
y u
*e <
a
(U
r*-. ^
r- O
1/1 0j
M
EU
X X
r- O
x;
=r x
O rJ
- cw
as
^ O
VD 3B
""1 33
y O
r- -5
JEFFESSCN ST
HA«K
«- y
o «c
«- CO
NO
YSOWVNV 3 n o
"X.
> M
3E *J
ai y
O
cc
[lj
;g} 33
oi y
W
M;
O
r-j ca
u
nrt x
«S U
ac
O
H
0
'SI tit
M tt
2 u
aa
r- :E
U
SB
O
35
Jl
O
I*
o
0
M OS
33
N U
Jl
M
u)
H SH
« O
c/l
0 SB
O 23
» O
-)
aj M
M u
O
yro* =»i~^O4'"4^ NfN *!*!
^i""l 2>O'-1'1~'~^~f*OvO
cu^o^r-r-oooo wo
H O r- rv o fN^J^- »* *~ "c~ (N O
t*l kTl in U1 L/l LOk-^kA lA LA LA LA in
M H
H -1 * « -« ««S-« H H ^ z M f-( J M k-i M M
H M; Oi
tO VI X E-c
Ctl Q Q Ol CO
< QJ a, t-« M ^
sa -< -( o >H y
QSasCJ *- M _j 0*0
O a* tK « co -1Q p-t O
HI << Ldb]-e i-t tn u y 05
'->HAi y y^O~v 7; K 3 ^j i-3 'jl h-t ^J
O ^ Cti Q IDLfiOHMQCEH
f-1 IJ O ^ **4 &uk-4iki O O <£ ^ Jl J^MUZ
ywo OCLO y u LU M^ -* aft/siw
£ -^ -a2 ai'/i «cc mo ^ z w " w^J - - " ^io aw ^U
4-J -CK ^^ * .a *twi -It- *as O-<
U y «3 (.1 *i r- t-5 « ?« C <-« '-3 U 2 JJ '- JJ * -O S rt ^ J
^ ^ y :ij MM jj cj ii3 ^ :o j w rt: 'J ^ ^u EU i: ^ ;u tu <
s^ * ~ ca z; ,-j 3; y T: .«. ^ y x '.j ~ y ' y 'c y T^ y o
y y y 'w» ^ ^l/^OCT*
>*ki>Hia3i-J^ -^0 -75 ^ "* ^ r» "» " f*« f
Itl (IH S3 \ O"0 "^TD O"O O'i) '-^'O "^'O ."TO "3 -1* OO Of*" '""(CH
r^Ett" CC1^ CO"^ .OO ^ ~t ,:**~ *Cr^ ^O 33"" O «". yr 'S'Nj
r-» *-.
-M 0
^) 1/1
(N **
LA tA
< <
J_, M
o o
y LJ
^ J »J
< -s en
y u **
H M CM
x: x: ra
x o s: a
y -o y
EB Q 30-4
o «* o y
* > ra
JJ -H J} O
zti i*. « y
y y
Li-l J
J -J SO
t O Ul O
00 OX
X N "^ "N
?* r* C3 **
<-S| «" fX.
^ T~ f\j
^- ;* > uc 5-
[J iJ fr3 O IM f
X O 1Z3 Z ^ i-t
u u y
1*1 -*i j-i
3- 0 U1
^J ^} r-
Figure 13
-------
ON OF
ES
M DISTRIB
NDS FACIU
PROG
g
00
R
If
«L
u>
-------
CERCLA
DATA BASE STRUCTURE
II" SITFS
SI ( MFC1ION
SI ! STATE
SI I LPA.ID
SI I NAME
SI ( STREET
SI F: CUV
SITS- ZIP
SITF-COUNTY.NAME
SITP COUNIY I'.ODF
SITF coNarnsi
SITE; INVENIORYIMU
SHI I'ED F.ACVINO
sin: SMSA
Silt: OESC
Sltf HPM NAMf
SITU nPM.CHONE
SITE REMED1A1 INU
SHE REMOVAL-INO
SITfc APPROACH
SITF CLASSIFICATION
SIN-MAST -UPIMTE
SI1F NAME SOURCE
S11E-RESPONS6-TERM
SIML-PRIOIIITY-LIST INO
SITE-NPL-UST1NC5-DA1E
SITE-NPL DIiLISriNG OA1F
SITE SOURCE-COUNT-NOTIS
SITI; SOURCE COUNT-STS
SITF SOURCE COUN1-HWUMS
SI Fli-SOUHCE COUNT-COMPOSITE
SIIF^SOUROE COUNT-OTHF'H
SHI-'SPILL-IDS
IATITLJUE
LONC-I1UUI-
ENr-IJISF'OSITION WHI'
TNF DISF'USIIIONVII
r.Nr-uisF'ij;iiiK)N :.'n
NF [3isfo%in<>rj -"M
ill it
IYQHO UfAi-CUllf
lYDF^O ?'J»FltO Cu
IY'l)F(O At:n IJNI1
IYLJK'1 i A1 At ',*'. .J
ISGS ". I i'K) (."!!
TO I. "
i. 1F-0 I ' '"
1
'HOC'.','
I'llO'j A.
*-i'?OO 1.-'
: HOGUI
'HOG I1-
HOO-ui
VfeNTS
.*
V^ i.i»IK
l.'t
iC
sf.
Atir-tR
,,,-,- .-... '-.. .
;^^,.;:';\
12' ' ' A[ IAS c«i
'.fNI-.r-.l-i:
' VENri'-l
i V'ENf-Cl
S-CODF
AUIriFF'
-.'F.tllHAMI'
vL'NUH
VtHIl :
VI- NU i
'C
OF'-AGHht-NO
flPAGHHr-AMCN
~j NO
vl:NU ' )OP-AGnLT.-AMFND.STATUS
,'EHTS:
vbrjl I'-.
tNI H'"
.'EN'S1.
.'EN III.
VEMi'l
-.ENl-'i
lEC'm-SHA COS
COMf.'F-N*
rOMMEN'
1 i.lS
»0
13 rt'ARi-DA'i;
iL5 roMi-1 i>vi';
T
-,'ENl r'.infi 5IAn;..j.,i t
.f'll-i'.
I'li-coMPnArc
-Elll Wi! UAlfc
' VENTC-'JMP-DAIE
I
!|
1HI.L
..._J _...! .._
1 <, i "'.U.li (;' r: I ' l,'M ' : i ' . >''. > -:
A:" ' ->MM1 Nl l| '. l 1 Si*,-1' ;J -..i'.'1; ' ' *
4C4- n.iiuvr- 'ir
iO-r P j.'O'-'. -vn ;
Ifjc,- it (iio';:. ' Ml.t ( .1
??00" ALIAS 1 IX"ATiOr-f
2210' ALIA!.', LOG STMtF 1
2211' ALIAS. LO
P2I2' AI.IAS-LO
spin1 ALIA;; LO
2220' Al IAO LO
!??.' ' ALIAS L11
22?2' AI.I.A^i H.l
2J?3' ALIA:; 10
2224' ALIAS LO
J2:ft' ANAS 0
jzao' AIIAS i'1
2261V AIIAS n
2261' ll IAS i'
226.1' AH\S r
22(U- ,v AS- i
2.W.:- A. IAS , i'
?J"'J' A i1S-L<
; CITY
' 7IF'
S 1 A 1 1
U:O1INI> NAM
:-couMivconi
L: lAHtUI.il
; lONc.iii'nr
; COI4G i JIM
' NON ro'l'IC. 1
5M3A
. MVOH1 1 HI ('i i'.
HYUH! l ..HHF^r
' HYClFll ' ..i"CT
HSUFli.l ' Al Al
'VISOSH'..'!*!
: ntsc
Jl>
,'I'F;
!i I.''."!'?
11(11
, UNIT
'III'
ASK i!i -xu 'OT uo;
ASK-t'.:tJIH*CTO«-i.An
ASK-CONin*t.I NO
ASK WOMK ASSIGK-.'O
ASK ORIGP1AN-STAM
ASK OMIO-l'i AM-COI.'P
ASK CUR PI AN STAKT
ASK CUB P-. A'-I-COMP
ASK-0'"! SIAHT
ASK A(: 1 -CUWF1
\n a-'. "I
tN A'.'i -UN I
ASK I f AH MONTH
ASK P iHlt.TXP
ASK I' un[-XF'
ASK P S! Of FfXP
ASK P 'HH5 reil-COMP
ASK r un|5tH-coMr
ASKI- SI PFHCOW
ASK-P :OMMEWT
-------
L'o, Ssvironmental FrotoctIT.-
Henry, Rocrr. f;4 ;- 5k~3U -A
iJL M St:-f>e':., .^.VC
Washington, DC 20460
15
------- |