calgary-ca/community-disorder-statistics-h3h6-kgme
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

Community Disorder Statistics

In addition to monitoring crime levels, the Calgary Police Service uses a range of types of calls for service (CFS) to monitor levels of "Disorder." Research indicates that disorder can have a negative impact on public perceptions of safety. Disorder is often highly visible, occurring in public spaces; drunks, panhandling, youth gangs, prostitution, littering, loitering and graffiti are examples of signals of social and physical disorder. A very low proportion of disorder-based calls for service result in crime reports.

Disorder CFS included are: Drunk, Disturbance, Indecent Act, Landlord/tenant, Mental health concern, Neighbor dispute, Party complaint, Suspicious person, Threats, Drugs, Noise complaint, Possible gunshots, Unwanted guest/patron, Prostitution, Speeder.

Please note there has been an update to the methodology for disorder in January of 2024, including the removal of property damage and Abandoned auto, resulting in the dissolution of disorder sub-categories. Disorder counts will therefore not be directly comparable to previously published disorder reporting.

Only public-generated call types are included: Advised, Callback, and Dispatched (police-generated calls are excluded). All dispositions are included.

Events are assigned to communities based on the geocode in CAD. Count is by single event.

Data source: Computer Aided Dispatch (CAD) run on the 4th of the month (or the closest business day) for the previous month. This data is considered to be static. Property Damage occurrences reported using the online reporting system are included from the CPS records management system (SENTRY). This data is considered to be cumulative.

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/community-disorder-statistics-h3h6-kgme\".\"community_disorder_statistics\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • community_disorder_statistics
     
     
     
     
     
Upstream Metadata