National Academies Press: OpenBook

Data Management and Governance Practices (2017)

Chapter: Appendix C - Integration of Data Sets

« Previous: Appendix B - Survey Respondents
Page 90
Suggested Citation:"Appendix C - Integration of Data Sets." National Academies of Sciences, Engineering, and Medicine. 2017. Data Management and Governance Practices. Washington, DC: The National Academies Press. doi: 10.17226/24777.
×
Page 90
Page 91
Suggested Citation:"Appendix C - Integration of Data Sets." National Academies of Sciences, Engineering, and Medicine. 2017. Data Management and Governance Practices. Washington, DC: The National Academies Press. doi: 10.17226/24777.
×
Page 91
Page 92
Suggested Citation:"Appendix C - Integration of Data Sets." National Academies of Sciences, Engineering, and Medicine. 2017. Data Management and Governance Practices. Washington, DC: The National Academies Press. doi: 10.17226/24777.
×
Page 92
Page 93
Suggested Citation:"Appendix C - Integration of Data Sets." National Academies of Sciences, Engineering, and Medicine. 2017. Data Management and Governance Practices. Washington, DC: The National Academies Press. doi: 10.17226/24777.
×
Page 93
Page 94
Suggested Citation:"Appendix C - Integration of Data Sets." National Academies of Sciences, Engineering, and Medicine. 2017. Data Management and Governance Practices. Washington, DC: The National Academies Press. doi: 10.17226/24777.
×
Page 94
Page 95
Suggested Citation:"Appendix C - Integration of Data Sets." National Academies of Sciences, Engineering, and Medicine. 2017. Data Management and Governance Practices. Washington, DC: The National Academies Press. doi: 10.17226/24777.
×
Page 95
Page 96
Suggested Citation:"Appendix C - Integration of Data Sets." National Academies of Sciences, Engineering, and Medicine. 2017. Data Management and Governance Practices. Washington, DC: The National Academies Press. doi: 10.17226/24777.
×
Page 96
Page 97
Suggested Citation:"Appendix C - Integration of Data Sets." National Academies of Sciences, Engineering, and Medicine. 2017. Data Management and Governance Practices. Washington, DC: The National Academies Press. doi: 10.17226/24777.
×
Page 97
Page 98
Suggested Citation:"Appendix C - Integration of Data Sets." National Academies of Sciences, Engineering, and Medicine. 2017. Data Management and Governance Practices. Washington, DC: The National Academies Press. doi: 10.17226/24777.
×
Page 98
Page 99
Suggested Citation:"Appendix C - Integration of Data Sets." National Academies of Sciences, Engineering, and Medicine. 2017. Data Management and Governance Practices. Washington, DC: The National Academies Press. doi: 10.17226/24777.
×
Page 99
Page 100
Suggested Citation:"Appendix C - Integration of Data Sets." National Academies of Sciences, Engineering, and Medicine. 2017. Data Management and Governance Practices. Washington, DC: The National Academies Press. doi: 10.17226/24777.
×
Page 100

Below is the uncorrected machine-read text of this chapter, intended to provide our own search engines and external engines with highly rich, chapter-representative searchable text of each book. Because it is UNCORRECTED material, please consider the following text as a useful but insufficient proxy for the authoritative book pages.

C-1 Figure C1 summarizes the DOTs’ responses to the question, “Which of these data sets are integrated in your agency to serve various business needs?” This figure is an extended form of Figure 20 in the body of the report. Appendix C integration of data Sets 0 5 10 15 20 25 30 G&J G&I E&I C&I C&D B&J O&P N&P J&P I&J A&O A&L A&K E&J C&J A&N A&H M&P M&N C&G B&G A&D G&H A&M B&E E&G C&E E&F A&F B&C A&J A&I A&B A&C A&G A&E No. of DOT respondents A. Roadway inventory (e.g., location, classification, geometrics) B. Crash data C. Traffic monitoring data (e.g., speed, volume) D. Travel modeling data (e.g., household surveys, origin- destination) E. Pavement inventory and condition data F. Pavement work history data G. Bridge inventory and condition data H. Bridge work history data I. Inventory and condition data for other assets (e.g., traffic signs, signals, drainage assets) J. Transportation improvement programs data K. Environmental impact and compliance data L. Project design and materials data (e.g., design plans, structural design, mix design) M. Contracts/procurement data (e.g., bid tabs) N. Project construction data (e.g., cost/payments, schedule, material acceptance testing, as-built plans) O. Real estate data (e.g., property acquisition, agency- owned) P. Financial data (e.g., current and historical revenues, expenditures, budgets) FIGURE C1 Pairs of integrated data sets at responding DOTs. (Continued on next page)

C-2 0 5 10 15 20 25 30 L&O L&M J&O I&O I&L H&L H&J H&I G&O G&N F&N F&L F&J F&H C&N C&L B&P N&O M&O L&P L&N J&M I&M G&P G&M G&L E&P E&L K&L J&N J&K I&P I&N E&N E&M B&I A&P No. of DOT respondents A. Roadway inventory (e.g., location, classification, geometrics) B. Crash data C. Traffic monitoring data (e.g., speed, volume) D. Travel modeling data (e.g., household surveys, origin-destination) E. Pavement inventory and condition data F. Pavement work history data G. Bridge inventory and condition data H. Bridge work history data I. Inventory and condition data for other assets (e.g., traffic signs, signals, drainage assets) J. Transportation improvement programs data K. Environmental impact and compliance data L. Project design and materials data (e.g., design plans, structural design, mix design) M. Contracts/procurement data (e.g., bid tabs) N. Project construction data (e.g., cost/payments, schedule, material acceptance testing, as-built plans) O. Real estate data (e.g., property acquisition, agency- owned) P. Financial data (e.g., current and historical revenues, expenditures, budgets) FIGURE C1 (continued ).

C-3 FIGURE C1 (continued ). 0 5 10 15 20 25 30 K&O H&K F&K D&H D&F C&H K&P K&M H&O H&N H&M G&K F&O D&P D&O D&M C&F B&K B&H K&N J&L I&K H&P F&P F&M F&I F&G E&O E&K E&F D&N D&L D&K D&J D&I D&G D&E C&P C&O C&M C&K B&O B&N B&M B&L B&F B&D No. of DOT respondents A. Roadway inventory (e.g., location, classification, geometrics) B. Crash data C. Traffic monitoring data (e.g., speed, volume) D. Travel modeling data (e.g., household surveys, origin-destination) E. Pavement inventory and condition data F. Pavement work history data G. Bridge inventory and condition data H. Bridge work history data I. Inventory and condition data for other assets (e.g., traffic signs, signals, drainage assets) J. Transportation improvement programs data K. Environmental impact and compliance data L. Project design and materials data (e.g., design plans, structural design, mix design) M. Contracts/procurement data (e.g., bid tabs) N. Project construction data (e.g., cost/payments, schedule, material acceptance testing, as-built plans) O. Real estate data (e.g., property acquisition, agency- owned) P. Financial data (e.g., current and historical revenues, expenditures, budgets)

C-4 Figure C2 summarizes the DOTs’ responses to the question, “What data sets would be beneficial for your agency to integrate?” This figure is an extended form of Figure 21 in the body of the report. 0 5 10 15 20 25 30 A&E A&G A&J B&I C&F C&G C&H C&K E&J E&K E&L F&G G&H G&J I&L J&N K&O A&B A&H A&L A&P B&E C&E C&I H&N J&K J&L J&M K&L K&N A&N A&C A&F A&D A&K A&I No. of DOT respondents A. Roadway inventory (e.g., location, classification, geometrics) B. Crash data C. Traffic monitoring data (e.g., speed, volume) D. Travel modeling data (e.g., household surveys, origin-destination) E. Pavement inventory and condition data F. Pavement work history data G. Bridge inventory and condition data H. Bridge work history data I. Inventory and condition data for other assets (e.g., traffic signs, signals, drainage assets) J. Transportation improvement programs data K. Environmental impact and compliance data L. Project design and materials data (e.g., design plans, structural design, mix design) M. Contracts/procurement data (e.g., bid tabs) N. Project construction data (e.g., cost/ payments, schedule, material acceptance testing, as-built plans) O. Real estate data (e.g., property acquisition, agency-owned) P. Financial data (e.g., current and historical revenues, expenditures, budgets) FIGURE C2 Pairs of data sets that would be beneficial to integrate at responding DOTs.

C-5 0 5 10 15 20 25 30 A&M B&C B&G B&L C&D D&J E&F E&H F&H F&J F&N F&P G&L G&P H&M H&P I&J K&P L&N L&P M&N M&O M&P N&O N&P A&O B&J C&J C&L D&E E&I E&N E&P F&I G&K H&I H&J H&L I&K I&N J&O J&P L&M No. of DOT respondents A. Roadway inventory (e.g., location, classification, geometrics) B. Crash data C. Traffic monitoring data (e.g., speed, volume) D. Travel modeling data (e.g., household surveys, origin-destination) E. Pavement inventory and condition data F. Pavement work history data G. Bridge inventory and condition data H. Bridge work history data I. Inventory and condition data for other assets (e.g., traffic signs, signals, drainage assets) J. Transportation improvement programs data K. Environmental impact and compliance data L. Project design and materials data (e.g., design plans, structural design, mix design) M. Contracts/procurement data (e.g., bid tabs) N. Project construction data (e.g., cost/payments, schedule, material acceptance testing, as-built plans) O. Real estate data (e.g., property acquisition, agency-owned) P. Financial data (e.g., current and historical revenues, expenditures, budgets) FIGURE C2 (continued ). (Continued on next page)

C-6 0 5 10 15 20 25 30 B&M D&M D&O C&O E&O G&O B&O B&P C&M C&N C&P D&F D&H D&P I&O B&F D&G D&N F&O G&M H&K H&O I&M B&H B&K D&L E&M F&K G&I I&P K&M O&P B&D B&N D&I D&K E&G F&L F&M G&N L&O No. of DOT respondents A. Roadway inventory (e.g., location, classification, geometrics) B. Crash data C. Traffic monitoring data (e.g., speed, volume) D. Travel modeling data (e.g., household surveys, origin- destination) E. Pavement inventory and condition data F. Pavement work history data G. Bridge inventory and condition data H. Bridge work history data I. Inventory and condition data for other assets (e.g., traffic signs, signals, drainage assets) J. Transportation improvement programs data K. Environmental impact and compliance data L. Project design and materials data (e.g., design plans, structural design, mix design) M. Contracts/procurement data (e.g., bid tabs) N. Project construction data (e.g., cost/payments, schedule, material acceptance testing, as-built plans) O. Real estate data (e.g., property acquisition, agency- owned) P. Financial data (e.g., current and historical revenues, expenditures, budgets) FIGURE C2 (continued ).

C-7 Figure C3 summarizes the local agencies’ responses to the question, “Which of these data sets are integrated in your agency to serve various business needs?” 0 1 2 3 4 5 6 7 8 M&O J&M I&O I&K H&K G&J F&J E&J D&N D&L D&K D&I D&E C&N C&J C&E B&D B&C A&N A&M A&L A&J A&I A&H N&O J&O J&L D&J B&J J&N C&D A&G A&E A&B K&L A&D A&C No. of local agency respondents A. Roadway inventory (e.g., location, classification, geometrics) B. Crash data C. Traffic monitoring data (e.g., speed, volume) D. Travel modeling data (e.g., household surveys, origin- destination) E. Pavement inventory and condition data F. Pavement work history data G. Bridge inventory and condition data H. Bridge work history data I. Inventory and condition data for other assets (e.g., traffic signs, signals, drainage assets) J. Transportation improvement programs data K. Environmental impact and compliance data L. Project design and materials data (e.g., design plans, structural design, mix design) M. Contracts/procurement data (e.g., bid tabs) N. Project construction data (e.g., cost/payments, schedule, material acceptance testing, as-built plans) O. Real estate data (e.g., property acquisition, agency- owned) P. Financial data (e.g., current and historical revenues, expenditures, budgets) FIGURE C3 Pairs of integrated data sets at responding local agencies.

C-8 Figure C4 summarizes the local agencies’ responses to the question, “What data sets would be beneficial for your agency to integrate?” 0 1 2 3 4 5 6 7 8 9 J&L J&K I&O I&K I&J G&J E&J E&G D&I D&E C&J B&J B&I B&G B&E B&D B&C A&K A&I A&F J&O D&K D&J A&J C&D A&G A&E A&C A&D A&B No. of local agency respondents A. Roadway inventory (e.g., location, classification, geometrics) B. Crash data C. Traffic monitoring data (e.g., speed, volume) D. Travel modeling data (e.g., household surveys, origin- destination) E. Pavement inventory and condition data F. Pavement work history data G. Bridge inventory and condition data H. Bridge work history data I. Inventory and condition data for other assets (e.g., traffic signs, signals, drainage assets) J. Transportation improvement programs data K. Environmental impact and compliance data L. Project design and materials data (e.g., design plans, structural design, mix design) M. Contracts/procurement data (e.g., bid tabs) N. Project construction data (e.g., cost/payments, schedule, material acceptance testing, as-built plans) O. Real estate data (e.g., property acquisition, agency- owned) P. Financial data (e.g., current and historical revenues, expenditures, budgets) FIGURE C4 Pairs of integrated data sets at responding local agencies.

C-9 0 1 2 3 4 5 6 7 8 9 O&P N&O M&O M&N K&O K&L J&N I&M H&O H&N H&M H&K H&I G&O G&N G&L G&K G&I G&H F&P F&N F&M F&L F&J E&O E&N E&L E&K E&I E&F D&O D&N D&L D&G C&O C&N C&L C&K C&I C&G C&E B&O B&N B&K B&H B&F A&P A&O A&N A&L A&H No. of local agency respondents A. Roadway inventory (e.g., location, classification, geometrics) B. Crash data C. Traffic monitoring data (e.g., speed, volume) D. Travel modeling data (e.g., household surveys, origin- destination) E. Pavement inventory and condition data F. Pavement work history data G. Bridge inventory and condition data H. Bridge work history data I. Inventory and condition data for other assets (e.g., traffic signs, signals, drainage assets) J. Transportation improvement programs data K. Environmental impact and compliance data L. Project design and materials data (e.g., design plans, structural design, mix design) M. Contracts/procurement data (e.g., bid tabs) N. Project construction data (e.g., cost/payments, schedule, material acceptance testing, as-built plans) O. Real estate data (e.g., property acquisition, agency-owned) P. Financial data (e.g., current and historical revenues, expenditures, budgets) FIGURE C4 (continued ).

Abbreviations and acronyms used without definitions in TRB publications: A4A Airlines for America AAAE American Association of Airport Executives AASHO American Association of State Highway Officials AASHTO American Association of State Highway and Transportation Officials ACI–NA Airports Council International–North America ACRP Airport Cooperative Research Program ADA Americans with Disabilities Act APTA American Public Transportation Association ASCE American Society of Civil Engineers ASME American Society of Mechanical Engineers ASTM American Society for Testing and Materials ATA American Trucking Associations CTAA Community Transportation Association of America CTBSSP Commercial Truck and Bus Safety Synthesis Program DHS Department of Homeland Security DOE Department of Energy EPA Environmental Protection Agency FAA Federal Aviation Administration FAST Fixing America’s Surface Transportation Act (2015) FHWA Federal Highway Administration FMCSA Federal Motor Carrier Safety Administration FRA Federal Railroad Administration FTA Federal Transit Administration HMCRP Hazardous Materials Cooperative Research Program IEEE Institute of Electrical and Electronics Engineers ISTEA Intermodal Surface Transportation Efficiency Act of 1991 ITE Institute of Transportation Engineers MAP-21 Moving Ahead for Progress in the 21st Century Act (2012) NASA National Aeronautics and Space Administration NASAO National Association of State Aviation Officials NCFRP National Cooperative Freight Research Program NCHRP National Cooperative Highway Research Program NHTSA National Highway Traffic Safety Administration NTSB National Transportation Safety Board PHMSA Pipeline and Hazardous Materials Safety Administration RITA Research and Innovative Technology Administration SAE Society of Automotive Engineers SAFETEA-LU Safe, Accountable, Flexible, Efficient Transportation Equity Act: A Legacy for Users (2005) TCRP Transit Cooperative Research Program TDC Transit Development Corporation TEA-21 Transportation Equity Act for the 21st Century (1998) TRB Transportation Research Board TSA Transportation Security Administration U.S.DOT United States Department of Transportation

TRANSPORTATION RESEARCH BOARD 5 0 0 F ifth S tre e t, N W W a s h in g to n , D C 2 0 0 0 1 A D D R ESS SER VICE R EQ UESTED NO N-PRO FIT O RG . U.S. PO STAG E PA ID CO LUM BIA, M D PER M IT NO . 88 ISBN 978-0-309-38996-9 9 7 8 0 3 0 9 3 8 9 9 6 9 9 0 0 0 0

Data Management and Governance Practices Get This Book
×
MyNAP members save 10% online.
Login or Register to save!
Download Free PDF

TRB's National Cooperative Highway Research Program (NCHRP) Synthesis 508: Data Management and Governance Practices develops a collection of transportation agency data management practices and experiences. The report demonstrates how agencies currently access, manage, use, and share data.

  1. ×

    Welcome to OpenBook!

    You're looking at OpenBook, NAP.edu's online reading room since 1999. Based on feedback from you, our users, we've made some improvements that make it easier than ever to read thousands of publications on our website.

    Do you want to take a quick tour of the OpenBook's features?

    No Thanks Take a Tour »
  2. ×

    Show this book's table of contents, where you can jump to any chapter by name.

    « Back Next »
  3. ×

    ...or use these buttons to go back to the previous chapter or skip to the next one.

    « Back Next »
  4. ×

    Jump up to the previous page or down to the next one. Also, you can type in a page number and press Enter to go directly to that page in the book.

    « Back Next »
  5. ×

    To search the entire text of this book, type in your search term here and press Enter.

    « Back Next »
  6. ×

    Share a link to this book page on your preferred social network or via email.

    « Back Next »
  7. ×

    View our suggested citation for this chapter.

    « Back Next »
  8. ×

    Ready to take your reading offline? Click here to buy this book in print or download it as a free PDF, if available.

    « Back Next »
Stay Connected!