wa-ef-mtbkr2022-1-3_control-points.xlsx

XLSX spreadsheet 38 KB Posted

Attached to
WA ERFO FS MTBKR605 2022-1(3) Mt. Baker - Forest Road 11 MP 23. 9 Repair
Solicitation number
69056726B000002
Issued by

About this file

This is a Survey Control Points spreadsheet for the Mt. Baker-Snoqualmie Forest Road 11 MP 23.9 Repair project. The document establishes survey control data and coordinate systems for the construction project identified as WA ERFO FS MTBKR605 2022-1(3), with field work conducted in July 2023 and final adjustments completed in August 2023. The project uses Washington North State Plane Coordinate System (SPCS) NAD83 2011 with orthometric elevations based on NAVD88 GEOID18, epoch date 2010.000, and all measurements in international feet.

The control sheet documents four survey control points (23101, 23102, 23103, and 23104) with their respective state plane coordinates, orthometric elevations, geographic coordinates (latitude/longitude), ellipsoid heights, and combined scale factors. Each point is marked with a 5/8-inch iron pin with FHWA aluminum cap. The coordinates range from approximately 637,587 to 637,195 feet North and 1,456,173 to 1,456,719 feet East, with elevations between 835.090 and 876.919 feet. The document was last revised on September 20, 2023, and references the source file location as c:\pw-work\d0611508[wa-ef-mtbkr2022-1-3_control-sheet.xlsx], indicating this is a technical data file supporting the forest road repair solicitation.

View the file

Other files

Show all 22

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

Survey Control Sheet
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.
Project:WA ERFO FS MTBKR605 2022-1(3)Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
NPS PMIS No.NPS PMIS No.Note: NPS fields do not appear on the sheet unless additional text is added.
NPS Drwg No.NPS Drwg No.
First sheet #:D.11.0
Title block text:SURVEY CONTROL
Show Totals?TRUE
Data location:Page 1Worksheet found
Data begins in col:A
Min. rows/table43.0
Base sheet name:Sheet4rows w/dataOK - no spaces in data
Max. row/table354data rowsWarnings:
35rows/table
PROJECT : Mt. Baker-Snoqualmie Erfo Repairs 2022-1(3) FR11-MP 23.9

DATE OF FIELD WORK : July, 2023 DATE OF FINAL ADJUSTMENT : August 2023

COORDINATE SYSTEM : Washington North SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : WA83/2011-NIF NSRS11(NAD83/2011) Washington, North Zone, International foot

PROJECT UNITS : International foot

Sheet Names
Input the names of the worksheets in the order you would like the sheets numbered.
WorksheetSheetHeaderNumberNotes
SheetD.131OK
Sheet (2)UndefinedFALSE1
Sheet (3)UndefinedFALSE1
Sheet (4)UndefinedFALSE1
Sheet (5)UndefinedFALSE1
Sheet (6)UndefinedFALSE1
Sheet (7)UndefinedFALSE1
Sheet (8)UndefinedFALSE1
Sheet (9)UndefinedFALSE1
Sheet (10)UndefinedFALSE1
Sheet (11)UndefinedFALSE1
Sheet (12)UndefinedFALSE1
Sheet (13)UndefinedFALSE1
Sheet (14)UndefinedFALSE1
Sheet (15)UndefinedFALSE1
Sheet (16)UndefinedFALSE1
Sheet (17)UndefinedFALSE1
Sheet (18)UndefinedFALSE1
Sheet (19)UndefinedFALSE1
Sheet (20)UndefinedFALSE1
Total Sheets:10sheets missing

Revised: 20 September 2023

Sheet

Sheet Information
Sheet num:D.1Filename0
Sheet name:Sheetc:\pw-work\d0611508\[wa-ef-mtbkr2022-1-3_control-sheet.xlsx]Sheet
Reference:Time
19-Feb-2025 10:40 AM
Begin Column:ABCDEFGHI
c:\pw-work\d0611508\[wa-ef-mtbkr2022-1-3_control-sheet.xlsx]Sheet
PROJECT : Mt. Baker-Snoqualmie Erfo Repairs 2022-1(3) FR11-MP 23.9

DATE OF FIELD WORK : July, 2023 DATE OF FINAL ADJUSTMENT : August 2023

PROJECT UNITS : International foot COORDINATE SYSTEM : Washington North SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : WA83/2011-NIF NSRS11(NAD83/2011) Washington, North Zone, International foot

STATE PLANE COORDINATESGEO COORDINATES
3.0POINT
NUMBERNORTHEASTORTHOMETRIC ELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTIONNOTE:
23101637587.9431456173.622876.91948°44'43.210939"N121°35'48.998611"W817.12360.99996324885/8" IR w/fhwa alum cap1.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.
23102637580.3131456449.069859.99148°44'43.162606"N121°35'44.888012"W800.20580.99996405435/8" IR w/fhwa alum cap
23103637378.2761456582.020847.31648°44'41.182159"N121°35'42.874642"W787.52980.99996455445/8" IR w/fhwa alum cap
23104637195.0311456719.054835.09048°44'39.387520"N121°35'40.803180"W775.30340.99996504295/8" IR w/fhwa alum cap
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.000000
00.0000.0000.000000

19-Feb-2025 10:40 AM

PROJECT : Mt. Baker-Snoqualmie Erfo Repairs 2022-1(3) FR11-MP 23.9 DATE OF FIELD WORK : July, 2023 DATE OF FINAL ADJUSTMENT : August 2023

COORDINATE SYSTEM : Washington North SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : WA83/2011-NIF NSRS11(NAD83/2011) Washington, North Zone, International foot

PROJECT UNITS : International foot

STATE PLANE COORDINATESGEO COORDINATES
POINT
NUMBERNORTHEASTELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTION
23101637587.9431456173.622876.91948°44'43.210939"N121°35'48.998611"W817.1240.999963255/8" IR w/fhwa alum cap
23102637580.3131456449.069859.99148°44'43.162606"N121°35'44.888012"W800.2060.999964055/8" IR w/fhwa alum cap
23103637378.2761456582.020847.31648°44'41.182159"N121°35'42.874642"W787.5300.999964555/8" IR w/fhwa alum cap
23104637195.0311456719.054835.09048°44'39.387520"N121°35'40.803180"W775.3030.999965045/8" IR w/fhwa alum cap

File details come from the government source that posted it. Updated .