Creating data sources for incident analytics

Before you configure incident analytics, create data sources for all of the incident data that you plan to use.

Procedure

  1. Create data sources with the following properties:
    Database content Purpose Property values
    Incidents Contains data about incidents in city, such as crime or traffic accidents, with location data such as latitude and longitude for each incident.
    • Geometry type = Point
    • Start and end date represent time of crime occurrence.
    Adult arrest records Contains arrest records for adults. Geometry type = All
    Juvenile arrest records Contains arrest records for juveniles. Geometry type = All
    Persons of interest (adult) Contains records for adults with arrest records, who are on parole, or otherwise might be considered suspects for a crime.
    • Geometry type = Point
    • Start and end date property mapping is not required.
    • Location format = Latitude and longitude
    Persons of interest (juvenile) Contains records for juveniles with arrest records, who are on parole, or otherwise might be considered suspects for a crime.
    • Geometry type = Point
    • Start and end date property mapping is not required.
    • Location format = Latitude and longitude
    Boundary areas, such as zones, districts, or precincts. Include one data source for each boundary area.
    • Set the data source as a boundary data source.
    • Geometry format = Polygon or multipolygon
    • All time and date fields can be left blank.
    Restriction: Import data for incident analysis as read-only data sources.
  2. Configure a geocoding data source to import data that contains addresses, but not latitude and longitude coordinates, for the location of the data.
    1. Use the data sources configuration tool to create a data source and select From my own source with my own property mapping as the data source definition type.
    2. Select Connect to a database as the acquisition method.
    3. On Step 3 of 3: Data Ingestion, ensure that the Location property is selected for import.
    4. On the Minimal Properties > Name & Location tabMinimal Properties page, Name & Location pane, Location Properties section, select the data source properties that define an address. You can add as many Address fields as necessary to define a complete address. For example, an address format for 25 Elm Street might require three address fields:
      • Address for the house number, such as "25."
      • Address 2 for the street name, such as "Elm."
      • Address 3 for the street suffix, such as "St." or "Blvd."
  3. If your city data uses a geographic coordinate system other than the World Geodetic System GCS_WGS_1984, configure a custom coordinate system data source.
    1. Use the data sources configuration tool to create a data source and select From my own source with my own property mapping as the data source definition type.
    2. Select Connect to database (custom coordinate system) as the acquisition method.
    3. Set the CustomCoordinateSystem system property to the name of the custom coordinate system.
  4. Optional: Configure a data source for weather data to apply to crime risk assessment.
    1. Use the data sources configuration tool to create a data source and select From a third-party source with predefined property mapping as the data source definition type.
    2. Select NOAA Weather as the acquisition method.
    3. Select the state, weather station, time zone, and units of measure. The weather station ID and location are automatically entered.
    4. Set up a polling interval for the weather data source to ensure that current data is used.
  5. Create filters for incident data and persons of interest.