Stehekin_NOCA 10(7)_emergency reroutes_controlsheet.xlsx
XLSX spreadsheet 41 KB Posted
- Solicitation number
- 69056721B000021
About this file
This document contains a survey control point list and related federal contract opportunity. The survey control point list provides state plane and geo coordinates, elevations, descriptions and other data for 29 survey control points along the Stehekin Valley Road in Washington state. It will be used as part of an emergency rerouting project by the National Park Service North Cascades Office under solicitation number 69056721B000021. The federal contract opportunity seeks emergency rerouting services along the Stehekin Valley Road, to be awarded by the Department of Transportation Federal Highway Administration. Key details include the project location, required survey and design work, and involvement of the National Park Service and Federal Highway Administration in managing the contract.
View the file
Other files
Show all 23
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: | WA | Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines. | |
| Project: | NPS NOCA 10(7) | ||
| NPS PMIS / |
Drawing No:
| Designed by: | WFLHD Survey | |||
| Date: | 1/1904 | |||
| Checked by: | WFLHD Survey | |||
| Date: | 1/1904 | |||
| First sheet #: | D.10 | 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 | 15 | rows w/data | OK - no spaces in data |
| Max. row/table | 40 | 15 | data rows | Warnings: |
| 40 | rows/table | |||
| PROJECT : Stehekin Valley Road Emergency Reroute |
DATE OF FIELD WORK : 10/2020
DATE OF FINAL ADJUSTMENT : ???
PROJECT UNITS : US Survey foot COORDINATE SYSTEM : Washington North SPCS NAD83
EPOCH DATE : 91
VERTICAL DATUM : NAVD88
GPK FILE DATED JAN 24, 2007
| 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.10 | 3 | 10 | OK | |
| Sheet (2) | Undefined | FALSE | 10 | ||
| Sheet (3) | Undefined | FALSE | 10 | ||
| Sheet (4) | Undefined | FALSE | 10 | ||
| Sheet (5) | Undefined | FALSE | 10 | ||
| Sheet (6) | Undefined | FALSE | 10 | ||
| Sheet (7) | Undefined | FALSE | 10 | ||
| Sheet (8) | Undefined | FALSE | 10 | ||
| Sheet (9) | Undefined | FALSE | 10 | ||
| Sheet (10) | Undefined | FALSE | 10 | ||
| Sheet (11) | Undefined | FALSE | 10 | ||
| Sheet (12) | Undefined | FALSE | 10 | ||
| Sheet (13) | Undefined | FALSE | 10 | ||
| Sheet (14) | Undefined | FALSE | 10 | ||
| Sheet (15) | Undefined | FALSE | 10 | ||
| Sheet (16) | Undefined | FALSE | 10 | ||
| Sheet (17) | Undefined | FALSE | 10 | ||
| Sheet (18) | Undefined | FALSE | 10 | ||
| Sheet (19) | Undefined | FALSE | 10 | ||
| Sheet (20) | Undefined | FALSE | 10 | ||
| Total Sheets: | 1 | 0 | sheets missing |
Revised: 15 June 2015
Sheet
| Sheet Information | ||||||||||||
| Sheet num: | D.10 | Filename | 0 | |||||||||
| Sheet name: | Sheet | c:\pw-work\dms08896\[Stehekin_NOCA 10(7)_emergency reroutes_controlsheet.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 17-Dec-2020 8:31 AM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
PROJECT : Stehekin Valley Road Emergency Reroute
DATE OF FIELD WORK : 10/2020
DATE OF FINAL ADJUSTMENT : ??? PROJECT UNITS : US Survey foot COORDINATE SYSTEM : Washington North SPCS NAD83
EPOCH DATE : 91
VERTICAL DATUM : NAVD88
GPK FILE DATED JAN 24, 2007
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||||||||
| 3.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| 20101 | 495651.478 | 1665957.509 | 1249.043 | 48°21'31.468221"N | 120°43'41.802597"W | N/A | 0.9998914139 | 5/8" IR W/FHWA ALUM CAP | 1. | To precisely check distances between points as measured on the ground, inverse the state plane coordinates and divide the computed distance by a mean combined factor of the two points. | |||||
| 20102 | 495914.203 | 1665717.711 | 1253.972 | 48°21'34.064101"N | 120°43'45.348154"W | N/A | 0.9998912315 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 20103 | 496070.946 | 1665549.120 | 1246.225 | 48°21'35.613139"N | 120°43'47.841488"W | N/A | 0.9998916331 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 20104 | 496160.408 | 1665536.682 | 1251.452 | 48°21'36.496147"N | 120°43'48.023890"W | N/A | 0.9998914016 | 5/8" rebar no cap | |||||||
| 20105 | 496230.046 | 1665396.707 | 1255.399 | 48°21'37.185209"N | 120°43'50.095254"W | N/A | 0.9998912272 | 5/8" rebar no cap | |||||||
| 20106 | 496222.046 | 1665278.551 | 1251.691 | 48°21'37.107816"N | 120°43'51.845065"W | N/A | 0.9998914027 | 5/8" rebar no cap | |||||||
| 20107 | 496319.153 | 1665207.567 | 1264.490 | 48°21'38.067031"N | 120°43'52.894290"W | N/A | 0.999890811 | 5/8" rebar no cap | |||||||
| 20108 | 496418.190 | 1665051.467 | 1275.747 | 48°21'39.046399"N | 120°43'55.203898"W | N/A | 0.9998902935 | 5/8" rebar no cap | |||||||
| 20109 | 496492.437 | 1664878.797 | 1278.902 | 48°21'39.781330"N | 120°43'57.759383"W | N/A | 0.9998901579 | 5/8" rebar no cap | |||||||
| 20110 | 496418.433 | 1664727.711 | 1276.261 | 48°21'39.052976"N | 120°43'59.998119"W | N/A | 0.9998902691 | 5/8" rebar no cap | |||||||
| 20111 | 496413.399 | 1664610.149 | 1272.735 | 48°21'39.004802"N | 120°44'01.739091"W | N/A | 0.9998904365 | 5/8" rebar no cap | |||||||
| 23123 | 496419.797 | 1664443.488 | 1263.477 | 48°21'39.070060"N | 120°44'04.206909"W | N/A | 0.99989088 | 1/2" IR W/YPC | |||||||
| 23124 | 496905.752 | 1663765.301 | 1277.428 | 48°21'43.874109"N | 120°44'14.240621"W | N/A | 0.9998903127 | 1/2" IR W/YPC | |||||||
| 29101 | 497180.599 | 1663753.901 | 1298.670 | 48°21'46.586536"N | 120°44'14.404361"W | N/A | 0.9998893542 | 5/8" IR W/ ALUMINUM CAP | |||||||
| 29102 | 497368.967 | 1663671.025 | 1308.552 | 48°21'48.446436"N | 120°44'15.628184"W | N/A | 0.9998889208 | 5/8" IR W/ ALUMINUM 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 |
PROJECT : Stehekin Valley Road Emergency Reroute
DATE OF FIELD WORK : 10/2020
DATE OF FINAL ADJUSTMENT : ???
PROJECT UNITS : US Survey foot COORDINATE SYSTEM : Washington North SPCS NAD83
EPOCH DATE : 91
VERTICAL DATUM : NAVD88
GPK FILE DATED JAN 24, 2007
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| 20101 | 495651.478 | 1665957.509 | 1249.043 | 48°21'31.468221"N | 120°43'41.802597"W | N/A | 0.99989141 | 5/8" IR W/FHWA ALUM CAP | |
| 20102 | 495914.203 | 1665717.711 | 1253.972 | 48°21'34.064101"N | 120°43'45.348154"W | N/A | 0.99989123 | 5/8" IR W/FHWA ALUM CAP | |
| 20103 | 496070.946 | 1665549.120 | 1246.225 | 48°21'35.613139"N | 120°43'47.841488"W | N/A | 0.99989163 | 5/8" IR W/FHWA ALUM CAP | |
| 20104 | 496160.408 | 1665536.682 | 1251.452 | 48°21'36.496147"N | 120°43'48.023890"W | N/A | 0.99989140 | 5/8" rebar no cap | |
| 20105 | 496230.046 | 1665396.707 | 1255.399 | 48°21'37.185209"N | 120°43'50.095254"W | N/A | 0.99989123 | 5/8" rebar no cap | |
| 20106 | 496222.046 | 1665278.551 | 1251.691 | 48°21'37.107816"N | 120°43'51.845065"W | N/A | 0.99989140 | 5/8" rebar no cap | |
| 20107 | 496319.153 | 1665207.567 | 1264.490 | 48°21'38.067031"N | 120°43'52.894290"W | N/A | 0.99989081 | 5/8" rebar no cap | |
| 20108 | 496418.190 | 1665051.467 | 1275.747 | 48°21'39.046399"N | 120°43'55.203898"W | N/A | 0.99989029 | 5/8" rebar no cap | |
| 20109 | 496492.437 | 1664878.797 | 1278.902 | 48°21'39.781330"N | 120°43'57.759383"W | N/A | 0.99989016 | 5/8" rebar no cap | |
| 20110 | 496418.433 | 1664727.711 | 1276.261 | 48°21'39.052976"N | 120°43'59.998119"W | N/A | 0.99989027 | 5/8" rebar no cap | |
| 20111 | 496413.399 | 1664610.149 | 1272.735 | 48°21'39.004802"N | 120°44'01.739091"W | N/A | 0.99989044 | 5/8" rebar no cap | |
| 23123 | 496419.797 | 1664443.488 | 1263.477 | 48°21'39.070060"N | 120°44'04.206909"W | N/A | 0.99989088 | 1/2" IR W/YPC | |
| 23124 | 496905.752 | 1663765.301 | 1277.428 | 48°21'43.874109"N | 120°44'14.240621"W | N/A | 0.99989031 | 1/2" IR W/YPC | |
| 29101 | 497180.599 | 1663753.901 | 1298.670 | 48°21'46.586536"N | 120°44'14.404361"W | N/A | 0.99988935 | 5/8" IR W/ ALUMINUM CAP | |
| 29102 | 497368.967 | 1663671.025 | 1308.552 | 48°21'48.446436"N | 120°44'15.628184"W | N/A | 0.99988892 | 5/8" IR W/ ALUMINUM CAP |
File details come from the government source that posted it. Updated .