mta-dot236-2_WinifredNorth_control-points.xlsx
XLSX spreadsheet 35 KB Posted
- Attached to
- MT FLAP DOT 236(2), Winifred North Federal contract opportunity
- Solicitation number
- 69056725B000010
About this file
This Excel file is a Survey Control Point List for the MT FLAP DOT 236(2) Winifred North highway project. The document provides detailed geospatial survey control point information for three specific reference points (23101, 23102, and 23103) with precise state plane coordinates, geographic coordinates, elevations, and descriptive locations relative to road centerlines and fences. The survey was conducted in July 2023, using the Montana State Plane Coordinate System (NAD 83 2011) with orthometric elevations based on NAVD88 GEOID18, and the project units are in International Foot. The control points are positioned near State Highway 236, with each point meticulously documented with latitude, longitude, elevation, combined factor, and specific positioning details such as distance from road centerline and fence.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| BidTabs_MT FLAP DOT 236(2) Winifred North.pdf | ||
| BidSum_MT FLAP DOT 236(2)_Winifred North.pdf | ||
| QA_10_17_2025.pdf | ||
| QA_10_15_2025.pdf | ||
| QA_10_14_2025.pdf | ||
| mta-dot236-2_WinifredNorth_Grizzly_Bear_Sightings_Log.docx | DOCX document | |
| mta-dot236-2_WinifredNorth_plans.pdf | ||
| IFB_69056725B000010_MT FLAP DOT 236(2).pdf | ||
| mta-dot236-2_WinifredNorth_Final Geotechnical Report-Signed.pdf | ||
| mta-dot236-2_WinifredNorth_Hydraulics_Memo_Final.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 DOT 236(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 | 3 | 3.0 | ||
| Base sheet name: | Sheet | 3 | rows w/data | OK - no spaces in data |
| Max. row/table | 35 | 3 | data rows | Warnings: |
| 35 | rows/table | |||
| PROJECT : Winifred North |
DATE OF FIELD WORK : July 2023 DATE OF FINAL ADJUSTMENT : July 2023
COORDINATE SYSTEM : Montana SPCS NAD 83 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
PROJECT UNITS : International 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 | F:\highways\FHWA\22500105_mt-a-dot23602_WinifredNorth\DGN\Plan and Profile\[mta-dot236-2_control-points.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 8-Jul-2024 2:06 PM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
| F:\highways\FHWA\22500105_mt-a-dot23602_WinifredNorth\DGN\Plan and Profile\[mta-dot236-2_control-points.xlsx]Sheet | |
| PROJECT : Winifred North |
DATE OF FIELD WORK : July 2023 DATE OF FINAL ADJUSTMENT : July 2023
PROJECT UNITS : International Foot COORDINATE SYSTEM : Montana SPCS NAD 83 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 | ||||||||||||||
| 23101 | 1222758.859 | 1969942.008 | 3380.653 | 47°36'14.67043" | -109°29'39.00325" | 3332.825 | 0.9992868073 | Set RPA RPC 37 ft W of road CL (S236) and 3 ft E of fence | |||||||
| 23102 | 1216713.917 | 1970026.978 | 3462.731 | 47°35'14.97856" | -109°29'37.76958" | 3415.069 | 0.9992799307 | Set RPA RPC 26 ft E of road CL (S236) and 2 ft W of fence | |||||||
| 23103 | 1231172.293 | 1967099.295 | 3384.967 | 47°37'37.74974" | -109°30'20.51760" | 3336.939 | 0.9992908584 | Set RPA RPC 35 ft N of road CL (S236) and 2.5 ft S of fence | |||||||
| 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 | |||||||
| 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 | NOTE: | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | 0 | 0 | 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. | |||||
| 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 |
8-Jul-2024 2:06 PM
PROJECT : Winifred North DATE OF FIELD WORK : July 2023 DATE OF FINAL ADJUSTMENT : July 2023
COORDINATE SYSTEM : Montana SPCS NAD 83 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
PROJECT UNITS : International Foot
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| 23101 | 1222758.859 | 1969942.008 | 3380.653 | 47°36'14.67043" | -109°29'39.00325" | 3332.825 | 0.99928681 | Set RPA RPC 37 ft W of road CL (S236) and 3 ft E of fence | |
| 23102 | 1216713.917 | 1970026.978 | 3462.731 | 47°35'14.97856" | -109°29'37.76958" | 3415.069 | 0.99927993 | Set RPA RPC 26 ft E of road CL (S236) and 2 ft W of fence | |
| 23103 | 1231172.293 | 1967099.295 | 3384.967 | 47°37'37.74974" | -109°30'20.51760" | 3336.939 | 0.99929086 | Set RPA RPC 35 ft N of road CL (S236) and 2.5 ft S of fence |
File details come from the government source that posted it. Updated .