Police Calls

The following data is from the St. Petersburg Police Department’s Computer-Aided Dispatch (CAD) system. Under Florida State Statute 119.071, victim information (i.e. addresses) associated with Sexual Battery, Sexual Offenses, Child Abuse, and Adult Abuse are considered confidential and exempt from public release. The data includes all officer responses to Priority 1, 2, 3, 4, 6, 7 and 9, calls for service. These calls for service don’t necessarily result in official police reports under UCR (Uniform Crime Reporting) standards. The calls do not include the Forensic Technicians, Off Duty, Administrative or similarly classified calls.

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 \"stat-stpete/police-calls-2eks-pg5j\".\"police_calls\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.