ida-bonner841-1_Controlsheet.xlsx

XLSX spreadsheet 57 KB Posted

Attached to
ID FLAP BONNER 841(1), Trestle Creek Road, MP 100 to 103. 7
Solicitation number
69056725R000015
Issued by

About this file

This file is a Survey Control Point List in Excel format for the Trestle Creek Road project (ID FLAP BONNER 841(1)) located in Idaho. The control sheet documents 47 survey control points with precise geographic and state plane coordinates using the Idaho West SPCS NAD83 (2011) coordinate system and NAVD88 GEOID12b vertical datum. All measurements are in US Survey Feet, with an epoch date of 2010.000. Each control point (numbered 19101 through 19147) includes north and east state plane coordinates, orthometric elevation, latitude and longitude coordinates, ellipsoid height, combined scale factors, and physical descriptions indicating 5/8-inch iron monuments with FHWA aluminum caps. The data spans two worksheets with 35 and 12 active data rows respectively, covering the project area from mile point 100 to 103.7 along Trestle Creek Road.

The survey control data was compiled on February 24, 2025, from field work conducted on multiple dates and is intended to support the Task Order Request for Proposals (69056725R000015) issued to six eligible prime contractors under the Idaho, Montana, and Surrounding Areas MATOC contract vehicle administered by the Federal Highway Administration. The control points serve as surveying reference markers for the design and construction phases of this road improvement project and provide the geodetic foundation necessary for contractors to verify distances, elevations, and spatial accuracy during project implementation.

View the file

Other files

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 FLAP BONNER 841(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.12.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:Sheet47rows w/dataOK - no spaces in data
Max. row/table3547data rowsWarnings:
35rows/table
PROJECT : Trestle Creek

DATE OF FIELD WORK : Multiple entries

COORDINATE SYSTEM : Idaho West SPCS NAD83 (2011) VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID12b

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)D.2382OK
Sheet (3)UndefinedFALSE2
Sheet (4)UndefinedFALSE2
Sheet (5)UndefinedFALSE2
Sheet (6)UndefinedFALSE2
Sheet (7)UndefinedFALSE2
Sheet (8)UndefinedFALSE2
Sheet (9)UndefinedFALSE2
Sheet (10)UndefinedFALSE2
Sheet (11)UndefinedFALSE2
Sheet (12)UndefinedFALSE2
Sheet (13)UndefinedFALSE2
Sheet (14)UndefinedFALSE2
Sheet (15)UndefinedFALSE2
Sheet (16)UndefinedFALSE2
Sheet (17)UndefinedFALSE2
Sheet (18)UndefinedFALSE2
Sheet (19)UndefinedFALSE2
Sheet (20)UndefinedFALSE2
Total Sheets:20sheets missing

Revised: 20 September 2023

Sheet

Sheet Information
Sheet num:D.1Filename0
Sheet name:SheetC:\Users\adam.davies\Documents\Projects_2025\Idaho\Trestle Creek\pw\[Trestle_Creek_Controlsheet.xlsx]Sheet
Reference:Sheet 1 of 2Time
24-Feb-2025 9:09 AM
Begin Column:ABCDEFGHI
C:\Users\adam.davies\Documents\Projects_2025\Idaho\Trestle Creek\pw\[Trestle_Creek_Controlsheet.xlsx]Sheet
PROJECT : Trestle Creek

DATE OF FIELD WORK : Multiple entries

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Idaho West SPCS NAD83 (2011) VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID12b

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:
191012413012.8802478607.4472089.99248°17'01.427016"N116°20'59.653282"W2034.4700.99986050275/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.
191022413204.1492479208.6852107.79248°17'03.360761"N116°20'50.785803"W2052.3120.99985945065/8" IR W/FHWA ALUM CAP
191032413368.5502479777.4272124.28348°17'05.026693"N116°20'42.395530"W2068.8430.99985847275/8" IR W/FHWA ALUM CAP
191042413511.8332480338.6572140.97648°17'06.483488"N116°20'34.113763"W2085.5770.99985748835/8" IR W/FHWA ALUM CAP
191052413840.9102480751.6262158.80948°17'09.762297"N116°20'28.045187"W2103.4460.99985649915/8" IR W/FHWA ALUM CAP
191062414258.9342481182.1082176.62448°17'13.920087"N116°20'21.727542"W2121.3020.99985550525/8" IR W/FHWA ALUM CAP
191072414585.3012481643.9362198.18548°17'17.175664"N116°20'14.935735"W2142.9030.99985432265/8" IR W/FHWA ALUM CAP
191082414764.9732482112.9872213.68048°17'18.984066"N116°20'08.020332"W2158.4350.9998534285/8" IR W/FHWA ALUM CAP
191092414965.2142482337.7242228.83248°17'20.976981"N116°20'04.719757"W2173.6080.99985263035/8" IR W/FHWA ALUM CAP
191102414955.6252482536.8292238.23448°17'20.897312"N116°20'01.774529"W2183.0230.9998521165/8" IR W/FHWA ALUM CAP
191112414992.6252482810.8572240.27448°17'21.282985"N116°19'57.726655"W2185.0820.99985192895/8" IR W/FHWA ALUM CAP
191122415378.8392483156.2962262.03748°17'25.120053"N116°19'52.661922"W2206.8890.99985077585/8" IR W/FHWA ALUM CAP
191132415654.7302483635.5172271.06348°17'27.878346"N116°19'45.606352"W2215.9520.99985018845/8" IR W/FHWA ALUM CAP
191142415758.0672483952.5712282.56748°17'28.921684"N116°19'40.929431"W2227.4790.9998495365/8" IR W/FHWA ALUM CAP
191152415929.4762484159.1232293.52148°17'30.628515"N116°19'37.894092"W2238.4500.99984894585/8" IR W/FHWA ALUM CAP
191162416052.8172484573.3112308.60348°17'31.876359"N116°19'31.782876"W2253.5610.99984809155/8" IR W/FHWA ALUM CAP
191172416329.1392484838.8082325.39248°17'34.622777"N116°19'27.887340"W2270.3730.99984720385/8" IR W/FHWA ALUM CAP
191182416340.9152485119.3002337.80848°17'34.759681"N116°19'23.740714"W2282.8070.99984652065/8" IR W/FHWA ALUM CAP
191192416396.9622485540.0592360.31848°17'35.343730"N116°19'17.524680"W2305.3450.99984531055/8" IR W/FHWA ALUM CAP
191202416753.6622485786.0972380.20448°17'38.881771"N116°19'13.925461"W2325.2520.99984428175/8" IR W/FHWA ALUM CAP
191212417079.9332486155.2372400.06548°17'42.128513"N116°19'08.502251"W2345.1410.9998432155/8" IR W/FHWA ALUM CAP
191222417270.3852486699.6552412.24948°17'44.047683"N116°19'00.471843"W2357.3520.99984246025/8" IR W/FHWA ALUM CAP
191232417550.8192487072.1302438.56148°17'46.842164"N116°18'54.993928"W2383.6900.99984108525/8" IR W/FHWA ALUM CAP
191242417721.3792487600.1072448.62248°17'48.563585"N116°18'47.204163"W2393.7830.99984043775/8" IR W/FHWA ALUM CAP
191252417721.3452488161.2752461.69848°17'48.603802"N116°18'38.904940"W2406.8910.99983963665/8" IR W/FHWA ALUM CAP
191262417908.0952488530.8772477.43648°17'50.473302"N116°18'33.458953"W2422.6530.99983876895/8" IR W/FHWA ALUM CAP
191272418101.7602488891.1072497.85948°17'52.410298"N116°18'28.152206"W2443.0990.99983768075/8" IR W/FHWA ALUM CAP
191282418238.1332489185.0932506.05548°17'53.777117"N116°18'23.818927"W2451.3160.99983719735/8" IR W/FHWA ALUM CAP
191292418393.1272489336.6662518.52848°17'55.317469"N116°18'21.593829"W2463.7990.99983655435/8" IR W/FHWA ALUM CAP
191302418506.5352489591.0672533.78948°17'56.454772"N116°18'17.843433"W2479.0760.99983574635/8" IR W/FHWA ALUM CAP
191312418733.6402489836.0892542.38348°17'58.713357"N116°18'14.243845"W2487.6870.99983525965/8" IR W/FHWA ALUM CAP
191322418971.9912490253.8242565.80248°18'01.095161"N116°18'08.090904"W2511.1330.99983401165/8" IR W/FHWA ALUM CAP
191332419087.5032490769.5552595.13848°18'02.271612"N116°18'00.475378"W2540.5000.99983245125/8" IR W/FHWA ALUM CAP
191342419328.6852491139.5692621.02748°18'04.677783"N116°17'55.028256"W2566.4130.99983110085/8" IR W/FHWA ALUM CAP
191352419655.8732491498.8662677.02448°18'07.931852"N116°17'49.748575"W2622.4340.99982831615/8" IR W/FHWA ALUM CAP

24-Feb-2025 9:09 AM

SHEET 1 OF 2

Sheet (2)

Sheet Information
Sheet num:D.2Filename0
Sheet name:Sheet (2)C:\Users\adam.davies\Documents\Projects_2025\Idaho\Trestle Creek\pw\[Trestle_Creek_Controlsheet.xlsx]Sheet (2)
Reference:Sheet 2 of 2Time
24-Feb-2025 9:09 AM
Begin Column:ABCDEFGHI
C:\Users\adam.davies\Documents\Projects_2025\Idaho\Trestle Creek\pw\[Trestle_Creek_Controlsheet.xlsx]Sheet (2)
PROJECT : Trestle Creek

DATE OF FIELD WORK : Multiple entries

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Idaho West SPCS NAD83 (2011) VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID12b

EPOCH DATE : 2010.000

CADD SYSTEM COORDINATE SYSTEM : ID83/2011-WF NSRS11(NAD83/2011) Idaho, West Zone, US Foot

STATE PLANE COORDINATESGEO COORDINATES
38.0POINT
NUMBERNORTHEASTORTHOMETRIC ELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTIONNOTE:
191362419884.2842491999.5492714.75748°18'10.221021"N116°17'42.367082"W2660.1990.99982636085/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.
191372419833.6072492339.7622732.03748°18'09.744750"N116°17'37.329691"W2677.4960.99982543195/8" IR W/FHWA ALUM CAP
191382419797.0192492693.6442739.47448°18'09.408403"N116°17'32.091622"W2684.9520.99982496915/8" IR W/FHWA ALUM CAP
191392419731.0152493167.2502751.13248°18'08.790030"N116°17'25.079683"W2696.6350.99982426895/8" IR W/FHWA ALUM CAP
191402419800.3972493670.6022785.49948°18'09.509615"N116°17'17.641869"W2731.0300.99982247555/8" IR W/FHWA ALUM CAP
191412419888.4042494275.7232828.99448°18'10.419875"N116°17'08.700656"W2774.5590.99982021635/8" IR W/FHWA ALUM CAP
191422420045.8482494471.4672841.57748°18'11.987042"N116°17'05.821640"W2787.1550.99981955665/8" IR W/FHWA ALUM CAP
191432419924.0162494692.8122857.94348°18'10.799993"N116°17'02.535155"W2803.5310.99981870895/8" IR W/FHWA ALUM CAP
191442420002.2302495130.8662863.20048°18'11.601861"N116°16'56.063904"W2808.8130.9998183275/8" IR W/FHWA ALUM CAP
191452419900.2902495428.8572864.83648°18'10.616269"N116°16'51.645852"W2810.4550.99981816055/8" IR W/FHWA ALUM CAP
191462420115.0672495776.6122872.22248°18'12.759451"N116°16'46.524121"W2817.8630.99981770445/8" IR W/FHWA ALUM CAP
191472420212.7512496005.4502882.00248°18'13.738990"N116°16'43.149285"W2827.6570.99981716945/8" IR W/FHWA ALUM CAP
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.00000000
00.0000.0000.000000
00.0000.0000.000000

24-Feb-2025 9:09 AM

SHEET 2 OF 2

PROJECT : Trestle Creek DATE OF FIELD WORK : Multiple entries

COORDINATE SYSTEM : Idaho West SPCS NAD83 (2011) VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID12b

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
191012413012.8802478607.4472089.99248°17'01.427016"N116°20'59.653282"W2034.4700.999860505/8" IR W/FHWA ALUM CAP
191022413204.1492479208.6852107.79248°17'03.360761"N116°20'50.785803"W2052.3120.999859455/8" IR W/FHWA ALUM CAP
191032413368.5502479777.4272124.28348°17'05.026693"N116°20'42.395530"W2068.8430.999858475/8" IR W/FHWA ALUM CAP
191042413511.8332480338.6572140.97648°17'06.483488"N116°20'34.113763"W2085.5770.999857495/8" IR W/FHWA ALUM CAP
191052413840.9102480751.6262158.80948°17'09.762297"N116°20'28.045187"W2103.4460.999856505/8" IR W/FHWA ALUM CAP
191062414258.9342481182.1082176.62448°17'13.920087"N116°20'21.727542"W2121.3020.999855515/8" IR W/FHWA ALUM CAP
191072414585.3012481643.9362198.18548°17'17.175664"N116°20'14.935735"W2142.9030.999854325/8" IR W/FHWA ALUM CAP
191082414764.9732482112.9872213.68048°17'18.984066"N116°20'08.020332"W2158.4350.999853435/8" IR W/FHWA ALUM CAP
191092414965.2142482337.7242228.83248°17'20.976981"N116°20'04.719757"W2173.6080.99985263035/8" IR W/FHWA ALUM CAP
191102414955.6252482536.8292238.23448°17'20.897312"N116°20'01.774529"W2183.0230.9998521165/8" IR W/FHWA ALUM CAP
191112414992.6252482810.8572240.27448°17'21.282985"N116°19'57.726655"W2185.0820.99985192895/8" IR W/FHWA ALUM CAP
191122415378.8392483156.2962262.03748°17'25.120053"N116°19'52.661922"W2206.8890.99985077585/8" IR W/FHWA ALUM CAP
191132415654.732483635.5172271.06348°17'27.878346"N116°19'45.606352"W2215.9520.99985018845/8" IR W/FHWA ALUM CAP
191142415758.0672483952.5712282.56748°17'28.921684"N116°19'40.929431"W2227.4790.9998495365/8" IR W/FHWA ALUM CAP
191152415929.4762484159.1232293.52148°17'30.628515"N116°19'37.894092"W2238.4500.99984894585/8" IR W/FHWA ALUM CAP
191162416052.8172484573.3112308.60348°17'31.876359"N116°19'31.782876"W2253.5610.99984809155/8" IR W/FHWA ALUM CAP
191172416329.1392484838.8082325.39248°17'34.622777"N116°19'27.887340"W2270.3730.99984720385/8" IR W/FHWA ALUM CAP
191182416340.9152485119.32337.80848°17'34.759681"N116°19'23.740714"W2282.8070.99984652065/8" IR W/FHWA ALUM CAP
191192416396.9622485540.0592360.31848°17'35.343730"N116°19'17.524680"W2305.3450.99984531055/8" IR W/FHWA ALUM CAP
191202416753.6622485786.0972380.20448°17'38.881771"N116°19'13.925461"W2325.2520.99984428175/8" IR W/FHWA ALUM CAP
191212417079.9332486155.2372400.06548°17'42.128513"N116°19'08.502251"W2345.1410.9998432155/8" IR W/FHWA ALUM CAP
191222417270.3852486699.6552412.24948°17'44.047683"N116°19'00.471843"W2357.3520.99984246025/8" IR W/FHWA ALUM CAP
191232417550.8192487072.132438.56148°17'46.842164"N116°18'54.993928"W2383.6900.99984108525/8" IR W/FHWA ALUM CAP
191242417721.3792487600.1072448.62248°17'48.563585"N116°18'47.204163"W2393.7830.99984043775/8" IR W/FHWA ALUM CAP
191252417721.3452488161.2752461.69848°17'48.603802"N116°18'38.904940"W2406.8910.99983963665/8" IR W/FHWA ALUM CAP
191262417908.0952488530.8772477.43648°17'50.473302"N116°18'33.458953"W2422.6530.99983876895/8" IR W/FHWA ALUM CAP
191272418101.762488891.1072497.85948°17'52.410298"N116°18'28.152206"W2443.0990.99983768075/8" IR W/FHWA ALUM CAP
191282418238.1332489185.0932506.05548°17'53.777117"N116°18'23.818927"W2451.3160.99983719735/8" IR W/FHWA ALUM CAP
191292418393.1272489336.6662518.52848°17'55.317469"N116°18'21.593829"W2463.7990.99983655435/8" IR W/FHWA ALUM CAP
191302418506.5352489591.0672533.78948°17'56.454772"N116°18'17.843433"W2479.0760.99983574635/8" IR W/FHWA ALUM CAP
191312418733.642489836.0892542.38348°17'58.713357"N116°18'14.243845"W2487.6870.99983525965/8" IR W/FHWA ALUM CAP
191322418971.9912490253.8242565.80248°18'01.095161"N116°18'08.090904"W2511.1330.99983401165/8" IR W/FHWA ALUM CAP
191332419087.5032490769.5552595.13848°18'02.271612"N116°18'00.475378"W2540.5000.99983245125/8" IR W/FHWA ALUM CAP
191342419328.6852491139.5692621.02748°18'04.677783"N116°17'55.028256"W2566.4130.99983110085/8" IR W/FHWA ALUM CAP
191352419655.8732491498.8662677.02448°18'07.931852"N116°17'49.748575"W2622.4340.99982831615/8" IR W/FHWA ALUM CAP
191362419884.2842491999.5492714.75748°18'10.221021"N116°17'42.367082"W2660.1990.99982636085/8" IR W/FHWA ALUM CAP
191372419833.6072492339.7622732.03748°18'09.744750"N116°17'37.329691"W2677.4960.99982543195/8" IR W/FHWA ALUM CAP
191382419797.0192492693.6442739.47448°18'09.408403"N116°17'32.091622"W2684.9520.99982496915/8" IR W/FHWA ALUM CAP
191392419731.0152493167.252751.13248°18'08.790030"N116°17'25.079683"W2696.6350.99982426895/8" IR W/FHWA ALUM CAP
191402419800.3972493670.6022785.49948°18'09.509615"N116°17'17.641869"W2731.0300.99982247555/8" IR W/FHWA ALUM CAP
191412419888.4042494275.7232828.99448°18'10.419875"N116°17'08.700656"W2774.5590.99982021635/8" IR W/FHWA ALUM CAP
191422420045.8482494471.4672841.57748°18'11.987042"N116°17'05.821640"W2787.1550.99981955665/8" IR W/FHWA ALUM CAP
191432419924.0162494692.8122857.94348°18'10.799993"N116°17'02.535155"W2803.5310.99981870895/8" IR W/FHWA ALUM CAP
191442420002.232495130.8662863.248°18'11.601861"N116°16'56.063904"W2808.8130.9998183275/8" IR W/FHWA ALUM CAP
191452419900.292495428.8572864.83648°18'10.616269"N116°16'51.645852"W2810.4550.99981816055/8" IR W/FHWA ALUM CAP
191462420115.0672495776.6122872.22248°18'12.759451"N116°16'46.524121"W2817.8630.99981770445/8" IR W/FHWA ALUM CAP
191472420212.7512496005.452882.00248°18'13.738990"N116°16'43.149285"W2827.6570.99981716945/8" IR W/FHWA ALUM CAP

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