Highway Data Element Dictionary

Source

datahub.transportation.gov

Quality score: 100/100.

Initial recorded revision.

Dataset refresh metadata

Current Source Files

• Highway_Data_Element_Dictionary.csv 20260926191854-8e947c8f0686 Provider source

Contract Versions

• 20260926191854-8e947c8f0686 Copy YAML link

Current Open Data Contract YAML

Open raw YAML

dataset_id: dot-highway-data-element-dictionary
title: Highway Data Element Dictionary
description: Highway Data Element Dictionary discovered from datahub.transportation.gov.
source_name: datahub.transportation.gov
source_url: https://datahub.transportation.gov/api/views/nhvr-exvq/rows.csv?accessType=DOWNLOAD
update_frequency: adhoc
next_scan_at: '2026-09-29T02:00:00+00:00'
license:
  name: Public Domain U.S. Government
  url: https://datahub.transportation.gov/Roadways-and-Bridges/Highway-Data-Element-Dictionary/nhvr-exvq
tags:
- datahub.transportation.gov
- transportation
geography:
- United States
revisions:
- revision_id: 20260926191854-8e947c8f0686
  detected_at: '2026-09-26T19:18:54+00:00'
  source_updated_at: Tue, 15 Jul 2025 20:23:23 GMT
  context: Highway_Data_Element_Dictionary.csv detected from rows.csv.
  assets:
  - asset_id: asset-7e783fbabc6e852a
    name: Highway_Data_Element_Dictionary.csv
    source_url: https://datahub.transportation.gov/api/views/nhvr-exvq/rows.csv?accessType=DOWNLOAD
    media_type: text/csv; charset=utf-8
    content_hash: 7e783fbabc6e852ad4d624f7a07544cc763094f3bf3408a31cf155ef7940d0c4
    size_bytes: 1189121
    parent_archive_id: null
  row_count: 6014
  headers:
  - Data Element Name
  - Preferred Physical Name
  - Subject Category Code
  - Description Text
  - Data Type Code
  - Maximum Length
  - Precision Number
  - Pattern Text
  - Unit of Measure
  - Value Domain
  - Business Owner Name
  - Data Asset Abbreviation
  - Data Asset Name
  - System Number
  sample_rows:
  - Data Element Name: Apparent Length Minimum
    Preferred Physical Name: APPARENT_LEN_MIN
    Subject Category Code: ''
    Description Text: Minimum possible value of apparent length.
    Data Type Code: Decimal
    Maximum Length: '3'
    Precision Number: '2'
    Pattern Text: ''
    Unit of Measure: m
    Value Domain: ''
    Business Owner Name: HRDI
    Data Asset Abbreviation: LTPP
    Data Asset Name: Long-Term Pavement Performance
    System Number: Single System
  - Data Element Name: Application Name
    Preferred Physical Name: APPLNAME
    Subject Category Code: ''
    Description Text: The application name that processes the entry sheet.
    Data Type Code: Integer
    Maximum Length: '31'
    Precision Number: '0'
    Pattern Text: ''
    Unit of Measure: ''
    Value Domain: ''
    Business Owner Name: HRDI
    Data Asset Abbreviation: LTPP
    Data Asset Name: Long-Term Pavement Performance
    System Number: Single System
  - Data Element Name: Apparent Specific Gravity
    Preferred Physical Name: APPARENT_SPECIFIC_GRAVITY
    Subject Category Code: ''
    Description Text: Apparent specific gravity of the specimen.
    Data Type Code: Decimal
    Maximum Length: '4'
    Precision Number: '2'
    Pattern Text: ''
    Unit of Measure: ''
    Value Domain: 4-Feb
    Business Owner Name: HRDI
    Data Asset Abbreviation: LTPP
    Data Asset Name: Long-Term Pavement Performance
    System Number: Single System
  - Data Element Name: Subrecipient Name
    Preferred Physical Name: SUBRECIPIENT_NAME
    Subject Category Code: Reference
    Description Text: "Legal Business Name of the project recipient's sub-organization.\
      \ Required when Subrecipient Project field is a Yes. Notes the Name of the Subrecipient\
      \ (defined in 2 CFR 200.1) in the UEI/Sam Database. NOTE: State DOT\u2019s and\
      \ Divisions will need to validate the UEI/Sam database to identify the appropriate\
      \ entity for use in the Subrecipient fields. Once identified, the State DOT\
      \ or Division Office will need to send this information to the [email protected]\
      \ to have the organization validated and loaded into FMIS for use."
    Data Type Code: Character
    Maximum Length: '200'
    Precision Number: '0'
    Pattern Text: ''
    Unit of Measure: ''
    Value Domain: ''
    Business Owner Name: HCF
    Data Asset Abbreviation: FMIS 5.0
    Data Asset Name: Fiscal Management Information System (FMIS) 5.0
    System Number: Single System
  - Data Element Name: Subrecipient Project
    Preferred Physical Name: SUBRECIPIENT_PROJECT
    Subject Category Code: Reference
    Description Text: Project associated with Subrecipient (defined in 2 CFR 200.1).
      Required only for State DOT project submissions. To be used to identify projects
      that will be administered by a subrecipient.
    Data Type Code: Yes/No indicating if project is associated with Subrecipient
    Maximum Length: '1'
    Precision Number: '0'
    Pattern Text: ''
    Unit of Measure: ''
    Value Domain: ''
    Business Owner Name: HCF
    Data Asset Abbreviation: FMIS 5.0
    Data Asset Name: Fiscal Management Information System (FMIS) 5.0
    System Number: Single System
  parser_errors: []
  logical_asset_id: 11bc91faf42a77768793dc3e
related_dataset_ids: []
quality:
  score: 100
  parsing_errors: []
  stale_warning: null
  broken_source_report: null
rss_feed_url: null
odc_version: '0.1'
last_successful_scan_at: '2026-09-26T19:18:54+00:00'

Current dbt Source YAML

Open raw YAML

version: 2
sources:
- name: dot_highway_data_element_dictionary
  description: Highway Data Element Dictionary discovered from datahub.transportation.gov.
  meta:
    opendataodc:
      dataset_id: dot-highway-data-element-dictionary
      revision_id: 20260926191854-8e947c8f0686
      detected_at: '2026-09-26T19:18:54+00:00'
      source_url: https://datahub.transportation.gov/api/views/nhvr-exvq/rows.csv?accessType=DOWNLOAD
  tables:
  - name: highway_data_element_dictionary_csv
    description: Source asset Highway_Data_Element_Dictionary.csv.
    meta:
      opendataodc:
        source_url: https://datahub.transportation.gov/api/views/nhvr-exvq/rows.csv?accessType=DOWNLOAD
        content_hash: 7e783fbabc6e852ad4d624f7a07544cc763094f3bf3408a31cf155ef7940d0c4
        row_count: 6014
        parser_errors: []
    columns:
    - name: Data Element Name
    - name: Preferred Physical Name
    - name: Subject Category Code
    - name: Description Text
    - name: Data Type Code
    - name: Maximum Length
    - name: Precision Number
    - name: Pattern Text
    - name: Unit of Measure
    - name: Value Domain
    - name: Business Owner Name
    - name: Data Asset Abbreviation
    - name: Data Asset Name
    - name: System Number

Sample Rows

Highway_Data_Element_Dictionary.csv

6014 parsed rows. 20260926191854-8e947c8f0686