id-a5557621_Survey_ControlSheet.xlsx

XLSX spreadsheet 41 KB Posted Jan 25, 2021

Attached to: ID KOOTENAI 5762(1), BUNCO ROAD IMPROVEMENTS
Solicitation number: 69056720B000019
Issued by: Department of Transportation Federal Highway Administration

About this file

Written by GovTribe AI · Dec 27, 2023

This document contains a survey control sheet and related federal contract opportunity. The survey control sheet provides state plane coordinate and elevation data for survey control points for the Bunco Road Improvements project in Idaho. It identifies the project units as U.S. survey foot, coordinate system as Idaho West SPCS NAD83 (2011), vertical datum as NAVD88, and date of field work and final adjustment as August 2016.

The related federal contract opportunity is solicitation number 69056720B000019 for the ID KOOTENAI 5762(1) Bunco Road Improvements project through the Department of Transportation Federal Highway Administration. No further details are provided on required products or services for the opportunity.

View the file

Other files

File	Type	Posted
BidSum.pdf	PDF	Feb 25, 2021
Sign-in sheet.pdf	PDF	Feb 25, 2021
QA_02-19-2021.pdf	PDF	Feb 19, 2021
QA_02-18-2021.pdf	PDF	Feb 18, 2021
QA_02-16-2021.pdf	PDF	Feb 16, 2021
QA_02-11-2021.pdf	PDF	Feb 11, 2021
id-a5557621_Nunn Rd_EW.pdf	PDF	Jan 25, 2021
id-a555762_Bohn_XS.pdf	PDF	Jan 25, 2021
id-a5557621_HA (1 00 to 23 80).pdf	PDF	Jan 25, 2021
id-a5557621_VA_Bohn Rd.pdf	PDF	Jan 25, 2021
Bunco Road plans.pdf	PDF	Jan 25, 2021
id-a5557621_VA (61 60 to 72 40).pdf	PDF	Jan 25, 2021
id-a5557621_VA_Nunn Rd.pdf	PDF	Jan 25, 2021
id-a5557621_HA_Nunn Rd.pdf	PDF	Jan 25, 2021
id-a5557621_Bunco_XS.pdf	PDF	Jan 25, 2021
id-a5557621_HA (61 60 to 72 40).pdf	PDF	Jan 25, 2021
id-a5557621_Geotech_Memo.pdf	PDF	Jan 25, 2021
Bunco Road Zip files.zip	ZIP file	Jan 25, 2021
id-a5557621_Bunco_EW.pdf	PDF	Jan 25, 2021
id-a5557621_VA (1 00 to 23 80).pdf	PDF	Jan 25, 2021
id-a5557621_Nunn_XS.pdf	PDF	Jan 25, 2021
id-a5557621_Bohn Rd_EW.pdf	PDF	Jan 25, 2021
id-a5557621_HA_Bohn Rd.pdf	PDF	Jan 25, 2021
IFB Bunco Road.pdf	PDF	Jan 25, 2021
id-a5557621_HA_Main Ali (1 00 to 274 39).pdf	PDF	Jan 25, 2021

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

Drawing No:

Designed by:	WFLHD Survey
Date:	1/1904
Checked by:	Goble
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	13	data rows	Warnings:
		40	rows/table
			PROJECT : Bunco Road Improvements

DATE OF FIELD WORK : August 2016 DATE OF FINAL ADJUSTMENT August 2016

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Idaho West SPCS NAD83 (2011)

EPOCH DATE : 2010.0000

VERTICAL DATUM : Orthometric Elevations based on the NAVD88 GEOID12b

GPK FILE DATED 9/13/2016

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:\pw-work\d0425253\[Bunco_ControlSheet.xlsx]Sheet

Reference:

Time

28-Apr-2020 1:35 PM

Begin Column:

PROJECT : Bunco Road Improvements DATE OF FIELD WORK : August 2016 DATE OF FINAL ADJUSTMENT August 2016 PROJECT UNITS : US SURVEY FOOT COORDINATE SYSTEM : Idaho West SPCS NAD83 (2011)

EPOCH DATE : 2010.0000

VERTICAL DATUM : Orthometric Elevations based on the NAVD88 GEOID12b

GPK FILE DATED 9/13/2016

						STATE PLANE COORDINATES			GEO COORDINATES
	3.0				POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION		NOTE:
					16100	2276154.188	2402483.471	2461.914	47°54'23.537946"N	116°39'21.300148"W	2405.0604	0.9998748	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.
					16101	2276595.388	2402489.302	2448.069	47°54'27.892422"N	116°39'21.290549"W	2391.2089	0.99987546	5/8" IR w/FHWA Alum Cap
					16102	2277322.950	2402496.404	2451.197	47°54'35.072887"N	116°39'21.311615"W	2394.327	0.99987531	5/8" IR w/FHWA Alum Cap
					16103	2278225.984	2402543.673	2458.151	47°54'43.989573"N	116°39'20.773335"W	2401.2745	0.99987495	5/8" IR w/FHWA Alum Cap
					16104	2278834.550	2402518.979	2450.734	47°54'49.992090"N	116°39'21.240619"W	2393.8509	0.99987532	5/8" IR w/FHWA Alum Cap
					BUNCO1	2275173.246	2402542.618	2459.198	47°54'13.864768"N	116°39'20.263204"W	2402.3608	0.9998749	5/8" IR w/FHWA Alum Cap
					BUNCO2	2275637.298	2402517.625	2458.708	47°54'18.441183"N	116°39'20.709889"W	2401.861	0.99987494	5/8" IR w/FHWA Alum Cap
					BUNCO3	2280017.732	2402577.109	2468.110	47°55'01.674548"N	116°39'20.591121"W	2411.2171	0.99987446	5/8" IR w/FHWA Alum Cap
					BUNCO4	2280376.495	2402653.073	2472.376	47°55'05.223641"N	116°39'19.537778"W	2415.4831	0.99987422	5/8" IR w/FHWA Alum Cap
					BUNCO5	2280441.037	2406261.158	2471.403	47°55'06.274784"N	116°38'26.582555"W	2414.5658	0.99987245	5/8" IR w/FHWA Alum Cap
					BUNCO6	2280459.811	2407839.331	2465.355	47°55'06.639103"N	116°38'03.418183"W	2408.5441	0.99987195	5/8" IR w/FHWA Alum Cap
					BUNCO7	2276646.936	2421591.405	2771.552	47°54'30.517916"N	116°34'40.934999"W	2715.161	0.99985072	5/8" IR w/FHWA Alum Cap
					BUNCO8	2276447.545	2421684.077	2780.094	47°54'28.560074"N	116°34'39.543443"W	2723.7129	0.99985027	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

PROJECT : Bunco Road Improvements DATE OF FIELD WORK : August 2016 DATE OF FINAL ADJUSTMENT August 2016

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Idaho West SPCS NAD83 (2011)

EPOCH DATE : 2010.0000

VERTICAL DATUM : Orthometric Elevations based on the NAVD88 GEOID12b

GPK FILE DATED 9/13/2016

		STATE PLANE COORDINATES			GEO COORDINATES
	POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION
	16100	2276154.188	2402483.471	2461.914	47°54'23.537946"N	116°39'21.300148"W	2405.060	0.99987480	5/8" IR w/FHWA Alum Cap
	16101	2276595.388	2402489.302	2448.069	47°54'27.892422"N	116°39'21.290549"W	2391.209	0.99987546	5/8" IR w/FHWA Alum Cap
	16102	2277322.950	2402496.404	2451.197	47°54'35.072887"N	116°39'21.311615"W	2394.327	0.99987531	5/8" IR w/FHWA Alum Cap
	16103	2278225.984	2402543.673	2458.151	47°54'43.989573"N	116°39'20.773335"W	2401.275	0.99987495	5/8" IR w/FHWA Alum Cap
	16104	2278834.550	2402518.979	2450.734	47°54'49.992090"N	116°39'21.240619"W	2393.851	0.99987532	5/8" IR w/FHWA Alum Cap
	BUNCO1	2275173.246	2402542.618	2459.198	47°54'13.864768"N	116°39'20.263204"W	2402.361	0.99987490	5/8" IR w/FHWA Alum Cap
	BUNCO2	2275637.298	2402517.625	2458.708	47°54'18.441183"N	116°39'20.709889"W	2401.861	0.99987494	5/8" IR w/FHWA Alum Cap
	BUNCO3	2280017.732	2402577.109	2468.110	47°55'01.674548"N	116°39'20.591121"W	2411.217	0.99987446	5/8" IR w/FHWA Alum Cap
	BUNCO4	2280376.495	2402653.073	2472.376	47°55'05.223641"N	116°39'19.537778"W	2415.483	0.99987422	5/8" IR w/FHWA Alum Cap
	BUNCO5	2280441.037	2406261.158	2471.403	47°55'06.274784"N	116°38'26.582555"W	2414.566	0.99987245	5/8" IR w/FHWA Alum Cap
	BUNCO6	2280459.811	2407839.331	2465.355	47°55'06.639103"N	116°38'03.418183"W	2408.544	0.99987195	5/8" IR w/FHWA Alum Cap
	BUNCO7	2276646.936	2421591.405	2771.552	47°54'30.517916"N	116°34'40.934999"W	2715.161	0.99985072	5/8" IR w/FHWA Alum Cap
	BUNCO8	2276447.545	2421684.077	2780.094	47°54'28.560074"N	116°34'39.543443"W	2723.713	0.99985027	5/8" IR w/FHWA Alum Cap

File details come from the government source that posted it. Updated Jan 25, 2021.