ITS Data Repository Functional Area

Description

Collect and maintain data and data catalogs from one or more data sources. May include quality checks, error notification, and archive coordination.

Included In

Ohio DPS Crash Database
Ohio EPA Air Quality Database
Ohio DOT Traffic Data Archive System
MPOs Data Archives
County and City Traffic Data Archives
Regional Transit Authorities Transit Data Archives

Functional Requirements

IDRequirement
1The center shall collect data to be archived from one or more data sources.
2The 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; e.g., time range of entries, number of entries; or a sample of the data (e. g. a thumbnail).
3The center shall store the archived data in a focused repository that is suited to a particular set of ITS data users.
4The center shall include capabilities for performing quality checks on the incoming archived data.
5The center shall include capabilities for error notification on the incoming archived data.
6The center shall include capabilities for archive to archive coordination.
7The 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 summarize transportation data from multiple sources and serve a broad array of users within a region.
8The center shall perform quality checks on received data.
9The 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.
10The center shall respond to requests from the administrator interface function to maintain the archive data.
11When data or a catalog of data is received from the archive, the center shall generate the requested data product for the users systems.
12For archive data requiring financial payment, the center shall process the financial requests and manage an interface to a Financial Institution.