ak-r-kna119201_control-points.xlsx

XLSX spreadsheet 42 KB Posted Nov 9, 2023

Attached to: AK FWS KNA 1192(1), Skilak Lake Road AOP Improvements
Solicitation number: 69056724B000002
Issued by: Department of Transportation Federal Highway Administration

About this file

Written by GovTribe AI · Dec 21, 2023

This document contains a federal contract opportunity and associated survey control point file. The federal contract opportunity is solicitation number 69056724B000002 from the Department of Transportation Federal Highway Administration for the AK FWS KNA 1192(1) Skilak Lake Road AOP Improvements project. The survey control point file provides state plane coordinates, geographic coordinates, elevations, and descriptions for survey control points across three sites for the project, formatted to populate an Excel control sheet template.

View the file

Other files

File	Type	Posted
BidTab AK FWS KNA 1192(1).pdf	PDF	Dec 14, 2023
BidSum AK FWS 1192(1).pdf	PDF	Dec 13, 2023
QA_12-12-2023.pdf	PDF	Dec 12, 2023
QA_11-29-2023.pdf	PDF	Nov 30, 2023
Amendment A003.pdf	PDF	Nov 21, 2023
QA_11-20-2023.pdf	PDF	Nov 21, 2023
QA_11-16-2023.pdf	PDF	Nov 16, 2023
QA_11-15-2023.pdf	PDF	Nov 16, 2023
A002_ak-r-kna119201_plans.pdf	PDF	Nov 15, 2023
Amendment A002.pdf	PDF	Nov 15, 2023
Amendment A001.pdf	PDF	Nov 13, 2023
QA 11.13.23.pdf	PDF	Nov 13, 2023
ak-r-kna119201_XS.pdf	PDF	Nov 9, 2023
AK FWS KNA 1192(1) Skilak Lake - Final AOP Foundation and Geotechnical Recommendations Memo.pdf	PDF	Nov 9, 2023
AK Jean AOP Report Final.pdf	PDF	Nov 9, 2023
AK Unnamed Creek AOP Report Final.pdf	PDF	Nov 9, 2023
AK_CompiledSWPPP_AK FWS KNA 1192(1).pdf	PDF	Nov 9, 2023
ak-r-kna119201_earthwork.pdf	PDF	Nov 9, 2023
AK Ohmer AOP Report Final.pdf	PDF	Nov 9, 2023
ak-r-kna119201_proposed-alignments.pdf	PDF	Nov 9, 2023
ak-r-kna119201_superelevations.pdf	PDF	Nov 9, 2023
IFB 69056724B000002 AK FWS KNA 1192(1).pdf	PDF	Nov 9, 2023
Physical Data.zip	ZIP file	Nov 9, 2023
ak-r-kna119201_plans.pdf	PDF	Nov 9, 2023
ak-r-kna119201_CulvertXS.pdf	PDF	Nov 9, 2023

Show all 25

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

Drawing No:

Designed by:	WFLHD Survey
Date:	1/1904
Checked by:	WFLHD Survey
Date:	1/1904
First sheet #:	D.9	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	13	rows w/data	OK - no spaces in data
Max. row/table	40	16	data rows	Warnings: Empty lines found within data set
		40	rows/table
			PROJECT :Skilak Lake Road AOP Improvements

DATE OF FIELD WORK : 10/2019, 9/2020

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM :Alaska Zone 4 SPCS NAD83 2011 DESIGN SOFTWARE COORDINATE SYSTEM:AK83/2011-4F NSRS11(NAD83/2011) datum, Alaska State Plane; Zone 4, US Foot VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID12b

EPOCH DATE : 2010.00

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

Revised: 15 June 2015

Sheet

Sheet Information

Sheet num:

D.9

Filename

Sheet name:

Sheet

C:\MyFiles\Projects_2023\Alaska\misc\pw\[Skilak_controlsheet.xlsx]Sheet

Reference:

Time

31-Aug-2023 8:41 AM

Begin Column:

PROJECT :Skilak Lake Road AOP Improvements

DATE OF FIELD WORK : 10/2019, 9/2020

PROJECT UNITS : US SURVEY FOOT

EPOCH DATE : 2010.00

						STATE PLANE COORDINATES			GEO COORDINATES
	3.0				POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION		NOTE:
						Site 1 (Jean Creek)								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.
					19101	2368909.058	1620197.011	291.747	60°29'03.355317"N	150°06'43.562919"W	324.7754	0.9998849733	5/8" IR W/FHWA ALUM CAP
					19102	2368739.068	1619665.714	284.506	60°29'01.672044"N	150°06'54.161091"W	317.5029	0.999885345	5/8" IR W/FHWA ALUM CAP
					19103	2368597.421	1619313.582	284.702	60°29'00.270840"N	150°07'01.184131"W	317.6789	0.9998853534	5/8" IR W/FHWA ALUM CAP
					19104	2368472.637	1618796.627	286.787	60°28'59.032673"N	150°07'11.497174"W	319.7327	0.9998852805	5/8" IR W/FHWA ALUM CAP
					19105	2368242.301	1618157.933	327.423	60°28'56.752454"N	150°07'24.235710"W	360.3326	0.9998833758	5/8" IR W/FHWA ALUM CAP
						Site 2
					19201	2358747.112	1584701.997	426.631	60°27'22.152825"N	150°18'31.047026"W	457.5214	0.9998817086	5/8" IR W/FHWA ALUM CAP
					19202	2358500.723	1584348.388	409.781	60°27'19.709767"N	150°18'38.075311"W	440.6589	0.999882558	5/8" IR W/FHWA ALUM CAP
					19203	2358384.643	1584240.447	412.545	60°27'18.561477"N	150°18'40.216823"W	443.4215	0.99988244	5/8" IR W/FHWA ALUM CAP
						Site 3
					19303	2353339.390	1582903.931	286.945	60°26'28.807816"N	150°19'06.381558"W	318.0264	0.9998885942	5/8" IR W/FHWA ALUM CAP
					19305	2354073.042	1583370.479	350.505	60°26'36.055692"N	150°18'57.152312"W	381.5783	0.999885502	5/8" IR W/FHWA ALUM CAP
					22301	2353772.711	1583164.896	327.284	60°26'33.087999"N	150°19'01.221494"W	358.3594	0.9998866362	5/8" IR W/FHWA ALUM CAP
					22302	2353552.138	1583000.700	300.738	60°26'30.907778"N	150°19'04.473196"W	331.814	0.9998879239	5/8" IR W/FHWA ALUM CAP
					22304	2353149.846	1582832.174	275.888	60°26'26.937575"N	150°19'07.793552"W	306.9752	0.9998891308	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

PROJECT :Skilak Lake Road AOP Improvements

DATE OF FIELD WORK : 10/2019, 9/2020

PROJECT UNITS : US SURVEY FOOT

EPOCH DATE : 2010.00

		STATE PLANE COORDINATES			GEO COORDINATES
	POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION

19101	2368909.058	1620197.011	291.747	60°29'03.355317"N	150°06'43.562919"W	324.775	0.99988497	5/8" IR W/FHWA ALUM CAP
19102	2368739.068	1619665.714	284.506	60°29'01.672044"N	150°06'54.161091"W	317.503	0.99988534	5/8" IR W/FHWA ALUM CAP
19103	2368597.421	1619313.582	284.702	60°29'00.270840"N	150°07'01.184131"W	317.679	0.99988535	5/8" IR W/FHWA ALUM CAP
19104	2368472.637	1618796.627	286.787	60°28'59.032673"N	150°07'11.497174"W	319.733	0.99988528	5/8" IR W/FHWA ALUM CAP
19105	2368242.301	1618157.933	327.423	60°28'56.752454"N	150°07'24.235710"W	360.333	0.99988338	5/8" IR W/FHWA ALUM CAP

19201	2358747.112	1584701.997	426.631	60°27'22.152825"N	150°18'31.047026"W	457.521	0.99988171	5/8" IR W/FHWA ALUM CAP
19202	2358500.723	1584348.388	409.781	60°27'19.709767"N	150°18'38.075311"W	440.659	0.99988256	5/8" IR W/FHWA ALUM CAP
19203	2358384.643	1584240.447	412.545	60°27'18.561477"N	150°18'40.216823"W	443.422	0.99988244	5/8" IR W/FHWA ALUM CAP

19303	2353339.390	1582903.931	286.945	60°26'28.807816"N	150°19'06.381558"W	318.026	0.99988859	5/8" IR W/FHWA ALUM CAP
19305	2354073.042	1583370.479	350.505	60°26'36.055692"N	150°18'57.152312"W	381.578	0.99988550	5/8" IR W/FHWA ALUM CAP
22301	2353772.711	1583164.896	327.284	60°26'33.087999"N	150°19'01.221494"W	358.359	0.99988664	5/8" IR W/FHWA ALUM CAP
22302	2353552.138	1583000.700	300.738	60°26'30.907778"N	150°19'04.473196"W	331.814	0.99988792	5/8" IR W/FHWA ALUM CAP
22304	2353149.846	1582832.174	275.888	60°26'26.937575"N	150°19'07.793552"W	306.975	0.99988913	5/8" IR W/FHWA ALUM CAP

File details come from the government source that posted it. Updated Nov 9, 2023.