Federal Title PageAuthor's Title PageDisclaimerAcknowledgmentsTable of ContentsList of FiguresList of TablesList of Acronyms, Abbreviations, and TermsChapter 1. IntroductionResearch NeedResearch ObjectivesChapter 2. Review of Utility Information Flows in the Project Development ProcessIntroductionMethodologyTxDOT Information SystemsDesign & Construction Information System (DCIS)Highway Project Task Management System (HPTMS)Right of Way Information System (ROWIS)FileNetBentley ProjectWiseSan Antonio District FMSTxDOT Use of Geographic Information SystemsTxDOT GIS Architecture and Infrastructure ProjectMain Street Texas (MST)San Antonio ROW Map Locator ApplicationChapter 3. Development of TxDOT Utility Relocation Business Process ModelReview of Existing Technical DocumentationTxDOT PDP ManualTxDOT PS&E Preparation Manual and Utility ManualChallenges with Existing Technical DocumentationUtility Coordination at TxDOT DistrictsUtlity Coordination at the Austin DistrictUtility Coordination ProcessUtility Coordination IssuesCurrent Utility Tracking and Conflict ManagementRecommendations for a Future Utility Information Management SystemUtility Coordination at the Dallas District OfficeUtility Coordination ProcessUtility Coordination IssuesCurrent Utility Tracking and Conflict ManagementRecommendations for a Future Utility Information Management SystemUtility Coordination at the Houston District OfficeUtility Coordination ProcessUtility Coordination IssuesCurrent Utility Tracking and Conflict ManagementRecommendations for a Future Utility Information Management SystemUtility Coordination at the San Antonio District OfficeUtility Coordination ProcessUtility Coordination IssuesCurrent Utility Tracking and Conflict ManagementRecommendations for a Future Utility Information Management SystemBusiness Process Model DevelopmentIDEF0 and IDEF3 Business Process ModelsVisio Business Process ModelsVisio Data Flow DiagramChapter 4. Utility and Utility Consultant's Perspective of the Utility Relocation ProcessIntroductionMethodologyUtility SurveyUtility Companies ContactedUtility Consultants ContactedUtility Business Process ModelUtility NotificationUse of ConsultantsUtility Coordination MeetingUtility Conflict ResolutionObservations and TrendsUtility Conflict Notification to Utility CompaniesUtility ConsultantsAerial UtilitiesEarly Involvement in the UCMPCoordination of New Utility LocationUtility Facility TrackingUtility Coordination IssuesRecommendations for a Utility Data Exchange SystemChapter 5. Development of Data Models for Utility Relocation PrototypeIntroductionUACT User RequirementsUACT Functional RequirementsSystem InterfaceDocument Exchange and StorageCommunicationsReportingVisualizationCompatibility with Existing and Future TxDOT Information SystemsUACT System RequirementsSoftwareInterfaceDocument Exchange and StorageCommunicationsReportingVisualizationCompatibility with existing and Future TxDOT Information SystemsHardwareUACT Data ModelProject Subject AreaEvent Subject AreaDocument Management SystemPermissions SystemTxDOT and UIR Company UserData Model Improvements in Beta Development PhaseChapter 6. Description of utility Data Management System PrototypeIntroductionSystem ArchitectureAlpha Prototype FunctionalityProject Summary ScreenUtility Inventory ScreenConflict Tracking ScreenContacts ScreenChapter 7. Concluding RemarksBeta Prototype DevelopmentReferencesAppendix A. Utility SurveyUtility InterviewGeneral QuestionsUtilities and Utility ConflictsAppendix B. Logical Data Models of Utility Data Management System Prototype1. Report No. FHWA/TX-07/0-5475-1 2. Government Accession No. 3. Recipient's Catalog No. 5. Report Date October 2006 Published: January 2007 4. Title and Subtitle DEVELOPMENT OF A UTILITY CONFLICT MANAGEMENT TOOL 6. Performing Organization Code 7. Author(s) Edgar Kraus, Cesar Quiroga, Ryan Brown, Charles Stevens, and Nicholas Koncz 8. Performing Organization Report No. Report 0-5475-1 10. Work Unit No. (TRAIS) 9. Performing Organization Name and Address Texas Transportation Institute The Texas A&M University System College Station, Texas 77843-3135 11. Contract or Grant No. Project 0-5475 13. Type of Report and Period Covered Technical Report: September 2005 – August 2006 12. Sponsoring Agency Name and Address Texas Department of Transportation Research and Technology Implementation Office P. O. Box 5080 Austin, Texas 78763-5080 14. Sponsoring Agency Code 15. Supplementary Notes Project performed in cooperation with the Texas Department of Transportation and the Federal Highway Administration. Project Title: Collection, Integration, and Analysis of Utility Data in the Transportation Project Development Process URL: http://tti.tamu.edu/documents/0-5475-1.pdf 16. Abstract A critical process for the timely development and delivery of highway construction projects is the early identification and depiction of utility interests that may interfere with proposed highway facilities. The effective management of such utility interests or conflicts involves utility relocation (or design changes), inspection, and documentation. The large number of stakeholders and the magnitude of the process results in an enormous amount of data. Despite substantial data exchange between stakeholders, there are currently no standards for the exchange of utility data/information in the project development process. The research will address this issue by analyzing specific information flows and data needs to determine data models and by developing a prototype utility conflict data management system. More specifically, the research will perform a comprehensive analysis of utility conflict data/information flows between utility accommodation stakeholders in the TxDOT project development process, develop data models to accommodate work and data flows between such stakeholders, develop a prototype system for the management of utility conflict data, and develop a tool for the visualization and analysis of utility conflicts within the prototype. This report summarizes the work completed during the first year, which resulted in the development of utility relocation data models and an alpha version of the utility conflict management system. The report includes a review of utility relocation and coordination practices, describes the development of data models, and illustrates the development of the prototype conflict management system. 17. Key