calgary-ca/central-business-district-cordon-count-2017-hzux-dsmm
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 11 months ago
Indexed 5 hours ago

Central Business District Cordon Count 2017

Every year in May, The City conducts the Central Business District (CBD) cordon count. The cordon count is performed at 31 locations around the CBD over a three week time period, collecting data on how people travel into and out of downtown Calgary. The CBD cordon circles the downtown with the Bow River to the north and the railway tracks to the south and from 11 Street in the west to the Elbow River in the east. These data represent the total number of persons entering (inbound) and exiting (outbound) at each location, by modes, during a 16 hour time period. This raw dataset is NOT normalized to average weekday. It is a snapshot of the inbound and outbound activity on a single day at these locations and reflects conditions specific to that day such as construction, lane closures, weather, etc. Therefore, data may not be directly comparable between locations or years.

Attachment is a summary of the inbound and outbound totals and mode of travel. For additional information on cordon counts, see <a href="http://www.calgary.ca/Transportation/TP/Pages/Planning/Transportation-Data/Central-Business-District-Cordon-Count.aspx">Central Business District Cordon Count</a>.

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 \"calgary-ca/central-business-district-cordon-count-2017-hzux-dsmm\".\"central_business_district_cordon_count_2017\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • central_business_district_cordon_count_2017
     
     
     
     
     
Upstream Metadata