1 / 37

The Facility Registry System

The Facility Registry System. Mainstreaming Locational Improvement In Our Work Status Update of Locational Data Improvement. 2006 GIS Workgroup Meeting Cincinnati. Purpose. Locational Status FRS Quality Improvements.

gina
Download Presentation

The Facility Registry System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Facility Registry System Mainstreaming Locational Improvement In Our Work Status Update of Locational Data Improvement 2006 GIS Workgroup Meeting Cincinnati

  2. Purpose • Locational Status • FRS Quality Improvements

  3. EPA’s architecture enables the Agency by location to describe the quality of the environment and the activities occurring at that location

  4. 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 EPA’s media information systems • Conforms to the Data Standard • Verifies the quality of data, including the linkages to EPA and State systems

  5. Snapshot of FRS Location Data Feb 2006

  6. Snapshot of FRS Location Data Aug 2006

  7. 746K Have NO Lat/Long! August 2006 Baseline May 2005 Baseline 51% without latitude/longitude 859,042 records 49% with latitude/longitude 825,854 records 62% with latitude/longitude 1,192,838 records 38% without latitude/longitude 746,565 records MASS CLEAN UP Removed locational points outside of U.S. Land/Territories and Zip Code centriod points previously entered by contractors 1,939,403 FRS 1,684,896 FRS Lat/Long data increased by 366,984 from May 2005 to August 2006

  8. What Can Be Done? • Who is to Do it? • Where is the Data? • What approach can be successful?

  9. Partnerships with Programs • 1.9 million unique records linking to program interests such as: • AFS • SDWIS • CAMDBS • NEI • PCS • Nat’l Performance Partnership • FRP (new) • BRACs (new) • TRI • RCRAInfo • RMP • RADInfo • ICIS • NCDB • CERCLIS • Schools (new)

  10. Partnerships with Programs: Goal Planned Efforts for Increased Partnerships • Underground Injection Control (UIC) ~700,000 • Emissions & Generation Resource Integrated Database (EGRID) ~4,000 • More complete School Data ~20,000 • OECA Criminal Database ~1,800 • Underground Storage Tanks (UST) ~600,000- 1 million

  11. Strategies to Locational Improvement • Partnerships • Leverage Exchange Network with States • Work closely with Regions and Program Offices • Data • Data Stewardship and Data Quality Reviews • Target critical data for consolidated acquisition/access • Integrated Error Correction Process • Automated Processes : Geo-Coding Lat/Long • Tools and Technologies • Improved Data Management • Develop reusable tools

  12. Partnerships with States: 6 more in 2006

  13. Top States for Records Without Locational Data in FRS in August 2006 STATE # WITHOUT LAT/LONG # WITH LAT/LONG Rank # for May 2005 (Without, With) New Jersey 85264 84571 #2 (84689, 29850) #1 (105837, 51959) New York 68264 94980 #3 (64875, 40495) Illinois 41400 74315 Kansas 31308 28927 #9 (25342, 11789) South Carolina 30686 25207 #4 (45492, 8956) North Carolina 29942 34355 #5 (30702, 29400) Florida 29815 36939 #10 (24349, 37554) Pennsylvania 26231 43151 #12 (23069, 45539) Texas 24175 41871 #8 (25690, 30903) Arizona 23998 6745 #14 (20336, 34079) Ohio 19646 48959 #11 (24058, 40996) Minnesota 18585 39283 #15 (19376, 16357) Missouri 17744 25342 #17 (17453, 21990) Indiana 17335 25332 #13 (20832, 18070) Wisconsin 16256 26104 #7 (25715, 55818)

  14. Database Enhancements • FRS/LRT Redesign - ongoing • Geospatially Enable Complete FRS Database -ongoing with RTP • Web Services Outbound through CDX - Done • Wisconsin Pilot using GML, Web Services and Polygonal Shapes • Regional Pilot – Web Services for Locational Data - Region 1 Complete • Upgraded our geo-coding tools to better address-match in an automated process - ongoing • Removal of all ZIP Code Centroids - Done • Addition of Border Zone Indicator - Done • Tribal Indicator on Tribal Country

  15. Data Quality Improvement Efforts • Locational Data Clean Up of Values in the Database • Quality Report of FRS Overall • Facilities on Tribal Land Universe – Redesign/Regional Clean Up • New Merge Script in FRS Reconciliation • Katrina Support on Missing and Incorrect Data • Updates to FRS Linkage Application • FRS - CDX Error Correction Service to Regulated Community • Develop quality checks in XML schema file structure • Increased Data Stewardship

  16. Ways to Correct Data • Inform National Program • Regional Exchanges • Site Locator Tool • Error Tracking System • FRS Update thru CDX • Linkage Application • State Exchanges

  17. ARC SDE Spatial Layers Available through Feature Services • Facility Site Table • Border Indicator • Site and Interest Table • CERCLIS • RMP • SDWIS • RCRA

  18. US-Mexico Border Flag: 100km

  19. Secure Entry

  20. Facility Information Update

  21. Search Facilities

  22. Search Results

  23. Facility Detail Report

  24. Merge Screen

  25. Linkage Screen

  26. Information Update Page

  27. Comments Page

  28. Select ESLT

  29. Enter Search Criteria

  30. Zoom to Desired Extent

  31. Select Function

  32. Confirm Existing Locational Data

  33. Correcting Locational Date thru CDX

  34. Correcting Locational Date thru CDX

  35. Correcting Locational Date thru CDX

  36. Correcting Locational Date thru CDX

  37. Questions? Pat Garvey Garvey.Pat@epa.gov 202-566-1687

More Related