Identification of Utility Conflicts and Solutions (2012) / Chapter Skim
Currently Skimming:
Pages 24-41
The Chapter Skim interface presents what we've algorithmically identified as the most significant single chunk of text within every page in the chapter.
Select key terms on the right to highlight them within pages of the chapter.
From page 24... ...
24 C h a p t e r 4 Introduction This chapter describes the development of a data architecture to support the use of a variety of UCMs in a database environment. The following sections describe data architecture components developed as part of this research, a utility conflict database prototype, and the results of testing the prototype with two sample UCMs and the prototype UCM described in Chapter 3.
|
From page 25... ...
25 conflicts resolved by the end of the design phase. Appendix B describes the utility coordination process for several of the states contacted.
|
From page 26... ...
26 • Attribute names use alphanumeric (no special) characters; have fewer than six words; and consist of one or more prime words, zero or more qualifier words, and end with one class word.
|
From page 27... ...
27 subject areas, one for each core data object in the conceptual model, as follows: • Utility conflict subject area (Figure 4.4) ; • Utility facility subject area (Figure 4.5)
|
From page 29... ...
29 In general, the process to replicate UCMs involved the following steps: • Review requirements and content of the original UCM. • Develop and test queries.
|
From page 31... ...
31 • Step 1. Create "UCM 1 estimated completion date" query.
|
From page 32... ...
32 Figure 4.8. Logical data model: Document subject area.
|
From page 33... ...
33 utility conflict status and the corresponding utility conflict event date for each utility conflict.
|
From page 34... ...
34 Figure 4.10. Utility conflict resolution alternatives: Cost estimate analysis.
|
From page 35... ...
35 • Step 2. Create "Alaska 1 transmission crosstab" query.
|
From page 36... ...
36 U lity Conflict Matrix Project Owner: Project No.: Texas Department of Transporta on 1234-56-789 Project Descrip on: Road construc on project in Houston Highway or Route: I-10 Katy Freeway Date: Date: _____________ _____________ U lity Conflict Matrix Developed/Revised By: ________________________________ Reviewed By: ________________________________ U lity Owner and/ or Contact Name U lity Type Start Sta on End Sta on Start Offset End Offset Size and/or Material U lity Inves ga on Level Needed Test Hole No. Es mated Resolu on Date Resolu on StatusDrawing or Sheet No.
|
From page 37... ...
37 Figure 4.12. Alaska DOT&PF sample utility conflict report excerpt.
|
From page 38... ...
38 • Step 4. Create "CA 1 UC comment" query.
|
From page 39... ...
39 I-10-EA 122401-Utilities Conflict Status date of last revision May 30, 2000 this document was prepared by htpeD/tcilfnoC ytilitUtcilfnoCelohnaM/elohtoPytilitUrenwOelohtoPytilitUtcilfnoC Util. Reloc.
|
From page 40... ...
40 Figure 4.15. Caltrans UCM report.
|
From page 41... ...
41 needs of a wide range of state DOTs, including linking to existing database systems to avoid data duplication. Additional advantages of a database approach to manage utility conflicts include the following: • The database can be adapted to address changes in DOT needs and business processes.
|
Key Terms
This material may be derived from roughly machine-read images, and so is provided only to facilitate research.
More
information on Chapter Skim is available.