FRS Physical Data Model
Researcher? Need to understand the model structure and relationships beyond what is provided on the EPA website? Please contact us at the FRS Request Form and request model clarification and your goals. This will help determine what information to share.
FRS Physical Model
The FRS model is a practical application of applying master data management principles to take in multiple sources of information, (e.g., program systems) and represent the relationships of these reported physical sites.
Researcher FRS Custom Query Example
A way to query FRS custom information is to use the Envirofacts API. This web API does not require requesting access and the browser can be used.
This example query joins FRS tables using the PGM_SYS_ACRNM and PGM_SYS_ID fields and filters by Colorado:
https://data.epa.gov/efservice/frs.frs_program_facility/state_code/equals/CO/left/frs.frs_interest/pgm_sys_id/equals/pgm_sys_id/pgm_sys_acrnm/equals/pgm_sys_acrnm/0:10/json
Review the example query results and reference the FRS Submit API Swagger page to help inform modifying for different fields. The Envirofacts API page has more examples to review as well.
Note - the underlying EPA legacy data model is being reviewed for simplification.