Traffic Signal Inventory - Heads (Displays) Detail

Detailed information about traffic signal pedestrian and vehicular heads and the display indications, such as “Walk/Don’t Walk”, “Pedestrian Countdowns”, “Red Ball, Amber Ball, Green Ball, Turn Indications”, etc. Includes direction accommodated by the vehicular or pedestrian display. Signal Location Number is based on general point location data from the Traffic Signals Inventory – Locations.

Point data in dataset maps to the specific pole location that supports these components. This data may change periodically.

Parent Component ID maps to Traffic Signal Inventory – Poles and Arms Detail dataset.

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 \"winnipeg-ca/traffic-signal-inventory-heads-displays-detail-3jzf-z9w2\".\"traffic_signal_inventory_heads_displays_detail\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.