LRS Block Segments

This dataset is an LRS event to be used in conjunction with the base LRS geometries at https://data.winnipeg.ca/d/jwfi-vjqw/data, the Location column provided is a dynamic segmentation of the event based on the LRS geometries.

This event provides information on the street classifications, address ranges, number of lanes, and direction of City of Winnipeg streets.

Values for the Oneway column are as follows:

0 – The street is a two-way street

1 – The one-way direction is opposite the digitized direction

2 – The one-way direction is the same as the digitized direction

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/lrs-block-segments-sr8r-ehr3\".\"lrs_block_segments\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.