The National Academies Press

Currently Skimming:

Pages 136-171

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 136... ... 136 Prototype Database Queries Introduction This appendix describes the process followed to replicate the following utility conflict matrix (UCM) examples: • Prototype UCM; • Alaska Department of Transportation and Public Facilities (Alaska DOT&PF) Read the entire page →
From page 137... ... 137 Figure D.1. Prototype UCM. Read the entire page →
From page 138... ... 138 Figure D.2. Prototype UCM subsheet: Cost estimate analysis for utility conflict resolution alternatives. Read the entire page →
From page 139... ... 139 Figure D.4. Design view of "UCM 2 estimated completion date" query. Read the entire page →
From page 140... ... 140 Figure D.5. Design view of "UCM 1 multiple utility conflict status" query. Read the entire page →
From page 142... ... 142 RESOLN_ALTERNAT.UC_RESOLN_ALTERNAT_FSBL_FLAG, UTIL_ CNFLT_RESOLN_ALTERNAT.UC_RESOLN_ALTERNAT_ADVANTAGE_ TXT, UTIL_CNFLT_RESOLN_ALTERNAT.UC_RESOLN_ALTERNAT_ DISADVANTAGE_TXT, UTIL_CNFLT_RESOLN_ALTERNAT_DCSN.UCR_ ALTERNAT_DCSN_NM, UTIL_CNFLT_RESOLN_ALTERNAT.UC_RESOLN_ ALTERNAT_RSPNBL_CD, UTIL_CNFLT_RESOLN_ALTERNAT_RSPNBL. UCR_ALTERNAT_RSPNBL_NM PIVOT ESTMT_TYPE.ESTMT_TYPE_NM; Step 8: Create "UCM 2 Alternative Analysis UC34" Query This query produces a list of utility conflict resolution alternatives and related cost estimates for a specific conflict, in this case utility conflict number 34 (UC34) Read the entire page →
From page 143... ... 143 CMPNY_ID = UTIL_FCLTY.CMPNY_ID) INNER JOIN (HWY_FUNCL_CLASS INNER JOIN (HWY_SYS INNER JOIN (DOT_PROJ INNER JOIN ([UCM 1 Estimates Crosstab] Read the entire page →
From page 144... ... 144 Figure D.11. Utility conflict resolution alternatives: Cost estimate analysis (using hypothetical data from TxDOT Katy Freeway project) Read the entire page →
From page 145... ... 145 The SQL statement is as follows: TRANSFORM Sum(ESTMT.ESTMT_COST_AMT) Read the entire page →
From page 146... ... 146 Figure D.12. Prototype UCM report. Read the entire page →
From page 147... ... 147 The SQL statement is as follows: SELECT Sum([Alaska 3 Distribution Cost] .[Adjustment Cost Estimate] Read the entire page →
From page 148... ... 148 Figure D.14. Design view of "Alaska 2 total distribution" query. Read the entire page →
From page 149... ... 149 Figure D.15. Design view of "Alaska 3 distribution cost" query. Read the entire page →
From page 150... ... 150 Figure D.19. Design view of "Alaska 6 grand total" query. Read the entire page →
From page 151... ... 151 The SQL statement is as follows: SELECT UTIL_CNFLT.UTIL_CNFLT_START_STATN_MS, UTIL_CNFLT.UTIL_ CNFLT_START_OFFST_MS, UTIL_CNFLT.UTIL_CNFLT_END_STATN_MS, UTIL_CNFLT.UTIL_CNFLT_END_OFFST_MS, UTIL_FCLTY_SUBTYPE.UTIL_ FCLTY_SUBTYPE_NM, UTIL_FCLTY_LOCN_TYPE.UFL_TYPE_ACRNM_TXT, UTIL_CNFLT.UTIL_CNFLT_LNGTH_MS, UTIL_CNFLT_TYPE.UTIL_CNFLT_ TYPE_NM, UTIL_CNFLT_RESOLN_STRTGY_TYPE.UC_RESOLN_STRTGY_ TYPE_NM, [Alaska 3 Transmission Cost] .[Adjustment Cost Estimate] Read the entire page →
From page 152... ... 152 California department of Transportation UCM Example The sample UCM provided by Caltrans (shown in Appendix B, Figure B.4) includes 24 data items (four data items in the header and 20 data items in the main body) Read the entire page →
From page 153... ... 153 Figure D.22. "Alaska UCM" report. Read the entire page →
From page 154... ... 154 Figure D.23. Design view of "CA 1 date last revised" query. Read the entire page →
From page 155... ... 155 Figure D.24. Design view of "CA 1 plan document sheet number" query. Read the entire page →
From page 156... ... 156 Figure D.25. Design view of "CA 1 required completion date" query. Read the entire page →
From page 157... ... 157 PROJ_NBR = UTIL_CNFLT.DOT_PROJ_NBR) AND (DOT_PROJ.DOT_ PROJ_NBR = [CA 2 Required Completion Date Outer Join] Read the entire page →
From page 158... ... 158 report also formats certain data items -- for example, a station stored as 16555 in the database becomes 165+55 in the report. Georgia department of Transportation UCM Example The sample UCM provided by GDOT is included in Appendix B (Figure B.11) Read the entire page →
From page 159... ... 159 Figure D.30. "California UCM" report. Read the entire page →
From page 160... ... 160 called UtilA (Figure D.32) Read the entire page →
From page 161... ... 161 Step 4: Create "GDOT 2 Utility Column Concatenate" Query This query selects all conflicts for a given project number, displays the value in utility conflict alternative number, combines the values in the temporary fields UtilA and UtilB, and stores the combined value in a temporary field called UtilC. This combined value is later displayed in the UCM report as the utility field of the Georgia UCM (Figure D.34) Read the entire page →
From page 162... ... 162 All data items provided in the report are selected from database entries, including additional data items such as project number, date, and time that appear in the header of the UCM. Names of individuals who developed, revised, or reviewed the UCM report could be added to the header as needed using an insertion mechanism such as a dialog box at the time of preparing, revising, or reviewing the document. Read the entire page →
From page 163... ... 163 The SQL statement is as follows: SELECT UTIL_CNFLT.UTIL_CNFLT_ID, UTIL_CNFLT.DOT_PROJ_NBR, UTIL_ AGRMT.UA_ID, Last(UTIL_AGRMT_DT_TYPE.UA_DT_TYPE_NM) Read the entire page →
From page 164... ... 164 The SQL statement is as follows: SELECT UTIL_CNFLT.DOT_PROJ_NBR, UTIL_CNFLT.UTIL_CNFLT_ID, Last(UTIL_CNFLT_EVNT.UTIL_CNFLT_EVNT_NBR) Read the entire page →
From page 165... ... 165 xirtaM tcilfnoC ytilitU TOD aigroeG ,yadseuT rebmetpeS ,81 210235:42:5 MPTODG tcejorP :rebmuN 123456789 tcilfnoC noitatS dna tesffO ytilitU deifitnedI tcilfnoC elohtseT dedeeN ytilitU tcapmI htiw tsoC sA"( - ) "dengised tifeneB fo * Read the entire page →
From page 166... ... 166 Figure D.37. Design view of "TxDOT 1 agreement status" query. Read the entire page →
From page 167... ... 167 field, which is a concatenation of the start station and utility conflict alternate location description fields. The query concatenates the two if both fields have an entry; otherwise, it displays either field content (Figure D.41) Read the entire page →
From page 168... ... 168 The SQL statement is as follows: SELECT UTIL_CNFLT.UTIL_CNFLT_NBR, CMPNY.CMPNY_NM, UTIL_FCLTY_ TYPE.UTIL_FCLTY_TYPE_NM, [UTIL_FCLTY_SZ] Read the entire page →
From page 169... ... 169 Figure D.41. Design view of "TxDOT 1 multiple projects" query. Read the entire page →
From page 170... ... 170 lbCSJ2.Caption = GetProjCSJ(sSQL, "DOT_PROJ_NBR") Read the entire page →
From page 171... ... 171 Figure D.44. "Texas UCM" report. Read the entire page →

From page 136...

... 136 Prototype Database Queries Introduction This appendix describes the process followed to replicate the following utility conflict matrix (UCM) examples: • Prototype UCM; • Alaska Department of Transportation and Public Facilities (Alaska DOT&PF)