Mitchell-Hood_River_controlsheet.xlsx

XLSX spreadsheet 59 KB Posted

Attached to
OR DOT CRGNSA 100(4), Historic Columbia River Highway State Trail, Mitchell Point Crossing
Solicitation number
69056720B000024
Issued by

About this file

This document contains a survey control sheet and related federal contract opportunity. The survey control sheet lists state plane and geospatial coordinates, elevations, and descriptions for survey control points along the Mitchell-Hood River section of the Historic Columbia River Highway State Trail project. It includes two sheets with coordinates for 53 control points.

The related federal contract opportunity is solicitation number 69056720B000024 from the Department of Transportation Federal Highway Administration for the OR DOT CRGNSA 100(4), Historic Columbia River Highway State Trail, Mitchell Point Crossing project. The solicitation seeks bids for survey and construction work associated with the Mitchell Point crossing of the Historic Columbia River Highway State Trail. Response and award dates are not provided. The solicitation documents contain requirements for the project but do not specify pricing terms or set-asides.

View the file

Other files

File Type Posted
Bid Opening Summary_OR DOT CRGNSA 100(4).pdf PDF
Pages F-70 through F-71.pdf PDF
Pages F-74 through F-75.pdf PDF
Page G-11.pdf PDF
QA_11-18-2020.pdf PDF
Amendment A002.pdf PDF
Page F-7.pdf PDF
Pages F-131 through F-132.pdf PDF
Pages F-28 through F-29.pdf PDF
Amendment A001.pdf PDF
QA_11-13-2020.pdf PDF
QA_11-09-2020.pdf PDF
OR_DOT_CRGNSA_100(4)_Earthwork.pdf PDF
Mitchell Point Crossing ESCP.pdf PDF
OR_DOT_CRGNSA_100(4)_Geotechnical Baseline Report.pdf PDF
IFB_OR DOT CRGNSA 100(4).pdf PDF
OR_DOT_CRGNSA_100(4)_plans.pdf PDF
OR_DOT_CRGNSA_100(4)_Geotechnical Data Report.pdf PDF
OR_DOT_CRGNSA_100(4)_xs.pdf PDF
Show all 19

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

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.
State:IDNote: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
Project:PRA-CRMO 10(2)
NPS PMIS /

Drawing No:

Designed by:A. Designer
Date:1/1904
Checked by:D. Checker
Date:1/1904
First sheet #:D.102.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:Sheet59rows w/dataOK - no spaces in data
Max. row/table4059data rowsWarnings:
40rows/table
PROJECT : State Trail Mitchell-Hood River

DATE OF FIELD WORK :May-June 2017 DATE OF FINAL ADJUSTMENT :June 2017

PROJECT UNITS : International feet COORDINATE SYSTEM : Oregon North SPCS NAD83 CORS96

VERTICAL DATUM :Orthometric elevations based on the NAVD88 GEOID99

Sheet Names
Input the names of the worksheets in the order you would like the sheets numbered.
Worksheet NameSheetHeader rowSheet NumberNotes
SheetD.10310OK
Sheet (2)D.114311OK
Sheet (3)UndefinedFALSE11
Sheet (4)UndefinedFALSE11
Sheet (5)UndefinedFALSE11
Sheet (6)UndefinedFALSE11
Sheet (7)UndefinedFALSE11
Sheet (8)UndefinedFALSE11
Sheet (9)UndefinedFALSE11
Sheet (10)UndefinedFALSE11
Sheet (11)UndefinedFALSE11
Sheet (12)UndefinedFALSE11
Sheet (13)UndefinedFALSE11
Sheet (14)UndefinedFALSE11
Sheet (15)UndefinedFALSE11
Sheet (16)UndefinedFALSE11
Sheet (17)UndefinedFALSE11
Sheet (18)UndefinedFALSE11
Sheet (19)UndefinedFALSE11
Sheet (20)UndefinedFALSE11
Total Sheets:20sheets missing

Revised: 15 June 2015

Sheet

Sheet Information
Sheet num:D.10Filename0
Sheet name:Sheetc:\pw-work\d0328114\[Mitchell-Hood_River_controlsheet.xlsx]Sheet
Reference:Sheet 1 of 2Time
22-Jun-2020 8:28 PM
Begin Column:ABCDEFGHI

PROJECT : State Trail Mitchell-Hood River DATE OF FIELD WORK :May-June 2017 DATE OF FINAL ADJUSTMENT :June 2017 PROJECT UNITS : International feet

STATE PLANE COORDINATESGEO COORDINATES
3.0POINT
NUMBERNORTHEASTELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTIONNOTE:
12259742609.8607905241.684142.16445°41'51.757100"N121°39'42.731664"W71.85840.999933765/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.
12260742666.9267905694.289135.82145°41'52.384673"N121°39'36.366879"W65.51280.999934095/8" IR W/FHWA ALUM CAP
12262742765.3607906509.171126.14745°41'53.471785"N121°39'24.906584"W55.83420.99993465/8" IR W/FHWA ALUM CAP
12263742808.7737906811.594122.17045°41'53.943095"N121°39'20.654739"W51.85520.999934815/8" IR W/FHWA ALUM CAP
12268743121.0497909358.449122.14945°41'57.384062"N121°38'44.836396"W51.81480.999934975/8" IR W/FHWA ALUM CAP
12269743165.6537909735.911125.91945°41'57.877214"N121°38'39.527425"W55.58160.999934815/8" IR W/FHWA ALUM CAP
12272743214.2517911167.659112.53145°41'58.556699"N121°38'19.365832"W42.17880.999935485/8" IR W/FHWA ALUM CAP
12273743129.6887911600.396104.12645°41'57.782056"N121°38'13.252408"W33.77050.999935855/8" IR W/FHWA ALUM CAP
12286744022.0377915732.321153.85645°42'07.161470"N121°37'15.213883"W83.46970.99993395/8" IR W/FHWA ALUM CAP
12287744218.4697915915.337162.62745°42'09.125732"N121°37'12.673704"W92.23940.999933575/8" IR W/FHWA ALUM CAP
17288744859.3887916272.972103.58345°42'15.501891"N121°37'07.759913"W33.19470.999936685/8" IR W/FHWA ALUM CAP
17289744935.4807916587.318103.83945°42'16.296035"N121°37'03.345669"W33.44870.99993675/8" IR W/FHWA ALUM CAP
17290744968.4967916930.406102.93545°42'16.668801"N121°36'58.518031"W32.54210.999936765/8" IR W/FHWA ALUM CAP
17291744965.9427917247.861101.12645°42'16.686867"N121°36'54.044625"W30.73080.999936855/8" IR W/FHWA ALUM CAP
17292744951.1597917618.100100.18445°42'16.591342"N121°36'48.825121"W29.78590.999936895/8" IR W/FHWA ALUM CAP
17293744824.5267917471.555161.99645°42'15.321258"N121°36'50.865318"W91.59820.999933885/8" IR W/FHWA ALUM CAP
17294744710.1327917636.737154.06845°42'14.214428"N121°36'48.515720"W83.66850.999934215/8" IR W/FHWA ALUM CAP
17295744531.1227917880.823157.09745°42'12.480415"N121°36'45.041879"W86.69490.999933985/8" IR W/FHWA ALUM CAP
17296744344.4267918146.628155.66245°42'10.673445"N121°36'41.260597"W85.2570.999933975/8" IR W/FHWA ALUM CAP
17297744310.7257918478.831155.97545°42'10.385838"N121°36'36.573498"W85.56730.999933945/8" IR W/FHWA ALUM CAP
17298744395.4407918884.763154.52545°42'11.277187"N121°36'30.870506"W84.11410.999934055/8" IR W/FHWA ALUM CAP
17299744460.8107919288.419149.61545°42'11.977174"N121°36'25.195797"W79.20010.999934325/8" IR W/FHWA ALUM CAP
17300744496.2567919673.289144.36545°42'12.379131"N121°36'19.779967"W73.94680.999934595/8" IR W/FHWA ALUM CAP
17301744725.2397920281.726139.78645°42'14.721793"N121°36'11.251368"W69.36360.999934915/8" IR W/FHWA ALUM CAP
17302744821.7397920714.122148.18345°42'15.732699"N121°36'05.177533"W77.75730.999934565/8" IR W/FHWA ALUM CAP
17303744839.0397921179.067166.73445°42'15.966016"N121°35'58.629835"W96.3040.999933685/8" IR W/FHWA ALUM CAP
17304744852.8287921588.480181.94745°42'16.157118"N121°35'52.863891"W111.51380.999932965/8" IR W/FHWA ALUM CAP
17305744767.3027921969.062178.81145°42'15.363823"N121°35'47.485169"W108.37350.999933085/8" IR W/FHWA ALUM CAP
17306744860.3527922239.511200.30345°42'16.318650"N121°35'43.692359"W129.86380.999932095/8" IR W/FHWA ALUM CAP
17307744839.6777922574.198217.41545°42'16.159320"N121°35'38.972699"W146.97260.999931275/8" IR W/FHWA ALUM CAP
17308744854.8067922907.510207.06045°42'16.353216"N121°35'34.279244"W136.61460.999931775/8" IR W/FHWA ALUM CAP
17309744903.3007923086.838195.51745°42'16.855898"N121°35'31.761761"W125.07030.999932355/8" IR W/FHWA ALUM CAP
17310745132.8877923085.483191.52745°42'19.122238"N121°35'31.824587"W121.08190.999932645/8" IR W/FHWA ALUM CAP
17311745146.0047923480.496216.18845°42'19.304414"N121°35'26.261298"W145.7390.999931475/8" IR W/FHWA ALUM CAP
17312745122.8547923829.012230.18645°42'19.122294"N121°35'21.346259"W159.73370.999930795/8" IR W/FHWA ALUM CAP
17313745165.1627924254.510245.44945°42'19.596560"N121°35'15.358960"W174.99310.999930095/8" IR W/FHWA ALUM CAP
17314745224.2207924579.554256.35845°42'20.222766"N121°35'10.790225"W185.89980.999929595/8" IR W/FHWA ALUM CAP
17315745338.4717925027.614269.77245°42'21.410104"N121°35'04.498574"W199.31090.999929015/8" IR W/FHWA ALUM CAP
17316745413.7317925297.026279.03945°42'22.188774"N121°35'00.716700"W208.57660.99992865/8" IR W/FHWA ALUM CAP
17317745552.2477925664.080290.72345°42'23.604798"N121°34'55.570920"W220.25890.999928115/8" IR W/FHWA ALUM CAP

Sheet (2)

Sheet Information
Sheet num:D.11Filename0
Sheet name:Sheet (2)c:\pw-work\d0328114\[Mitchell-Hood_River_controlsheet.xlsx]Sheet (2)
Reference:Sheet 2 of 2Time
22-Jun-2020 8:28 PM
Begin Column:ABCDEFGHI

PROJECT : State Trail Mitchell-Hood River DATE OF FIELD WORK :May-June 2017 DATE OF FINAL ADJUSTMENT :June 2017 PROJECT UNITS : International feet

STATE PLANE COORDINATESGEO COORDINATES
43.0POINT
NUMBERNORTHEASTELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTIONNOTE:
17318745719.9957926128.256303.36045°42'25.322165"N121°34'49.062073"W232.89390.999927585/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.
17319745826.5707926742.874307.40745°42'26.455340"N121°34'40.421781"W236.9370.999927445/8" IR W/FHWA ALUM CAP
17320745729.2307927174.316310.44845°42'25.551167"N121°34'34.324203"W239.97340.999927255/8" IR W/FHWA ALUM CAP
17321745659.9537927565.595314.51745°42'24.918673"N121°34'28.797858"W244.03620.999927035/8" IR W/FHWA ALUM CAP
17322745658.7707927936.194322.28745°42'24.955631"N121°34'23.575686"W251.80320.999926665/8" IR W/FHWA ALUM CAP
17323745717.8587928502.211340.05845°42'25.613115"N121°34'15.611217"W269.57090.999925845/8" IR W/FHWA ALUM CAP
17324745834.6807928989.348354.93045°42'26.830103"N121°34'08.768935"W284.44130.999925195/8" IR W/FHWA ALUM CAP
17325746024.3957929627.593389.19845°42'28.786294"N121°33'59.810900"W318.70870.999923645/8" IR W/FHWA ALUM CAP
17326746081.7317929869.947383.31745°42'29.383901"N121°33'56.406582"W312.8270.999923955/8" IR W/FHWA ALUM CAP
17327746264.8017930531.936368.23345°42'31.277309"N121°33'47.112506"W297.73410.999924765/8" IR W/FHWA ALUM CAP
17328746451.1847931176.123359.60945°42'33.200908"N121°33'38.069722"W289.11180.999925265/8" IR W/FHWA ALUM CAP
17329746674.7717931951.644338.04045°42'35.508571"N121°33'27.182960"W267.54470.999926395/8" IR W/FHWA ALUM CAP
17330746884.9087932653.856324.25945°42'37.673720"N121°33'17.326512"W253.76770.999927155/8" IR W/FHWA ALUM CAP
17331747139.1637933268.324321.27945°42'40.262893"N121°33'08.714411"W250.79360.999927415/8" IR W/FHWA ALUM CAP
CRH21744045.6567915031.22399.5880,45°42'07.298489"N121°37'25.096437"W29.20660.9999365ODOT Alum cap
CRH22744560.7977915895.69296.2430,45°42'12.502548"N121°37'13.017375"W25.85630.99993689ODOT Alum cap
CRH23744908.8897921927.258173.12445°42'16.755991"N121°35'48.101263"W102.68780.99993341ODOT Alum cap
CRH24745092.6757923641.719227.47945°42'18.799423"N121°35'23.979505"W157.0280.99993091ODOT Alum cap
PONDER2747040.3247933902.414336.73845°42'39.368586"N121°32'59.760914"W266.25160.99992663NGS Brass Cap
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000
00.0000.0000.000000

PROJECT : State Trail Mitchell-Hood River DATE OF FIELD WORK :May-June 2017 DATE OF FINAL ADJUSTMENT :June 2017

PROJECT UNITS : International feet

STATE PLANE COORDINATESGEO COORDINATES
POINT
NUMBERNORTHEASTELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTION
12259742609.8607905241.684142.16445°41'51.757100"N121°39'42.731664"W71.8580.999933765/8" IR W/FHWA ALUM CAP
12260742666.9267905694.289135.82145°41'52.384673"N121°39'36.366879"W65.5130.999934095/8" IR W/FHWA ALUM CAP
12262742765.3607906509.171126.14745°41'53.471785"N121°39'24.906584"W55.8340.999934605/8" IR W/FHWA ALUM CAP
12263742808.7737906811.594122.17045°41'53.943095"N121°39'20.654739"W51.8550.999934815/8" IR W/FHWA ALUM CAP
12268743121.0497909358.449122.14945°41'57.384062"N121°38'44.836396"W51.8150.999934975/8" IR W/FHWA ALUM CAP
12269743165.6537909735.911125.91945°41'57.877214"N121°38'39.527425"W55.5820.999934815/8" IR W/FHWA ALUM CAP
12272743214.2517911167.659112.53145°41'58.556699"N121°38'19.365832"W42.1790.999935485/8" IR W/FHWA ALUM CAP
12273743129.6887911600.396104.12645°41'57.782056"N121°38'13.252408"W33.7710.999935855/8" IR W/FHWA ALUM CAP
12286744022.0377915732.321153.85645°42'07.161470"N121°37'15.213883"W83.4700.999933905/8" IR W/FHWA ALUM CAP
12287744218.4697915915.337162.62745°42'09.125732"N121°37'12.673704"W92.2390.999933575/8" IR W/FHWA ALUM CAP
17288744859.3887916272.972103.58345°42'15.501891"N121°37'07.759913"W33.1950.999936685/8" IR W/FHWA ALUM CAP
17289744935.4807916587.318103.83945°42'16.296035"N121°37'03.345669"W33.4490.999936705/8" IR W/FHWA ALUM CAP
17290744968.4967916930.406102.93545°42'16.668801"N121°36'58.518031"W32.5420.999936765/8" IR W/FHWA ALUM CAP
17291744965.9427917247.861101.12645°42'16.686867"N121°36'54.044625"W30.7310.999936855/8" IR W/FHWA ALUM CAP
17292744951.1597917618.100100.18445°42'16.591342"N121°36'48.825121"W29.7860.999936895/8" IR W/FHWA ALUM CAP
17293744824.5267917471.555161.99645°42'15.321258"N121°36'50.865318"W91.5980.999933885/8" IR W/FHWA ALUM CAP
17294744710.1327917636.737154.06845°42'14.214428"N121°36'48.515720"W83.6690.999934215/8" IR W/FHWA ALUM CAP
17295744531.1227917880.823157.09745°42'12.480415"N121°36'45.041879"W86.6950.999933985/8" IR W/FHWA ALUM CAP
17296744344.4267918146.628155.66245°42'10.673445"N121°36'41.260597"W85.2570.999933975/8" IR W/FHWA ALUM CAP
17297744310.7257918478.831155.97545°42'10.385838"N121°36'36.573498"W85.5670.999933945/8" IR W/FHWA ALUM CAP
17298744395.447918884.763154.52545°42'11.277187"N121°36'30.870506"W84.11410.999934055/8" IR W/FHWA ALUM CAP
17299744460.817919288.419149.61545°42'11.977174"N121°36'25.195797"W79.20010.999934325/8" IR W/FHWA ALUM CAP
17300744496.2567919673.289144.36545°42'12.379131"N121°36'19.779967"W73.94680.999934595/8" IR W/FHWA ALUM CAP
17301744725.2397920281.726139.78645°42'14.721793"N121°36'11.251368"W69.36360.999934915/8" IR W/FHWA ALUM CAP
17302744821.7397920714.122148.18345°42'15.732699"N121°36'05.177533"W77.75730.999934565/8" IR W/FHWA ALUM CAP
17303744839.0397921179.067166.73445°42'15.966016"N121°35'58.629835"W96.3040.999933685/8" IR W/FHWA ALUM CAP
17304744852.8287921588.48181.94745°42'16.157118"N121°35'52.863891"W111.51380.999932965/8" IR W/FHWA ALUM CAP
17305744767.3027921969.062178.81145°42'15.363823"N121°35'47.485169"W108.37350.999933085/8" IR W/FHWA ALUM CAP
17306744860.3527922239.511200.30345°42'16.318650"N121°35'43.692359"W129.86380.999932095/8" IR W/FHWA ALUM CAP
17307744839.6777922574.198217.41545°42'16.159320"N121°35'38.972699"W146.97260.999931275/8" IR W/FHWA ALUM CAP
17308744854.8067922907.51207.0645°42'16.353216"N121°35'34.279244"W136.61460.999931775/8" IR W/FHWA ALUM CAP
17309744903.37923086.838195.51745°42'16.855898"N121°35'31.761761"W125.07030.999932355/8" IR W/FHWA ALUM CAP
17310745132.8877923085.483191.52745°42'19.122238"N121°35'31.824587"W121.08190.999932645/8" IR W/FHWA ALUM CAP
17311745146.0047923480.496216.18845°42'19.304414"N121°35'26.261298"W145.7390.999931475/8" IR W/FHWA ALUM CAP
17312745122.8547923829.012230.18645°42'19.122294"N121°35'21.346259"W159.73370.999930795/8" IR W/FHWA ALUM CAP
17313745165.1627924254.51245.44945°42'19.596560"N121°35'15.358960"W174.99310.999930095/8" IR W/FHWA ALUM CAP
17314745224.227924579.554256.35845°42'20.222766"N121°35'10.790225"W185.89980.999929595/8" IR W/FHWA ALUM CAP
17315745338.4717925027.614269.77245°42'21.410104"N121°35'04.498574"W199.31090.999929015/8" IR W/FHWA ALUM CAP
17316745413.7317925297.026279.03945°42'22.188774"N121°35'00.716700"W208.57660.999928605/8" IR W/FHWA ALUM CAP
17317745552.2477925664.08290.72345°42'23.604798"N121°34'55.570920"W220.25890.999928115/8" IR W/FHWA ALUM CAP
17318745719.9957926128.256303.3645°42'25.322165"N121°34'49.062073"W232.89390.999927585/8" IR W/FHWA ALUM CAP
17319745826.5707926742.874307.40745°42'26.455340"N121°34'40.421781"W236.9370.999927445/8" IR W/FHWA ALUM CAP
17320745729.2307927174.316310.44845°42'25.551167"N121°34'34.324203"W239.9730.999927255/8" IR W/FHWA ALUM CAP
17321745659.9537927565.595314.51745°42'24.918673"N121°34'28.797858"W244.0360.999927035/8" IR W/FHWA ALUM CAP
17322745658.7707927936.194322.28745°42'24.955631"N121°34'23.575686"W251.8030.999926665/8" IR W/FHWA ALUM CAP
17323745717.8587928502.211340.05845°42'25.613115"N121°34'15.611217"W269.5710.999925845/8" IR W/FHWA ALUM CAP
17324745834.6807928989.348354.93045°42'26.830103"N121°34'08.768935"W284.4410.999925195/8" IR W/FHWA ALUM CAP
17325746024.3957929627.593389.19845°42'28.786294"N121°33'59.810900"W318.7090.999923645/8" IR W/FHWA ALUM CAP
17326746081.7317929869.947383.31745°42'29.383901"N121°33'56.406582"W312.8270.999923955/8" IR W/FHWA ALUM CAP
17327746264.8017930531.936368.23345°42'31.277309"N121°33'47.112506"W297.7340.999924765/8" IR W/FHWA ALUM CAP
17328746451.1847931176.123359.60945°42'33.200908"N121°33'38.069722"W289.1120.999925265/8" IR W/FHWA ALUM CAP
17329746674.7717931951.644338.04045°42'35.508571"N121°33'27.182960"W267.5450.999926395/8" IR W/FHWA ALUM CAP
17330746884.9087932653.856324.25945°42'37.673720"N121°33'17.326512"W253.7680.999927155/8" IR W/FHWA ALUM CAP
17331747139.1637933268.324321.27945°42'40.262893"N121°33'08.714411"W250.7940.999927415/8" IR W/FHWA ALUM CAP
CRH21744045.6567915031.22399.5880,45°42'07.298489"N121°37'25.096437"W29.2070.99993650ODOT Alum cap
CRH22744560.7977915895.69296.2430,45°42'12.502548"N121°37'13.017375"W25.8560.99993689ODOT Alum cap
CRH23744908.8897921927.258173.12445°42'16.755991"N121°35'48.101263"W102.6880.99993341ODOT Alum cap
CRH24745092.6757923641.719227.47945°42'18.799423"N121°35'23.979505"W157.0280.99993091ODOT Alum cap
PONDER2747040.3247933902.414336.73845°42'39.368586"N121°32'59.760914"W266.2520.99992663NGS Brass Cap

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