wa-ep-olym2022-1--1_control-points.xlsx

XLSX spreadsheet 41 KB Posted Mar 28, 2025

Attached to: WA ERFO NPS OLYM 2022‐1 (1), OLYMPIC NPS ERFO REPAIRS 2022
Solicitation number: 69056725B000006
Issued by: Department of Transportation Federal Highway Administration

About this file

Written by GovTribe AI · Mar 28, 2025

This Excel file contains survey control point data for the WA ERFO NPS OLYM 2022-1(1) project, a National Park Service (NPS) Emergency Relief for Federally Owned (ERFO) Repairs project at Big Creek Culvert. The document specifies precise geospatial survey information including six control points with detailed coordinate data, using the Washington North State Plane Coordinate System (NAD83 2011) and vertical datum NAVD88 GEOID18. The survey was conducted in April 2023, with final adjustments made on 4/18/2023, and uses international foot units for project measurements. Each control point is marked with specific identifiers (23201-23206) and includes state plane coordinates, geographic coordinates, elevations, combined factors, and physical marker descriptions such as "5/8" iron rod with FHWA aluminum cap" or "hub & tack".

View the file

Other files

File	Type	Posted
Tabulation of Bids_WA ERFO NPS OLYM 2022-1(1).pdf	PDF	Apr 30, 2025
BidSum_WA ERFO NPS OLYM 2022-1 (1).pdf	PDF	Apr 29, 2025
Amendment A001.pdf	PDF	Apr 24, 2025
wa-ep-olym2022-1--1_proposed-alignment.pdf	PDF	Mar 28, 2025
wa-ep-olym2022-1--1_plans.pdf	PDF	Mar 28, 2025
wa-ep-olym2022-1--1_Earthwork.pdf	PDF	Mar 28, 2025
FLH Bridge oversized or overload vehicle permit request form August 2023.pdf	PDF	Mar 28, 2025
IFB 69056725B000006.pdf	PDF	Mar 28, 2025
Physical Data_WA ERFO NPS OLYM.zip	ZIP file	Mar 28, 2025
wa-ep-olym2022-1--1_xs.pdf	PDF	Mar 28, 2025

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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:		Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
	Project:	WA ERFO NPS OLYM 2022-1(1)
NPS PMIS /

Drawing No:

Designed by:	WFLHD_Survey
Date:	1/1904
Checked by:	WFLHD_Survey
Date:	1/1904
First sheet #:	D.1	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	6	rows w/data	OK - no spaces in data
Max. row/table	40	6	data rows	Warnings:
		40	rows/table
			PROJECT :NPS ERFO Repairs 2022 Big Creek Culvert

DATE OF FIELD WORK :April 2023

DATE OF FINAL ADJUSTMENT :4/18/2023

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

EPOCH DATE : 2010.0000

CADD 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.
	Worksheet Name	Sheet	Header row	Sheet Number	Notes
	Sheet	D.1	3	1	OK
	Sheet (2)	Undefined	FALSE	1
	Sheet (3)	Undefined	FALSE	1
	Sheet (4)	Undefined	FALSE	1
	Sheet (5)	Undefined	FALSE	1
	Sheet (6)	Undefined	FALSE	1
	Sheet (7)	Undefined	FALSE	1
	Sheet (8)	Undefined	FALSE	1
	Sheet (9)	Undefined	FALSE	1
	Sheet (10)	Undefined	FALSE	1
	Sheet (11)	Undefined	FALSE	1
	Sheet (12)	Undefined	FALSE	1
	Sheet (13)	Undefined	FALSE	1
	Sheet (14)	Undefined	FALSE	1
	Sheet (15)	Undefined	FALSE	1
	Sheet (16)	Undefined	FALSE	1
	Sheet (17)	Undefined	FALSE	1
	Sheet (18)	Undefined	FALSE	1
	Sheet (19)	Undefined	FALSE	1
	Sheet (20)	Undefined	FALSE	1
	Total Sheets:	1	0	sheets missing

Revised: 15 June 2015

Sheet

Sheet Information

Sheet num:

D.1

Filename

Sheet name:

Sheet

c:\pw-work\d0602870\[Big_Creek_controlsheet.xlsx]Sheet

Reference:

Time

21-Jan-2025 2:44 PM

Begin Column:

PROJECT :NPS ERFO Repairs 2022 Big Creek Culvert DATE OF FIELD WORK :April 2023 DATE OF FINAL ADJUSTMENT :4/18/2023 COORDINATE SYSTEM : Washington North SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18

EPOCH DATE : 2010.0000

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

						STATE PLANE COORDINATES			GEO COORDINATES
	3.0				POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION		NOTE:
					23201	209267.514	918303.871	279.622	47°32'09.896004"N	123°45'26.485172"W	208.6436	0.9999834969	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.
					23202	209359.933	918542.561	278.640	47°32'10.896932"N	123°45'23.060215"W	207.6916	0.9999834936	5/8" ir w/fhwa alum cap
					23203	209409.701	918737.123	279.713	47°32'11.460665"N	123°45'20.254279"W	208.775	0.9999834143	hub&tack
					23204	209437.137	918877.078	278.965	47°32'11.783678"N	123°45'18.231237"W	208.0341	0.9999834339	hub&tack
					23205	209460.958	919079.808	279.155	47°32'12.094541"N	123°45'15.291968"W	208.2337	0.9999834092	5/8" ir w/fhwa alum cap
					23206	209535.536	919396.157	281.466	47°32'12.948496"N	123°45'10.726061"W	210.5609	0.9999832564	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
					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 :NPS ERFO Repairs 2022 Big Creek Culvert DATE OF FIELD WORK :April 2023

DATE OF FINAL ADJUSTMENT :4/18/2023

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

EPOCH DATE : 2010.0000

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

PROJECT UNITS : International Foot

		PROJECT COORDINATES			GEO COORDINATES
	POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION
	23201	209267.514	918303.871	279.622	47°32'09.896004"N	123°45'26.485172"W	208.644	0.99998350	5/8" ir w/fhwa alum cap
	23202	209359.933	918542.561	278.640	47°32'10.896932"N	123°45'23.060215"W	207.692	0.99998349	5/8" ir w/fhwa alum cap
	23203	209409.701	918737.123	279.713	47°32'11.460665"N	123°45'20.254279"W	208.775	0.99998341	hub&tack
	23204	209437.137	918877.078	278.965	47°32'11.783678"N	123°45'18.231237"W	208.034	0.99998343	hub&tack
	23205	209460.958	919079.808	279.155	47°32'12.094541"N	123°45'15.291968"W	208.234	0.99998341	5/8" ir w/fhwa alum cap
	23206	209535.536	919396.157	281.466	47°32'12.948496"N	123°45'10.726061"W	210.561	0.99998326	5/8" ir w/fhwa alum cap

File details come from the government source that posted it. Updated Mar 28, 2025.