Context Crime Index is compiled using two inputs: Precisely boundary polygons and crime data compiled by Precisely. Precisely boundary polygons are updated on a quarterly basis. Crime data from federal and local sources is compiled and updated annually.
The structure of the Context Crime Index data schema workbook changed in this release. Changes include renaming and re-ordering existing columns, as well as the addition of several new columns. Additionally, all CHAR and VARCHAR data types are now represented as TEXT, and data type and field length are represented in two separate columns.
The following columns were added to the schema workbook:
- product_table_name
- index
- primary_key
- type_code
- table_name
- grouping
Refer to the Notices tab in the schema workbook for additional information.
The following column name changes were made in the schema workbook:
| Former Column Name | New Column Name |
| Table Name | table_friendly_name |
| Seq. | sequence_number |
| Field Name | field_name |
| Field Value Key Reference | field_value_key_reference |
| Description | description |