AK_FNSB_Tanana_controlsheet.xlsx
XLSX spreadsheet 42 KB Posted
- Solicitation number
- 69056722B000024
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: | AK | Note: 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.14 | 1.0 | ||
| Title block text: | SURVEY CONTROL | |||
| Show Totals? | TRUE | |||
| Data location: | Page 1 | Worksheet found | ||
| Data begins in col: | A | |||
| Min. rows/table | 5 | 3.0 | ||
| Base sheet name: | Sheet | 16 | rows w/data | OK - no spaces in data |
| Max. row/table | 40 | 16 | data rows | Warnings: |
| 40 | rows/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 Name | Sheet | Header row | Sheet Number | Notes | |
| Sheet | D.14 | 3 | 14 | OK | |
| Sheet (2) | Undefined | FALSE | 14 | ||
| Sheet (3) | Undefined | FALSE | 14 | ||
| Sheet (4) | Undefined | FALSE | 14 | ||
| Sheet (5) | Undefined | FALSE | 14 | ||
| Sheet (6) | Undefined | FALSE | 14 | ||
| Sheet (7) | Undefined | FALSE | 14 | ||
| Sheet (8) | Undefined | FALSE | 14 | ||
| Sheet (9) | Undefined | FALSE | 14 | ||
| Sheet (10) | Undefined | FALSE | 14 | ||
| Sheet (11) | Undefined | FALSE | 14 | ||
| Sheet (12) | Undefined | FALSE | 14 | ||
| Sheet (13) | Undefined | FALSE | 14 | ||
| Sheet (14) | Undefined | FALSE | 14 | ||
| Sheet (15) | Undefined | FALSE | 14 | ||
| Sheet (16) | Undefined | FALSE | 14 | ||
| Sheet (17) | Undefined | FALSE | 14 | ||
| Sheet (18) | Undefined | FALSE | 14 | ||
| Sheet (19) | Undefined | FALSE | 14 | ||
| Sheet (20) | Undefined | FALSE | 14 | ||
| Total Sheets: | 1 | 0 | sheets missing |
Revised: 15 June 2015
Sheet
| Sheet Information | ||||||||||||
| Sheet num: | D.14 | Filename | 0 | |||||||||
| Sheet name: | Sheet | C:\MyFiles\Projects_2022\Alaska\Tanana\[AK_FNSB_Tanana_controlsheet_update.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 2-Sep-2022 7:02 AM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
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.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| 1 | 181283.760 | 672785.310 | 438.470 | N64°47'47.732886" | W147°44'56.638107" | 469.5135 | N/A | PRIMS CP1 | 1. | 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 | |||||
| 2 | 181299.040 | 673481.640 | 439.970 | N64°47'47.971340" | W147°44'40.570210" | 471.0116 | N/A | SPIKE CP2 | |||||||
| 20101 | 185195.070 | 673508.160 | 441.050 | N64°48'26.315135" | W147°44'41.110976" | 472.0614 | N/A | REBAR CAP SET 2020 | |||||||
| 20102 | 184976.720 | 673504.840 | 441.400 | N64°48'24.165956" | W147°44'41.123000" | 472.4131 | N/A | REBAR CAP SET 2020 | |||||||
| 20103 | 184657.750 | 673539.260 | 442.540 | N64°48'21.031346" | W147°44'40.233841" | 473.5555 | N/A | REBAR CAP SET 2020 | |||||||
| 20104 | 184355.630 | 673505.980 | 440.700 | N64°48'18.054016" | W147°44'40.912835" | 471.7181 | N/A | REBAR CAP SET 2020 | |||||||
| 20105 | 184061.410 | 673508.770 | 439.450 | N64°48'15.158977" | W147°44'40.761339" | 470.4705 | N/A | REBAR CAP SET 2020 | |||||||
| 20106 | 183796.950 | 673527.610 | 439.240 | N64°48'12.558829" | W147°44'40.248104" | 470.2625 | N/A | REBAR CAP SET 2020 | |||||||
| 20107 | 183449.690 | 673551.040 | 451.940 | N64°48'09.144459" | W147°44'39.604393" | 482.9604 | N/A | RBCS CP20107 S14 | |||||||
| 20108 | 182987.050 | 673564.030 | 441.160 | N64°48'04.593272" | W147°44'39.167701" | 472.189 | N/A | REBAR CAP SET 2020 | |||||||
| 20109 | 182639.720 | 673467.990 | 440.670 | N64°48'01.163117" | W147°44'41.282039" | 471.7025 | N/A | REBAR CAP SET 2020 | |||||||
| 20110 | 182269.250 | 673437.390 | 438.340 | N64°47'57.513496" | W147°44'41.878764" | 469.3758 | N/A | REBAR CAP SET 2020 | |||||||
| 20111 | 182012.830 | 673497.330 | 439.330 | N64°47'54.997652" | W147°44'40.419249" | 470.3676 | N/A | REBAR CAP SET 2020 | |||||||
| 20112 | 181512.790 | 673503.900 | 439.490 | N64°47'50.077603" | W147°44'40.119554" | 470.5284 | N/A | REBAR CAP SET 2020 | |||||||
| 20113 | 182940.190 | 674093.150 | 447.600 | N64°48'04.198698" | W147°44'26.938847" | 478.6265 | N/A | REBAR CAP SET 2020 | |||||||
| 20114 | 182942.240 | 674593.190 | 442.270 | N64°48'04.281576" | W147°44'15.395654" | 473.2985 | N/A | RBCS S14471 2020 | |||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 | |||||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | 0 | 0 |
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 | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| 1 | 181283.760 | 672785.310 | 438.470 | N64°47'47.732886" | W147°44'56.638107" | 469.514 | N/A | PRIMS CP1 | |
| 2 | 181299.040 | 673481.640 | 439.970 | N64°47'47.971340" | W147°44'40.570210" | 471.012 | N/A | SPIKE CP2 | |
| 20101 | 185195.070 | 673508.160 | 441.050 | N64°48'26.315135" | W147°44'41.110976" | 472.061 | N/A | REBAR CAP SET 2020 | |
| 20102 | 184976.720 | 673504.840 | 441.400 | N64°48'24.165956" | W147°44'41.123000" | 472.413 | N/A | REBAR CAP SET 2020 | |
| 20103 | 184657.750 | 673539.260 | 442.540 | N64°48'21.031346" | W147°44'40.233841" | 473.556 | N/A | REBAR CAP SET 2020 | |
| 20104 | 184355.630 | 673505.980 | 440.700 | N64°48'18.054016" | W147°44'40.912835" | 471.718 | N/A | REBAR CAP SET 2020 | |
| 20105 | 184061.410 | 673508.770 | 439.450 | N64°48'15.158977" | W147°44'40.761339" | 470.471 | N/A | REBAR CAP SET 2020 | |
| 20106 | 183796.950 | 673527.610 | 439.240 | N64°48'12.558829" | W147°44'40.248104" | 470.263 | N/A | REBAR CAP SET 2020 | |
| 20107 | 183449.690 | 673551.040 | 451.940 | N64°48'09.144459" | W147°44'39.604393" | 482.960 | N/A | RBCS CP20107 S14 | |
| 20108 | 182987.050 | 673564.030 | 441.160 | N64°48'04.593272" | W147°44'39.167701" | 472.189 | N/A | REBAR CAP SET 2020 | |
| 20109 | 182639.720 | 673467.990 | 440.670 | N64°48'01.163117" | W147°44'41.282039" | 471.703 | N/A | REBAR CAP SET 2020 | |
| 20110 | 182269.250 | 673437.390 | 438.340 | N64°47'57.513496" | W147°44'41.878764" | 469.376 | N/A | REBAR CAP SET 2020 | |
| 20111 | 182012.830 | 673497.330 | 439.330 | N64°47'54.997652" | W147°44'40.419249" | 470.368 | N/A | REBAR CAP SET 2020 | |
| 20112 | 181512.790 | 673503.900 | 439.490 | N64°47'50.077603" | W147°44'40.119554" | 470.528 | N/A | REBAR CAP SET 2020 | |
| 20113 | 182940.190 | 674093.150 | 447.600 | N64°48'04.198698" | W147°44'26.938847" | 478.627 | N/A | REBAR CAP SET 2020 | |
| 20114 | 182942.240 | 674593.190 | 442.270 | N64°48'04.281576" | W147°44'15.395654" | 473.299 | N/A | RBCS S14471 2020 |
File details come from the government source that posted it. Updated .