Document ID: EPA-HQ-OW-2002-0033-0110
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2003-04-14T04:00Z

Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
PERM_
TYP­
FINAL.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
SID
Survey
ID
Permit_
Type
A
N
Weight
Sample
Weight
Permit_
Type
C
Y
=
VLOOKUP(
A6,[
facdata_
Final.
xls]
FacData!$
A$
5:$
F$
929,6,0)
SURVEY
TYPE
Survey
Type
(
e.
g.,
long,
municipality)
Permit_
Type
D
N
=
VLOOKUP(
A6,[
facdata_
Final.
xls]
FacData!$
A$
5:$
I$
1000,7,0)
FLOW
SIZE
Flow
Range:
0:
<=
1
million
gallons
per
year;
1:
1­
2
mgpy;
2:
2­
3
mgpy;
3:
3­
4
mgpy;
4:
4­
5
mgpy;
5:
5­
6.25
mgpy;
6:
over
6.25
mgpy
Permit_
Type
E
Y
=
VLOOKUP($
A6,[
Summary_
Final.
xls]
Data!$
A$
6:$
CV$
1054,
E$
1,
FALSE)

FLOW
CAT
Flow
Group:
L=
low
(<
1
mgy);
M=
medium
(
between
1
and
6.25
mgy);
H=
high
(>
6.25
mgy)
Permit_
Type
F
Y
=
IF(
E6=
6,"
H",
IF(
OR(
E6=
1,
E6=
2,
E6=
3,
E6=
4,
E6=
5),"
M",
IF(
E6=
0,"
L","
n/
a")))

SITE
DEST
Discharge
type:
D=
Direct;
I=
Indirect
Permit_
Type
G
N
=
VLOOKUP($
A6,[
Summary_
Final.
xls]
Data!$
A$
6:$
CV$
1054,
G$
1,
FALSE)
CATEGORICAL
Was
the
site
regulated
under
one
or
more
existing
federal
categorical
effluent
limitations
guidelines
during
1996?
Permit_
Type
H
Y
Comes
from
Muni's,
P1,
Long,
or
Short
POTW
PERMIT
#
POTW
NPDES
Permit
Number
Permit_
Type
I
Y
Comes
from
Muni's,
P1,
Long,
or
Short
NPDES
PERMIT
#
Facility
NPDES
Permit
Number
Permit_
Type
J
Y
Comes
from
Muni's,
P1,
Long,
or
Short
MASSBASED
Does
the
facility
have
a
mass
based
permit?
Permit_
Type
K
Y
=
IF(
AND(
H6="
Yes",
NOT(
E6=
0)),"
Y","
N")

CONCBASED
Does
the
facility
have
a
concentration
based
permit?
Permit_
Type
L
Y
=
IF(
AND(
H6="
Yes",
E6'=
0),"
Y",
IF(
AND(
H6="
No",
I6<>""),"
Y","
N"))

NOPERMIT
Does
the
faciltiy
not
have
a
permit?
Permit_
Type
M
Y
=
IF(
AND(
K6="
N",
L6="
N"),"
Y","
N")
PERMIT
TYPE
M=
Mass
Based;
C=
Concentration
Based;
N=
No
Permit;
D=
Direct
Discharger
Permit_
Type
N
Y
=
IF(
G6="
D","
D",
IF(
K6="
y","
M",
IF(
L6="
y","
C",
IF(
M6="
Y","
N","
n/
a"))))

Regulatory
Status:
Status1
Regulatory
Status
under
Option
1:
Excl
=
subcategory
exclusion;
Exmpt
=
below
cutoffs
in
baseline;
Base
Close
=
baseline
closure;
Reg
=
subject
to
regulatory
requirements
and
not
a
closure
or
moderate
impact;
Reg
Close
=
postcompliance
closure;
Mod
=
post­
compliance
moderate
impact
Permit_
Type
O
N
=
VLOOKUP($
A6,[
Summary_
Final.
xls]
Data!$
A$
6:$
DD$
1054,
O$
1,
FALSE)

Regulatory
Status:
Status2
Regulatory
Status
under
Option
2:
Excl
=
subcategory
exclusion;
Exmpt
=
below
cutoffs
in
baseline;
Base
Close
=
baseline
closure;
Reg
=
subject
to
regulatory
requirements
and
not
a
closure
or
moderate
impact;
Reg
Close
=
postcompliance
closure;
Mod
=
post­
compliance
moderate
impact
Permit_
Type
P
N
=
VLOOKUP($
A6,[
Summary_
Final.
xls]
Data!$
A$
6:$
DD$
1054,
P$
1,
FALSE)

Regulatory
Status:
Status3
Regulatory
Status
under
Option
3:
Excl
=
subcategory
exclusion;
Exmpt
=
below
cutoffs
in
baseline;
Base
Close
=
baseline
closure;
Reg
=
subject
to
regulatory
requirements
and
not
a
closure
or
moderate
impact;
Reg
Close
=
postcompliance
closure;
Mod
=
post­
compliance
moderate
impact
Permit_
Type
Q
N
=
VLOOKUP($
A6,[
Summary_
Final.
xls]
Data!$
A$
6:$
DD$
1054,
Q$
1,
FALSE)

Regulatory
Status:
Status4
Regulatory
Status
under
Option
4:
Excl
=
subcategory
exclusion;
Exmpt
=
below
cutoffs
in
baseline;
Base
Close
=
baseline
closure;
Reg
=
subject
to
regulatory
requirements
and
not
a
closure
or
moderate
impact;
Reg
Close
=
postcompliance
closure;
Mod
=
post­
compliance
moderate
impact
Permit_
Type
R
N
=
VLOOKUP($
A6,[
Summary_
Final.
xls]
Data!$
A$
6:$
DD$
1054,
R$
1,
FALSE)

Universe
of
Facilities
Subject
to
Reg.
Requirements:
Reg1
Is
this
facility
subject
to
regulatory
requirements
in
option
1?
0=
no;
1=
yes
Permit_
Type
S
N
=
VLOOKUP($
A6,[
Summary_
Final.
xls]
Data!$
A$
6:$
DD$
1054,
S$
1,
FALSE)

February
14,
2003
1
of
39
perm_
typ­
final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
PERM_
TYP­
FINAL.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
Universe
of
Facilities
Subject
to
Reg.
Requirements:
Reg2
Is
this
facility
subject
to
regulatory
requirements
in
option
2?
0=
no;
1=
yes
Permit_
Type
T
N
=
VLOOKUP($
A6,[
Summary_
Final.
xls]
Data!$
A$
6:$
DD$
1054,
T$
1,
FALSE)

Universe
of
Facilities
Subject
to
Reg.
Requirements:
Reg3
Is
this
facility
subject
to
regulatory
requirements
in
option
3?
0=
no;
1=
yes
Permit_
Type
U
N
=
VLOOKUP($
A6,[
Summary_
Final.
xls]
Data!$
A$
6:$
DD$
1054,
U$
1,
FALSE)

Universe
of
Facilities
Subject
to
Reg.
Requirements:
Reg4
Is
this
facility
subject
to
regulatory
requirements
in
option
4?
0=
no;
1=
yes
Permit_
Type
V
N
=
VLOOKUP($
A6,[
Summary_
Final.
xls]
Data!$
A$
6:$
DD$
1054,
V$
1,
FALSE)

Baseline
or
Regulatory
Closure:
Close1
Is
this
facility
considered
a
baseline
or
regulatory
closure
in
option
1?
0=
no;
1=
yes
Permit_
Type
W
N
=
IF(
OR(
O6="
base
close",
O6="
reg
close"),
1,0)

Baseline
or
Regulatory
Closure:
Close2
Is
this
facility
considered
a
baseline
or
regulatory
closure
in
option
2?
0=
no;
1=
yes
Permit_
Type
X
N
=
IF(
OR(
P6="
base
close",
P6="
reg
close"),
1,0)

Baseline
or
Regulatory
Closure:
Close3
Is
this
facility
considered
a
baseline
or
regulatory
closure
in
option
3?
0=
no;
1=
yes
Permit_
Type
Y
N
=
IF(
OR(
Q6="
base
close",
Q6="
reg
close"),
1,0)

Baseline
or
Regulatory
Closure:
Close4
Is
this
facility
considered
a
baseline
or
regulatory
closure
in
option
4?
0=
no;
1=
yes
Permit_
Type
Z
N
=
IF(
OR(
R6="
base
close",
R6="
reg
close"),
1,0)

SITEID
Survey
ID
Munis
B
N
Q8aPerm
POTW
NPDES
Permit
Number
Munis
C
Y
Q8bPerm
Facility
NPDES
Permit
Number
Munis
D
Y
Q9aRegu
Was
the
site
regulated
under
one
or
more
existing
federal
categorical
effluent
limitations
guidelines
during
1996?
Munis
E
Y
SiteID
Survey
ID
P1
A
N
467
Federal
Categorical
Effluent
Limitations:
Aluminum
Forming,
40
CFR
467
P1
B
Y
461
Federal
Categorical
Effluent
Limitations:
Battery
Manufacturing,
40
CFR
461
P1
C
Y
465
Federal
Categorical
Effluent
Limitations:
Coil
Coating,
40
CFR
465
P1
D
Y
468
Federal
Categorical
Effluent
Limitations:
Copper
Forming,
40
CFR
468
P1
E
Y
469
Federal
Categorical
Effluent
Limitations:
Electrical
and
Electronic
Components,
40
CFR
469
P1
F
Y
413
Federal
Categorical
Effluent
Limitations:
Electroplating,
40
CFR
413
P1
G
Y
424
Federal
Categorical
Effluent
Limitations:
Ferroalloy
Manufacturing,
40
CFR
424
P1
H
Y
420
Federal
Categorical
Effluent
Limitations:
Iron
and
Steel
Manufacturing,
40
CFR
420
P1
I
Y
433
Federal
Categorical
Effluent
Limitations:
Metal
Finishing,
40
CFR
433
P1
J
Y
464
Federal
Categorical
Effluent
Limitations:
Metal
Molding
and
Casting,
40
CFR
464
P1
K
Y
421
Federal
Categorical
Effluent
Limitations:
Nonferrous
Metal
Manufacturing,
40
CFR
421
P1
L
Y
471
Federal
Categorical
Effluent
Limitations:
Nonferrous
Metals
Forming
and
Metal
Powders,
40
CFR
471
P1
M
Y
463
Federal
Categorical
Effluent
Limitations:
Plastics
Molding
and
Forming,
40
CFR
463
P1
N
Y
466
Federal
Categorical
Effluent
Limitations:
Porcelain
Enameling,
40
CFR
466
P1
O
Y
403
Federal
Categorical
Effluent
Limitations:
x,
40
CFR
403
P1
P
Y
February
14,
2003
2
of
39
perm_
typ­
final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
VARIABLE
DESCRIPTIONS
FOR
PERM_
TYP­
FINAL.
XLS
VARIABLE
DESCRIPTION
WORKSHEET
COLUMN
CBI
FORMULA
428
Federal
Categorical
Effluent
Limitations:
x,
40
CFR
428
P1
Q
Y
458
Federal
Categorical
Effluent
Limitations:
x,
40
CFR
458
P1
R
Y
459
Federal
Categorical
Effluent
Limitations:
x,
40
CFR
459
P1
S
Y
414
Federal
Categorical
Effluent
Limitations:
x,
40
CFR
414
P1
T
Y
CATEGORICAL
LIMITATIONS
Was
the
site
regulated
under
one
or
more
existing
federal
categorical
effluent
limitations
guidelines
during
1996?
P1
U
Y
=
MAX(
B4:
T4)

SITEID
Survey
ID
Long
A
N
Q9APERM
POTW
NPDES
Permit
Number
Long
B
Y
Q9BPERM
Facility
NPDES
Permit
Number
Long
C
Y
Q10AREGU
Was
the
site
regulated
under
one
or
more
existing
federal
categorical
effluent
limitations
guidelines
during
1996?
Long
D
Y
SITEID
Survey
ID
Short
A
N
Q9APERM
POTW
NPDES
Permit
Number
Short
B
Y
Q9BPERM
Facility
NPDES
Permit
Number
Short
C
Y
Q10AREGU
Was
the
site
regulated
under
one
or
more
existing
federal
categorical
effluent
limitations
guidelines
during
1996?
Short
D
Y
February
14,
2003
3
of
39
perm_
typ­
final.
xls
­
Var
Desc
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
23
4
567
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
A
B
C
D
E
F
Permit
Type
Option
1
Option
2
Option
3
Option
4
Direct
Dischargers
2,382
4,143
2,382
2,382
With
Existing
Concentration­
Based
Discharge
Permits
0
692
184
515
With
Existing
Mass­
Based
Discharge
Permits
0
2,892
770
899
Without
Existing
Discharge
Permits
0
103
0
0
Total
Number
of
Facilities
2,382
7,830
3,337
3,796
Of
facilities
closing
due
to
the
rule:
Option
1
Option
2
Option
3
Option
4
Existing
concentration­
based
0
209
0
0
Iron
and
Steel
0
0
0
0
Existing
mass­
based
0
513
120
120
Iron
and
Steel
0
10
0
0
Reg1
1
Close1
0
Sum
of
Weight
PERMIT
TYPE
SURVEY
TYPE
D
Grand
Total
Long
18
18
Short
772
772
Phase
1
1,135
1,135
Municipality
458
458
Grand
Total
2,382
2,382
Reg2
1
Close2
0
Sum
of
Weight
PERMIT
TYPE
SURVEY
TYPE
D
M
C
N
Grand
Total
Long
68
1,488
189
1
1,746
Short
772
259
522
25
1,578
Phase
1
1,288
1,180
276
562
3,306
Rail
6
23
6
35
Municipality
458
32
64
555
Grand
Total
2,592
2,927
1,043
659
7,220
Reg3
1
Close3
0
Sum
of
Weight
PERMIT
TYPE
SURVEY
TYPE
D
M
C
Grand
Total
Long
18
383
15
416
Short
772
259
1,030
Phase
1
1,135
129
169
1,432
Municipality
458
458
Grand
Total
2,382
770
184
3,337
February
14,
2003
4
of
39
perm_
typ­
final.
xls
­
Summary
Record
for
the
Final
Metal
Product
and
Machinery
Rule
52
53
54
55
56
57
58
59
60
61
62
63
A
B
C
D
E
F
Reg4
1
Close4
0
Sum
of
Weight
PERMIT
TYPE
SURVEY
TYPE
D
M
C
N
Grand
Total
Long
18
452
69
538
Short
772
259
1,030
Phase
1
1,135
189
420
21
1,765
Rail
5
5
Municipality
458
22
480
Grand
Total
2,382
899
515
21
3,818
February
14,
2003
5
of
39
perm_
typ­
final.
xls
­
Summary
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
5
9
7
74
75
Permit
Type
Data
comes
from
summary_
final.
xls,
facdata_
final.
xls
and
technical
data
on
permits
Regulatory
Status
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
1
Long
I
excl
exmpt
2
Long
I
excl
reg
3
Phase
1
I
excl
exmpt
4
Municipality
I
excl
exmpt
5
Long
I
excl
exmpt
6
Long
I
excl
reg
7
Phase
1
I
excl
exmpt
8
Long
D
reg
reg
9
Long
I
excl
reg
10
Phase
1
I
excl
exmpt
12
Phase
1
I
excl
exmpt
13
Phase
1
I
excl
exmpt
14
Phase
1
I
excl
exmpt
15
Phase
1
I
base
close
base
close
16
Phase
1
I
excl
excl
17
Municipality
I
excl
exmpt
18
Municipality
D
reg
reg
20
Phase
1
I
base
close
base
close
21
Long
I
excl
exmpt
22
Long
I
excl
reg
23
Municipality
I
excl
exmpt
24
Phase
1
I
excl
exmpt
25
Phase
1
I
excl
reg
26
Long
I
excl
reg
27
Long
I
excl
reg
28
Phase
1
I
base
close
base
close
29
Long
I
base
close
base
close
30
Municipality
I
excl
exmpt
31
Phase
1
I
excl
reg
32
Phase
1
I
excl
exmpt
33
Long
I
excl
exmpt
35
Phase
1
I
base
close
base
close
36
Long
I
excl
exmpt
37
Short
I
excl
exmpt
38
Phase
1
I
excl
reg
39
Municipality
D
reg
reg
40
Municipality
I
excl
exmpt
41
Long
I
excl
reg
42
Phase
1
I
base
close
base
close
43
Phase
1
I
excl
reg
44
Long
I
excl
exmpt
45
Long
I
excl
reg
46
Phase
1
I
base
close
base
close
47
Long
I
excl
exmpt
48
Phase
1
I
excl
exmpt
50
Long
I
excl
excl
51
Long
I
base
close
base
close
52
Phase
1
I
excl
reg
53
Long
I
excl
reg
55
Phase
1
I
excl
exmpt
57
Phase
1
I
excl
exmpt
58
Phase
1
I
base
close
base
close
59
Phase
1
I
excl
exmpt
60
Phase
1
I
excl
exmpt
February
14,
2003
6
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
Q
R
S
T
U
V
W
X
Y
Z
76
77
69
70
71
72
Regulatory
Status
Universe
of
Regulated
Facilities
Baseline
or
Regulatory
Closure
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
mod
0
1
0
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
February
14,
2003
7
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
61
Long
I
excl
reg
62
Long
I
excl
excl
64
Long
I
excl
reg
65
Long
I
excl
excl
67
Long
I
excl
reg
close
68
Phase
1
I
excl
exmpt
69
Phase
1
I
excl
reg
70
Phase
1
I
excl
reg
71
Short
I
excl
exmpt
72
Phase
1
I
excl
exmpt
73
Phase
1
I
excl
reg
74
Long
I
excl
reg
close
75
Long
I
excl
reg
76
Phase
1
I
base
close
base
close
78
Phase
1
I
excl
reg
79
Long
I
excl
mod
80
Rail
I
excl
reg
81
Long
I
excl
exmpt
83
Phase
1
I
base
close
base
close
84
Phase
1
I
excl
reg
85
Phase
1
I
excl
exmpt
86
Phase
1
I
excl
exmpt
87
Long
I
excl
reg
88
Phase
1
I
base
close
base
close
89
Short
I
excl
reg
close
90
Long
I
excl
exmpt
91
Long
I
excl
reg
92
Long
I
base
close
base
close
93
Municipality
I
excl
reg
94
Phase
1
I
excl
exmpt
95
Short
I
excl
mod
96
Phase
1
I
excl
reg
97
Long
I
excl
reg
98
Municipality
I
excl
exmpt
99
Long
I
excl
reg
100
Phase
1
D
base
close
base
close
101
Long
I
excl
reg
102
Phase
1
I
excl
exmpt
103
Long
I
excl
exmpt
104
Municipality
I
excl
exmpt
105
Phase
1
I
excl
reg
106
Short
I
excl
exmpt
108
Long
I
excl
exmpt
109
Phase
1
I
excl
exmpt
110
Long
I
excl
reg
111
Long
I
excl
reg
close
112
Phase
1
I
excl
exmpt
113
Long
I
base
close
base
close
114
Phase
1
I
excl
exmpt
115
Phase
1
I
excl
exmpt
116
Long
I
excl
reg
117
Municipality
I
excl
exmpt
118
Phase
1
D
excl
reg
119
Phase
1
I
excl
reg
120
Phase
1
I
excl
reg
121
Long
I
excl
reg
122
Long
I
excl
mod
123
Municipality
I
excl
exmpt
February
14,
2003
8
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
Q
R
S
T
U
V
W
X
Y
Z
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
reg
reg
0
1
1
1
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
0
1
1
1
1
1
1
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
1
1
1
1
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
0
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
1
1
1
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
February
14,
2003
9
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
124
Rail
D
excl
reg
125
Phase
1
I
excl
reg
126
Long
I
excl
reg
close
127
Long
I
excl
reg
128
Long
D
excl
reg
129
Phase
1
I
excl
exmpt
130
Phase
1
I
excl
exmpt
131
Long
I
excl
reg
132
Phase
1
I
excl
exmpt
134
Municipality
I
excl
exmpt
135
Phase
1
I
excl
reg
136
Phase
1
I
excl
exmpt
137
Long
I
excl
reg
close
138
Phase
1
I
base
close
base
close
139
Municipality
I
excl
exmpt
140
Long
I
excl
reg
close
141
Phase
1
I
excl
reg
142
Phase
1
D
base
close
base
close
143
Phase
1
D
reg
reg
145
Rail
I
excl
exmpt
146
Long
I
excl
reg
147
Phase
1
I
excl
exmpt
148
Phase
1
I
excl
exmpt
149
Phase
1
I
excl
exmpt
150
Long
I
excl
reg
151
Long
I
excl
reg
152
Municipality
I
excl
exmpt
153
Long
I
excl
reg
154
Phase
1
I
excl
exmpt
155
Phase
1
I
base
close
base
close
156
Long
I
excl
exmpt
157
Long
I
base
close
base
close
158
Rail
I
excl
reg
159
Phase
1
I
excl
exmpt
161
Short
I
excl
reg
close
162
Phase
1
I
excl
reg
163
Phase
1
I
excl
exmpt
164
Phase
1
I
excl
reg
165
Phase
1
I
excl
reg
166
Phase
1
I
excl
exmpt
167
Municipality
I
excl
exmpt
170
Phase
1
I
base
close
base
close
171
Municipality
I
excl
exmpt
172
Phase
1
D
excl
reg
173
Long
I
excl
reg
174
Phase
1
I
excl
exmpt
176
Long
I
excl
reg
177
Phase
1
D
excl
reg
178
Phase
1
I
excl
reg
179
Phase
1
I
excl
exmpt
181
Phase
1
I
excl
reg
182
Long
I
excl
exmpt
183
Phase
1
I
excl
exmpt
184
Phase
1
I
excl
reg
185
Phase
1
I
excl
exmpt
186
Long
I
excl
reg
187
Phase
1
D
reg
reg
188
Phase
1
I
excl
exmpt
February
14,
2003
10
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
Q
R
S
T
U
V
W
X
Y
Z
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
close
reg
close
0
1
1
1
0
1
1
1
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
mod
mod
0
1
1
1
0
1
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
1
1
1
1
1
1
1
1
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
0
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
reg
reg
0
0
1
1
0
0
0
0
February
14,
2003
11
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
189
Long
I
excl
reg
close
190
Phase
1
I
base
close
excl
191
Phase
1
I
excl
exmpt
192
Long
I
excl
reg
193
Phase
1
I
excl
exmpt
194
Rail
I
excl
reg
195
Long
I
excl
exmpt
196
Long
I
excl
reg
close
197
Phase
1
I
excl
reg
199
Phase
1
I
excl
reg
200
Phase
1
I
excl
mod
201
Long
I
excl
reg
202
Phase
1
I
excl
exmpt
203
Long
I
excl
exmpt
204
Long
I
excl
reg
205
Municipality
I
excl
exmpt
207
Long
I
excl
reg
208
Phase
1
I
excl
exmpt
209
Phase
1
I
excl
reg
210
Phase
1
D
reg
reg
211
Long
I
excl
reg
close
212
Phase
1
I
base
close
base
close
213
Municipality
D
reg
reg
214
Phase
1
D
reg
reg
215
Long
I
excl
reg
216
Phase
1
I
excl
reg
218
Municipality
I
excl
exmpt
219
Phase
1
I
excl
exmpt
221
Phase
1
I
excl
exmpt
222
Long
I
base
close
base
close
223
Phase
1
I
excl
exmpt
224
Short
I
excl
exmpt
225
Long
I
excl
reg
226
Phase
1
I
excl
exmpt
227
Phase
1
I
excl
exmpt
228
Long
I
excl
reg
229
Phase
1
I
base
close
base
close
230
Phase
1
I
excl
exmpt
231
Long
I
excl
exmpt
232
Phase
1
I
excl
reg
233
Phase
1
I
excl
exmpt
235
Phase
1
I
excl
exmpt
236
Rail
I
excl
reg
237
Long
I
excl
reg
close
238
Rail
I
excl
excl
239
Phase
1
I
excl
reg
240
Long
I
excl
reg
241
Long
I
excl
reg
242
Long
I
excl
reg
close
243
Long
I
excl
reg
245
Phase
1
I
excl
reg
246
Long
I
excl
reg
247
Phase
1
I
excl
exmpt
248
Phase
1
I
excl
exmpt
249
Phase
1
I
excl
exmpt
250
Long
I
excl
reg
252
Phase
1
I
excl
reg
253
Long
I
excl
reg
close
February
14,
2003
12
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
Q
R
S
T
U
V
W
X
Y
Z
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
excl
excl
0
1
0
0
0
1
0
0
base
close
base
close
0
0
0
0
1
0
1
1
reg
reg
0
0
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
base
close
base
close
0
0
0
0
1
1
1
1
reg
reg
1
1
1
1
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
1
1
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
reg
reg
0
1
1
1
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
close
reg
close
0
1
1
1
0
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
February
14,
2003
13
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
254
Phase
1
I
excl
exmpt
255
Long
I
excl
reg
close
257
Long
I
base
close
base
close
258
Municipality
I
excl
exmpt
259
Long
I
excl
mod
261
Phase
1
I
excl
exmpt
262
Phase
1
I
excl
exmpt
263
Long
I
excl
exmpt
264
Phase
1
I
excl
exmpt
265
Phase
1
D
excl
reg
266
Phase
1
D
reg
reg
267
Phase
1
I
excl
reg
268
Phase
1
I
excl
reg
269
Long
I
excl
reg
270
Long
I
base
close
base
close
271
Long
I
excl
reg
272
Municipality
I
excl
exmpt
273
Phase
1
I
excl
reg
274
Phase
1
D
reg
reg
276
Phase
1
I
excl
exmpt
277
Municipality
I
excl
exmpt
278
Municipality
D
reg
reg
279
Phase
1
I
base
close
base
close
280
Phase
1
I
base
close
base
close
281
Phase
1
D
excl
reg
282
Phase
1
I
excl
exmpt
283
Phase
1
D
reg
reg
284
Phase
1
I
excl
reg
close
285
Phase
1
I
excl
reg
286
Short
I
excl
exmpt
288
Phase
1
I
excl
exmpt
289
Phase
1
I
excl
exmpt
290
Long
I
excl
reg
291
Short
I
excl
exmpt
292
Municipality
I
excl
reg
293
Phase
1
I
excl
reg
295
Long
I
excl
mod
296
Phase
1
I
excl
exmpt
298
Long
I
base
close
base
close
299
Long
I
excl
exmpt
300
Long
I
base
close
base
close
301
Phase
1
I
base
close
base
close
302
Phase
1
I
base
close
base
close
303
Phase
1
I
excl
exmpt
304
Phase
1
D
base
close
base
close
305
Phase
1
I
base
close
base
close
306
Phase
1
I
base
close
base
close
307
Short
I
excl
exmpt
308
Long
I
excl
reg
309
Phase
1
I
excl
reg
310
Long
I
excl
reg
311
Municipality
I
excl
exmpt
312
Long
I
base
close
base
close
313
Phase
1
I
excl
exmpt
314
Phase
1
I
excl
exmpt
315
Phase
1
I
excl
exmpt
316
Long
I
excl
reg
318
Municipality
I
excl
exmpt
February
14,
2003
14
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
Q
R
S
T
U
V
W
X
Y
Z
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
1
1
1
1
1
base
close
base
close
0
1
0
0
1
1
1
1
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
1
1
1
1
1
1
1
1
base
close
base
close
0
0
0
0
1
1
1
1
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
February
14,
2003
15
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
319
Phase
1
I
base
close
base
close
322
Phase
1
I
excl
reg
323
Phase
1
I
excl
exmpt
324
Long
I
excl
reg
325
Phase
1
I
excl
reg
326
Phase
1
I
excl
exmpt
327
Long
I
excl
reg
328
Long
I
excl
reg
329
Long
I
base
close
base
close
330
Long
I
base
close
base
close
331
Phase
1
I
excl
exmpt
332
Long
I
excl
reg
333
Phase
1
I
excl
exmpt
334
Long
D
excl
reg
335
Phase
1
I
excl
reg
336
Phase
1
I
excl
exmpt
337
Long
I
excl
exmpt
338
Phase
1
I
base
close
base
close
340
Phase
1
I
excl
exmpt
341
Municipality
I
excl
exmpt
342
Long
I
excl
exmpt
345
Phase
1
I
excl
exmpt
346
Municipality
I
excl
exmpt
347
Municipality
I
excl
exmpt
348
Municipality
I
excl
reg
349
Long
I
excl
reg
350
Long
I
excl
reg
351
Phase
1
I
base
close
base
close
352
Rail
I
excl
reg
355
Long
I
excl
reg
357
Long
I
excl
reg
358
Phase
1
I
excl
#
N/
A
359
Phase
1
I
excl
exmpt
360
Municipality
D
reg
reg
361
Phase
1
I
excl
exmpt
362
Municipality
I
excl
exmpt
363
Phase
1
I
excl
exmpt
364
Phase
1
I
excl
exmpt
365
Phase
1
I
excl
reg
368
Municipality
I
excl
exmpt
369
Phase
1
I
excl
exmpt
370
Phase
1
I
excl
exmpt
372
Long
I
excl
reg
373
Rail
I
excl
excl
374
Long
I
excl
exmpt
376
Phase
1
I
excl
exmpt
377
Phase
1
I
excl
reg
378
Phase
1
I
excl
reg
379
Municipality
I
excl
exmpt
380
Phase
1
I
excl
exmpt
381
Phase
1
I
excl
exmpt
382
Rail
I
excl
excl
383
Long
I
excl
reg
384
Phase
1
I
excl
exmpt
385
Municipality
I
excl
exmpt
386
Phase
1
I
excl
exmpt
387
Phase
1
I
excl
reg
388
Phase
1
I
excl
exmpt
February
14,
2003
16
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
Q
R
S
T
U
V
W
X
Y
Z
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
base
close
base
close
0
1
0
0
1
1
1
1
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
#
N/
A
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
February
14,
2003
17
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
390
Phase
1
I
excl
reg
391
Municipality
I
excl
reg
392
Long
I
excl
reg
393
Long
I
excl
reg
394
Municipality
I
excl
reg
395
Phase
1
I
excl
reg
close
396
Phase
1
I
excl
exmpt
397
Municipality
I
excl
exmpt
398
Phase
1
I
excl
exmpt
399
Phase
1
I
base
close
base
close
400
Long
I
excl
reg
401
Long
I
excl
reg
402
Long
I
excl
reg
403
Phase
1
D
reg
reg
404
Phase
1
I
excl
reg
405
Municipality
I
excl
exmpt
406
Long
I
excl
mod
407
Long
I
excl
exmpt
408
Phase
1
I
base
close
base
close
409
Phase
1
I
base
close
base
close
410
Phase
1
I
base
close
base
close
411
Long
I
excl
mod
412
Long
D
excl
reg
413
Phase
1
I
excl
reg
414
Phase
1
I
excl
exmpt
416
Phase
1
I
excl
exmpt
417
Long
I
excl
reg
close
418
Phase
1
I
excl
exmpt
419
Long
I
base
close
base
close
420
Long
I
excl
reg
421
Long
I
excl
reg
422
Phase
1
I
excl
reg
423
Short
I
excl
exmpt
424
Phase
1
I
excl
reg
425
Long
I
excl
reg
427
Municipality
I
excl
exmpt
428
Phase
1
I
excl
reg
429
Phase
1
I
excl
exmpt
430
Long
I
excl
reg
433
Long
I
excl
reg
434
Short
I
excl
exmpt
435
Long
I
excl
reg
436
Rail
I
excl
reg
437
Municipality
I
excl
exmpt
439
Long
I
excl
reg
440
Phase
1
I
excl
exmpt
441
Phase
1
I
excl
exmpt
442
Phase
1
I
excl
exmpt
443
Long
I
excl
reg
445
Long
I
excl
excl
446
Phase
1
I
excl
reg
447
Phase
1
I
base
close
base
close
448
Short
I
base
close
base
close
449
Long
I
excl
reg
450
Long
I
excl
reg
451
Phase
1
I
excl
exmpt
452
Phase
1
I
base
close
base
close
453
Long
I
excl
reg
February
14,
2003
18
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
Q
R
S
T
U
V
W
X
Y
Z
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
base
close
base
close
0
0
0
0
1
1
1
1
base
close
base
close
0
1
0
0
1
1
1
1
mod
mod
0
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
February
14,
2003
19
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
455
Long
I
excl
reg
456
Phase
1
I
excl
exmpt
457
Phase
1
I
excl
exmpt
458
Phase
1
I
excl
reg
459
Phase
1
I
excl
exmpt
460
Long
I
excl
reg
close
461
Phase
1
I
base
close
base
close
462
Phase
1
I
excl
exmpt
463
Long
I
excl
reg
close
464
Phase
1
I
base
close
base
close
465
Municipality
I
excl
reg
466
Phase
1
I
excl
reg
467
Municipality
I
excl
exmpt
468
Phase
1
D
reg
reg
470
Phase
1
I
excl
exmpt
471
Short
I
excl
exmpt
472
Phase
1
I
excl
reg
473
Phase
1
D
reg
reg
475
Phase
1
I
excl
exmpt
476
Short
I
excl
exmpt
477
Long
I
excl
reg
close
478
Municipality
I
excl
exmpt
479
Phase
1
I
base
close
base
close
480
Phase
1
I
excl
exmpt
481
Phase
1
I
base
close
base
close
482
Short
I
excl
exmpt
483
Municipality
I
excl
exmpt
484
Phase
1
I
excl
reg
485
Municipality
D
reg
reg
486
Phase
1
I
excl
reg
487
Long
I
excl
reg
488
Phase
1
I
excl
reg
489
Phase
1
I
excl
exmpt
490
Phase
1
I
excl
exmpt
491
Municipality
I
excl
exmpt
492
Phase
1
I
excl
exmpt
493
Phase
1
I
excl
exmpt
494
Long
I
excl
mod
495
Long
I
excl
reg
close
496
Phase
1
I
excl
exmpt
497
Long
I
excl
mod
498
Long
I
excl
excl
499
Municipality
I
excl
exmpt
500
Rail
I
excl
excl
501
Long
I
excl
reg
close
502
Phase
1
I
excl
exmpt
503
Long
I
excl
reg
close
504
Phase
1
I
excl
exmpt
505
Short
I
excl
exmpt
506
Long
I
excl
exmpt
507
Long
I
excl
excl
508
Municipality
I
excl
exmpt
509
Phase
1
I
excl
exmpt
510
Phase
1
I
excl
reg
511
Phase
1
I
excl
exmpt
513
Long
I
excl
mod
514
Phase
1
I
excl
exmpt
515
Phase
1
I
excl
exmpt
February
14,
2003
20
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
Q
R
S
T
U
V
W
X
Y
Z
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
mod
mod
0
0
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
February
14,
2003
21
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
516
Long
I
excl
reg
517
Long
I
excl
reg
close
518
Phase
1
I
excl
exmpt
519
Long
I
excl
reg
520
Phase
1
I
excl
reg
521
Municipality
I
excl
exmpt
522
Phase
1
I
excl
exmpt
523
Phase
1
I
excl
exmpt
524
Phase
1
I
excl
reg
525
Long
I
excl
reg
526
Phase
1
I
excl
exmpt
527
Short
I
excl
exmpt
528
Long
I
excl
exmpt
530
Phase
1
I
base
close
base
close
531
Phase
1
I
base
close
base
close
532
Phase
1
I
excl
exmpt
533
Long
I
excl
reg
534
Phase
1
I
excl
reg
535
Municipality
I
excl
exmpt
536
Phase
1
I
excl
exmpt
537
Phase
1
I
excl
reg
538
Phase
1
I
excl
exmpt
539
Phase
1
I
excl
reg
540
Phase
1
I
excl
reg
541
Municipality
I
excl
exmpt
542
Phase
1
I
excl
exmpt
543
Long
I
excl
exmpt
545
Phase
1
I
excl
reg
547
Long
I
excl
exmpt
548
Phase
1
I
excl
exmpt
549
Long
I
excl
reg
550
Long
I
excl
reg
552
Long
I
excl
reg
close
553
Municipality
I
excl
exmpt
554
Municipality
I
excl
exmpt
555
Phase
1
I
base
close
base
close
556
Short
I
base
close
base
close
557
Municipality
I
excl
reg
558
Municipality
D
reg
reg
560
Long
I
excl
reg
561
Phase
1
I
excl
exmpt
562
Rail
I
excl
exmpt
563
Long
I
excl
reg
close
564
Long
I
excl
reg
565
Municipality
I
excl
exmpt
566
Phase
1
I
excl
reg
567
Phase
1
I
excl
excl
569
Municipality
I
excl
exmpt
570
Phase
1
D
excl
reg
571
Municipality
I
excl
exmpt
572
Rail
I
excl
reg
573
Municipality
I
excl
exmpt
574
Phase
1
D
excl
reg
575
Long
I
excl
reg
577
Long
I
excl
reg
578
Phase
1
I
excl
exmpt
579
Phase
1
I
base
close
base
close
580
Long
I
excl
reg
February
14,
2003
22
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
Q
R
S
T
U
V
W
X
Y
Z
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
excl
excl
0
1
0
0
0
0
0
0
reg
close
reg
close
0
1
1
1
0
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
base
close
base
close
0
0
0
0
1
1
1
1
excl
reg
0
1
0
1
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
February
14,
2003
23
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
581
Municipality
I
excl
exmpt
582
Municipality
I
excl
exmpt
583
Phase
1
D
reg
reg
584
Long
I
excl
reg
586
Phase
1
I
excl
reg
587
Long
I
excl
reg
588
Municipality
D
reg
reg
590
Phase
1
I
excl
exmpt
591
Long
I
excl
reg
594
Long
I
excl
reg
595
Phase
1
I
excl
exmpt
596
Rail
I
excl
excl
598
Long
I
excl
reg
599
Long
D
excl
reg
600
Long
I
excl
reg
close
602
Municipality
I
excl
exmpt
603
Phase
1
I
excl
exmpt
605
Phase
1
I
base
close
base
close
606
Long
I
excl
reg
close
607
Short
I
excl
exmpt
608
Phase
1
I
excl
exmpt
609
Phase
1
I
excl
reg
610
Long
I
excl
reg
close
611
Phase
1
I
excl
reg
612
Phase
1
I
excl
reg
613
Phase
1
I
excl
exmpt
614
Phase
1
I
base
close
base
close
615
Phase
1
I
excl
exmpt
616
Phase
1
D
excl
reg
617
Phase
1
I
excl
exmpt
619
Long
I
excl
exmpt
620
Rail
I
base
close
base
close
621
Phase
1
I
excl
reg
622
Phase
1
D
base
close
base
close
623
Phase
1
I
excl
exmpt
624
Phase
1
I
excl
exmpt
625
Long
I
excl
reg
626
Long
I
excl
reg
627
Phase
1
I
excl
exmpt
628
Long
I
excl
reg
629
Phase
1
D
reg
reg
630
Phase
1
I
excl
exmpt
631
Phase
1
I
base
close
base
close
632
Phase
1
I
excl
exmpt
633
Phase
1
I
base
close
base
close
634
Phase
1
I
excl
reg
635
Phase
1
I
excl
reg
636
Long
I
excl
reg
637
Long
I
excl
exmpt
638
Rail
I
excl
excl
639
Long
I
excl
reg
640
Long
I
excl
reg
close
641
Long
I
excl
reg
close
643
Long
I
excl
reg
645
Long
I
excl
exmpt
646
Municipality
I
excl
exmpt
647
Municipality
I
excl
exmpt
648
Phase
1
I
excl
exmpt
February
14,
2003
24
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
Q
R
S
T
U
V
W
X
Y
Z
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
close
reg
close
0
1
1
1
0
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
reg
0
1
0
1
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
1
1
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
1
1
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
close
reg
close
0
1
1
1
0
1
1
1
excl
excl
0
1
0
0
0
1
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
February
14,
2003
25
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
649
Long
I
excl
reg
close
650
Long
D
reg
reg
651
Long
I
excl
reg
653
Phase
1
I
excl
reg
655
Phase
1
I
base
close
base
close
656
Phase
1
I
excl
reg
657
Municipality
I
excl
exmpt
658
Long
I
excl
reg
659
Rail
I
excl
reg
660
Long
I
excl
reg
661
Phase
1
I
excl
reg
662
Phase
1
I
excl
reg
663
Phase
1
I
excl
reg
664
Phase
1
I
excl
exmpt
665
Phase
1
I
excl
exmpt
666
Short
I
excl
reg
667
Long
I
excl
reg
668
Long
D
excl
reg
669
Phase
1
I
base
close
base
close
670
Long
I
excl
reg
close
671
Short
I
excl
exmpt
672
Municipality
I
excl
exmpt
673
Phase
1
I
excl
exmpt
674
Long
I
excl
reg
675
Phase
1
I
excl
exmpt
679
Phase
1
I
excl
exmpt
680
Short
I
excl
exmpt
681
Phase
1
I
excl
exmpt
682
Long
I
excl
reg
close
683
Phase
1
I
excl
exmpt
684
Phase
1
I
excl
exmpt
685
Long
I
excl
reg
close
686
Municipality
I
excl
exmpt
687
Phase
1
I
excl
reg
688
Phase
1
I
excl
reg
689
Municipality
I
excl
exmpt
690
Phase
1
I
base
close
base
close
691
Municipality
I
excl
exmpt
692
Municipality
I
excl
exmpt
693
Phase
1
I
excl
exmpt
694
Long
I
excl
reg
695
Phase
1
I
excl
exmpt
696
Phase
1
I
excl
exmpt
698
Short
I
excl
excl
699
Short
I
base
close
base
close
700
Phase
1
I
excl
exmpt
701
Long
D
excl
reg
close
702
Long
I
excl
reg
703
Short
I
excl
exmpt
704
Phase
1
I
excl
exmpt
705
Phase
1
I
base
close
base
close
706
Phase
1
I
excl
reg
707
Phase
1
I
excl
reg
708
Phase
1
I
excl
reg
709
Long
I
excl
exmpt
710
Phase
1
I
excl
exmpt
711
Phase
1
I
base
close
base
close
712
Long
I
excl
reg
February
14,
2003
26
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
Q
R
S
T
U
V
W
X
Y
Z
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
mod
mod
0
1
1
1
0
1
0
0
reg
reg
1
1
1
1
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
close
reg
close
0
1
1
1
0
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
0
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
February
14,
2003
27
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
713
Long
I
excl
reg
714
Phase
1
I
excl
reg
715
Long
I
excl
reg
716
Long
I
excl
exmpt
717
Phase
1
I
excl
exmpt
718
Phase
1
I
base
close
base
close
719
Long
I
excl
excl
720
Phase
1
I
excl
reg
721
Long
I
excl
reg
722
Short
I
excl
exmpt
723
Long
I
excl
reg
724
Long
I
excl
exmpt
725
Long
I
base
close
base
close
726
Phase
1
D
reg
reg
727
Long
I
excl
reg
728
Long
I
excl
reg
729
Long
I
excl
reg
close
730
Phase
1
I
excl
reg
732
Phase
1
I
base
close
base
close
733
Long
I
excl
exmpt
734
Long
I
excl
reg
735
Short
I
excl
exmpt
736
Municipality
I
excl
exmpt
737
Long
I
excl
reg
738
Long
I
excl
reg
740
Phase
1
I
excl
exmpt
741
Phase
1
I
excl
exmpt
743
Municipality
D
reg
reg
744
Municipality
I
excl
reg
745
Long
I
base
close
base
close
746
Phase
1
I
excl
exmpt
747
Phase
1
I
base
close
base
close
748
Long
I
excl
reg
749
Phase
1
I
base
close
base
close
751
Phase
1
I
excl
reg
752
Phase
1
I
excl
exmpt
753
Phase
1
I
excl
exmpt
755
Long
I
excl
reg
close
756
Phase
1
I
excl
exmpt
757
Long
I
excl
reg
758
Phase
1
I
excl
reg
759
Long
I
base
close
base
close
760
Phase
1
I
excl
exmpt
761
Rail
I
excl
reg
762
Long
I
excl
excl
763
Phase
1
D
excl
reg
764
Phase
1
I
excl
exmpt
765
Long
I
excl
reg
766
Long
I
excl
reg
767
Phase
1
I
excl
exmpt
768
Long
I
base
close
base
close
770
Municipality
D
reg
reg
771
Phase
1
I
excl
exmpt
772
Short
I
base
close
base
close
773
Long
I
excl
reg
774
Phase
1
I
excl
reg
775
Phase
1
I
excl
exmpt
777
Phase
1
I
excl
reg
February
14,
2003
28
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
Q
R
S
T
U
V
W
X
Y
Z
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
reg
reg
0
0
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
reg
reg
0
1
1
1
0
1
0
0
excl
reg
0
1
0
1
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
1
0
1
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
1
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
0
1
1
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
reg
reg
0
0
1
1
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
February
14,
2003
29
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
778
Long
I
excl
reg
close
779
Long
I
excl
reg
780
Phase
1
I
excl
reg
781
Long
I
excl
reg
782
Long
I
excl
reg
783
Municipality
D
reg
reg
784
Long
I
excl
excl
785
Phase
1
I
base
close
base
close
786
Long
I
excl
reg
787
Phase
1
I
base
close
base
close
788
Long
I
excl
reg
close
789
Phase
1
I
excl
exmpt
790
Phase
1
I
excl
exmpt
791
Long
I
excl
reg
close
792
Long
I
excl
reg
793
Long
I
excl
reg
794
Municipality
I
excl
exmpt
795
Long
I
base
close
base
close
796
Phase
1
D
excl
reg
797
Phase
1
I
excl
exmpt
798
Rail
I
excl
excl
799
Phase
1
I
excl
reg
800
Phase
1
I
excl
reg
801
Municipality
I
excl
exmpt
802
Long
I
excl
exmpt
803
Municipality
I
excl
exmpt
804
Short
I
excl
exmpt
805
Long
I
excl
reg
close
806
Long
I
excl
reg
807
Phase
1
I
excl
reg
808
Phase
1
I
base
close
base
close
809
Phase
1
I
excl
excl
810
Municipality
I
excl
exmpt
811
Long
I
excl
reg
813
Phase
1
I
base
close
base
close
814
Phase
1
I
excl
exmpt
815
Phase
1
I
excl
exmpt
816
Phase
1
I
excl
exmpt
817
Long
I
excl
exmpt
818
Short
I
excl
mod
819
Long
I
excl
mod
820
Long
I
base
close
base
close
821
Phase
1
I
excl
exmpt
822
Long
I
excl
reg
823
Phase
1
I
excl
reg
824
Phase
1
I
excl
exmpt
825
Short
I
excl
exmpt
826
Municipality
I
excl
exmpt
827
Municipality
I
excl
exmpt
828
Municipality
D
reg
reg
829
Phase
1
I
excl
exmpt
830
Long
I
excl
excl
831
Phase
1
I
excl
reg
close
833
Municipality
I
excl
exmpt
834
Long
I
excl
reg
835
Rail
I
excl
reg
836
Phase
1
I
excl
exmpt
837
Phase
1
I
base
close
base
close
February
14,
2003
30
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
Q
R
S
T
U
V
W
X
Y
Z
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
reg
close
reg
close
0
1
1
1
0
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
reg
reg
0
1
1
1
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
1
0
0
0
1
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
1
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
1
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
base
close
base
close
0
1
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
close
reg
close
0
1
1
1
0
1
1
1
excl
excl
0
0
0
0
0
0
0
0
reg
reg
0
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
February
14,
2003
31
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
839
Long
I
excl
reg
841
Short
I
excl
exmpt
842
Short
I
excl
exmpt
843
Short
I
excl
exmpt
844
Short
D
reg
reg
845
Municipality
I
excl
exmpt
846
Long
I
excl
mod
848
Long
I
excl
reg
close
849
Long
I
excl
reg
close
850
Phase
1
I
excl
exmpt
851
Phase
1
I
excl
reg
852
Rail
D
excl
reg
853
Phase
1
I
excl
reg
854
Phase
1
I
excl
reg
855
Phase
1
I
excl
reg
856
Phase
1
I
excl
exmpt
857
Phase
1
I
base
close
base
close
858
Phase
1
I
base
close
base
close
859
Phase
1
I
excl
exmpt
860
Phase
1
I
base
close
base
close
861
Phase
1
I
excl
exmpt
862
Long
I
excl
reg
863
Short
I
excl
reg
864
Phase
1
I
excl
exmpt
866
Long
I
excl
mod
867
Phase
1
I
excl
exmpt
868
Municipality
D
reg
reg
869
Long
I
excl
reg
870
Phase
1
I
excl
exmpt
871
Phase
1
I
excl
reg
873
Phase
1
I
excl
exmpt
874
Phase
1
I
excl
reg
875
Phase
1
I
excl
exmpt
877
Municipality
I
excl
exmpt
878
Municipality
D
reg
reg
879
Long
I
excl
exmpt
880
Phase
1
I
excl
excl
881
Rail
I
excl
exmpt
882
Municipality
I
excl
exmpt
884
Long
I
excl
reg
885
Phase
1
I
excl
exmpt
886
Phase
1
I
excl
exmpt
887
Short
I
excl
exmpt
888
Short
I
excl
exmpt
890
Municipality
I
excl
exmpt
891
Short
I
excl
exmpt
892
Municipality
I
excl
exmpt
893
Municipality
I
excl
exmpt
894
Short
I
excl
exmpt
895
Municipality
D
reg
reg
896
Municipality
I
excl
exmpt
898
Municipality
I
excl
exmpt
900
Municipality
I
excl
exmpt
902
Municipality
I
excl
exmpt
904
Municipality
I
excl
exmpt
905
Short
I
excl
exmpt
906
Municipality
D
reg
reg
907
Municipality
I
excl
exmpt
February
14,
2003
32
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
Q
R
S
T
U
V
W
X
Y
Z
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
1
0
0
reg
close
reg
close
0
1
1
1
0
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
reg
0
1
0
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
1
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
reg
reg
1
1
1
1
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
February
14,
2003
33
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
A
C
D
E
F
G
H
I
J
K
L
M
N
O
P
SID
Weight
SURVEY
TYPE
FLOW
SIZE
FLOW
CAT
SITE
DEST
CATEGORICAL
POTW
PERMIT
#
NPDES
PERMIT
#
MASSBASED
CONCBASED
NOPERMIT
PERMIT
TYPE
Status1
Status2
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
908
Municipality
I
excl
exmpt
910
Municipality
I
excl
exmpt
913
Municipality
I
excl
exmpt
915
Municipality
I
excl
exmpt
916
Municipality
I
excl
reg
917
Municipality
I
excl
exmpt
919
Municipality
I
excl
exmpt
920
Municipality
I
excl
exmpt
921
Short
I
excl
exmpt
922
Short
I
excl
exmpt
923
Municipality
I
excl
exmpt
924
Municipality
I
excl
exmpt
925
Municipality
I
excl
exmpt
926
Short
I
excl
exmpt
927
Short
I
excl
exmpt
928
Municipality
I
excl
exmpt
930
Short
I
excl
exmpt
933
Municipality
I
excl
exmpt
934
Short
I
excl
exmpt
936
Municipality
I
excl
exmpt
937
Municipality
I
excl
exmpt
939
Municipality
I
excl
exmpt
940
Iron
&
Steel
I
excl
0
941
Iron
&
Steel
D
excl
0
942
Municipality
I
excl
0
943
Iron
&
Steel
D
excl
0
944
Iron
&
Steel
I
excl
0
945
Iron
&
Steel
I
excl
0
946
Iron
&
Steel
D
excl
0
947
Iron
&
Steel
D
excl
0
948
Short
I
excl
0
949
Iron
&
Steel
D
excl
0
950
Iron
&
Steel
I
excl
0
951
Iron
&
Steel
D
excl
0
952
Municipality
I
excl
0
953
Iron
&
Steel
D
base
close
0
954
Iron
&
Steel
D
excl
0
955
Iron
&
Steel
I
excl
0
956
Iron
&
Steel
I
excl
0
957
Iron
&
Steel
D
excl
0
958
Iron
&
Steel
D
base
close
0
959
Iron
&
Steel
I
excl
0
960
Iron
&
Steel
D
excl
0
961
Iron
&
Steel
D
excl
0
962
Iron
&
Steel
I
excl
0
963
Iron
&
Steel
D
excl
0
964
Iron
&
Steel
D
excl
0
965
Iron
&
Steel
I
excl
0
966
Iron
&
Steel
I
excl
0
February
14,
2003
34
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
5
Q
R
S
T
U
V
W
X
Y
Z
Status3
Status4
Reg1
Reg2
Reg3
Reg4
Close1
Close2
Close3
Close4
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
1
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
0
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
base
close
base
close
0
0
0
0
1
0
1
1
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
excl
excl
0
0
0
0
0
0
0
0
February
14,
2003
35
of
39
perm_
typ­
final.
xls
­
Permit_
Type
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
B
C
D
E
PERMIT
DATA
FOR
MUNICIPALITY
FACILITIES
Comes
from
"
Permit
Type"
query
in
I&
S_
Muni(
2000).
mdb
SID
Q8aPerm
Q8bPerm
Q9aRegu
4
17
18
23
30
39
40
93
98
104
117
123
134
139
152
167
171
205
213
218
258
272
277
278
292
311
318
341
346
347
348
360
362
368
379
385
391
394
397
405
427
437
465
467
478
483
485
491
499
508
521
535
541
553
554
557
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
36
of
39
perm_
typ­
final.
xls
­
Munis
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
PERMIT
DATA
FOR
PHASE
1
FACILITIES
Comes
from
Abtquest.
mdb
SiteID
467
461
465
468
469
413
424
420
433
464
421
471
463
466
403
428
458
459
414
CATEGORICAL
LIMITATIONS
3
7
10
12
13
14
15
16
20
24
25
28
31
32
35
38
42
43
46
48
52
55
57
58
59
60
68
69
70
72
73
76
78
83
84
85
86
88
94
96
100
102
105
109
112
114
115
118
119
120
125
129
130
132
135
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
37
of
39
perm_
typ­
final.
xls
­
P1
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
A
B
C
D
PERMIT
DATA
FOR
LONG
SURVEY
FACILITIES
Comes
from
ShrtLong.
mdb
SITEID
Q9APERM
Q9BPERM
Q10AREGU
1
2
5
6
8
9
21
22
26
27
29
33
36
41
44
45
47
50
51
53
56
61
62
64
65
67
74
75
79
80
81
87
90
91
92
97
99
101
103
108
110
111
113
116
121
122
124
126
127
128
131
137
140
145
146
150
Note:
All
data
except
site
identification
not
shown
to
protect
confidential
business
information.
Sample
page
provided
to
show
structure
of
worksheet.
February
14,
2003
38
of
39
perm_
typ­
final.
xls
­
Long
Record
for
the
Final
Metal
Product
and
Machinery
Rule
1
2
3
456789
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
A
B
C
D
PERMIT
DATA
FOR
SHORT
SURVEY
FACILITIES
Comes
from
ShrtLong.
mdb
SITEID
Q9APERM
Q9BPERM
Q10AREGU
37
49
71
89
95
106
161
224
286
291
307
371
423
434
438
448
471
476
482
505
527
556
607
666
671
678
680
698
699
703
722
735
772
804
818
825
841
842
843
844
863
887
888
891
894
905
918
921
922
926
927
929
930
934
948
February
14,
2003
39
of
39
perm_
typ­
final.
xls
­
Short