mora12302_control-points.xlsx

XLSX spreadsheet 44 KB Posted Jun 28, 2024

Attached to: WA NP MORA 123(2) SR-123: Laughingwater Creek Bridge to Panther Creek Bridge
Solicitation number: 69056723B000008
Issued by: Department of Transportation Federal Highway Administration

About this file

Written by GovTribe AI · Jun 28, 2024

This document contains a spreadsheet with survey control point information related to a federal contract opportunity. The spreadsheet provides the state plane coordinates, geographic coordinates, and descriptions for over 100 survey control points along the SR-123 corridor from Laughingwater Creek Bridge to Panther Creek Bridge in Washington State. The related federal contract opportunity is for the NP MORA 123(2) project to construct improvements along this section of SR-123. The solicitation number is 69056723B000008, and the contracting agency is the Department of Transportation Federal Highway Administration. The key details and requirements for this contract opportunity are provided in the attachments referenced in the opportunity description.

View the file

Other files

File	Type	Posted
BidTab_WA NP MORA 123(2).pdf	PDF	Aug 1, 2024
BidSum_WA NP MORA 123(2).pdf	PDF	Jul 31, 2024
QA_07-31-2024.pdf	PDF	Jul 31, 2024
Amendment A005.pdf	PDF	Jul 25, 2024
QA_07-24-2024.pdf	PDF	Jul 24, 2024
QA_07-23-2024.pdf	PDF	Jul 23, 2024
Amendment A004.pdf	PDF	Jul 23, 2024
QA1_07-19-2024.pdf	PDF	Jul 19, 2024
Amendment A003.pdf	PDF	Jul 19, 2024
QA_07-18-2024.pdf	PDF	Jul 18, 2024
Amendment A002.pdf	PDF	Jul 18, 2024
Amendment A001.pdf	PDF	Jul 11, 2024
QA_07-09-2024.pdf	PDF	Jul 9, 2024
QA_07-05-2024.pdf	PDF	Jul 8, 2024
QA_08-24-2023.pdf	PDF	Jul 5, 2024
mora 12302_XYZ asphalt_APPR01.xlsx	XLSX spreadsheet	Jun 28, 2024
mora 12302_XYZ subex_MAIN01.xlsx	XLSX spreadsheet	Jun 28, 2024
mora 12302_XYZ base_APPR01.xlsx	XLSX spreadsheet	Jun 28, 2024
mora12302_plans.pdf	PDF	Jun 28, 2024
WA NP MORA 123(2) - EPA_CompiledSWPPP_Final Signed.pdf	PDF	Jun 28, 2024
mora12302_BIR_9450-020P.pdf	PDF	Jun 28, 2024
mora12302_Earthwork_APPR 01.pdf	PDF	Jun 28, 2024
mora 12302_XYZ asphalt_MAIN01.xlsx	XLSX spreadsheet	Jun 28, 2024
Physical Data_WA NP MORA 123(2).zip	ZIP file	Jun 28, 2024
mora12302_Project Name Change Memo.pdf	PDF	Jun 28, 2024
mora12302_construction staking notes_APPR01.xlsx	XLSX spreadsheet	Jun 28, 2024
mora12302_construction staking notes_MAIN01.xlsx	XLSX spreadsheet	Jun 28, 2024
mora12302_Earthwork_MAIN 01.pdf	PDF	Jun 28, 2024
mora12302_XS.pdf	PDF	Jun 28, 2024
IFB 69056723B000008.pdf	PDF	Jun 28, 2024
mora12302_GR09-22.pdf	PDF	Jun 28, 2024
mora12302_proposed-alignment_MAIN01.pdf	PDF	Jun 28, 2024
FLH Bridge oversized or overload vehicle permit request form Oct 2018.pdf	PDF	Jun 28, 2024
mora12302_clearing limits (culverts).pdf	PDF	Jun 28, 2024
mora12302_1992_LaughingwaterCreekBridgePlans.pdf	PDF	Jun 28, 2024
mora12302_proposed-alignment_APPR01.pdf	PDF	Jun 28, 2024
mora 12302_XYZ base_MAIN01.xlsx	XLSX spreadsheet	Jun 28, 2024

Show all 37

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:	WA	Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
		Project:	NP MORA 123(2)
	NPS PMIS /
Drawing No:		NPS PMIS No.184913

NPS Drwg. No.105/182837

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	27	rows w/data	OK - no spaces in data
Max. row/table	40	27	data rows	Warnings:
		40	rows/table
			PROJECT : SR123 Laughingwater creek bridge to Panther Creek Bridge

DATE OF FIELD WORK : multiple entries DATE OF FINAL ADJUSTMENT : June 2020

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Washington South SPCS NAD83 2011

EPOCH DATE : 2010.000

VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18

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:\MyFiles\Projects_2023\Misc\[SR123_mp3-5_controlsheet.xlsx]Sheet

Reference:

Time

5-Jul-2023 2:02 PM

Begin Column:

PROJECT : SR123 Laughingwater creek bridge to Panther Creek Bridge DATE OF FIELD WORK : multiple entries DATE OF FINAL ADJUSTMENT : June 2020 PROJECT UNITS : US SURVEY FOOT COORDINATE SYSTEM : Washington South SPCS NAD83 2011

						STATE PLANE COORDINATES			GEO COORDINATES
	3.0				POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION		NOTE:
					20101	531861.991	1376239.042	2314.582	46°47'13.123713"N	121°33'16.719882"W	2251.8638	0.9998132227	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	531547.552	1376299.747	2312.286	46°47'10.028053"N	121°33'15.787138"W	2249.564	0.9998132799	Mag nail & Washer
					20103	531050.421	1376406.804	2301.246	46°47'05.135242"N	121°33'14.153280"W	2238.5183	0.9998137246	5/8" IR w/FHWA alum cap
					20104	530331.009	1376541.306	2271.189	46°46'58.052013"N	121°33'12.082486"W	2208.4533	0.9998150417	5/8" IR w/FHWA alum cap
					20105	529848.853	1376513.308	2279.521	46°46'53.289193"N	121°33'12.392256"W	2216.7807	0.9998145646	5/8" IR w/FHWA alum cap
					20106	529370.740	1376642.406	2296.213	46°46'48.586985"N	121°33'10.445580"W	2233.4682	0.9998136898	5/8" IR w/FHWA alum cap
					20107	528922.923	1376919.092	2289.626	46°46'44.203235"N	121°33'06.384260"W	2226.8799	0.9998139325	5/8" IR w/FHWA alum cap
					20108	528190.231	1377109.754	2246.134	46°46'36.996264"N	121°33'03.504549"W	2183.3818	0.9998158927	5/8" IR w/FHWA alum cap
					20109	527358.741	1377283.491	2211.725	46°46'28.811856"N	121°33'00.849312"W	2148.9652	0.9998174047	5/8" IR w/FHWA alum cap
					20110	526458.152	1377584.030	2220.191	46°46'19.962031"N	121°32'56.359421"W	2157.4262	0.9998168597	5/8" IR w/FHWA alum cap
					20111	526009.165	1377739.499	2212.250	46°46'15.550687"N	121°32'54.040183"W	2149.4833	0.9998171696	5/8" IR w/FHWA alum cap
					20112	525511.842	1377747.119	2199.697	46°46'10.642834"N	121°32'53.835757"W	2136.9232	0.9998176927	5/8" IR w/FHWA alum cap
					20113	524820.761	1377661.671	2195.329	46°46'03.810270"N	121°32'54.931276"W	2132.5373	0.9998177962	5/8" IR w/FHWA alum cap
					20114	524214.506	1377636.099	2192.363	46°45'57.822838"N	121°32'55.182828"W	2129.5615	0.9998178463	5/8" IR w/FHWA alum cap
					20115	523229.330	1377544.977	2198.706	46°45'48.086636"N	121°32'56.303547"W	2135.8877	0.9998173964	5/8" IR w/FHWA alum cap
					20116	522832.900	1377363.956	2204.824	46°45'44.149876"N	121°32'58.827929"W	2141.9948	0.9998170456	5/8" IR w/FHWA alum cap
					20117	522327.906	1376823.846	2217.501	46°45'39.094276"N	121°33'06.489116"W	2154.6501	0.9998163657	5/8" IR w/FHWA alum cap
					20118	521912.023	1376629.631	2217.792	46°45'34.963701"N	121°33'09.198952"W	2154.9305	0.9998162912	5/8" IR w/FHWA alum cap
					20119	521177.302	1376241.327	2214.867	46°45'27.660401"N	121°33'14.635096"W	2151.9863	0.9998163247	5/8" IR w/FHWA alum cap
					20120	520771.963	1375983.743	2198.326	46°45'23.625479"N	121°33'18.256736"W	2135.4341	0.9998170567	5/8" IR w/FHWA alum cap
					20121	520077.736	1375489.579	2185.434	46°45'16.707753"N	121°33'25.220330"W	2122.521	0.9998175738	5/8" IR w/FHWA alum cap
					20122	519740.198	1375461.814	2184.918	46°45'13.372386"N	121°33'25.554108"W	2121.9994	0.9998175511	Mag nail & Washer
					20123	519263.902	1375512.067	2172.697	46°45'08.677718"N	121°33'24.740751"W	2109.7723	0.9998180685	5/8" IR w/FHWA alum cap
					20124	518651.565	1375226.866	2152.609	46°45'02.595856"N	121°33'28.718554"W	2089.6701	0.9998189431	5/8" IR w/FHWA alum cap
					20125	518443.404	1375250.766	2146.061	46°45'00.544350"N	121°33'28.335244"W	2083.1195	0.9998192274	5/8" IR w/FHWA alum cap
					20126	517972.477	1375484.473	2131.974	46°44'55.926952"N	121°33'24.888503"W	2069.0311	0.9998198362	5/8" IR w/FHWA alum cap
					20127	517584.719	1375539.143	2121.753	46°44'52.106784"N	121°33'24.028842"W	2058.8064	0.9998202718	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

PROJECT : SR123 Laughingwater creek bridge to Panther Creek Bridge DATE OF FIELD WORK : multiple entries DATE OF FINAL ADJUSTMENT : June 2020

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Washington South SPCS NAD83 2011

		STATE PLANE COORDINATES			GEO COORDINATES
	POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION
	20101	531861.991	1376239.042	2314.582	46°47'13.123713"N	121°33'16.719882"W	2251.864	0.99981322	5/8" IR w/FHWA alum cap
	20102	531547.552	1376299.747	2312.286	46°47'10.028053"N	121°33'15.787138"W	2249.564	0.99981328	Mag nail & Washer
	20103	531050.421	1376406.804	2301.246	46°47'05.135242"N	121°33'14.153280"W	2238.518	0.99981372	5/8" IR w/FHWA alum cap
	20104	530331.009	1376541.306	2271.189	46°46'58.052013"N	121°33'12.082486"W	2208.453	0.99981504	5/8" IR w/FHWA alum cap
	20105	529848.853	1376513.308	2279.521	46°46'53.289193"N	121°33'12.392256"W	2216.781	0.99981456	5/8" IR w/FHWA alum cap
	20106	529370.740	1376642.406	2296.213	46°46'48.586985"N	121°33'10.445580"W	2233.468	0.99981369	5/8" IR w/FHWA alum cap
	20107	528922.923	1376919.092	2289.626	46°46'44.203235"N	121°33'06.384260"W	2226.880	0.99981393	5/8" IR w/FHWA alum cap
	20108	528190.231	1377109.754	2246.134	46°46'36.996264"N	121°33'03.504549"W	2183.382	0.99981589	5/8" IR w/FHWA alum cap
	20109	527358.741	1377283.491	2211.725	46°46'28.811856"N	121°33'00.849312"W	2148.965	0.99981740	5/8" IR w/FHWA alum cap
	20110	526458.152	1377584.030	2220.191	46°46'19.962031"N	121°32'56.359421"W	2157.426	0.99981686	5/8" IR w/FHWA alum cap
	20111	526009.165	1377739.499	2212.250	46°46'15.550687"N	121°32'54.040183"W	2149.483	0.99981717	5/8" IR w/FHWA alum cap
	20112	525511.842	1377747.119	2199.697	46°46'10.642834"N	121°32'53.835757"W	2136.923	0.99981769	5/8" IR w/FHWA alum cap
	20113	524820.761	1377661.671	2195.329	46°46'03.810270"N	121°32'54.931276"W	2132.537	0.99981780	5/8" IR w/FHWA alum cap
	20114	524214.506	1377636.099	2192.363	46°45'57.822838"N	121°32'55.182828"W	2129.562	0.99981785	5/8" IR w/FHWA alum cap
	20115	523229.330	1377544.977	2198.706	46°45'48.086636"N	121°32'56.303547"W	2135.888	0.99981740	5/8" IR w/FHWA alum cap
	20116	522832.900	1377363.956	2204.824	46°45'44.149876"N	121°32'58.827929"W	2141.995	0.99981705	5/8" IR w/FHWA alum cap
	20117	522327.906	1376823.846	2217.501	46°45'39.094276"N	121°33'06.489116"W	2154.650	0.99981637	5/8" IR w/FHWA alum cap
	20118	521912.023	1376629.631	2217.792	46°45'34.963701"N	121°33'09.198952"W	2154.931	0.99981629	5/8" IR w/FHWA alum cap
	20119	521177.302	1376241.327	2214.867	46°45'27.660401"N	121°33'14.635096"W	2151.986	0.99981632	5/8" IR w/FHWA alum cap
	20120	520771.963	1375983.743	2198.326	46°45'23.625479"N	121°33'18.256736"W	2135.434	0.99981706	5/8" IR w/FHWA alum cap
	20121	520077.736	1375489.579	2185.434	46°45'16.707753"N	121°33'25.220330"W	2122.521	0.99981757	5/8" IR w/FHWA alum cap
	20122	519740.198	1375461.814	2184.918	46°45'13.372386"N	121°33'25.554108"W	2121.9994	0.99981755	Mag nail & Washer
	20123	519263.902	1375512.067	2172.697	46°45'08.677718"N	121°33'24.740751"W	2109.7723	0.99981807	5/8" IR w/FHWA alum cap
	20124	518651.565	1375226.866	2152.609	46°45'02.595856"N	121°33'28.718554"W	2089.6701	0.99981894	5/8" IR w/FHWA alum cap
	20125	518443.404	1375250.766	2146.061	46°45'00.544350"N	121°33'28.335244"W	2083.1195	0.99981923	5/8" IR w/FHWA alum cap
	20126	517972.477	1375484.473	2131.974	46°44'55.926952"N	121°33'24.888503"W	2069.0311	0.99981984	5/8" IR w/FHWA alum cap
	20127	517584.719	1375539.143	2121.753	46°44'52.106784"N	121°33'24.028842"W	2058.8064	0.99982027	5/8" IR w/FHWA alum cap

File details come from the government source that posted it. Updated Jun 28, 2024.