Icon for Socrata external plugin
Open repository in Console
Updated over 2 years ago
Indexed 6 days ago

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"winnipeg-ca/traffic-signal-inventory-heads-displays-detail-3jzf-z9w2\".\"traffic_signal_inventory_heads_displays_detail\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • traffic_signal_inventory_heads_displays_detail
Upstream Metadata