ID_BOR_SRAO_TCROWN(1)_sites1-6_control-sheet.xlsx
XLSX spreadsheet 39 KB Posted
- Solicitation number
- 69056725R000014
About this file
This is a Survey Control Point spreadsheet that documents precise geographical and elevation data for the Crown Point Trail and Parking Area project located in Idaho. The file contains a control sheet template with survey point coordinates, elevations, and reference information used for construction planning and execution.
The spreadsheet lists 13 survey control points (numbered 23101 through 23602, plus a reference pier) established during field work conducted in August 2023, with final adjustments completed on August 29, 2023. Each point includes State Plane Coordinates (Idaho West SPCS NAD83 2011), orthometric elevations, geodetic coordinates (latitude/longitude), ellipsoid heights, combined factors for distance verification, and point descriptions. All control points are marked with 5/8-inch iron rods with FHWA aluminum caps, with elevations ranging from 4,835.134 to 4,865.957 feet. The vertical datum is based on a Safety of Dams Monitoring published elevation of 4,845.609 feet for the reference pier. Project units are in US Survey Foot, using the CADD system coordinate system ID83/2011-WF NSRS11 (NAD83/2011) for Idaho West Zone. This control sheet serves as the baseline survey data for the design and construction phases of the Crown Point Trail and Parking Area project being administered by the Department of Transportation Federal Highway Administration.
View the file
Other files
Show all 12
On GovTribe
Work with this file
- 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: | ID BOR SRAO TCROWN(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 | 13 | rows w/data | OK - no spaces in data |
| Max. row/table | 35 | 13 | data rows | Warnings: |
| 35 | rows/table | |||
| PROJECT :Crown Point Trail and Parking Area |
DATE OF FIELD WORK :August 2023 DATE OF FINAL ADJUSTMENT : August 29, 2023
COORDINATE SYSTEM : Idaho West SPCS NAD83 2011 VERTICAL DATUM : Based on Safety of Dams Monitoring publishe elevation of 4845.609' for Pier1
EPOCH DATE : 2010.000
CADD SYSTEM COORDINATE SYSTEM :ID83/2011-WF NSRS11(NAD83/2011) Idaho, West Zone, US Foot
PROJECT UNITS : US SURVEY 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\ID\ID BOR SRAO TCROWN(1) Crown Point Trail\[Copy of ID_BOR_SRAO_TCROWN(1)_sites1-6_control-sheet.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 6-Nov-2024 4:19 PM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
| C:\MyFiles\#Projects\ID\ID BOR SRAO TCROWN(1) Crown Point Trail\[Copy of ID_BOR_SRAO_TCROWN(1)_sites1-6_control-sheet.xlsx]Sheet | |
| PROJECT :Crown Point Trail and Parking Area |
DATE OF FIELD WORK :August 2023 DATE OF FINAL ADJUSTMENT : August 29, 2023
PROJECT UNITS : US SURVEY FOOT COORDINATE SYSTEM : Idaho West SPCS NAD83 2011 VERTICAL DATUM : Based on Safety of Dams Monitoring publishe elevation of 4845.609' for Pier1
EPOCH DATE : 2010.000
CADD SYSTEM COORDINATE SYSTEM :ID83/2011-WF NSRS11(NAD83/2011) Idaho, West Zone, US Foot
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||||||||
| 3.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ORTHOMETRIC ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| 23101 | 1042096.904 | 2545282.090 | 4835.134 | 44°31'32.022062"N | 116°03'15.833646"W | 4785.3911 | 0.9997118966 | 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. | |||||
| 23102 | 1042250.822 | 2545217.859 | 4848.248 | 44°31'33.539642"N | 116°03'16.728206"W | 4798.5061 | 0.9997112818 | 5/8"ir w/fhwa alum cap | |||||||
| 23201 | 1043028.937 | 2542654.476 | 4853.063 | 44°31'41.127651"N | 116°03'52.154503"W | 4803.3221 | 0.9997115244 | 5/8"ir w/fhwa alum cap | |||||||
| 23202 | 1043098.859 | 2542418.068 | 4852.571 | 44°31'41.809139"N | 116°03'55.421728"W | 4802.831 | 0.9997115922 | 5/8"ir w/fhwa alum cap | |||||||
| 23301 | 1044617.166 | 2542347.155 | 4853.874 | 44°31'56.799751"N | 116°03'56.481629"W | 4804.1327 | 0.9997115434 | 5/8"ir w/fhwa alum cap | 2. | The published “Pier 1” elevation is 2.908 feet | |||||
| 23302 | 1044787.653 | 2542334.490 | 4853.955 | 44°31'58.482831"N | 116°03'56.665579"W | 4804.2136 | 0.999711542 | 5/8"ir w/fhwa alum cap | lower than an OPUS derived NAVD88 elevation | ||||||
| 23401 | 1051150.214 | 2543223.293 | 4853.681 | 44°33'01.346923"N | 116°03'44.731046"W | 4803.9431 | 0.9997113891 | 5/8"ir w/fhwa alum cap | of 4848.517. | ||||||
| 23402 | 1051108.916 | 2543133.360 | 4838.579 | 44°33'00.935716"N | 116°03'45.970817"W | 4788.8403 | 0.9997121272 | 5/8"ir w/fhwa alum cap | |||||||
| 23501 | 1052368.096 | 2543190.298 | 4853.780 | 44°33'13.372254"N | 116°03'45.251069"W | 4804.0433 | 0.9997113905 | 5/8"ir w/fhwa alum cap | |||||||
| 23502 | 1052485.805 | 2543182.842 | 4865.178 | 44°33'14.534348"N | 116°03'45.360265"W | 4815.4415 | 0.9997108475 | 5/8"ir w/fhwa alum cap | |||||||
| 23601 | 1053310.353 | 2543127.528 | 4865.957 | 44°33'22.674662"N | 116°03'46.167816"W | 4816.2206 | 0.9997108206 | 5/8"ir w/fhwa alum cap | |||||||
| 23602 | 1053375.145 | 2543065.312 | 4861.157 | 44°33'23.312123"N | 116°03'47.030514"W | 4811.4209 | 0.9997110615 | 5/8"ir w/fhwa alum cap | |||||||
| PIER1 | 1041805.151 | 2546552.289 | 4845.609 | 44°31'29.187344"N | 116°02'58.285146"W | 4795.8581 | 0.9997111682 | Concrete Pier | |||||||
| 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.000 | 0.000 | 0.000 | 0 | 0 | 0 |
6-Nov-2024 4:19 PM
PROJECT :Crown Point Trail and Parking Area DATE OF FIELD WORK :August 2023 DATE OF FINAL ADJUSTMENT : August 29, 2023
COORDINATE SYSTEM : Idaho West SPCS NAD83 2011 VERTICAL DATUM : Based on Safety of Dams Monitoring publishe elevation of 4845.609' for Pier1
EPOCH DATE : 2010.000
CADD SYSTEM COORDINATE SYSTEM :ID83/2011-WF NSRS11(NAD83/2011) Idaho, West Zone, US Foot
PROJECT UNITS : US SURVEY FOOT
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| 23101 | 1042096.904 | 2545282.090 | 4835.134 | 44°31'32.022062"N | 116°03'15.833646"W | 4785.391 | 0.99971190 | 5/8"ir w/fhwa alum cap | |
| 23102 | 1042250.822 | 2545217.859 | 4848.248 | 44°31'33.539642"N | 116°03'16.728206"W | 4798.506 | 0.99971128 | 5/8"ir w/fhwa alum cap | |
| 23201 | 1043028.937 | 2542654.476 | 4853.063 | 44°31'41.127651"N | 116°03'52.154503"W | 4803.322 | 0.99971152 | 5/8"ir w/fhwa alum cap | |
| 23202 | 1043098.859 | 2542418.068 | 4852.571 | 44°31'41.809139"N | 116°03'55.421728"W | 4802.831 | 0.99971159 | 5/8"ir w/fhwa alum cap | |
| 23301 | 1044617.166 | 2542347.155 | 4853.874 | 44°31'56.799751"N | 116°03'56.481629"W | 4804.133 | 0.99971154 | 5/8"ir w/fhwa alum cap | |
| 23302 | 1044787.653 | 2542334.490 | 4853.955 | 44°31'58.482831"N | 116°03'56.665579"W | 4804.214 | 0.99971154 | 5/8"ir w/fhwa alum cap | |
| 23401 | 1051150.214 | 2543223.293 | 4853.681 | 44°33'01.346923"N | 116°03'44.731046"W | 4803.943 | 0.99971139 | 5/8"ir w/fhwa alum cap | |
| 23402 | 1051108.916 | 2543133.360 | 4838.579 | 44°33'00.935716"N | 116°03'45.970817"W | 4788.840 | 0.99971213 | 5/8"ir w/fhwa alum cap | |
| 23501 | 1052368.0957 | 2543190.2983 | 4853.7799 | 44°33'13.372254"N | 116°03'45.251069"W | 4804.0433 | 0.9997113905 | 5/8"ir w/fhwa alum cap | |
| 23502 | 1052485.8048 | 2543182.8422 | 4865.178 | 44°33'14.534348"N | 116°03'45.360265"W | 4815.4415 | 0.9997108475 | 5/8"ir w/fhwa alum cap | |
| 23601 | 1053310.3533 | 2543127.5276 | 4865.9566 | 44°33'22.674662"N | 116°03'46.167816"W | 4816.2206 | 0.9997108206 | 5/8"ir w/fhwa alum cap | |
| 23602 | 1053375.1448 | 2543065.3122 | 4861.1572 | 44°33'23.312123"N | 116°03'47.030514"W | 4811.4209 | 0.9997110615 | 5/8"ir w/fhwa alum cap | |
| PIER1 | 1041805.151 | 2546552.289 | 4845.609 | 44°31'29.187344"N | 116°02'58.285146"W | 4795.8581 | 0.9997111682 | Concrete Pier |
File details come from the government source that posted it. Updated .