In regards to quality assurance procedures, the datasets were checked for both duplicates as well as inaccurate data in both its raw data file form and the converted file form. The changes and problems found are detailed under each source category.

In each dataset, there should be a unique record for every specific combination of certain parameters.

  • Area Source: FIPSST, FIPSCNTY, SCC, EMISSTYPE, PLLTCODE
  • Point Source: FIPSST, FIPSCNTY, SCC, EMISSTYPE, PLLTCODE, PLANTID, POINTID, SEGMENTID
  • Nonroad Source: FIPSST, FIPSCNTY, SCC, EMISSTYPE
  • Highway Source: FIPSST, FIPSCNTY, SCC, EMISSTYPE

To verify that no duplicate records existed in the tables, "find duplicate queries" were generated and then the duplicate records were removed.

1997 Point Source Maps

Quality Assurance/Quality Control Measures

There were over 2,000 duplicate records from the states of West Virginia, New Jersey, and Pennsylvania that were removed.

New York failed to submit 1997 summer and annual data. All New York Data is from 1996.

There were 48 unknown pollutant ID codes from Delaware that were removed. It is thought that numeric pollutant codes are CAS Numbers for Hazardous Air Pollutants.

1997 Area Source Maps

Quality Assurance/Quality Control Measures

There were no duplicate records.

New York failed to submit 1997 summer and annual data. All New York Data is from 1996.

Maine and North Carolina only provided 1997 ozone season daily emissions. No annual emissions were provided. Their annual data is from 1996.

Maine grouped Architectural Coatings, Auto Refinishing, and other surface categories into a single category. (SCC 24-01-999-000)

Maine and Maryland did not submit dry-cleaning data because they do not consider those dry-cleaning emissions to be technically VOC.

Significant portions of New York were missing from the 1996 EPA data for both summer and annual emissions for Gas Marketing - Stage II.

New Jersey and New York did not submit open burning data because of their open burning prohibition laws.

New Jersey used the incorrect code for cigarette smoke (SCC 28-10-600-000). For all New Jersey counties, the SCC code was replaced with SCC 28-10-003-000.

1997 Non-Road Source Maps

Quality Assurance/Quality Control Measures

There were no duplicate records.

New York failed to submit 1997 summer and annual data. All New York Data is from 1996. 

1996 Highway Mobile Source Maps

Quality Assurance/Quality Control Measures

There were six duplicate records removed.

New York failed to submit 1997 summer and annual data. All New York Data is from 1996.

rotate2.jpg