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. Note - this diagram is simplified and does not show every table.

Custom Query Example

A way to query specific custom information based on the model above is to use the Envirofacts API. 

This example query joins tables using the PGM_SYS_ACRNM and PGM_SYS_ID fields:
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 and FRS Model Data Dictionary to help inform modifying for different fields. The Envirofacts API page has more examples to review.

Note - the underlying EPA legacy data model is being reviewed for simplification.