ITS Element: Mesilla Valley MPO Data Warehouse

Send Your Comments

Description: The data warehouse for the Mesilla Valley MPO. Allows virtual access points into other archives through one portal.
Status: Existing
Stakeholder: Mesilla Valley MPO
Mapping: Archived Data Management

Interfaces:

Archive Data Users
City of Las Cruces Traffic Management Center
City of Las Cruces Website
Dona Ana County Traffic Operations Center
Mesilla Valley MPO Traffic Monitoring Program
MVRDA Communications Center
NMDOT District 1 TOC
NMDOT Highway Maintenance Management System (HMMS)
NMDOT Park and Ride Dispatch
NMDOT Traffic Information Management System (TIMS)
NMSU Emergency Dispatch Center
Other Transit Dispatch
RoadRUNNER Fixed Route Dispatch System
RoadRUNNER Paratransit Dispatch Center
South Central RTD Operations Center
Service Packages: AD2 - ITS Data Warehouse - Las Cruces MPO Data Warehouse (2 of 2)
AD2 - ITS Data Warehouse - Las Cruces MPO Data Warehouse (1 of 2)
Functional Requirements:

ITS Data Repository

  • The center shall collect data to be archived from one or more data sources.
  • 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; e.g., time range of entries, number of entries; or a sample of the data (e. g. a thumbnail).
  • 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 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.
  • 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 capability to select data from an ITS archive for use in government reports.
  • The center shall provide the capability to format data from an ITS archive suitable for input into government reports.
  • The center shall support requests for ITS archived data from Government Reporting Systems.

On-Line Analysis and Mining

  • The center shall support the interface with Archive Data User Systems for requests for analysis of the archive data.
  • The center shall provide the capability to perform activities such as data mining, data fusion, summarizations, aggregations, and recreation from archive data. This may include multidimensional analysis, selective summarization and expansion of data details, and many other advanced analysis services.
  • The center shall receive the user’s systems requests and develop the request to retrieve the data from the archive.
  • The center shall respond to users systems requests for a catalog of the archived data analysis products available.

Traffic and Roadside Data Archival

  • The center shall manage the collection of archive data directly from collection equipment located at the roadside.
  • The center shall collect traffic sensor information from roadside devices.
  • The center shall send the request for data and control parameters to the field equipment where the information is collected and returned.
  • The center shall record the status about the imported traffic and roadside data.

Last updated: 08-08-14