About this Dataset

Calls For Service (2012-2015)

Note: This dataset was deprecated effective April 30, 2025. Please refer to the Calls for Service (Consolidated) dataset for current data and access to historical records, including prior reporting years.

The Calls for Service dataset includes police service requests for which patrol officers, traffic officers, bike officers and, on occasion, detectives will be dispatched to public safety response. It also includes self-initiated calls for service where an officer witnesses a violation or suspicious activity for which they would respond.

Contact E-mail

Contact Phone: N/A

Link: N/A

Data Source: Versaterm Informix RMS

Data Source Type: Informix and/or SQL Server

Preparation Method: Preparation Method: Automated View pulled from CADWSQL (SQL Server) and duplicated on the GIS Server

Publish Frequency: Weekly

Publish Method: Automatic

Data Dictionary
Organization: City of Tempe
Last updated: 2024-08-02T17:38:56.452429
Tags: archived-data, calls-for-service, open-data, police-department-data, public-safety

Tables

Table 1

@usgov.city_of_tempe_calls_for_service_2012_2015_f08fc.table_1

25.19 MB
540,473 rows
23 columns

CREATE TABLE table_1 (
  "x" BIGINT,
  "y" BIGINT,
  "objectid" BIGINT,
  "primarykey" VARCHAR,
  "occurrencedatetime" TIMESTAMP,
  "occurrenceyear" BIGINT,
  "occurrencemonth" BIGINT,
  "occurrencehour" BIGINT,
  "occurrenceweek" BIGINT,
  "occurrencedatepart" BIGINT,
  "occurrenceweekday" VARCHAR,
  "obfuscatedaddress" VARCHAR,
  "xcoordinate" BIGINT,
  "ycoordinate" BIGINT,
  "disclaimer" VARCHAR,
  "placename" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "characterarea" VARCHAR,
  "reportdistrict" VARCHAR,
  "reportbeat" VARCHAR,
  "postalcode" DOUBLE,
  "censustractid" DOUBLE
);