Grade Crossing Inventory System - Highway-Rail Grade Crossing Inventory (Form 71) Field Reference Table

This a reference table for the Grade Crossing Inventory System, which is the application used to submit data for the Highway-Rail Grade Crossing Inventory (Form 71). The data dictionary for GCIS is attached as well.

The LookupType column contains the name of the field/column in the source GCIS/Form 71 dataset. The LookupValue column contains the submitted value and the LookupText field is the human-readable text description of that value (e.g. for LookupType=TypeXing; LookupValue=3 and LookupText=Public, which designates that a crossing is public). This reference table can be used for the Crossing Inventory Source Data Form 71 – Current: https://datahub.transportation.gov/dataset/Crossing-Inventory-Source-Data-Form-71-Current/xp92-5xme.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"datahub-transportation-gov/grade-crossing-inventory-system-highwayrail-grade-6phk-249c\".\"grade_crossing_inventory_system_highwayrail_grade\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.