ak-13506-Signoff_ControlSheet.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- AK DOT 135(6), Glenn Highway Rehabilitation Kings River Bridge Section: MP 66. 0 to 67. 2
- Solicitation number
- 69056719B000032
About this file
This document contains a survey control sheet and related federal contract opportunity. The survey control sheet provides coordinate and elevation data for 12 survey control points along the Kings River Section of the Glenn Highway in Alaska. It establishes the coordinate system, vertical datum, and basis of coordinates, bearings, and vertical control used for the project.
The related federal contract opportunity is a solicitation for IFB 69056719B000032 issued by the Department of Transportation Federal Highway Administration. The opportunity is for the AK DOT 135(6) Glenn Highway Rehabilitation Kings River Bridge Section project from milepost 66.0 to 67.2. The attachments to the solicitation provide the full requirements for the project.
View the file
Other files
Show all 38
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Information
| Information | |
| 1. | This file transfers the Survey Control point list (in Excel format) to an Excel plan sheet. Open the point list files in Excel. Select the tab at the bottom of the worksheet and drag it to this spreadsheet. It will become a new tab. Place the name of this tab in the "Data Location" block below. The Survey Control point list will appear. |
| 2. | If extra sheets are needed, copy the original plan sheet by holding the left mouse button on the worksheet's tab (below) and hold the <CTRL>key. A mini sheet with a plus sign should appear. Drag this and drop it to the desired location. |
| Common Sheet Information | |||
| Insert the following values. They will appear on every sheet. | |||
| State: | AK | Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines. | |
| Project: | DOT 135(6) | ||
| NPS PMIS / |
Drawing No:
| Designed by: | WFLHD Survey | |||
| Date: | 1/1904 | |||
| Checked by: | WFLHD Survey | |||
| Date: | 1/1904 | |||
| First sheet #: | D.7 | 1.0 | ||
| Title block text: | SURVEY CONTROL | |||
| Show Totals? | TRUE | |||
| Data location: | Page 1 | Worksheet found | ||
| Data begins in col: | A | |||
| Min. rows/table | 5 | 3.0 | ||
| Base sheet name: | Sheet | 11 | rows w/data | OK - no spaces in data |
| Max. row/table | 40 | 11 | data rows | Warnings: |
| 40 | rows/table | |||
| PROJECT : Kings River Section |
COORDINATE SYSTEM : MV-1, local system developed by ADOT VERTICAL DATUM : Differential levels holding beginning elevation at CP13101
PROJECT UNITS : US SURVEY FOOT
| Sheet Names | |||||
| Input the names of the worksheets in the order you would like the sheets numbered. | |||||
| Worksheet Name | Sheet | Header row | Sheet Number | Notes | |
| Sheet | D.7 | 3 | 7 | OK | |
| Sheet (2) | Undefined | FALSE | 7 | ||
| Sheet (3) | Undefined | FALSE | 7 | ||
| Sheet (4) | Undefined | FALSE | 7 | ||
| Sheet (5) | Undefined | FALSE | 7 | ||
| Sheet (6) | Undefined | FALSE | 7 | ||
| Sheet (7) | Undefined | FALSE | 7 | ||
| Sheet (8) | Undefined | FALSE | 7 | ||
| Sheet (9) | Undefined | FALSE | 7 | ||
| Sheet (10) | Undefined | FALSE | 7 | ||
| Sheet (11) | Undefined | FALSE | 7 | ||
| Sheet (12) | Undefined | FALSE | 7 | ||
| Sheet (13) | Undefined | FALSE | 7 | ||
| Sheet (14) | Undefined | FALSE | 7 | ||
| Sheet (15) | Undefined | FALSE | 7 | ||
| Sheet (16) | Undefined | FALSE | 7 | ||
| Sheet (17) | Undefined | FALSE | 7 | ||
| Sheet (18) | Undefined | FALSE | 7 | ||
| Sheet (19) | Undefined | FALSE | 7 | ||
| Sheet (20) | Undefined | FALSE | 7 | ||
| Total Sheets: | 1 | 0 | sheets missing |
Revised: 15 June 2015
Sheet
| Sheet Information | ||||||||||||
| Sheet num: | D.7 | Filename | 0 | |||||||||
| Sheet name: | Sheet | C:\MyFiles\Projects\Alaska\Glenn_Highway\Kings_River_Bridge\design\PW\[Kings_River_Section_ControlSheet.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 29-Apr-2019 1:20 PM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
PROJECT : Kings River Section COORDINATE SYSTEM : MV-1, local system developed by ADOT VERTICAL DATUM : Differential levels holding beginning elevation at CP13101 PROJECT UNITS : US SURVEY FOOT
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||||||||
| 3.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| 13102 | 203306.181 | 116086.292 | 564.782 | 61°44'04.388521" N | 148°45'45.901514" W | 622.244 | 0.99992331 | 5/8"IR W/FHWA ALUM CAP | 1. | To convert the local coordinates to NAD83(CORS) State Plane U.S. Survey Foot coordinates, translate using +2,624,893.36529 N, +1,738,991.40294 E, and scale using 0.9999202167 | |||||
| 13103 | 203562.495 | 116758.866 | 576.247 | 61°44'06.785582" N | 148°45'31.839818" W | 633.716 | 0.99992309 | 5/8"IR W/FHWA ALUM CAP | |||||||
| 13104 | 203686.664 | 117396.702 | 589.467 | 61°44'07.887925" N | 148°45'18.551076" W | 646.948 | 0.99992277 | 5/8"IR W/FHWA ALUM CAP | |||||||
| 13105 | 203382.650 | 118086.918 | 584.551 | 61°44'04.764914" N | 148°45'04.345457" W | 642.052 | 0.99992334 | 5/8"IR W/FHWA ALUM CAP | |||||||
| 13106 | 202627.909 | 118286.106 | 575.324 | 61°43'57.297469" N | 148°45'00.512075" W | 632.846 | 0.99992388 | 5/8"IR W/FHWA ALUM CAP | |||||||
| 13107 | 201899.565 | 118320.532 | 571.846 | 61°43'50.121032" N | 148°45'00.088075" W | 629.385 | 0.99992406 | 5/8"IR W/FHWA ALUM CAP | |||||||
| 13108 | 201134.652 | 118384.069 | 572.347 | 61°43'42.579095" N | 148°44'59.074585" W | 629.906 | 0.99992407 | 5/8"IR W/FHWA ALUM CAP | |||||||
| 13109 | 200406.419 | 118691.919 | 587.086 | 61°43'35.351983" N | 148°44'52.976880" W | 644.667 | 0.99992352 | 1 1/2"DIA ALUM CAP DOT 90 | |||||||
| 13110 | 200107.704 | 119297.105 | 634.249 | 61°43'32.296561" N | 148°44'40.538405" W | 691.848 | 0.99992157 | 5/8"IR W/FHWA ALUM CAP | |||||||
| 13111 | 200152.535 | 119773.789 | 660.617 | 61°43'32.647224" N | 148°44'30.629133" W | 718.224 | 0.99992054 | 5/8"IR W/FHWA ALUM CAP | |||||||
| 13112 | 200325.736 | 120339.571 | 689.221 | 61°43'34.244364" N | 148°44'18.819309" W | 746.833 | 0.99991946 | 5/8"IR W/FHWA ALUM CAP | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 |
Basis of Coordinates:
The Basis of Coordinates is NGS Station PURIN, located near Milepost 91 of the Glenn Highway. Said station has MV-1 coordinates of 231,730.0664 N, 232,079.1864 E.
Basis of Bearings:
The Basis of Bearings is a local plane bearing between NGS Station PURIN and NGS Station PAQB. NGS Station PAQB bears S 64º53’54”W a distance of 189,974.66 U.S. Survey Feet from NGS Station PURIN. NGS Station PAQB has MV-1 coordinates of 151,137.6479 N, 60,046.5335 E Basis of Vertical Control:
The Basis of Vertical Control is NAVD88 as determined by a series of level loops performed by DOT
PROJECT : Kings River Section COORDINATE SYSTEM : MV-1, local system developed by ADOT VERTICAL DATUM : Differential levels holding beginning elevation at CP13101
PROJECT UNITS : US SURVEY FOOT
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| 13102 | 203306.181 | 116086.292 | 564.782 | 61°44'04.388521" N | 148°45'45.901514" W | 622.244 | 0.99992331 | 5/8"IR W/FHWA ALUM CAP | |
| 13103 | 203562.495 | 116758.866 | 576.247 | 61°44'06.785582" N | 148°45'31.839818" W | 633.716 | 0.99992309 | 5/8"IR W/FHWA ALUM CAP | |
| 13104 | 203686.664 | 117396.702 | 589.467 | 61°44'07.887925" N | 148°45'18.551076" W | 646.948 | 0.99992277 | 5/8"IR W/FHWA ALUM CAP | |
| 13105 | 203382.650 | 118086.918 | 584.551 | 61°44'04.764914" N | 148°45'04.345457" W | 642.052 | 0.99992334 | 5/8"IR W/FHWA ALUM CAP | |
| 13106 | 202627.909 | 118286.106 | 575.324 | 61°43'57.297469" N | 148°45'00.512075" W | 632.846 | 0.99992388 | 5/8"IR W/FHWA ALUM CAP | |
| 13107 | 201899.565 | 118320.532 | 571.846 | 61°43'50.121032" N | 148°45'00.088075" W | 629.385 | 0.99992406 | 5/8"IR W/FHWA ALUM CAP | |
| 13108 | 201134.652 | 118384.069 | 572.347 | 61°43'42.579095" N | 148°44'59.074585" W | 629.906 | 0.99992407 | 5/8"IR W/FHWA ALUM CAP | |
| 13109 | 200406.419 | 118691.919 | 587.086 | 61°43'35.351983" N | 148°44'52.976880" W | 644.667 | 0.99992352 | 1 1/2"DIA ALUM CAP DOT 90 | |
| 13110 | 200107.704 | 119297.105 | 634.249 | 61°43'32.296561" N | 148°44'40.538405" W | 691.848 | 0.99992157 | 5/8"IR W/FHWA ALUM CAP | |
| 13111 | 200152.535 | 119773.789 | 660.617 | 61°43'32.647224" N | 148°44'30.629133" W | 718.224 | 0.99992054 | 5/8"IR W/FHWA ALUM CAP | |
| 13112 | 200325.736 | 120339.571 | 689.221 | 61°43'34.244364" N | 148°44'18.819309" W | 746.833 | 0.99991946 | 5/8"IR W/FHWA ALUM CAP |
File details come from the government source that posted it. Updated .