calgary-ca/community-disorder-statistics-h3h6-kgme
Icon for Socrata external plugin
 
Readme
Updated 12 days ago
Indexed 4 hours 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, Suspicious Auto (grouped as Social Disorder), Property damage and Abandoned auto (grouped as Physical Disorder).

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.

Resident counts are pulled from the latest census data

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