About this Dataset

General Offenses (Open Data)

The General Offense Crime Report Dataset includes criminal and city code violation offenses which document the scope and nature of each offense or information gathering activity. It is used to computate the Uniform Crime Report Index as reported to the Federal Bureau of Investigation and for local crime reporting purposes.

Contact E-mail

Link: N/A

Data Source: Versaterm Informix RMS \

Data Source Type: Informix and/or SQL Server

Preparation Method: Preparation Method: Automated View pulled from SQL Server and published as hosted resource onto ArcGIS Online

Publish Frequency: Weekly

Publish Method: Automatic

Data Dictionary
Organization: City of Tempe
Last updated: 2024-02-09T15:00:45.252670
Tags: crime, open-data-view, police-department, public-safety

Tables

Table 1

@usgov.city_of_tempe_general_offenses_open_data.table_1

12.72 MB
345147 rows
28 columns


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