HFO Home Page

OSM Home Page

Field Office Staff

2001 Annual Rpt

2002 Annual Rpt

 

 

 

 

RELATED LINKS

PA DEP
PA DEP, Mining and Mineral Resources
PA DEP, Water Management
USGS PA Mine Drainage Projects
Mine Drainage Newsletter

Privacy Notice

Harrisburg Field Office
1999 Pennsylvania AMD Inventory
Meta Data Report

Introduction:

This report characterizes the status and content of the Harrisburg Field Office’s (HFO) Pennsylvania AMD Inventory (AMDI) The AMDI was compiled from databases and printouts of data from the Pennsylvania Department of Environmental Protection (PADEP) Mine Drainage Inventory (MDI) and various other PADEP maintained computer database systems, including the PADEP LUMIS system. More specifically, five database sources from various time periods were combined to create the HFO AMDI. Those database sources were: a 1994 printout from the MDI of discharges from surface mines (only data source that includes water quality and quantity data); a 1996 printout from the MDI of permits where if treatment were discontinued potentially serious downstream impacts would occur; a current copy of the BAMR (Bureau of Abandoned Mine Reclamation) bond forfeiture database; a 1999 printed list from LUMIS of sites where surface reclamation was complete, but bond release was being withheld due to a pollutional discharge; a printout from the MDI of primacy permits with discharges; and the Pennsylvania Inspectable Units List (IUL) database.

Appendices

Appendix A contains data dictionaries (where available) for the individual PADEP database sources.

Appendix B contains a scanned copy of the PADEP document that established the state inventory.

HFO AMDI Data Dictionary

The HFO AMDI database contains two tables or data files. They are the Master1 table and the Seep table. The Master1 table contains 500 unique permits where a pollutional discharge was identified in one of the inventory database sources. The Seep table contains 376 detail records about the water quality and quantity of the discharges for the permits in the Master1 database. However, only 211 of the Master1 records have a detail record in the Seep table. Where a relationship exists between the two tables, there is a one (Master1) to many (Seep) relationship. The key field for relating both tables to one another is the permit number (permit_num) field in each table.

Note: The database container (.DBC) was created in Visual FoxPro 6. The tables Master1.DBF and Seep.DBF must be accessed through this database container.


Structure for table: MASTER1.DBF

Number of data records: 500

Field Field Name Type Width Dec Description

1

PERMIT_NUM

Character

15

Key Field. The permit number field was taken from each of the database sources. As the sources were combined a unique permit number was enforced.

2

COMPANY

Character

40

The company name is the name of the company that holds the permit (permittee).

3

FACTYPE

Character

5

This is the type of facility or mine. A- Surface, B- Underground, C- . The source is the IUL table.

4

COUNTY

Character

30

This is the name of the county in which the permit is located. The source is the IUL table.

5

COUNTYCODE

Character

10

This is the FIPS code for the county in which the permit is located. The source is the IUL table.

6

PERMTYPE

Character

2

This is a code to indicate under which program the permit was issued. IP- Interim Program, PP- Permanent Program. The source is the IUL table.

7

PERMSTATUS

Character

3

This is the activity status of the permit. A- Active, IN- Inactive, BR- Bond Release, AB- Abandoned in bond forfeiture. This data may be out of date. The source is the IUL table.

8

MAJ_IMPACT

Character

1

A yes or no field indicating whether a significant adverse impact would occur if treatment were ceased. The source is the printout from the State AMD inventory indicating that if treatment were ceased......

9

PERMACRES

Numeric

7

1

The number of acres permitted for surface disturbance. The source is the IUL table.

10

PERMEXP

Date

8

The date the permit expires. Data may be out of date. The source is the IUL table.

11

PERMISSUE

Date

8

The original date the permit was issued. The source is the IUL table.

12

TWP

Character

20

This is the township in which the pemrit is located. Source ?

13

MINE_NAME

Character

20

The name to which the mine is commonly referred. The source is the IUL table.

14

BONDTYPE

Character

20

The type of bond posted whether surety or cash. Source is the 1998 list of permits with discharges.

15

BONDAMT

Currency

8

4

The amount of bond posted for the permit. Source is the 1998 list of pemrits with discharges in the major impact list.

16

COST_EST

Currency

8

4

The estimated annual treatment cost for the discharges on the permit. Source is the major impact list.

17

TREAT_TYPE

Character

4

The type of treatment either passive or chemical being employed to treat the discharges. Source the LUMIS list.

18

REC_STATUS

Character

3

Reclamation status of the permit. REC indicates that all surface reclamation is complete. This list of fully reclaimed sites may not be complete. Source is the LUMIS list.

19

BND_FORF

Character

1

A yes or no field indicating that the site has completed bond forfeiture action. Source is the BAMR database of bond forfeited sites.


The source of the seep table is a 1994 printout from the PA AMD database showing water quality and quantity information for surface mines in the inventory at that time.

Structure for table: SEEP.DBF

Number of data records: 376

Field

Field Name

Type

Width

Dec

Description

1

PERMIT_NUM

Character

15

Key Field. The pemrit number assigned by the permitting authority. There may be many of the same permit number with unique discharge IDs.

2

DISCHRG_ID

Character

10

An number to identify each individual pollutional discharge on a permit.

3

FLOW

Numeric

6

1

The flow rate in gallons per minute for the discharge.

4

PH

Numeric

4

2

The pH of the discharge.

5

TOT_ACIDTY

Numeric

8

2

The total acidity of the discharge in milligrams per liter.

6

ACID_LOAD

Numeric

8

1

A calculated field based on the flow and the total acidity of the discharge. The formula for calculating the load was ???

7

TOT_ALK

Numeric

8

2

The total alkalinity of the discharge in milligrams per liter.

8

NET_ACIDTY

Numeric

8

2

A calculated field generated by subtracting alkalinity from acidity. A negative number indicates an alkaline discharge.

9

SULFATES

Numeric

8

2

The sulfate level of the discharge in milligrams per liter.

10

SULF_LOAD

Numeric

8

1

A calculated field based on the flow and the sulfate level of the discharge.

11

IRON

Numeric

8

2

The iron level in the discharge in milligrams per liter.

12

IRON_LOAD

Numeric

8

1

A calculated field based on the flow and the iron level of the discharge.

13

MANGANESE

Numeric

8

2

The manganese level in the discharge in milligrams per liter.

14

MANG_LOAD

Numeric

8

1

A calculated field based on the flow and the manganese level of the discharge.


Appendix A

 

AMD Seep Inventory

Table Name: seep.dbf

This data was supplied to OSM on January 12, 1995, in the form of a printed report, no digital data was provided. These printed reports were entered into digital format via scanning and optical character recognition (OCR). This printed report does not represent the complete database as maintained by PADEP. Only discharges from surface mines are included.

This table contains information on all discharges from Pennsylvania surface coal mines as of the end of 1994. In some instances, there are many discharges listed for a single permit.

This table has been supplemented with fields from other tables. The Pennsylvania Inspectable Units List (IUL) and the BAMR bond forfeiture table were used. The data was merged using a Visual FoxPro (VFP) program that searched the IUL and bond forfeiture tables for permit numbers from the seep.dbf. Where a match was found the fields were merged into the seep table. Additionally, several calculated fields were generated including net acidity and load.

Structure for table: SEEP.DBF

Number of data records: 376

Field Name

Type

Width

Dec

Description

PERMIT_NUM

Character

15

The number of the permit (i.e., permit number)

PERMISSUE

Date

8

The issue date of the permit.

FACTYPE

Character

5

The type of facility.(A-Surface, B-Underground, C- Preparation Plant, D- Ancillary, E- Refuse Impoundment, F- Tipple

COMPANY

Character

40

The name of the permittee of the mining operation.

COUNTY

Character

30

Name of the county in which the mine is located.

FIPS

Character

10

FIPS State code.

STATE

Character

2

State abbreviation.

COUNTYCODE

Character

3

County FIPS code.

BONDFORF

Character

1

Bond Forfeiture yes or no.

BONDAMT

Numeric

12

2

The amount of bond currently held.

MINE_NAME

Character

20

Name the mine is known by.

PERMTYPE

Character

2

The type of permit whether IP - Interim Program, PP - Permanent Program, NP- No Permit.

PERMSTATUS

Character

3

The activity status of the permit. A-Active, IN- Inactive, BR- Bond Released, AB- Abandoned. (From MSE form.)

PERMACRES

Numeric

7

1

Acres permitted for surface disturbance.

PERMEXP

Date

8

Date of permit expiration.

DISCHRG_ID

Character

10

Identification number of the discharge (specific to each permit).

FLOW

Numeric

6

1

The flow rate (volume) of the discharge in gallons per minute.

PH

Numeric

4

2

The pH of the discharge.

TOT_ACIDTY

Numeric

8

2

The total acidity of the discharge in milligrams per liter.

ACID_LOAD

Numeric

8

1

The acid load produced by the discharge in pounds per day.

TOT_ALK

Numeric

8

2

The total alkalinity of the discharge in milligrams per liter.

NET_ACIDTY

Numeric

8

2

A calculated field generated by subtracting total alkalinity from total acidity.

SULFATES

Numeric

8

2

The sulfates content of the discharge in milligrams per liter.

SULF_LOAD

Numeric

8

1

The sulfate load produced by the discharge in pounds per day.

IRON

Numeric

8

2

The iron content of the discharge in milligrams per liter.

IRON_LOAD

Numeric

8

1

The iron load produced by the discharge in pounds per day.

MANGANESE

Numeric

8

2

The manganese content of the discharge in milligrams per liter.

MANG_LOAD

Numeric

8

1

The manganese load produced by the discharge in pounds per day.

TWP

Character

20

The name of the township in which the mine is located.

** Total ** 289


High AMD Impact Inventory

This table represents a subset of the PADEP MDI as of about 1996. It is a report showing the sites with the highest potential for serious environmental impact if treatment were discontinued. This data was supplied to OSM in hard copy format. These printed reports were entered into digital format via scanning and optical character recognition (OCR). There are 51 permits in this table.

This table was supplemented with fields from other tables. The Pennsylvania Inspectable Units List (IUL) and the BAMR bond forfeiture table were used. The data was merged using a Visual FoxPro (VFP) program that searched the IUL and bond forfeiture tables for permit numbers from the pa_active.dbf. Where a match was found the fields were merged.

Structure for table: PA_ACTIVE.DBF

Number of data records: 51

Field Names:

Description

PERMIT_NUM

This is the state permit number assigned to the operation.

COMPANY

This is the name of the permittee.

TWP

The name of the township in which the permit is located.

COUNTY

The name of the county in which the permit is located.

SITE TYPE

The type of mining operation. Types include:

SMP - Surface Mining Permit.
MDP - Mine Discharge Permit.
Refuse Disp.- Refuse disposal site.
Deep Mine - Underground mining operation.
Prep Plant - Preparation plant.

BONDAMOUNT

The amount of bond posted on the site.

COST_EST

The estimated annual treatment costs for the discharges on the site.

DIST_OFFCE

The PADEP District office from which the permit is regulated.


Bond Forfeiture Inventory

File name: bf_amd.dbf,

The bond forfeiture inventory is supplied, in digital format, to OSM by PADEP on a quarterly basis or as requested. The inventory is uploaded to the \BMR_BF directory on the Harrisburg Field Office FTP Server. The PADEP contact for the upload is Brian Bradley, Hydrogeologist, Division of Mine Hazards, Bureau of Abandoned Mine Reclamation (BAMR), P.O. Box 8476, Harrisburg, PA 17105-8467 (phone: 717-783-2268).

A subset of the bond forfeiture database supplied by PADEP was created using the command {copy to bf_amd for amd = 'Y' .AND. ABAND>CTOD('08/01/82')}. This created a new database of only sites with AMD that were abandoned after Pennsylvania primacy. There are 152 records in the subset database.

It should be noted that the field AMD Y/N does not always mean a discharge. It could also mean, for example, acid water in a pit.

 

Structure for table: D:\DATA\AMD INVENTORY\BF_AMD.DBF

Number of data records: 152

Memo file block size: 64

Field Name

Type

Width

Dec

Description

COMPANY

Character

40

Name of the company holding the permit.

PERMIT_NUM

Character

15

This is the state permit number assigned to the operation.

COUNTY

Character

30

The county in which the permit is located.

COUNTYCODE

Character

3

The county FIPS code.

DISTRICT

Character

15

The PADEP District office from which the permit is regulated.

MINE_NAME

Character

20

Name the mine is known by.

FACTYPE

Character

5

The type of facility.(A-Surface, B-Underground, C- Preparation Plant, D- Ancillary, E- Refuse Impoundment, F- Tipple

MINE_TYPE Character 7

PERMTYPE

Character

2

The type of permit whether IP - Interim Program, PP - Permanent Program, NP- No Permit.

PERMSTATUS

Character

3

The activity status of the permit. A-Active, IN- Inactive, BR- Bond Released, AB- Abandoned. (From MSE form.)

PERMACRES

Numeric

7

1

Acres permitted for surface disturbance.

PERMEXP

Date

8

Date of permit expiration.

PERMISSUE

Date

8

The issue date of the permit.

TWP

Character

20

The name of the township in which the mine is located.

TREAT_TYPE

Character

4

REC_STATUS

Character

3

** Total ** 191


Bond Forfeiture Inventory

File name: bf_amd.dbf,

The bond forfeiture inventory is supplied, in digital format, to OSM by PADEP on a quarterly basis or as requested. The inventory is uploaded to the \BMR_BF directory on the Harrisburg Field Office FTP Server. The PADEP contact for the upload is Brian Bradley, Hydrogeologist, Division of Mine Hazards, Bureau of Abandoned Mine Reclamation (BAMR), P.O. Box 8476, Harrisburg, PA 17105-8467 (phone: 717-783-2268).

A subset of the bond forfeiture database supplied by PADEP was created using the command {copy to bf_amd for amd = 'Y' .AND. ABAND>CTOD('08/01/82')}. This created a new database of only sites with AMD that were abandoned after Pennsylvania primacy. There are 152 records in the subset database.

It should be noted that the field AMD Y/N does not always mean a discharge. It could also mean, for example, acid water in a pit.

 

Structure for table: D:\DATA\AMD INVENTORY\BF_AMD.DBF

Number of data records: 152

Memo file block size: 64

Field

Field Name

Type

Width/Dec

Description

1

BF_ID_

Numeric

11

An ID number assigned by BAMR.

2

ABAND

Date

8

Date the site was declared abandoned or the last coal was removed. (Source: BAMR invest).

3

ABANDONED_

Character

12

4

ACRES_NEED

Numeric

20/5

Acres needing reclaimed.

5

ADOBE

Logical

1

Is this site related to the Adobe Company large scale forfeiture.

6

AFFAC

Numeric

20/5

Affected acres by the mine operator. (Source: BAMR investigation.)

7

AMD

Character

1

Presence of Acid Mine Discharge related to the site [N=No AMD; Y= discharge exists] (Source: BAMR investigation.)

8

ASSIGNDATE

Date

8

Date the BF case was assigned for project development. (Source: BAMR invest)

9

AWARD

Date

8

Date the project was awarded. (Source: Engineering and Contracts.)

10

BF_TYPE

Character

9

Type of permit being forfeited. BF-surface mine forfeiture; DMF-deep mine forfeiture; NCF-non-coal forfeiture; CRF-coal refuse permit.

11

BFNUMBER

Character

9

Bond forfeiture project number assigned to a site when it is sent from project development to design as a reclamation project. (Source: BAMR investigation)

12

BID

Date

8

Date the project was put out for bids. (Source: Engineering and Contracts)

13

NO_BID

Character

8

14

BNDAC

Numeric

20/5

Bonded acres of the permit. (Source: BMR records)

15

BOND

Numeric

20/5

Amount of bond forfeited on the site. (Source: BMR records, Forf Letter)

16

BONDFUND

Character

1

Eligibility for bond pool funds.

17

BONDTYPE

Character

12

Type of bond (surety, cash, etc.)

18

CATEGORY

Character

8

A system of codes which provide the project status. (Source: BMR investigation)

19

CN

Character

8

Forf case number. (Source: BAMR records)

20

COALRES

Character

1

Estimation of existence fo coal reserves and potential for remining. [1=definite reserves which are mineable; 2= probable reserves which are mineable; 3= questionable reserves which are mineable; 4= no reserves or not mineable.] (Source: BAMR investigation)

21

COLLECT

Date

8

Date the bonds were collected. (Source: BMR records (collection notice)

22

COLLECTION

Character

90

23

COLBND

Numeric

20/5

The bond collected on the forfeited site. (Source: BMR records, collection notices.)

24

COMP

Date

8

Date the reclamation project was completed. (Source: Engineering and Crontracts)

25

COMNT

Character

60

A brief comment explaining the status of a project, used in the Quarterly Report. (Source: BAMR invest)

26

COUNTY

Character

45

County(s) names in which the mining occurred. (Source: BMR records.)

27

DATE_LUMIS

Date

8

28

DATE_FULL_

Date

8

29

DESIGN_ASS

Date

8

30

DEVAC

Numeric

20/5

The acreage estimated during project development that requires some type of reclamation. (Source: BAMR investigation.)

31

DEVCOST

Numeric

20/5

The cost of reclamation as estimated during Project Development. (Source: BAMR investigation)

##

DEVCOSTAC

Estimated per acre reclamation cost. (Source: derived [DEVCOST / DEVAC])

32

FILE_LABEL

Date

8

33

FORFT

Date

8

Date the site was declared forfeited. (Source: BMR records)

34

FORLETRECV

Date

8

Date on which BAMR received its copy of the forfeiture letter. (Source: BAMR invest)

35

FUNDTYPE

Character

8

Type of finding for a planned recl proj. [B= bond forf; O=collected bond plus OSM funding; I=interim program funding; IR=interim program rejected (no PR-1 or PR-2)] (Source: BAMR investigation)

36

INTERIM

Character

1

37

IS_REPORT_

Logical

1

38

ISSUE

Date

8

Date the permit was issued. (Source:BMR records)

39

MAPUPDATE

Character

3

The date on which Drafting updated the AML maps for the site. (Source: BAMR invest)

40

MDPNO

Character

20

Mine Drainage permit number of surface mine permit number. (Source: BMR records.)

41

MEMO

Memo

10

An unlimited, unstructured area for comments similar to the Comment Application in LUMIS. (Source: BAMR invest)

42

MINEPERMIT

Character

30

The forfeited mining permits or bonding increments. (Source: BMR records)

43

ONHOLDTIL

Date

8

A date until which a project is temporarily delayed for various reasons, i.e., possible remining, pending legal actions. (Source: BAMR investigation.)

44

OPERATOR

Character

45

The mining company (Source: BMR records.)

45

OSM

Character

1

46

PANUMBER

Character

11

Problem Area number form the NALIS system. (Source: BAMR invest)

47

PAQUADNAME

Character

30

The name of the USGS 7.5' quadrangle map. (Source: BAMR invest)

48

PASSIVE_TR

Logical

1

Passive treatment?

49

PITAC

Numeric

20/5

Number of acres of open pit. (Source: BAMR investigation)

50

PLANS_PROV

Character

100

51

PRIOR

Character

3

Site priority based on hazards. (Source: BAMR investigation.)

52

PROJAC

Numeric

20/5

The acreage actually included in a reclamation project. (Source: Engineering and contracting [bid documents of final change orders])

53

PROJCOOR

Character

20

The Div of Mine Hazards Project Coordinator responsible for the Project Development. (Source: BAMR invest)

54

PROJCOST

Numeric

20/5

The actual bid or final cost of a const proj. (Source: Engineering & contracts [bid documents or final change orders])

##

PROJCOSTAC

Actual per acre reclamation cost. (Source: derived [projcost / projac])

55

PSAAFFAC

Numeric

20/5

The total acreage affected by the operator as estimated during the preliminary site assessment. (Source: BAMR investigation.)

56

PSACOST

Numeric

20/5

The cost of reclamation as estimated during the preliminary site assessment. (Source: BAMR invest)

57

PSANEEDAC

Numeric

20/5

The acreage estimated during the preliminary site assessment that requires some type of reclamation. This field is no longer used.. (Source: BAMR invest)

58

PSAPITAC

Numeric

20/5

The acreage of open pit as estimated during the preliminary site assessment. This field is no longer used.. (Source: BAMR invest)

59

PSAPROJCOR

Character

20

The Division of Mine Hazards Project Coordinator responsible for the preliminary assessment. (Source: BAMR invest)

60

PSARECLMAC

Numeric

20/5

The acreage that is adequately reclaimed (no work required) as estimated during the preliminary site assessment. (Source: BAMR invest)

61

PSAREPDATE

Date

8

The date the preliminary site assessment was completed. (Source: BAMR invest)

62

PSASGNDATE

Date

8

Date the project was assigned for the preliminary site assessment. (Source: BAMR invest)

63

PSATOBMR

Date

8

The date the preliminary site assessment was entered on LUMIS. This field is no longer used. (Source: BAMR investigation.)

64

RECLMAC

Numeric

20/5

The acreage that is adequately reclaimed (no work required) (Source: BAMR investigation)

65

REPDATE

Date

8

The date the project development report was completed (Source: BAMR invest)

66

SECTION

Character

3

67

SMPCONFLCT

Logical

1

Indicates possibility of conflict with permit that has been recently applied for or issued. Y=Possible conflict; N= No conflict.. (Source: BMR records (permit application))

68

TOCOLLECT

Date

8

Date to bonds were sent for collection. (Source: BMR records)

69

TOCOLRECVD

Date

8

Date on which BAMR received the "to collection" transmittal memo. (Source: BAMR invest)

70

TWP

Character

45

Township of the mine. (Source: BMR records)

71

TREES_ADDR

Logical

1

72

TREE_PLANT

Logical

1

73

WETAC

Numeric

20/5

The acreage of wetlands either created by the Dept as a result of reclamation or water bodies left in place at the request of the property owner (sed ponds). (Source: BAMR investigation.)

74

ACT_43

Character

30

** Total ** 1162

Contact Information:
Office of Surface Mining
Appalachian Regional Office
3 Parkway Center
Pittsburgh, PA  15220
Phone: (412) 937-2804

getinfo@osmre.gov


Webmasters message
Please send website comments and suggestions
to Brent Means at
bmeans@osmre.gov


Privacy Policy
Freedom of Information Act (FOIA)
Disclaimer

First GOV link button

OSM Home Page

Handycapped access link