mta-park34-2_control-points.xlsx
XLSX spreadsheet 40 KB Posted
- Attached to
- MT FLAP PARK 34(2), Shields River Road Surface Improvement Federal contract opportunity
- Solicitation number
- 69056724B000004
About this file
This document is an Excel spreadsheet containing survey control point information for the "MT FLAP PARK 34(2), Shields River Road Surface Improvement" project. The spreadsheet includes the project details, such as the project name, date of field work, project units, coordinate system, vertical datum, and CADD system. It provides a list of 16 survey control points with their corresponding state plane coordinates, geographic coordinates, orthometric elevations, and descriptions.
The related federal contract opportunity is an Invitation for Bids (IFB) for the construction of the "MT FLAP PARK 34(2), Shields River Road Surface Improvement" project. The solicitation is offered for full and open competition and includes 3 bid schedules, with only 1 bid schedule to be awarded. The Department of Transportation Federal Highway Administration is the agency responsible for this contract opportunity.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Bid Tabulation_MT FLAP PARK 34(2).pdf | ||
| BidSum_MT FLAP PARK 34(2).pdf | ||
| Amendment A002.pdf | ||
| QA 4.5.24.pdf | ||
| Amendment A001.pdf | ||
| QA 3.29.24.pdf | ||
| mta-park34-2_plans.pdf | ||
| mta-park34-2_Existing_Terrian_LIDAR-Feb2023.zip | ZIP file | |
| mta-park34-2_Shields River Road over Flathead MDT_Inspection_Report.pdf | ||
| IFB_69056724B000004_MT FLAP PARK 34(2).pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
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 34(2) | 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 : Shields River Road Surface Improvement |
DATE OF FIELD WORK :August/September 2023 PROJECT UNITS : Internatonal 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 | 0 | |||||||||
| Sheet name: | Sheet | C:\MyFiles\Projects_2023\Montana\Shields_Road\field\[Shields_Road_controlsheet.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 31-Oct-2023 10:39 AM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
| C:\MyFiles\Projects_2023\Montana\Shields_Road\field\[Shields_Road_controlsheet.xlsx]Sheet | |
| PROJECT : Shields River Road Surface Improvement |
DATE OF FIELD WORK :August/September 2023 PROJECT UNITS : Internatonal 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: | |||||||||||||
| SRR1 | 639860.912 | 1673371.247 | 5070.135 | 45°59'56.253915"N | 110°39'42.568839"W | 5034.0428 | 0.9993072193 | 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. | |||||
| SRR2 | 640175.040 | 1673903.659 | 5050.005 | 45°59'59.433962"N | 110°39'35.090599"W | 5013.917 | 0.999307911 | 5/8" ir w/fhwa alum cap | |||||||
| SRR3 | 649082.576 | 1676267.193 | 5156.511 | 46°01'27.743392"N | 110°39'03.454188"W | 5120.5018 | 0.9992954444 | 5/8" ir w/fhwa alum cap | |||||||
| SRR4 | 649690.004 | 1676055.781 | 5168.433 | 46°01'33.711287"N | 110°39'06.577875"W | 5132.4238 | 0.9992943831 | 5/8" ir w/fhwa alum cap | |||||||
| SRR5 | 658496.104 | 1680258.785 | 5223.356 | 46°03'01.281322"N | 110°38'08.802960"W | 5187.4828 | 0.9992846272 | 5/8" ir w/fhwa alum cap | |||||||
| SRR6 | 659479.534 | 1680557.052 | 5242.308 | 46°03'11.035825"N | 110°38'04.774670"W | 5206.4468 | 0.9992829389 | 5/8" ir w/fhwa alum cap | |||||||
| SRR7 | 666663.539 | 1684092.818 | 5342.451 | 46°04'22.484090"N | 110°37'16.082291"W | 5306.7022 | 0.9992724845 | 5/8" ir w/fhwa alum cap | |||||||
| SRR8 | 667219.934 | 1684546.064 | 5335.065 | 46°04'28.042787"N | 110°37'09.763992"W | 5299.3287 | 0.9992724004 | 5/8" ir w/fhwa alum cap | |||||||
| SRR9 | 676616.495 | 1688123.279 | 5370.141 | 46°06'01.340575"N | 110°36'20.887538"W | 5334.517 | 0.9992635075 | 5/8" ir w/fhwa alum cap | |||||||
| SRR10 | 677723.478 | 1688414.172 | 5414.021 | 46°06'12.313185"N | 110°36'16.979605"W | 5378.4072 | 0.9992605772 | 5/8" ir w/fhwa alum cap | |||||||
| SRR11 | 686047.992 | 1688586.270 | 5505.819 | 46°07'34.546413"N | 110°36'16.202978"W | 5470.2537 | 0.9992500223 | 5/8" ir w/fhwa alum cap | |||||||
| SRR12 | 687469.116 | 1688565.942 | 5510.008 | 46°07'48.578006"N | 110°36'16.776378"W | 5474.4515 | 0.9992487846 | 5/8" ir w/fhwa alum cap | |||||||
| SRR13 | 694308.164 | 1694854.712 | 5634.265 | 46°08'56.984024"N | 110°34'48.789894"W | 5598.919 | 0.9992378511 | 5/8" ir w/fhwa alum cap | |||||||
| SRR14 | 694958.364 | 1695492.949 | 5648.958 | 46°09'03.491994"N | 110°34'39.848271"W | 5613.6355 | 0.9992366793 | 5/8" ir w/fhwa alum cap | |||||||
| SRR15 | 700449.610 | 1703128.190 | 5782.359 | 46°09'58.744968"N | 110°32'52.398464"W | 5747.3639 | 0.9992263508 | 5/8" ir w/fhwa alum cap | |||||||
| SRR16 | 701878.104 | 1704025.270 | 5785.448 | 46°10'12.970694"N | 110°32'39.918478"W | 5750.5017 | 0.9992251967 | 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 |
31-Oct-2023 10:39 AM
PROJECT : Shields River Road Surface Improvement DATE OF FIELD WORK :August/September 2023 PROJECT UNITS : Internatonal 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 | ||||||||
| SRR1 | 639860.912 | 1673371.247 | 5070.135 | 45°59'56.253915"N | 110°39'42.568839"W | 5034.043 | 0.99930722 | 5/8" ir w/fhwa alum cap | |
| SRR2 | 640175.040 | 1673903.659 | 5050.005 | 45°59'59.433962"N | 110°39'35.090599"W | 5013.917 | 0.99930791 | 5/8" ir w/fhwa alum cap | |
| SRR3 | 649082.576 | 1676267.193 | 5156.511 | 46°01'27.743392"N | 110°39'03.454188"W | 5120.502 | 0.99929544 | 5/8" ir w/fhwa alum cap | |
| SRR4 | 649690.004 | 1676055.781 | 5168.433 | 46°01'33.711287"N | 110°39'06.577875"W | 5132.424 | 0.99929438 | 5/8" ir w/fhwa alum cap | |
| SRR5 | 658496.104 | 1680258.785 | 5223.356 | 46°03'01.281322"N | 110°38'08.802960"W | 5187.483 | 0.99928463 | 5/8" ir w/fhwa alum cap | |
| SRR6 | 659479.534 | 1680557.052 | 5242.308 | 46°03'11.035825"N | 110°38'04.774670"W | 5206.447 | 0.99928294 | 5/8" ir w/fhwa alum cap | |
| SRR7 | 666663.539 | 1684092.818 | 5342.451 | 46°04'22.484090"N | 110°37'16.082291"W | 5306.702 | 0.99927248 | 5/8" ir w/fhwa alum cap | |
| SRR8 | 667219.934 | 1684546.064 | 5335.065 | 46°04'28.042787"N | 110°37'09.763992"W | 5299.329 | 0.99927240 | 5/8" ir w/fhwa alum cap | |
| SRR9 | 676616.4949 | 1688123.279 | 5370.1412 | 46°06'01.340575"N | 110°36'20.887538"W | 5334.517 | 0.9992635075 | 5/8" ir w/fhwa alum cap | |
| SRR10 | 677723.4784 | 1688414.172 | 5414.0207 | 46°06'12.313185"N | 110°36'16.979605"W | 5378.4072 | 0.9992605772 | 5/8" ir w/fhwa alum cap | |
| SRR11 | 686047.9915 | 1688586.2698 | 5505.8186 | 46°07'34.546413"N | 110°36'16.202978"W | 5470.2537 | 0.9992500223 | 5/8" ir w/fhwa alum cap | |
| SRR12 | 687469.1162 | 1688565.9421 | 5510.0079 | 46°07'48.578006"N | 110°36'16.776378"W | 5474.4515 | 0.9992487846 | 5/8" ir w/fhwa alum cap | |
| SRR13 | 694308.1644 | 1694854.7117 | 5634.2645 | 46°08'56.984024"N | 110°34'48.789894"W | 5598.919 | 0.9992378511 | 5/8" ir w/fhwa alum cap | |
| SRR14 | 694958.3641 | 1695492.949 | 5648.958 | 46°09'03.491994"N | 110°34'39.848271"W | 5613.6355 | 0.9992366793 | 5/8" ir w/fhwa alum cap | |
| SRR15 | 700449.61 | 1703128.1904 | 5782.3589 | 46°09'58.744968"N | 110°32'52.398464"W | 5747.3639 | 0.9992263508 | 5/8" ir w/fhwa alum cap | |
| SRR16 | 701878.1037 | 1704025.2695 | 5785.4482 | 46°10'12.970694"N | 110°32'39.918478"W | 5750.5017 | 0.9992251967 | 5/8" ir w/fhwa alum cap |
File details come from the government source that posted it. Updated .