Download Data Integration Procedures in Support of

1.
To identify data items and data sources that are commonly used in the State of Florida for
transportation planning and modeling
2.
To develop data integration procedures that allow the extraction and integration of
variables from a variety of sources, formats, and levels of aggregation
3.
To provide a mechanism by which planning and modeling databases can be easily
updated as key data sources (e.g., census) get updated.
METHODOLOGY
The Department proposed to develop and implement a comprehensive set of data integration
procedures in support of modeling and planning processes in the State of Florida.
The
procedures would not only focus on the extraction and integration of data derived from a wide
variety of disparate data sources, but also on the updating and verification of the databases
over time. The project involved close coordination with several other ongoing research projects
dealing with the integration of state-of-the-art methodologies into Florida’s statewide model,
the development of urban and statewide freight models, and the development of conflation
(data or network matching) tools. This project also included an extensive effort to coordinate
closely with MPOs, state agencies, Districts, the Turnpike District, and the agencies responsible
for compiling the data sources from which input variables are derived.
This section provides an overall description of the tasks undertaken to accomplish the mission
of the project. The project was divided into two main phases. The first phase focused on the
development of data integration procedures while the second phase focused on the
development of procedures for data updating and verification.
The first phase involved the development of data integration procedures that allowed the
extraction of data items from a variety of data sources. Within this phase, the data items that
are used for modeling and planning in the State of Florida were identified and the relevant data
sources from which these items may be extracted were recognized.
The major activities
undertaken in the first phase are as follows:
Review of Current Practice: A comprehensive review of the state-of-the-practice in data
integration was conducted. The review focused on methods for integrating and matching data
BC353, RPWO#20: Data Integration Procedures
2