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
"}
EOFSee the Splitgraph documentation
for more information.
