Police Service

The City of Calgary is broken down into 8 Districts. These districts are a geographical representation which help centralize police offices within the communities to ensure quick response to community needs. Each District has a district office. These districts can be used to calculate information submitted by investigators on criminal activity. The crime statistics can be used to develop crime prevention strategies.

Location of Calgary Police Service headquarters, district offices, and community stations.

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/police-service-ap4r-bav3\".\"police_service\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.