AK_FNSB_Tanana_controlsheet.xlsx

XLSX spreadsheet 42 KB Posted

Attached to
AK FNSB TANANA(1), Tanana River Recreation Access Improvements
Solicitation number
69056722B000024
Issued by

About this file

This document contains survey control point data and coordinates for the Tanana River Recreation Access Improvements project. The Excel file lists 14 survey control points established in 2020 by the Alaska Department of Transportation and Public Facilities for the project. Point identifiers, northing and easting coordinates, elevations, latitude and longitude values, ellipsoid heights, and descriptions are provided for each control point. The project is located along the Tanana River in Fairbanks North Star Borough, Alaska and uses the Fairbanks Low Distortion projection within the NAD83 2011 datum for coordinates. Invitation for Bid 69056722B000024 was issued by the Federal Highway Administration for the Tanana River Recreation Access Improvements project and references the included survey control point data and plans.

View the file

Other files

Show all 28

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

Drawing No:

Designed by:ADOT&PF
Date:1/1904
Checked by:ADOT&PF
Date:1/1904
First sheet #:D.141.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:Sheet16rows w/dataOK - no spaces in data
Max. row/table4016data rowsWarnings:
40rows/table
PROJECT :Tanana River Recreation Access Improvements

DATE OF FIELD WORK : May/June 2020

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Fairbanks LDP, NAD83 2011

EPOCH DATE :2010.000

VERTICAL DATUM : NAVD88 NAVD88 (OPUS+Geoid12A)

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

Revised: 15 June 2015

Sheet

Sheet Information
Sheet num:D.14Filename0
Sheet name:SheetC:\MyFiles\Projects_2022\Alaska\Tanana\[AK_FNSB_Tanana_controlsheet_update.xlsx]Sheet
Reference:Time
2-Sep-2022 7:02 AM
Begin Column:ABCDEFGHI

PROJECT :Tanana River Recreation Access Improvements DATE OF FIELD WORK : May/June 2020

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Fairbanks LDP, NAD83 2011

3.0POINT
NUMBERNORTHEASTELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTIONNOTE:
1181283.760672785.310438.470N64°47'47.732886"W147°44'56.638107"469.5135N/APRIMS CP11.This Project is located within the the Fairbanks Low Distortion projection (LDP). A low distortion projection created by the Alaska Department of Transportation and Public Facilities
2181299.040673481.640439.970N64°47'47.971340"W147°44'40.570210"471.0116N/ASPIKE CP2
20101185195.070673508.160441.050N64°48'26.315135"W147°44'41.110976"472.0614N/AREBAR CAP SET 2020
20102184976.720673504.840441.400N64°48'24.165956"W147°44'41.123000"472.4131N/AREBAR CAP SET 2020
20103184657.750673539.260442.540N64°48'21.031346"W147°44'40.233841"473.5555N/AREBAR CAP SET 2020
20104184355.630673505.980440.700N64°48'18.054016"W147°44'40.912835"471.7181N/AREBAR CAP SET 2020
20105184061.410673508.770439.450N64°48'15.158977"W147°44'40.761339"470.4705N/AREBAR CAP SET 2020
20106183796.950673527.610439.240N64°48'12.558829"W147°44'40.248104"470.2625N/AREBAR CAP SET 2020
20107183449.690673551.040451.940N64°48'09.144459"W147°44'39.604393"482.9604N/ARBCS CP20107 S14
20108182987.050673564.030441.160N64°48'04.593272"W147°44'39.167701"472.189N/AREBAR CAP SET 2020
20109182639.720673467.990440.670N64°48'01.163117"W147°44'41.282039"471.7025N/AREBAR CAP SET 2020
20110182269.250673437.390438.340N64°47'57.513496"W147°44'41.878764"469.3758N/AREBAR CAP SET 2020
20111182012.830673497.330439.330N64°47'54.997652"W147°44'40.419249"470.3676N/AREBAR CAP SET 2020
20112181512.790673503.900439.490N64°47'50.077603"W147°44'40.119554"470.5284N/AREBAR CAP SET 2020
20113182940.190674093.150447.600N64°48'04.198698"W147°44'26.938847"478.6265N/AREBAR CAP SET 2020
20114182942.240674593.190442.270N64°48'04.281576"W147°44'15.395654"473.2985N/ARBCS S14471 2020
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

Fairbanks LDP Definition:

Linear Unit: US Survey Foot

DATUM: NAD83(2011)

Projection Lambert Conformal Conic (Single Parallel) Standard Parallel and Grid Origin 64 51' 00"N Central Meridian Grid Origin)146 56'00"W False Northing 200,000 SFT False Easting 800,000 SFT Standard Parallel Scale 1.00003 (exact)

PROJECT :Tanana River Recreation Access Improvements DATE OF FIELD WORK : May/June 2020

PROJECT UNITS : US SURVEY FOOT

COORDINATE SYSTEM : Fairbanks LDP, NAD83 2011

GEO COORDINATES
POINT
NUMBERNORTHEASTELEVATIONLATITUDELONGITUDEELLIPSOID
HEIGHTCOMBINED
FACTORDESCRIPTION
1181283.760672785.310438.470N64°47'47.732886"W147°44'56.638107"469.514N/APRIMS CP1
2181299.040673481.640439.970N64°47'47.971340"W147°44'40.570210"471.012N/ASPIKE CP2
20101185195.070673508.160441.050N64°48'26.315135"W147°44'41.110976"472.061N/AREBAR CAP SET 2020
20102184976.720673504.840441.400N64°48'24.165956"W147°44'41.123000"472.413N/AREBAR CAP SET 2020
20103184657.750673539.260442.540N64°48'21.031346"W147°44'40.233841"473.556N/AREBAR CAP SET 2020
20104184355.630673505.980440.700N64°48'18.054016"W147°44'40.912835"471.718N/AREBAR CAP SET 2020
20105184061.410673508.770439.450N64°48'15.158977"W147°44'40.761339"470.471N/AREBAR CAP SET 2020
20106183796.950673527.610439.240N64°48'12.558829"W147°44'40.248104"470.263N/AREBAR CAP SET 2020
20107183449.690673551.040451.940N64°48'09.144459"W147°44'39.604393"482.960N/ARBCS CP20107 S14
20108182987.050673564.030441.160N64°48'04.593272"W147°44'39.167701"472.189N/AREBAR CAP SET 2020
20109182639.720673467.990440.670N64°48'01.163117"W147°44'41.282039"471.703N/AREBAR CAP SET 2020
20110182269.250673437.390438.340N64°47'57.513496"W147°44'41.878764"469.376N/AREBAR CAP SET 2020
20111182012.830673497.330439.330N64°47'54.997652"W147°44'40.419249"470.368N/AREBAR CAP SET 2020
20112181512.790673503.900439.490N64°47'50.077603"W147°44'40.119554"470.528N/AREBAR CAP SET 2020
20113182940.190674093.150447.600N64°48'04.198698"W147°44'26.938847"478.627N/AREBAR CAP SET 2020
20114182942.240674593.190442.270N64°48'04.281576"W147°44'15.395654"473.299N/ARBCS S14471 2020

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