fiokg

SAWGraph FRS KG

The FRS (Facility Registry Service) KG is the part of the SAWGraph project that stores data about facilities from EPA's Facility Registry service (FRS) together with their NAICS industry classification and the spatial location.

294.9M triples
109 classes
68 properties
18.4M subjects

The FRS KG is a core component of the SAWGraph (Safe Agricultural Products and Water Graph) project, an NSF-funded Proto-OKN initiative to monitor and trace PFAS and other contaminants in the nation's food and water systems. This knowledge graph integrates comprehensive facility (i.e. industrial, federal, and utility facilities) and industry classification data for the coterminous United States (48 states) from EPA's Facility Registry Service (FRS), which provides an integrated source of environmental information about over 826,000 regulated facilities across air, water, and waste programs. The graph is built on top of the Facilities and Industries Ontology (FIO) that offers hierarchically structured NAICS industries and generalized links to facilities. The FRS KG currently contains 2.6 million entities and over 10 million triples, structuring data around facilities, environmental records (monitoring, permits, enforcement), and NAICS industry codes. Each facility is spatially indexed to S2 cells (Level 13; from the Spatial KG) and Level 3 administrative regions (county subdivisions; using DataCommons URIs) using KnowWhereGraph’s spatial relations and linked to environmental interest types, compliance systems, and temporal tracking records. The dataset employs standard vocabularies including Dublin Core, PROV-O, GeoSPARQL, and Schema.org. The graph supports SPARQL queries such as for environmental compliance research, contaminant pathway analysis, and facility-industry profiling.

Retrieve all solid waste landfills (NAICS Industry Code 562212) in the state of Georgia (FIPS code 13) and their name and the town they are located in. 
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX fio: <http://w3id.org/fio/v1/fio#>
PREFIX naics: <http://w3id.org/fio/v1/naics#> 
PREFIX epa-frs: <http://w3id.org/fio/v1/epa-frs#>
PREFIX geo: <http://www.opengis.net/ont/geosparql#>
PREFIX kwg-ont: <http://stko-kwg.geog.ucsb.edu/lod/ontology/>
PREFIX kwgr: <http://stko-kwg.geog.ucsb.edu/lod/resource/>
PREFIX spatial: <http://purl.org/spatialai/spatial/spatial-full#>


SELECT * WHERE {
  VALUES ?code {naics:NAICS-562212}
  ?fac rdf:type fio:Facility ;
       fio:ofIndustry ?code ;
       spatial:connectedTo ?town ;
       geo:hasGeometry/geo:asWKT ?facWKT;
       rdfs:label ?facilityName.

  # filter by administrative region (kwgr:administrativeRegion.USA.13 denotes the state of Georgia) and retrieve town
  ?town rdf:type kwg-ont:AdministrativeRegion_3 ;
                   kwg-ont:administrativePartOf+ kwgr:administrativeRegion.USA.13 ;
                   rdfs:label ?townLabel .

  # also retrieve any labels associated with the facility and industry 
  OPTIONAL { ?fac rdfs:label ?faclabel . }
  OPTIONAL { ?code rdfs:label ?ind . }
}

graph TD
Run in FRINK
Retrieve all chemical manufacturing facilities (NAICS code 325), their 6-digit industry code and their locations. 
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX fio: <http://w3id.org/fio/v1/fio#>
PREFIX naics: <http://w3id.org/fio/v1/naics#> 
PREFIX epa-frs: <http://w3id.org/fio/v1/epa-frs#>
PREFIX geo: <http://www.opengis.net/ont/geosparql#>
PREFIX kwg-ont: <http://stko-kwg.geog.ucsb.edu/lod/ontology/>

SELECT ?fac ?faclabel ?code ?codelabel ?fac_s2 ?fac_wkt WHERE {
  VALUES ?subsector {naics:NAICS-325}
  ?fac rdf:type fio:Facility ;
       fio:ofIndustry ?code ;
       kwg-ont:sfWithin ?fac_s2.
  ?code rdf:type naics:NAICS-IndustryCode; 
    fio:subcodeOf ?subsector.
  ?fac_s2 a kwg-ont:S2Cell_Level13.
  ?fac_s2 geo:hasGeometry/geo:asWKT ?fac_wkt .

  # also retrieve any labels associated with the facility and industry 
  OPTIONAL { ?fac rdfs:label ?faclabel . }
  OPTIONAL { ?code rdfs:label ?codelabel . }
}

graph TD
Run in FRINK
SPARQL Endpoint https://frink.apps.renci.org/fiokg/sparql
Triple Pattern Fragments https://frink.apps.renci.org/ldf/fiokg
ClassEntities
PropertyTriples