Software Tools for Sharing and Integrating GIS Data

Print
General Information
Study Number: TPF-5(108)
Former Study Number:
Lead Organization: Washington State Department of Transportation
Solicitation Number: 922
Partners: CA, ID, NE, OH, OR, TN, WA
Status: Closed
Est. Completion Date:
Contract/Other Number:
Last Updated: May 03, 2012
Contract End Date:
Financial Summary
Contract Amount: $250,000.00
Suggested Contribution:
Total Commitments Received: $530,000.00
100% SP&R Approval: Approved
Contact Information
Lead Study Contact(s): Mustafa Mohamedali
Mustafa.Mohamedali@wsdot.wa.gov
Phone: 360-704-6307
FHWA Technical Liaison(s): Mark Sarmiento
Mark.Sarmiento@dot.gov
Phone: 202-366-4828
Organization Year Commitments Technical Contact Name Funding Contact Name
California Department of Transportation 2007 $45,000.00 Harold Feinberg Sang Le
California Department of Transportation 2008 $45,000.00 Harold Feinberg Sang Le
Idaho Department of Transportation 2007 $20,000.00 Amanda Laib
Idaho Department of Transportation 2008 $20,000.00 Amanda Laib
Idaho Department of Transportation 2009 $20,000.00 Amanda Laib
Nebraska Department of Transportation 2006 $30,000.00 Rose Braun Amy Starr
Nebraska Department of Transportation 2007 $30,000.00 Rose Braun Amy Starr
Nebraska Department of Transportation 2008 $30,000.00 Rose Braun Amy Starr
Ohio Department of Transportation 2005 $30,000.00 Dave Blackstone General Research
Ohio Department of Transportation 2007 $30,000.00 Dave Blackstone General Research
Ohio Department of Transportation 2009 $30,000.00 Dave Blackstone General Research
Oregon Department of Transportation 2006 $35,000.00 Chad Brady Barnie Jones
Tennessee Department of Transportation 2005 $65,000.00 Stephanie Vincent
Tennessee Department of Transportation 2008 $25,000.00 Stephanie Vincent
Tennessee Department of Transportation 2010 $25,000.00 Stephanie Vincent
Washington State Department of Transportation 0 $0.00 Tami Griffin Tim Carlile
Washington State Department of Transportation 2005 $30,000.00 Tami Griffin Tim Carlile
Washington State Department of Transportation 2007 $20,000.00 Tami Griffin Tim Carlile

Study Description

Location data is the central focus of information collected and utilized by modern transportation agencies at all levels of government, state, federal, county, city, and tribal. This data is used internally for nearly every aspect of department functions, including highway maintenance, planning, safety, traffic, and environmental mitigation. It is also used to coordinate with other agencies within the jurisdiction such as law enforcement, parks and recreation, ecology, health departments, etc. and with outside interests such as economic development groups, freight carriers, and transportation agencies in other jurisdictions. This data is becoming particularly relevant to meet requirements for use of Federally provided safety related funding and new requests of the Highway Performance Monitoring System (HPMS). Development of a statewide transportation network, with roads and other transportation modes has become a critical need for many agencies and while there are various options for how this development is handled the most cost effective way over the long-term is to develop this network using data maintained and provided by local governments about the portions of the network they maintain. Thus data is developed and maintained at the location where the most information is available and then shared for the creation and maintenance of a statewide transportation network. There are various obstacles to development and maintenance of such a statewide network using data from multiple of sources, both organizational and technical. This study looks at both, but focuses on developing processes and utilities to overcome the technical obstacles. A consortium of public and private entities was established for the purpose of researching, developing and implementing computer based tools that facilitate geo-spatial transportation data sharing and integration for a variety of purposes. The Geo-spatial Integration and Sharing Data Consortium (GISDC) is funded by a Transportation Pooled Fund arrangement and managed by the Washington Department of Transportation (WSDOT). The states currently participating in the pooled fund include; California, Idaho, Nebraska, Ohio, Oregon, Tennessee and Washington. This solicitation seeks other states to participate in the process. As more participants become involved, the project will benefit from a broader input of ideas, financing, and technical assistance. Those states joining now will benefit from research already completed. However, in order to complete the scope of work planned at least 3 more partners must join, and the existing partners must pay the full amount requested in order to fully participate. The Project Description document linked to this solicitation contains a description of the project - project phases, data to be considered, software tools to be developed, and sharing agreements among the participating jurisdictions. Several items under the scope have been completed already or are within 3 months of completion.

Objectives

The goal of the consortium is to develop, implement and distribute a variety of tools and process for sharing and integrating geo-spatial transportation data. The basic objectives are: · Design and implementation of a core database, based on federal standards, within the state as a central repository of multi-jurisdictional location data, · Translation of the data from provider's schema to a centralized database and from one database to another, · Development of Internet portals for data providers to submit data and data users to download data and security to support data access, · Integration of data from disparate data sources into a seamless whole, · QA/QC processes and software to monitor data quality, security, data entry and retrieval processes, · Change detection, and change management to support maintenance of the data over time, · Documentation of a set of processes necessary to support data sharing from a variety of sources, e.g. data sharing agreements, agreement points, · Linear Referencing Integration. The initial timeline for this development is three to four years depending on funding. Annual consortium meetings and electronic communication are used to coordinate project activities. The timeline of the project and is updated based on current status and dependent upon available resources.

Scope of Work

The following products/processes are necessary to successful implementation of the transportation network data sharing. Each product/process is listed. For a detailed description of each process listed please refer to the Project Description.doc found on this we site. Two packages have been delivered to TPF partners: 1.) Data User Internet Portal code and configuration documentation. 2.) Database models, configuration and associated documentation. embership include: · Flexible Translator (bi-directional) - Process to translate data into a variety of formats (convert GIS data into any type of system). Status: Research complete. A Translator Template has been created and substantially reduces the time to create input translations for new providers. · Data Provider Internet Interface (portal) - Provide the ability for a data provider to submit data periodically to maintain current data. Status: The Data Provider Internet Portal prototype is completed and available for trial use. · Data User Internet Interface (portal) - Provide a method for users to obtain transportation framework data. Status: The Data User Internet Portal prototype is complete. · Security - Status: Internet Portal Security is completed for both portals. · Change Detection and Change Management - Processes to support transportation data maintenance. Status: Change Detection and Change Management process are 95% complete. · Data Integration - To integrate and conflate data from various jurisdictions in order to create a connected statewide transportation framework. Status: Several integration and conflation issues are being researched to include: Coincident segments, connectivity between jurisdictions, integration of centerlines from multiple providers for a single jurisdiction, Multiple Linear Referencing Systems. Many of these are in advanced stages of research. · Quality Control and Quality Assurance - establish and enforce data consistency and accuracy by checking topological, scale/spatial, attribute, and metadata (standard GIS requirements). Status: Requirements are being identified and developed. A strategy for when to perform specific types of quality control has been identified. · Linear Referencing Implementation - This objective was not estimated in the initial solicitation of this study. More partners are being sought to support the cost if this item. Status: Multiple Linear Referencing Systems have been included for some jurisdictions and can be used as expected. Utilities to support maintenance of this are being researched. · Various data pilots are planned or being implemented to test and support the concepts being developed during this research.

Comments

California, Idaho, Nebraska, Ohio, Oregon, and Tennessee have committed to three years in the pooled fund and are contributing financially, as well as with technical and testing assistance. The addition of four more states will fully fund all phases of this project. Other states have expressed interest. WA-Trans and the GISDC are actively pursuing new members. The commitment requested from each state is a total of $90,000. This can be provided over a multi-year period of time. Only as much work as is funded can be completed. If current partners wish to provide funds beyond their original commitment, to help complete the original project scope, this is also an option.

Subjects: Highway and Facility Design Planning and Administration

Documents Attached
Title File/Link Document Category Document Type Privacy Document Date Download
Final Report WA-Trans TPF 5(108) Final Report kl 2.pdf Deliverable Final Report Public 2011-07-06
Quarterly Report: April - June 2011 SPR Report GIS Software Tools 06-30-2011.pdf Progress Report Quarterly Progress Report Public 2011-06-27
Quarterly Report: January - March 2011 SPR_Report_GIS_Software_Tools_03-31-2011.pdf Progress Report Quarterly Progress Report Public 2011-06-10
Quarterly Report: October - December 2010 SPRReportGISSoftwareTools 12-31-2010.pdf Progress Report Quarterly Progress Report Public 2010-12-22
Quarterly Report: July - September 2010 SPR_Report_GIS_Software_Tools_9-30-2010.pdf Progress Report Quarterly Progress Report Public 2010-10-18
Quarterly Report: October - December 2009 qrtrly_rpt_2009_12_31.pdf Progress Report Quarterly Progress Report Public 2010-04-07
Quarterly Report: April-June 2010 SPRReportGISSoftwareTools6-30-2010.pdf Progress Report Quarterly Progress Report Public 2010-07-13
Quarterly Report: January - March 2010 SPRReportGISSoftwareTools03-31-2010.pdf Progress Report Quarterly Progress Report Public 2010-06-10
Quarterly Report: July - September 2009 qtrly_rpt_2009_09_30.pdf Progress Report Quarterly Progress Report Public 2009-10-27
Quarterly Report: April - June 2009 qtrly_rpt_2009_06_30.pdf Progress Report Quarterly Progress Report Public 2009-10-27
Quarterly Report: July - September 2008 qrtrly_rpt_2008_09_30.pdf Progress Report Quarterly Progress Report Public 2008-10-31
Quarterly Report: January - March 2009 qrtrly_rpt_2009_03_31.pdf Progress Report Quarterly Progress Report Public 2009-04-23
Quarterly Report: October - December 2008 qrtrly_rpt_2008_12_31.pdf Progress Report Quarterly Progress Report Public 2009-01-13
Quarterly Report: April - June 2008 qrtrly_rpt_2008_06_30.pdf Progress Report Quarterly Progress Report Public 2008-07-24
Quarterly Report: January - March 2008 qrtrly_rpt_2008_03_31.pdf Progress Report Quarterly Progress Report Public 2008-04-30
Quarterly Report: October - December 2007 qrtrly_rpt_2007_12_31.pdf Progress Report Quarterly Progress Report Public 2008-03-28
Project Description description.pdf TPF Study Documentation Study Summary Public 2008-07-25
Quarterly Report: July - September 2006 qrtrly_rpt_2006_09_30.pdf Progress Report Quarterly Progress Report Public 2006-10-11
Quarterly Report: April - June 2007 qrtrly_rpt_2007_06_30.pdf Progress Report Quarterly Progress Report Public 2007-07-19
Quarterly Report: July - September 2007 qrtrly_rpt_2007_09_30.pdf Progress Report Quarterly Progress Report Public 2007-11-26
Quarterly Report: January - March 2007 qrtrly_rpt_2007_03_31.pdf Progress Report Quarterly Progress Report Public 2007-04-10
Quarterly Report: October - December 2006 qrtrly_rpt_2006_12_31.pdf Progress Report Quarterly Progress Report Public 2007-01-23
Quarterly Report: January - March 2006 qrtrly_rpt_qrt1_06.pdf Progress Report Quarterly Progress Report Public 2006-04-26
Quarterly Report: October - December 2005 qrtrly_rpt_october-december_2005.pdf Progress Report Quarterly Progress Report Public 2006-01-25
Quarterly Report: July - October 2005 qrtrly_rpt_july-october_2005.pdf Progress Report Quarterly Progress Report Public 2005-10-31
Quarterly Report: April - June 2006 qrtrly_rpt_2006_06_30.pdf Progress Report Quarterly Progress Report Public 2006-07-28
Quarterly Report: April-June 2005 qrtrly_rpt_April-June_2005.pdf Progress Report Quarterly Progress Report Public 2005-07-28
Documents Attached
Title File/Link Document Category Document Type Privacy Document Date Download
Software Tools for Sharing and Integrating GIS Data 922.pdf TPF Study Documentation Solicitation Public 2011-09-25

Software Tools for Sharing and Integrating GIS Data

General Information
Study Number: TPF-5(108)
Lead Organization: Washington State Department of Transportation
Solicitation Number: 922
Partners: CA, ID, NE, OH, OR, TN, WA
Status: Closed
Est. Completion Date:
Contract/Other Number:
Last Updated: May 03, 2012
Contract End Date:
Financial Summary
Contract Amount: $250,000.00
Total Commitments Received: $530,000.00
100% SP&R Approval:
Contact Information
Lead Study Contact(s): Mustafa Mohamedali
Mustafa.Mohamedali@wsdot.wa.gov
Phone: 360-704-6307
FHWA Technical Liaison(s): Mark Sarmiento
Mark.Sarmiento@dot.gov
Phone: 202-366-4828
Commitments by Organizations
Organization Year Commitments Technical Contact Name Funding Contact Name Contact Number Email Address
California Department of Transportation 2007 $45,000.00 Harold Feinberg Sang Le (916)701-3998 sang.le@dot.ca.gov
California Department of Transportation 2008 $45,000.00 Harold Feinberg Sang Le (916)701-3998 sang.le@dot.ca.gov
Idaho Department of Transportation 2007 $20,000.00 Amanda Laib 208-334-8181 amanda.laib@itd.idaho.gov
Idaho Department of Transportation 2008 $20,000.00 Amanda Laib 208-334-8181 amanda.laib@itd.idaho.gov
Idaho Department of Transportation 2009 $20,000.00 Amanda Laib 208-334-8181 amanda.laib@itd.idaho.gov
Nebraska Department of Transportation 2006 $30,000.00 Rose Braun Amy Starr 402-479-3687 amy.starr@nebraska.gov
Nebraska Department of Transportation 2007 $30,000.00 Rose Braun Amy Starr 402-479-3687 amy.starr@nebraska.gov
Nebraska Department of Transportation 2008 $30,000.00 Rose Braun Amy Starr 402-479-3687 amy.starr@nebraska.gov
Ohio Department of Transportation 2005 $30,000.00 Dave Blackstone General Research 614-644-8135 Research@dot.state.oh.us
Ohio Department of Transportation 2007 $30,000.00 Dave Blackstone General Research 614-644-8135 Research@dot.state.oh.us
Ohio Department of Transportation 2009 $30,000.00 Dave Blackstone General Research 614-644-8135 Research@dot.state.oh.us
Oregon Department of Transportation 2006 $35,000.00 Chad Brady Barnie Jones 503- 986-2845 barnie.p.jones@odot.state.or.us
Tennessee Department of Transportation 2005 $65,000.00 Stephanie Vincent 615.741.2203 Stephanie.Vincent@tn.gov
Tennessee Department of Transportation 2008 $25,000.00 Stephanie Vincent 615.741.2203 Stephanie.Vincent@tn.gov
Tennessee Department of Transportation 2010 $25,000.00 Stephanie Vincent 615.741.2203 Stephanie.Vincent@tn.gov
Washington State Department of Transportation 0 $0.00 Tami Griffin Tim Carlile 360-705-7975 carlilt@wsdot.wa.gov
Washington State Department of Transportation 2005 $30,000.00 Tami Griffin Tim Carlile 360-705-7975 carlilt@wsdot.wa.gov
Washington State Department of Transportation 2007 $20,000.00 Tami Griffin Tim Carlile 360-705-7975 carlilt@wsdot.wa.gov

Study Description

Study Description

Location data is the central focus of information collected and utilized by modern transportation agencies at all levels of government, state, federal, county, city, and tribal. This data is used internally for nearly every aspect of department functions, including highway maintenance, planning, safety, traffic, and environmental mitigation. It is also used to coordinate with other agencies within the jurisdiction such as law enforcement, parks and recreation, ecology, health departments, etc. and with outside interests such as economic development groups, freight carriers, and transportation agencies in other jurisdictions. This data is becoming particularly relevant to meet requirements for use of Federally provided safety related funding and new requests of the Highway Performance Monitoring System (HPMS). Development of a statewide transportation network, with roads and other transportation modes has become a critical need for many agencies and while there are various options for how this development is handled the most cost effective way over the long-term is to develop this network using data maintained and provided by local governments about the portions of the network they maintain. Thus data is developed and maintained at the location where the most information is available and then shared for the creation and maintenance of a statewide transportation network. There are various obstacles to development and maintenance of such a statewide network using data from multiple of sources, both organizational and technical. This study looks at both, but focuses on developing processes and utilities to overcome the technical obstacles. A consortium of public and private entities was established for the purpose of researching, developing and implementing computer based tools that facilitate geo-spatial transportation data sharing and integration for a variety of purposes. The Geo-spatial Integration and Sharing Data Consortium (GISDC) is funded by a Transportation Pooled Fund arrangement and managed by the Washington Department of Transportation (WSDOT). The states currently participating in the pooled fund include; California, Idaho, Nebraska, Ohio, Oregon, Tennessee and Washington. This solicitation seeks other states to participate in the process. As more participants become involved, the project will benefit from a broader input of ideas, financing, and technical assistance. Those states joining now will benefit from research already completed. However, in order to complete the scope of work planned at least 3 more partners must join, and the existing partners must pay the full amount requested in order to fully participate. The Project Description document linked to this solicitation contains a description of the project - project phases, data to be considered, software tools to be developed, and sharing agreements among the participating jurisdictions. Several items under the scope have been completed already or are within 3 months of completion.

Objectives

The goal of the consortium is to develop, implement and distribute a variety of tools and process for sharing and integrating geo-spatial transportation data. The basic objectives are: · Design and implementation of a core database, based on federal standards, within the state as a central repository of multi-jurisdictional location data, · Translation of the data from provider's schema to a centralized database and from one database to another, · Development of Internet portals for data providers to submit data and data users to download data and security to support data access, · Integration of data from disparate data sources into a seamless whole, · QA/QC processes and software to monitor data quality, security, data entry and retrieval processes, · Change detection, and change management to support maintenance of the data over time, · Documentation of a set of processes necessary to support data sharing from a variety of sources, e.g. data sharing agreements, agreement points, · Linear Referencing Integration. The initial timeline for this development is three to four years depending on funding. Annual consortium meetings and electronic communication are used to coordinate project activities. The timeline of the project and is updated based on current status and dependent upon available resources.

Scope of Work

The following products/processes are necessary to successful implementation of the transportation network data sharing. Each product/process is listed. For a detailed description of each process listed please refer to the Project Description.doc found on this we site. Two packages have been delivered to TPF partners: 1.) Data User Internet Portal code and configuration documentation. 2.) Database models, configuration and associated documentation. embership include: · Flexible Translator (bi-directional) - Process to translate data into a variety of formats (convert GIS data into any type of system). Status: Research complete. A Translator Template has been created and substantially reduces the time to create input translations for new providers. · Data Provider Internet Interface (portal) - Provide the ability for a data provider to submit data periodically to maintain current data. Status: The Data Provider Internet Portal prototype is completed and available for trial use. · Data User Internet Interface (portal) - Provide a method for users to obtain transportation framework data. Status: The Data User Internet Portal prototype is complete. · Security - Status: Internet Portal Security is completed for both portals. · Change Detection and Change Management - Processes to support transportation data maintenance. Status: Change Detection and Change Management process are 95% complete. · Data Integration - To integrate and conflate data from various jurisdictions in order to create a connected statewide transportation framework. Status: Several integration and conflation issues are being researched to include: Coincident segments, connectivity between jurisdictions, integration of centerlines from multiple providers for a single jurisdiction, Multiple Linear Referencing Systems. Many of these are in advanced stages of research. · Quality Control and Quality Assurance - establish and enforce data consistency and accuracy by checking topological, scale/spatial, attribute, and metadata (standard GIS requirements). Status: Requirements are being identified and developed. A strategy for when to perform specific types of quality control has been identified. · Linear Referencing Implementation - This objective was not estimated in the initial solicitation of this study. More partners are being sought to support the cost if this item. Status: Multiple Linear Referencing Systems have been included for some jurisdictions and can be used as expected. Utilities to support maintenance of this are being researched. · Various data pilots are planned or being implemented to test and support the concepts being developed during this research.

Comments

California, Idaho, Nebraska, Ohio, Oregon, and Tennessee have committed to three years in the pooled fund and are contributing financially, as well as with technical and testing assistance. The addition of four more states will fully fund all phases of this project. Other states have expressed interest. WA-Trans and the GISDC are actively pursuing new members. The commitment requested from each state is a total of $90,000. This can be provided over a multi-year period of time. Only as much work as is funded can be completed. If current partners wish to provide funds beyond their original commitment, to help complete the original project scope, this is also an option.

Subjects: Highway and Facility Design Planning and Administration

Title File/Link Type Private
Final Report WA-Trans TPF 5(108) Final Report kl 2.pdf Deliverable Public
Quarterly Report: April - June 2011 SPR Report GIS Software Tools 06-30-2011.pdf Progress Report Public
Quarterly Report: January - March 2011 SPR_Report_GIS_Software_Tools_03-31-2011.pdf Progress Report Public
Quarterly Report: October - December 2010 SPRReportGISSoftwareTools 12-31-2010.pdf Progress Report Public
Quarterly Report: July - September 2010 SPR_Report_GIS_Software_Tools_9-30-2010.pdf Progress Report Public
Quarterly Report: April-June 2010 SPRReportGISSoftwareTools6-30-2010.pdf Progress Report Public
Quarterly Report: January - March 2010 SPRReportGISSoftwareTools03-31-2010.pdf Progress Report Public
Quarterly Report: October - December 2009 qrtrly_rpt_2009_12_31.pdf Progress Report Public
Quarterly Report: July - September 2009 qtrly_rpt_2009_09_30.pdf Progress Report Public
Quarterly Report: April - June 2009 qtrly_rpt_2009_06_30.pdf Progress Report Public
Quarterly Report: January - March 2009 qrtrly_rpt_2009_03_31.pdf Progress Report Public
Quarterly Report: October - December 2008 qrtrly_rpt_2008_12_31.pdf Progress Report Public
Quarterly Report: July - September 2008 qrtrly_rpt_2008_09_30.pdf Progress Report Public
Project Description description.pdf TPF Study Documentation Public
Quarterly Report: April - June 2008 qrtrly_rpt_2008_06_30.pdf Progress Report Public
Quarterly Report: January - March 2008 qrtrly_rpt_2008_03_31.pdf Progress Report Public
Quarterly Report: October - December 2007 qrtrly_rpt_2007_12_31.pdf Progress Report Public
Quarterly Report: July - September 2007 qrtrly_rpt_2007_09_30.pdf Progress Report Public
Quarterly Report: April - June 2007 qrtrly_rpt_2007_06_30.pdf Progress Report Public
Quarterly Report: January - March 2007 qrtrly_rpt_2007_03_31.pdf Progress Report Public
Quarterly Report: October - December 2006 qrtrly_rpt_2006_12_31.pdf Progress Report Public
Quarterly Report: July - September 2006 qrtrly_rpt_2006_09_30.pdf Progress Report Public
Quarterly Report: April - June 2006 qrtrly_rpt_2006_06_30.pdf Progress Report Public
Quarterly Report: January - March 2006 qrtrly_rpt_qrt1_06.pdf Progress Report Public
Quarterly Report: October - December 2005 qrtrly_rpt_october-december_2005.pdf Progress Report Public
Quarterly Report: July - October 2005 qrtrly_rpt_july-october_2005.pdf Progress Report Public
Quarterly Report: April-June 2005 qrtrly_rpt_April-June_2005.pdf Progress Report Public
Title File/Link Type Private
Software Tools for Sharing and Integrating GIS Data 922.pdf TPF Study Documentation Public

Currently, Transportation Pooled Fund is not supported on mobile devices, please access this Web portal using a desktop or laptop computer.