ITS Element: Ohio DPS Crash Records Database

Send Your Comments

Description: Statewide database of crash records.
Status: Planned
Stakeholder: Ohio Department of Public Safety
Mapping: Archived Data Management Subsystem
Other Archives

Interfaces:

City of Cleveland Police, Fire, and EMS Dispatch
County Public Safety Dispatch
Crash Records Database Users
Municipal Public Safety Dispatch
Ohio State Highway Patrol Posts
Market Packages: AD1 - ITS Data Mart - Ohio DPS Crash Records Database
Functional Requirements:

ITS Data Repository

  • For archive data requiring financial payment, the center shall process the financial requests and manage an interface to a Financial Institution.
  • The center shall collect data catalogs from one or more data sources. A catalog describes the data contained in the collection of archived data and may include descriptions of the schema or structure of the data, a description of the contents of the data
  • The center shall collect data to be archived from one or more data sources.
  • The center shall include capabilities for archive to archive coordination.
  • The center shall include capabilities for error notification on the incoming archived data.
  • The center shall include capabilities for performing quality checks on the incoming archived data.
  • The center shall perform quality checks on received data.
  • The center shall provide the capability to execute methods on the incoming data such as cleansing, summarizations, aggregations, or transformations applied to the data before it is stored in the archive.
  • The center shall respond to requests from the administrator interface function to maintain the archive data.
  • The center shall store the archived data in a focused repository that is suited to a particular set of ITS data users.
  • The center shall support a broad range of archived data management implementations, ranging from simple data marts that collect a focused set of data and serve a particular user community to large-scale data warehouses that collect, integrate, and summari
  • When data or a catalog of data is received from the archive, the center shall generate the requested data product for the users systems.

Government Reporting Systems Support

  • The center shall provide data from an ITS archive to federal, state, or local government reporting systems.
  • The center shall provide the applicable meta-data for any ITS archived data to satisfy government reporting system requests. Meta-data may include attributes that describe the source and quality of the data and the conditions surrounding the collection o
  • The center shall provide the capability to format data from an ITS archive suitable for input into government reports.
  • The center shall provide the capability to select data from an ITS archive for use in government reports.
  • The center shall support requests for ITS archived data from Government Reporting Systems.

Last updated: 03-17-10