Identification of Utility Conflicts and Solutions: Pilot Implementation of the SHRP 2 R15B Products at the Maryland State Highway Administration (2014) / Chapter Skim
Currently Skimming:
Pages 37-60
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 37... ...
CHAPTER 3 Utility Conflict Data Model and Database Introduction The research team updated the UCM data model and Access database to reflect suggestions from MDSHA district officials on the usability of the UCM approach as well as lessons learned by members of the research team as part of other research initiatives, in particular related to the development of generalized inventories of utility facilities within the highway right-of-way. Part of this effort involved developing data entry forms in Access to manage information about projects, utility owners, utility facilities, and utility conflicts.
|
From page 38... ...
coordination of utility relocation activities, preparation and execution of utility agreements, preparation of utility certifications, and monitoring of utility relocations and reimbursement of utility owners. Figure 3.1.
|
From page 39... ...
Utility conflict management is a multistage activity within the utility process. Although every project is different, a generalized description of the major utility process stages follows.
|
From page 40... ...
• Conduct detailed utility investigations with appropriate geophysical methods at QLB for the location and soil conditions of the project to produce a map of horizontal locations of belowground utility installations. QLB investigations often turn up a significant number of previously "unknown" utility facilities, raising the question as to the benefit of limiting investigations to only existing records (i.e., QLD data)
|
From page 41... ...
• If a utility installation needs to be relocated, coordinate utility relocation design with utility owners. Coordination with utility owners involves all aspects leading to the identification and design of utility conflict resolution measures and setting dates by which critical milestones must be complete.
|
From page 42... ...
UCM Updates Effective utility conflict management involves preparing and using UCMs systematically throughout the entire utility process. Using the six-stage process described earlier, UCMs could be updated as follows (or at other critical milestones as needed)
|
From page 43... ...
Logical Data Model The research team developed a logical data model using AllFusion ERwin Data Modeler software. To facilitate implementation, the logical data model complied with the following requirements and standards: • Use of information engineering notation to model entity relationships.
|
From page 44... ...
information needed to relate utility conflict data to other components of the data model. The utility facility subject area includes a data model to build comprehensive inventories of utility facilities along transportation corridors.
|
From page 45... ...
area using SYSTEM USER ID; TEST HOLE UTILITY FACILITY, which links utility investigation test holes to utility facility records; and UTILITY CONFLICT EVENT DOCUMENT, which links utility conflict events to records of documents in the system. Figure 3.3.
|
From page 46... ...
Table 3.1. Utility Conflict Subject Area Entities and Definitions Entity Name Definition COMMENT A COMMENT is miscellaneous information that provides extra detail or description for an event.
|
From page 47... ...
Entity Name Definition UTILITY CONFLICT PARCEL A UTILITY CONFLICT PARCEL is a mapping between a UTILITY CONFLICT and a RIGHT-OF-WAY PARCEL. It identifies all UTILITY CONFLICTS associated with a RIGHT-OF-WAY PARCEL, and all RIGHT-OF-WAY PARCLELS associated with a UTILITY CONFLICT.
|
From page 48... ...
(e.g., one point feature class and one linear feature class for water installations, as well as one point feature class and one linear feature class for wastewater installations) using the Spatial Data Standards for Facilities, Infrastructure, and Environment (SDSFIE)
|
From page 49... ...
feature class is provided by FEATURE CLASS ATTRIBUTE. This linking table allows the management of utility facility feature attributes by using a data table instead of hardcoding values.
|
From page 50... ...
Table 3.2. Utility Facility Subject Area Entities and Definitions Entity Name Definition ALIGNMENT REFERENCE An ALIGNMENT REFERENCE is a point or line that can be used to define a location in reference to the point or a position on the line.
|
From page 51... ...
Entity Name Definition UTILITY FACILITY LOCATION TYPE A UTILITY FACILITY LOCATION TYPE is a characterization of the site where a UTILITY FACILITY is located. Examples of UTILITY FACILITY LOCATION TYPE include "State Right-of-Way (Permit)
|
From page 52... ...
this perspective, they provide a unique opportunity for users to become familiar with some of the typical protocols that would take place when managing utility conflicts in a database environment. Although the Access forms are not compatible with an enterprise-level environment, they provide a preliminary design based on which enterprise-level forms could be developed.
|
From page 53... ...
Figure 3.6. Form to manage projects: Add new project.
|
From page 54... ...
Figure 3.7. Form to manage projects: Edit existing project.
|
From page 55... ...
Figure 3.8. Form to manage projects: Delete existing project.
|
From page 56... ...
Figure 3.9. Form to manage utility companies: Edit utility company.
|
From page 57... ...
Figure 3.10. Form to manage utility facilities: Edit utility facility.
|
From page 58... ...
Figure 3.11. Form to manage utility conflicts: Edit utility conflict.
|
From page 59... ...
Because the number of possible optional attributes can vary drastically among utility facility classes, the research team wrote code that only displays the attributes that pertain to each facility class. Unfortunately, VBA in Access does not support dynamic controls, which made it necessary to use static controls to simulate this functionality.
|
From page 60... ...
expectation of a significant return on that investment during the life of the project. The rate of return of that investment can be huge, possibly by a factor of 100 or more.
|
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.