ID_BOR_SRAO_TCROWN(1)_sites1-6_control-sheet.xlsx

XLSX spreadsheet 39 KB Posted

Attached to
ID BOR SRAO TCROWN(1), Crown Point Trail and Parking Area
Solicitation number
69056725R000014
Issued by

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

File Type Posted
QA_3-16-2026.pdf PDF
RFP_69056725R000014_ID BOR SRAO TCROWN(1).pdf PDF
idr-srao-tcrown1_xs.pdf PDF
idr-srao-tcrown1_ewk_combined.pdf PDF
idr-srao-tcrown1_plans.pdf PDF
idr-srao-tcrown1_geo_memo.pdf PDF
idr-srao-tcrown1_clearing-limit.pdf PDF
idr-srao-tcrown1_xyz_final.pdf PDF
idr-srao-tcrown1_construction-staking-notes.pdf PDF
idr-srao-tcrown1_xyz_base.pdf PDF
idr-srao-tcrown1_ali.pdf PDF
Physical Data.zip ZIP file
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.11.0
Title block text:SURVEY CONTROL
Show Totals?TRUE
Data location:Page 1Worksheet found
Data begins in col:A
Min. rows/table53.0
Base sheet name:Sheet13rows w/dataOK - no spaces in data
Max. row/table3513data rowsWarnings:
35rows/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.
WorksheetSheetHeaderNumberNotes
SheetD.131OK
Sheet (2)UndefinedFALSE1
Sheet (3)UndefinedFALSE1
Sheet (4)UndefinedFALSE1
Sheet (5)UndefinedFALSE1
Sheet (6)UndefinedFALSE1
Sheet (7)UndefinedFALSE1
Sheet (8)UndefinedFALSE1
Sheet (9)UndefinedFALSE1
Sheet (10)UndefinedFALSE1
Sheet (11)UndefinedFALSE1
Sheet (12)UndefinedFALSE1
Sheet (13)UndefinedFALSE1
Sheet (14)UndefinedFALSE1
Sheet (15)UndefinedFALSE1
Sheet (16)UndefinedFALSE1
Sheet (17)UndefinedFALSE1
Sheet (18)UndefinedFALSE1
Sheet (19)UndefinedFALSE1
Sheet (20)UndefinedFALSE1
Total Sheets:10sheets missing

Revised: 20 September 2023

Sheet

Sheet Information
Sheet num:D.1Filename0
Sheet name:SheetC:\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:ABCDEFGHI
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 COORDINATESGEO COORDINATES
3.0POINT
NUMBERNORTHEASTORTHOMETRIC ELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTIONNOTE:
231011042096.9042545282.0904835.13444°31'32.022062"N116°03'15.833646"W4785.39110.99971189665/8"ir w/fhwa alum cap1.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.
231021042250.8222545217.8594848.24844°31'33.539642"N116°03'16.728206"W4798.50610.99971128185/8"ir w/fhwa alum cap
232011043028.9372542654.4764853.06344°31'41.127651"N116°03'52.154503"W4803.32210.99971152445/8"ir w/fhwa alum cap
232021043098.8592542418.0684852.57144°31'41.809139"N116°03'55.421728"W4802.8310.99971159225/8"ir w/fhwa alum cap
233011044617.1662542347.1554853.87444°31'56.799751"N116°03'56.481629"W4804.13270.99971154345/8"ir w/fhwa alum cap2.The published “Pier 1” elevation is 2.908 feet
233021044787.6532542334.4904853.95544°31'58.482831"N116°03'56.665579"W4804.21360.9997115425/8"ir w/fhwa alum caplower than an OPUS derived NAVD88 elevation
234011051150.2142543223.2934853.68144°33'01.346923"N116°03'44.731046"W4803.94310.99971138915/8"ir w/fhwa alum capof 4848.517.
234021051108.9162543133.3604838.57944°33'00.935716"N116°03'45.970817"W4788.84030.99971212725/8"ir w/fhwa alum cap
235011052368.0962543190.2984853.78044°33'13.372254"N116°03'45.251069"W4804.04330.99971139055/8"ir w/fhwa alum cap
235021052485.8052543182.8424865.17844°33'14.534348"N116°03'45.360265"W4815.44150.99971084755/8"ir w/fhwa alum cap
236011053310.3532543127.5284865.95744°33'22.674662"N116°03'46.167816"W4816.22060.99971082065/8"ir w/fhwa alum cap
236021053375.1452543065.3124861.15744°33'23.312123"N116°03'47.030514"W4811.42090.99971106155/8"ir w/fhwa alum cap
PIER11041805.1512546552.2894845.60944°31'29.187344"N116°02'58.285146"W4795.85810.9997111682Concrete Pier
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.00000000
00.0000.0000.000000
00.0000.0000.000000

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 COORDINATESGEO COORDINATES
POINT
NUMBERNORTHEASTELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTION
231011042096.9042545282.0904835.13444°31'32.022062"N116°03'15.833646"W4785.3910.999711905/8"ir w/fhwa alum cap
231021042250.8222545217.8594848.24844°31'33.539642"N116°03'16.728206"W4798.5060.999711285/8"ir w/fhwa alum cap
232011043028.9372542654.4764853.06344°31'41.127651"N116°03'52.154503"W4803.3220.999711525/8"ir w/fhwa alum cap
232021043098.8592542418.0684852.57144°31'41.809139"N116°03'55.421728"W4802.8310.999711595/8"ir w/fhwa alum cap
233011044617.1662542347.1554853.87444°31'56.799751"N116°03'56.481629"W4804.1330.999711545/8"ir w/fhwa alum cap
233021044787.6532542334.4904853.95544°31'58.482831"N116°03'56.665579"W4804.2140.999711545/8"ir w/fhwa alum cap
234011051150.2142543223.2934853.68144°33'01.346923"N116°03'44.731046"W4803.9430.999711395/8"ir w/fhwa alum cap
234021051108.9162543133.3604838.57944°33'00.935716"N116°03'45.970817"W4788.8400.999712135/8"ir w/fhwa alum cap
235011052368.09572543190.29834853.779944°33'13.372254"N116°03'45.251069"W4804.04330.99971139055/8"ir w/fhwa alum cap
235021052485.80482543182.84224865.17844°33'14.534348"N116°03'45.360265"W4815.44150.99971084755/8"ir w/fhwa alum cap
236011053310.35332543127.52764865.956644°33'22.674662"N116°03'46.167816"W4816.22060.99971082065/8"ir w/fhwa alum cap
236021053375.14482543065.31224861.157244°33'23.312123"N116°03'47.030514"W4811.42090.99971106155/8"ir w/fhwa alum cap
PIER11041805.1512546552.2894845.60944°31'29.187344"N116°02'58.285146"W4795.85810.9997111682Concrete Pier

File details come from the government source that posted it. Updated .