The Facility Registry System

1
TheFacility Registry System

• IT FORUM
• Boston, MA

2
The Facility Registry System
3
Facility Registry System
The Agency Repository of Places of Environmental
Interest

• Creates a single, integrated set of facility
  identification information
• Environmental Interests
• Locational Coordinates
• Affiliation
• Provides links to EPAs media information systems
• Conforms to the Data Standard
• QA/QC

4
Why is FRS Needed?

• FRS links facility data across program systems,
  which satisfies EPAs business need to identify
• the regulated facilities within a particular
  sector
• the location of a facility
• the different permits and regulations that apply
  to a particular facility
• all facilities owned by a particular corporation
• FRS provides essential support for applications
  that rely on integrated views of facilities
• Public Access (Envirofacts, EnviroMapper, ECHO)
• Enforcement (IDEA, OTIS)

5
High Level Data Model
Affiliation
Mailing Address
SIC/NAICS
Facility/Site
Relationship
one
many
6
FRS All about key identifiers

• Name and Location
• Contact and Organization / Mailing Address
• Program Identifiers
• Latitude / Longitude
• Other key informational elements
• HUC,
• Indian country,
• Federal Facilities

• Environmental Justice
• Environmental Interest Type
• Industrial Codes

7
FRS Dependencies
These activities rely on FRS data integration!
Envirofacts(Direct Connection)
Online Targeting Information System (OTIS)
Integrated Data for Enforcement Analysis (IDEA)
FRS
National EmissionInventory (NEI)
Central Data Exchange (CDX)
AIRS FacilitySubsystem(AFS)
Portal Project
Federal Facilities
Clean Air Markets Division Business System
(CAMDBS)
Integrated Compliance Information System (ICIS)
States
8
Goals

• Ultimate Goal
• Improve Data Quality and Integration to better
  serve our Customers
• Measured Goals for CY 2006
• 90 Lat Long
• Currently at 62 documented
• 3 more National Data Sets
• Added 3 BRAC, FRP, and NCES (Schools)
• 7 More State Exchanges
• Have 1 (AR), rest in the pipeline

9
FRS Goals CY 2006
10
Adding State and Program Exchanges

• A

National Datasets DOD BRACs Facility Response
Plan Schools Working towards E-Grid UIC, STORET
Weve added AR this year and are moving towards
Production in all States in Orange!
11
Early Snapshot of FRS Locational Data
Feb 2006
12
Snapshot of FRS Location Data
August 2006
13
Examples of Locational Information Captured in FRS

• Collection Method
• Address Matching
• GPS
• Map interpolation
• Accuracy
• Range 1 meter (GPS) and greater
• Reference Point Description
• Plant Entrance
• Water Release Pipe
• Air Release Stack, etc

14
Locational Improvement
Better data equals better analysis
Inaccurate data impedes our work to complete the
mission. (No Longer Accept ZIP Code Centroids)
15
Strategies to Locational Improvement

• Partnerships
• Leverage Exchange Network with States
• Work closely with Regions and Program Offices
• Work with other Agencies and Departments
• Data
• Data Stewardship and Data Quality Reviews
• Target critical data for consolidated
  acquisition/access
• Integrated Error Correction Process
• Tools and Technologies
• Improved Data Management
• Geo-Code
• Bounding Boxes

16
FRS Universe
August,20 2006 Baseline
May 2005 Baseline
51 without latitude/longitude 859,042 records
49 with latitude/longitude 825,854 records
62 with latitude/longitude 1,157,041 records
37.5 without latitude/longitude 777,925 records

1,913,469 FRS
1,684,896 FRS
MASS CLEAN UP Removed locational points outside
of U.S. Land/Territories and Zip Code centriod
points previously entered by contractors

17
National Programs
August 2006

• 1.9M unique records linking to 2.6M program
  interests from

18
State Programs

• CaSWIS
• ECOMAP
• FIS GEIMS
• HI-ECS
• HI-SW
• HI-UST
• HWTS-DATAMART
• IDNR_EFD
• IN-FRS
• KS-FP
• MA-EPICS

• MD-EPSC
• MD-PEMIS
• MD-RCRA
• ME-EFIS
• MN-DELTA
• MO-DNR
• MS-ENSITE
• MT-CEDARS
• NC-FITS
• ND-FP
• NE-IIS
• NH-DES
• NJ-NJEMS

• NM-TEMPO
• OH-CORE
• OK-FMS
• OR-DEQ
• PA-EFACTS
• SC-EFIS
• SWIS
• UORS
• WA-DO
• EFSIS
• WI-ESR
• AR-FRS

19
Still Missing!

• National Sets
• ICIS- NPDES A Current Refresh
• STORET
• SDWIS A Better Mapped File
• UIC
• States
• FL, AL, GA, KY, TN, TX

20
Other Data Sets and Key Identifiers of Interest?

• RAD Sites
• Biological Waste Sites
• 100Km Border Flag
• Criminal Cases on Facilities
• Others?

21
Partners with Other Agencies/Govt Entities

• Dept Homeland Security
• Interested in many of our data types
• Department of Education
• 100K Schools
• SBA- Small Business Flag
• Interested in DOE, DOI, DOD, USDA for sharing

22
Serving Our Customers
23
Who are our Customers?

• First Responders have Competing Needs
• Layers versus Integration
• Quality versus Access
• Services versus Databasing
• Data Requirements Are They Fully Known?
  Understood?
• However, We Do Have Other!

24
Customer ExpectationsData Quality Vs. Access

• Sources
• Refreshes
• Validation

• Feature Services
• Web Services
• Clip and Ship
• Node Clients
• FTP
• Account Access

25
Requests from First Responders

• Break down Stove Pipe Ownership of Data - have
  the Programs buy into the Enterprise
  Architecture.
• Improve data ownership - data received from
  critical EPA Data sets do not conform to adopted
  data standards.
• Ensure data consistency - Program Data Managers
  creating different views of data depending on the
  sharing partners.

Provide timely and accurate data according to
Emergency Priority.
26
Tools Assisting FRS

• FRS Is the Agency Architecture Enterprise
  Solution to Stovepiped data
• Integrator of environmental data for places
• Tools
• FRS Merge Applications
• Manual Review of Duplicate Candidates by Data
  Stewards
• Data Quality Validity Reports
• Enterprise Site Locator Tool
• Integrated Error Correction Process
• Query Tools
• Web Services- FRS US thru CDX
• Feature Services

27
FRS Feature and Web Services

• Allows FRS data to be queried both spatially and
  non-spatially
• Allows dynamic interface
• Clip and Ship capabilities
• Production of Shapefiles that can be used to
  create of new feature instance of the dataset
• Points and Polygons can (will) be stored.

28
Questions?

• Pat Garvey
• Garvey.Pat_at_epa.gov
• 202.566.1687