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.
57 This appendix contains sample templates for compiling an inventory of DOT organizational functions that have data management responsibilities. Data management responsibilities may include data scoping, data collection or compilation, data validation, data quality improvement, data documentation, data loading, data integration, data analysis, data provisioning, data access management, and/or data user support. The term âdata programâ (which can also be referred to as a âdata management areaâ to avoid confusion with the term âcomputer programâ) is used here to refer to a logical unit of analysis for assessing capabilities and developing improvements. A data program can be a single organi- zational unit or team (e.g., a data management office), or an organizational function involving individuals from multiple organizational units to manage a particular category of data (e.g., financial data management). Table B.1 provides an inventory listing that covers potential DOT data programs. Agen- cies can use this as a model for developing a master list of data programs for assessment and improvement. Figure B.1 is a sample template for compiling basic information about a specific data management area. These two templates are intended to be used togetherâonce an inven- tory listing of data programs is developed, an inventory form can be completed for each data management area. A P P E N D I X B DOT Data Program Inventory
58 Data to Support Transportation Agency Business Needs: A Self-Assessment Guide Table B.1. DOT data program/data management area inventory list. Data Category Data Program/ Management Areas for Assessment Sample Data Types Included Responsible Unit(s) General IT Applicaons Development, Database Management and Administraon Mulple Transportaon Data Office Mulple Data Warehouse Group Mulple Business Intelligence/Dashboard /Repor ng Group Mul ple GIS Group Geospa al Transporta on Features (e.g., road centerlines, rail lines, and ferry routes), land and environmental features, mul ple business data layers Performance Management Mul ple performance measuresâsystem condi on, opera ons, agency efficiency Travel Data Traffic Monitoring AADT, Vehicle Classifica on, Turning Movements, Volume, Occupancy, Speed, Intersecon Level of Service, Travel Time, WIM Data Planning/Travel Modeling Household Survey Data, Socioeconomic Data, Network Links and Nodes, Origin- Desnaon Matrices Planning/Freight Commodity flows, supply chain data, boÂlenecks, infrastructure Bicycle/Pedestrian Program Bicycle Routes, Bicycle Paths, Bicycle and Pedestrian Counts System Inventory and Condion Data Road Inventory Mileage, Classificaon, Geometrics, etc.â including Model Minimum Inventory Elements (MIRE) HPMS (typically combined with Road Inventory) HPMS Data Elementsâ full extent and sample (e.g., road inventory, traffic, and pavement)
DOT Data Program Inventory 59 Table B.1. (Continued). Data Category Data Program/ Management Areas for Assessment Sample Data Types Included Responsible Unit(s) Bridge Management Structure inventory and inspecon Traffic Engineering Traffic signal inventory, guardrail inventory, sign inventory, railroad crossing inventory ITS/Traffic Management Center ITS device inventory, communicaons infrastructure inventory, Facilies Data Property Management Fleet Management Maintenance Management Plant and facilies inventory and condion, fleet inventory and ulizaon Financial/ Program Management Data Capital Program/STIP Federal Obligaons, Construcon Project Data, delivery performance (on-me, on-budget) Financial Management Funding and Allocaons, Budgets and Expenditures Contracts/ Procurement Contracts, bid tabs Human Resources Personnel data Project Development Data Design and Materials Studies, surveys, non- destrucve tests, core samples, design plans Right-of-Way Property inventory, transacons, appraisals, deeds Environmental Land use, water bodies, wetlands, groundwater, endangered species, historic sites, permits and commitments Construcon Materials tests, inspecons, payments, civil rights, claims, as- built plans System Operaons Data Incident Management Incidents (real-me status, incident response me) Traffic Management Real-me traffic and travel me data Pavement Management Pavement inventory, IRI, cracking, summary condion, layer history (continued on next page)
60 Data to Support Transportation Agency Business Needs: A Self-Assessment Guide Table B.1. (Continued). Data Category Data Program/ Management Areas for Assessment Sample Data Types Included Responsible Unit(s) Road Weather Management Weather/Road Condion (real me and historical) Motor Carrier Motor Carrier safety, operang stascs, IRP, IFTA, oversize/overweight permits Modal Programs (e.g., transit and ferry) Operaons Stascs (e.g., vehicle miles, passenger miles, and revenues) Safety Data Crash Records/FARS Reporng FARS reports, police accident records, Crash locaon, Crash frequency Safety Planning Enforcement data (citaons and convicons), injury surveillance, road safety audits, behavioral (e.g., seat belt and helmet compliance) Customer RelaÂons Public Affairs Customer opinion surveys, website transacons Equipment Management Fleet/Equipment inventory, ulizaon , cost Maintenance Management Work requests, work orders, work accomplishments, resource ulizaon, cost
DOT Data Program Inventory 61 Data Program/Management Area: Road Inventory Primary Contact: Jane Doe, jane.doe@mystate.dot.us, 987-654-3210 Data Steward(s): Same as Primary Contact Data Types Included: FuncÂonal ClassificaÂon, NHS, Road Geometrics, JurisdicÂonal ResponsibiliÂes Data Management Funcons Performed: ü Data Requirements q Data Architecture ü Data CollecÂon/AcquisiÂon ü Quality Assurance/ValidaÂon ü Data TransformaÂon/AggregaÂon/IntegraÂon q Data Analysis ü Data DistribuÂon ü Data Storage and Backup ü User Access Privileges ü Data User Support q Other__________________________________ Federal Requirements Addressed by Program: HPMS, CerÂfied Mileage ReporÂng State Requirements Addressed by Program: NA Internal Agency Users and Funcons Served: Planning â HPMS Report, Long Range Planning, Corridor Planning; Pavement Management, Bridge Management, Maintenance Management, Traffic Monitoring, Project Development External Users: FHWA, MPOs, Local JurisdicÂons Data Sources (by data type if mulple): Planning, FHWA, MPOs Data Storage Locaon (by data type if mulple): (name and storage locaon of applicaon or file(s)): Road Inventory Management System â Oracle database applicaÂon on central servers managed in IT Data Update Frequency (by data type if mulple): Annual Figure B.1. Sample data program/management area inventory form.