mta-park2021-1_control-points.xlsx

XLSX spreadsheet 40 KB Posted Apr 3, 2025

Attached to: MT FLAP PARK 2021(1), Old Yellowstone Trail South Improvements and Preservation
Solicitation number: 69056725R000003
Issued by: Department of Transportation Federal Highway Administration

About this file

Written by GovTribe AI · Apr 3, 2025

The file is an Excel-based Survey Control Point list for the Old Yellowstone Trail South project, documenting precise geospatial survey data collected in July/August 2023. The survey uses the Montana State Plane Coordinate System (NAD83 2011) with international foot units and orthometric elevations based on NAVD88 GEOID18, capturing 16 control points (OYTS1-OYTS16) with detailed coordinate information including state plane coordinates, geographic coordinates, elevations, and combined factors.

The related federal contract opportunity is a task order solicitation (No. 69056725R000003) for MT FLAP PARK 2021(1) Old Yellowstone Trail South Improvements and Preservation, exclusively limited to six pre-selected prime contractors: H-K Contractors, M.A. Deatley Construction, Missouri River Contractors, Oftedal Construction, Riverside Contracting, and Sundt Construction. The project is managed by the Department of Transportation Federal Highway Administration and is being advertised on SAM.gov to help potential subcontractors identify opportunities, with full details available on the agency's website.

View the file

Other files

File	Type	Posted
QA_04-30-2025.pdf	PDF	May 1, 2025
Amendment A001.pdf	PDF	Apr 30, 2025
QA_04-29-2025.pdf	PDF	Apr 30, 2025
QA_04-28-2025.pdf	PDF	Apr 29, 2025
QA_04-24-2025.pdf	PDF	Apr 24, 2025
QA_04-23-2025.pdf	PDF	Apr 23, 2025
FLH Bridge oversized or overload vehicle permit request form.pdf	PDF	Apr 3, 2025
RFP_69056725R000003_MT FLAP PARK 2021(1).pdf	PDF	Apr 3, 2025
Physical Data.zip	ZIP file	Apr 3, 2025
mta-park2021-1_Geotechnical report.pdf	PDF	Apr 3, 2025
mta-park2021-1_plans.pdf	PDF	Apr 3, 2025

Show all 11

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

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:	MT FLAP Park 2021(1)	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.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	16	rows w/data	OK - no spaces in data
Max. row/table	35	16	data rows	Warnings:
		35	rows/table
			PROJECT :Old Yellowstone Trail South

DATE OF FIELD WORK :July/August 2023 PROJECT UNITS : International foot

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

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : MT83/2011IF NSRS11(NAD83/2011) Montana, Intl Foot

Sheet Names
Input the names of the worksheets in the order you would like the sheets numbered.
Worksheet	Sheet	Header	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: 20 September 2023

Sheet

Sheet Information

Sheet num:

D.1

Filename

Sheet name:

Sheet

C:\MyFiles\Projects_2023\Montana\Old_Yellowstone_Trail_South\Summer_2023_entry\[OYTS_controlsheet.xlsx]Sheet

Reference:

Time

1-Nov-2023 8:20 AM

Begin Column:

C:\MyFiles\Projects_2023\Montana\Old_Yellowstone_Trail_South\Summer_2023_entry\[OYTS_controlsheet.xlsx]Sheet
	PROJECT :Old Yellowstone Trail South

DATE OF FIELD WORK :July/August 2023 PROJECT UNITS : International foot

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

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : MT83/2011IF NSRS11(NAD83/2011) Montana, Intl Foot

						STATE PLANE COORDINATES			GEO COORDINATES
	3.0				POINT
NUMBER	NORTH	EAST	ORTHOMETRIC ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION		NOTE:
					OYTS1	287164.669	1654875.656	5309.469	45°01'50.888891"N	110°42'47.235054"W	5280.7183	0.999729364	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.
					OYTS2	287539.838	1654493.902	5278.455	45°01'54.534388"N	110°42'52.631095"W	5249.7018	0.9997302471	5/8" ir w/fhwa alum cap
					OYTS3	292131.938	1645980.463	5252.985	45°02'38.549136"N	110°44'52.180700"W	5224.1691	0.999724267	5/8" ir w/fhwa alum cap
					OYTS4	292621.172	1645277.467	5246.637	45°02'43.268455"N	110°45'02.079318"W	5217.8171	0.9997238011	5/8" ir w/fhwa alum cap
					OYTS5	298613.490	1639266.555	5216.780	45°03'41.471811"N	110°46'27.145712"W	5187.922	0.999715782	5/8" ir w/fhwa alum cap
					OYTS6	299464.990	1639184.705	5199.619	45°03'49.865202"N	110°46'28.478931"W	5170.7509	0.9997152462	5/8" ir w/fhwa alum cap
					OYTS7	309639.140	1636945.033	5205.188	45°05'29.950211"N	110°47'02.002668"W	5176.2729	0.9996989362	5/8" ir w/fhwa alum cap
					OYTS8	310309.936	1636825.533	5203.817	45°05'36.553455"N	110°47'03.821558"W	5174.8986	0.9996979512	5/8" ir w/fhwa alum cap
					OYTS9	315999.406	1634951.341	5110.980	45°06'32.419865"N	110°47'31.252548"W	5082.0017	0.9996935383	5/8" ir w/fhwa alum cap
					OYTS10	316712.992	1634401.040	5118.118	45°06'39.375237"N	110°47'39.089272"W	5089.1242	0.9996921013	5/8" ir w/fhwa alum cap
					OYTS11	324274.699	1630471.007	5142.754	45°07'53.385442"N	110°48'35.647036"W	5113.6185	0.9996793281	5/8" ir w/fhwa alum cap
					OYTS12	324945.683	1630185.077	5136.060	45°07'59.962722"N	110°48'39.791761"W	5106.9162	0.999678623	5/8" ir w/fhwa alum cap
					OYTS13	332520.186	1625809.521	5377.207	45°09'14.016710"N	110°49'42.614403"W	5347.9557	0.9996556363	5/8" ir w/fhwa alum cap
					OYTS14	333125.399	1625617.960	5324.469	45°09'19.959814"N	110°49'45.430636"W	5295.2111	0.9996572398	5/8" ir w/fhwa alum cap
					OYTS15	337719.415	1618595.375	5071.904	45°10'04.126980"N	110°51'24.531299"W	5042.6948	0.9996625213	5/8" ir w/fhwa alum cap
					OYTS16	337891.583	1618205.217	5074.246	45°10'05.759999"N	110°51'30.018270"W	5045.0447	0.9996621593	5/8" ir w/fhwa alum cap
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000	0	0	0	0	0
					0	0.000	0.000	0.000			0	0	0
					0	0.000	0.000	0.000			0	0	0

1-Nov-2023 8:20 AM

PROJECT :Old Yellowstone Trail South DATE OF FIELD WORK :July/August 2023 PROJECT UNITS : International foot

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

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : MT83/2011IF NSRS11(NAD83/2011) Montana, Intl Foot

		STATE PLANE COORDINATES			GEO COORDINATES
	POINT
NUMBER	NORTH	EAST	ELEVATION	LATITUDE	LONGITUDE	ELLIPSOID
HEIGHT	COMBINED
FACTOR	DESCRIPTION
	OYTS1	287164.669	1654875.656	5309.469	45°01'50.888891"N	110°42'47.235054"W	5280.718	0.99972936	5/8" ir w/fhwa alum cap
	OYTS2	287539.838	1654493.902	5278.455	45°01'54.534388"N	110°42'52.631095"W	5249.702	0.99973025	5/8" ir w/fhwa alum cap
	OYTS3	292131.938	1645980.463	5252.985	45°02'38.549136"N	110°44'52.180700"W	5224.169	0.99972427	5/8" ir w/fhwa alum cap
	OYTS4	292621.172	1645277.467	5246.637	45°02'43.268455"N	110°45'02.079318"W	5217.817	0.99972380	5/8" ir w/fhwa alum cap
	OYTS5	298613.490	1639266.555	5216.780	45°03'41.471811"N	110°46'27.145712"W	5187.922	0.99971578	5/8" ir w/fhwa alum cap
	OYTS6	299464.990	1639184.705	5199.619	45°03'49.865202"N	110°46'28.478931"W	5170.751	0.99971525	5/8" ir w/fhwa alum cap
	OYTS7	309639.140	1636945.033	5205.188	45°05'29.950211"N	110°47'02.002668"W	5176.273	0.99969894	5/8" ir w/fhwa alum cap
	OYTS8	310309.936	1636825.533	5203.817	45°05'36.553455"N	110°47'03.821558"W	5174.899	0.99969795	5/8" ir w/fhwa alum cap
	OYTS9	315999.4064	1634951.3408	5110.9798	45°06'32.419865"N	110°47'31.252548"W	5082.0017	0.9996935383	5/8" ir w/fhwa alum cap
	OYTS10	316712.9919	1634401.0398	5118.1179	45°06'39.375237"N	110°47'39.089272"W	5089.1242	0.9996921013	5/8" ir w/fhwa alum cap
	OYTS11	324274.6985	1630471.0073	5142.7536	45°07'53.385442"N	110°48'35.647036"W	5113.6185	0.9996793281	5/8" ir w/fhwa alum cap
	OYTS12	324945.6829	1630185.0766	5136.0603	45°07'59.962722"N	110°48'39.791761"W	5106.9162	0.999678623	5/8" ir w/fhwa alum cap
	OYTS13	332520.1856	1625809.5209	5377.2065	45°09'14.016710"N	110°49'42.614403"W	5347.9557	0.9996556363	5/8" ir w/fhwa alum cap
	OYTS14	333125.3987	1625617.9595	5324.4686	45°09'19.959814"N	110°49'45.430636"W	5295.2111	0.9996572398	5/8" ir w/fhwa alum cap
	OYTS15	337719.415	1618595.3748	5071.9042	45°10'04.126980"N	110°51'24.531299"W	5042.6948	0.9996625213	5/8" ir w/fhwa alum cap
	OYTS16	337891.5828	1618205.2171	5074.2464	45°10'05.759999"N	110°51'30.018270"W	5045.0447	0.9996621593	5/8" ir w/fhwa alum cap

File details come from the government source that posted it. Updated Apr 3, 2025.