FAF5 Freight Flows — Ontology Crosswalk v1.0
Dataset: FAF5 Freight Flows (faf5-freight-flows)
Target standards: USDOT BTS / FHWA / ORNL Freight Analysis Framework 5.7.1 (DOI 10.21949/1529116); Standard Classification of Transported Goods (SCTG); ANSI/FIPS state codes; APRS ingestion contract.
Dataset license: LicenseRef-US-Gov-Public-Domain — U.S. Government public domain (FAF5.7.1 U.S. Government work; cite USDOT BTS, FHWA and ORNL, FAF5.7.1, DOI 10.21949/1529116), research release · not commercially licensable; outside the Commercial All-access license
Effective: 2026-11-07
FAF rows are modeled annual aggregate flow estimates. Publisher codes are authoritative source terms and are preserved as strings; the FAF5 User Guide defines their meaning. The APRS envelope mappings describe the canonical conceptual boundary; envelope-only fields are not emitted by the flat releases.
1. Field mapping
| Codex field | External term / source field | Namespace | Notes |
|---|---|---|---|
chunk_id |
dct:identifier | Dublin Core / APRS | Envelope-only. |
doc_id |
schema:identifier | schema.org / APRS | Envelope-only; would bind record_id. |
record_id |
dct:identifier | Dublin Core / APRS | Stable release-qualified source-row URN. |
source_native_id |
FAF natural identity | FAF5 | Pipe-joined publisher codes plus year. |
release_version |
FAF release | FAF5 | 5.7.1. |
year |
time:Year | OWL-Time | Annual estimate period. |
estimate_status |
FAF estimate status | FAF5 | final or preliminary. |
fr_orig |
fr_orig |
FAF5 | Foreign origin region code. |
origin_state_fips |
dms_origst |
FAF5 / ANSI FIPS | State panel origin state. |
destination_state_fips |
dms_destst |
FAF5 / ANSI FIPS | State panel destination state. |
dms_orig |
dms_orig |
FAF5 | Zone sample origin FAF zone. |
dms_dest |
dms_dest |
FAF5 | Zone sample destination FAF zone. |
fr_dest |
fr_dest |
FAF5 | Foreign destination region code. |
fr_inmode |
fr_inmode |
FAF5 | Foreign inbound mode code. |
dms_mode |
dms_mode |
FAF5 | Domestic mode code. |
fr_outmode |
fr_outmode |
FAF5 | Foreign outbound mode code. |
sctg2 |
SCTG two-digit commodity | SCTG | Not NAICS. |
trade_type |
trade_type |
FAF5 | Trade type code. |
dist_band |
dist_band |
FAF5 | Distance band classification. |
tons_thousands |
tons_<year> |
FAF5 | Thousand short tons. |
value_million_2017_usd |
value_<year> |
FAF5 | Million constant 2017 US dollars. |
current_value_million_usd |
current_value_<year> |
FAF5 | Million current-year US dollars. |
ton_miles_millions |
tmiles_<year> |
FAF5 | Million ton-miles. |
source_feed |
dct:source | Dublin Core / Axiom registry | Governed source feed identifier. |
source_system |
dct:source | Dublin Core / Axiom registry | faf5. |
source_uri |
dct:source | Dublin Core | Exact FAF5.7.1 input file. |
acl_tier |
dct:accessRights | Dublin Core / Axiom policy | Research tier marker. |
acl |
dct:accessRights | Dublin Core / APRS | Envelope-only. |
schema_version |
dct:conformsTo | Dublin Core | Frozen row-level schema string. |
normalization_version |
dct:conformsTo | Dublin Core | Normalization contract version. |
occurred_at |
prov:startedAtTime | W3C PROV-O | Always null. |
effective_from |
time:hasBeginning | OWL-Time | Envelope-only. |
effective_to |
time:hasEnd | OWL-Time | Envelope-only. |
ingested_at |
prov:generatedAtTime | W3C PROV-O | Codex observation clock. |
modified_at |
prov:generatedAtTime | W3C PROV-O / Axiom | Last re-derivation clock. |
superseded_by |
prov:wasRevisionOf | W3C PROV-O | Envelope-only. |
confidence_score |
N/A | APRS envelope | Envelope-only; no Codex confidence is assigned. |
provenance |
prov:wasGeneratedBy | W3C PROV-O | Envelope-only; release manifest.json carries provenance. |
2. Deviations
| Deviation | Rationale |
|---|---|
| Annual year columns are pivoted into one row per year. | One record per natural identity and year keeps measures comparable across years. |
occurred_at is null. |
An annual estimate has no event instant. |
No h3_index. |
A state or FAF zone has no canonical observation point; a centroid would misrepresent an aggregate flow as cell-level freight. |
3. References
- Freight Analysis Framework (data.gov)
- FAF5 User Guide
JOIN_KEYS.mdINGESTION_CONTRACT.md