waa-jeffer150009-1_Control_Point_Coordinates.xlsx

XLSX spreadsheet 41 KB Posted

Attached to
WA FLAP JEFFER 150009(1), Undi Road Bypass Improvements
Solicitation number
69056723B00005
Issued by

About this file

This document package includes an invitation for bid (IFB) for a federal-aid highway project and supporting files. The IFB is for the WA FLAP JEFFER 150009(1) Undi Road Bypass Improvements project to be administered by the Federal Highway Administration. Attached files provide survey control point coordinates, horizontal and vertical alignment profiles, proposed 3D breaklines and finish surfaces for two sites. Bids are due in accordance with standard procurement procedures for an IFB of this type. The project involves construction activities to improve a section of Undi Road.

View the file

Other files

Show all 18

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:WANote: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines.
Project:JEFFERSON 150009(1)
NPS PMIS /

Drawing No:

Designed by:WFLHD Survey
Date:1/1904
Checked by:WFLHD Survey
Date:1/1904
First sheet #:D.101.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/table4013data rowsWarnings:
40rows/table
PROJECT : Undi Road bypass improvements

DATE OF FIELD WORK :Jan-Feb 2020

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Washington North SPCS NAD83 2011 VERTICAL DATUM :Orthometric elevations based on the NAVD88 GEOID18

EPOCH DATE : 2010.0000

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

Revised: 15 June 2015

Sheet

Sheet Information
Sheet num:D.10Filename0
Sheet name:SheetC:\MyFiles\Projects_2020\Washington\Undie_Road\Infinity\[undie_road_controlsheet.xlsx]Sheet
Reference:Time
16-Dec-2020 11:23 AM
Begin Column:ABCDEFGHI

PROJECT : Undi Road bypass improvements DATE OF FIELD WORK :Jan-Feb 2020 PROJECT UNITS : US SURVEY FOOT COORDINATE SYSTEM : Washington North SPCS NAD83 2011

STATE PLANE COORDINATESGEO COORDINATES
3.0POINT
NUMBERNORTHEASTELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTIONNOTE:
20201341177.583779685.544232.44247°52'53.471417"N124°20'32.200299"W157.71530.99994319185/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.
20202341149.757779953.173232.32647°52'53.317455"N124°20'28.259379"W157.61260.99994319985/8" IR W/FHWA ALUM CAP
20203341132.967780261.617238.57547°52'53.290607"N124°20'23.727664"W163.87760.99994290115/8" IR W/FHWA ALUM CAP
20204341119.563780541.858244.92147°52'53.284417"N124°20'19.611551"W170.23820.99994259735/8" IR W/FHWA ALUM CAP
20205341092.258780954.349250.15347°52'53.200545"N124°20'13.547922"W175.49170.99994234815/8" IR W/FHWA ALUM CAP
20208341962.835781774.942408.73847°53'02.151970"N124°20'02.102218"W334.15360.99993459175/8" IR W/FHWA ALUM CAP
20209342011.949782002.070444.03747°53'02.738100"N124°19'58.806061"W369.46750.99993289335/8" IR W/FHWA ALUM CAP
20210342299.829782267.003497.06947°53'05.695152"N124°19'55.114995"W422.52570.99993030075/8" IR W/FHWA ALUM CAP
20211342085.453782472.782530.82247°53'03.673905"N124°19'51.956013"W456.28280.99992872795/8" IR W/FHWA ALUM CAP
20301339448.181786830.863361.00447°52'39.622016"N124°18'46.331355"W286.61950.9999373125/8" IR W/FHWA ALUM CAP
20302339208.648786625.132318.11147°52'37.168651"N124°18'49.187471"W243.70410.99993941175/8" IR W/FHWA ALUM CAP
20303338999.782786483.284291.12647°52'35.046125"N124°18'51.127676"W216.70210.99994074465/8" IR W/FHWA ALUM CAP
20304338948.411786317.167277.77247°52'34.465516"N124°18'53.527971"W203.33620.99994139495/8" IR W/FHWA ALUM 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
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 : Undi Road bypass improvements DATE OF FIELD WORK :Jan-Feb 2020

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Washington North SPCS NAD83 2011

STATE PLANE COORDINATESGEO COORDINATES
POINT
NUMBERNORTHEASTELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTION
20201341177.583779685.544232.44247°52'53.471417"N124°20'32.200299"W157.7150.999943195/8" IR W/FHWA ALUM CAP
20202341149.757779953.173232.32647°52'53.317455"N124°20'28.259379"W157.6130.999943205/8" IR W/FHWA ALUM CAP
20203341132.967780261.617238.57547°52'53.290607"N124°20'23.727664"W163.8780.999942905/8" IR W/FHWA ALUM CAP
20204341119.563780541.858244.92147°52'53.284417"N124°20'19.611551"W170.2380.999942605/8" IR W/FHWA ALUM CAP
20205341092.258780954.349250.15347°52'53.200545"N124°20'13.547922"W175.4920.999942355/8" IR W/FHWA ALUM CAP
20208341962.835781774.942408.73847°53'02.151970"N124°20'02.102218"W334.1540.999934595/8" IR W/FHWA ALUM CAP
20209342011.949782002.070444.03747°53'02.738100"N124°19'58.806061"W369.4680.999932895/8" IR W/FHWA ALUM CAP
20210342299.829782267.003497.06947°53'05.695152"N124°19'55.114995"W422.5260.999930305/8" IR W/FHWA ALUM CAP
20211342085.453782472.782530.82247°53'03.673905"N124°19'51.956013"W456.2830.999928735/8" IR W/FHWA ALUM CAP
20301339448.181786830.863361.00447°52'39.622016"N124°18'46.331355"W286.6200.999937315/8" IR W/FHWA ALUM CAP
20302339208.648786625.132318.11147°52'37.168651"N124°18'49.187471"W243.7040.999939415/8" IR W/FHWA ALUM CAP
20303338999.782786483.284291.12647°52'35.046125"N124°18'51.127676"W216.7020.999940745/8" IR W/FHWA ALUM CAP
20304338948.411786317.167277.77247°52'34.465516"N124°18'53.527971"W203.3360.999941395/8" IR W/FHWA ALUM CAP

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