or-a1902511_control-points.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- OR FLAP DOUGLAS 251(1), Oregon Dunes National Recreation Area ‐ Umpqua Dunes Access Improvements
- Solicitation number
- 69056724B000025
About this file
This Excel file contains survey control point data for the Oregon Dunes-Umpqua Dunes Access Improvements project. The document details 10 survey control points (numbered 21101-21109 and C181) with precise geographic and state plane coordinates, including latitude, longitude, elevation, and combined factor measurements. The survey was conducted in January 2021, finalized in February 2021, and uses the Oregon South SPCS NAD83 2011 coordinate system with orthometric elevations based on the NAVD88 GEOID18 vertical datum.
Each control point is marked with a 5/8" iron rod with an FHWA aluminum cap (except point C181, which has a brass cap), and includes detailed spatial information such as North and East state plane coordinates, elevation, geographic coordinates, and ellipsoid height. The project is associated with Federal Highway Administration Solicitation Number 69056724B000025 for construction improvements at the Oregon Dunes National Recreation Area, specifically focusing on Umpqua Dunes Access Improvements.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Bid Tabulation_OR FLAP DOUGLAS 251(1).pdf | ||
| Bid Summary_OR FLAP DOUGLAS 251(1).pdf | ||
| QA_6-18-2025_2.pdf | ||
| QA_6-18-2025.pdf | ||
| Amendment A002.pdf | ||
| Amendment A001.pdf | ||
| QA_6-16-2025.pdf | ||
| IFB 69056724B000025_OR FLAP DOUGLAS 251(1).pdf | ||
| or-a1902511_earthwork.pdf | ||
| WFLHD Construction Contract Administration_FY 23 V2.pdf | ||
| or-a1902511_plans.pdf | ||
| Physical Data.zip | ZIP file | |
| or-a1902511_superelevation_report_SHD.xlsx | XLSX spreadsheet | |
| or-a1902511_Alignments.pdf | ||
| or-a1902511_escp.pdf | ||
| or-a1902511_XS.pdf |
Show all 16
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: | OR | Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines. | |
| Project: | DOUGLAS 251(1) | ||
| NPS PMIS / |
Drawing No:
| Designed by: | WFLHD Survey | |||
| Date: | 1/1904 | |||
| Checked by: | WFLHD Survey | |||
| Date: | 1/1904 | |||
| First sheet #: | D.16 | 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 | 10 | rows w/data | OK - no spaces in data |
| Max. row/table | 40 | 10 | data rows | Warnings: |
| 40 | rows/table | |||
| PROJECT :Oregon Dunes-Umpqua dunes access improvements |
DATE OF FIELD WORK : January, 2021
PROJECT UNITS : International foot COORDINATE SYSTEM : Oregon South SPCS NAD83 2011
EPOCH DATE : 2010.0000
VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18
Control Finalized: February, 2021
| 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.16 | 3 | 16 | OK | |
| Sheet (2) | Undefined | FALSE | 16 | ||
| Sheet (3) | Undefined | FALSE | 16 | ||
| Sheet (4) | Undefined | FALSE | 16 | ||
| Sheet (5) | Undefined | FALSE | 16 | ||
| Sheet (6) | Undefined | FALSE | 16 | ||
| Sheet (7) | Undefined | FALSE | 16 | ||
| Sheet (8) | Undefined | FALSE | 16 | ||
| Sheet (9) | Undefined | FALSE | 16 | ||
| Sheet (10) | Undefined | FALSE | 16 | ||
| Sheet (11) | Undefined | FALSE | 16 | ||
| Sheet (12) | Undefined | FALSE | 16 | ||
| Sheet (13) | Undefined | FALSE | 16 | ||
| Sheet (14) | Undefined | FALSE | 16 | ||
| Sheet (15) | Undefined | FALSE | 16 | ||
| Sheet (16) | Undefined | FALSE | 16 | ||
| Sheet (17) | Undefined | FALSE | 16 | ||
| Sheet (18) | Undefined | FALSE | 16 | ||
| Sheet (19) | Undefined | FALSE | 16 | ||
| Sheet (20) | Undefined | FALSE | 16 | ||
| Total Sheets: | 1 | 0 | sheets missing |
Revised: 15 June 2015
Sheet
| Sheet Information | ||||||||||||
| Sheet num: | D.16 | Filename | 0 | |||||||||
| Sheet name: | Sheet | C:\MyFiles\Projects_2021\Oregon\Oregon_Dunes\gps\[Oregon_Dunes_Controlsheet.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 9-Dec-2021 9:22 AM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
PROJECT :Oregon Dunes-Umpqua dunes access improvements DATE OF FIELD WORK : January, 2021 PROJECT UNITS : International foot COORDINATE SYSTEM : Oregon South SPCS NAD83 2011
EPOCH DATE : 2010.0000
VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18 Control Finalized: February, 2021
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||||||||
| 3.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| 21101 | 753517.066 | 3948250.977 | 16.578 | 43°40'32.012882"N | 124°10'44.685785"W | -66.3428 | 0.999936892 | 5/8" IR W/FHWA ALUM CAP | 1. | 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. | |||||
| 21102 | 753626.861 | 3947513.844 | 13.544 | 43°40'32.776390"N | 124°10'54.772451"W | -69.4357 | 0.9999370726 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21103 | 753557.278 | 3945842.767 | 18.357 | 43°40'31.363814"N | 124°11'17.448335"W | -64.7569 | 0.9999367883 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21104 | 752943.273 | 3945248.318 | 16.806 | 43°40'25.046838"N | 124°11'25.161501"W | -66.3555 | 0.9999365942 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21105 | 752218.010 | 3944673.951 | 19.418 | 43°40'17.640669"N | 124°11'32.534510"W | -63.7884 | 0.9999361554 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21106 | 751531.568 | 3944213.153 | 17.358 | 43°40'10.666876"N | 124°11'38.386553"W | -65.8846 | 0.9999359592 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21107 | 751087.339 | 3943295.032 | 19.205 | 43°40'05.883620"N | 124°11'50.599923"W | -64.1134 | 0.9999356719 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21108 | 750637.435 | 3943053.360 | 15.129 | 43°40'01.339043"N | 124°11'53.614699"W | -68.2086 | 0.9999356756 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21109 | 750358.656 | 3942661.526 | 14.624 | 43°39'58.417447"N | 124°11'58.773209"W | -68.7462 | 0.9999355781 | 5/8" IR W/FHWA ALUM CAP | |||||||
| C181 | 753676.075 | 3946324.678 | 15.603 | 43°40'32.745485"N | 124°11'10.968133"W | -67.4724 | 0.9999369774 | Brass cap | |||||||
| 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 | |||||||||
| 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 |
PROJECT :Oregon Dunes-Umpqua dunes access improvements DATE OF FIELD WORK : January, 2021
PROJECT UNITS : International foot COORDINATE SYSTEM : Oregon South SPCS NAD83 2011
EPOCH DATE : 2010.0000
VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18
Control Finalized: February, 2021
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| 21101 | 753517.066 | 3948250.977 | 16.578 | 43°40'32.012882"N | 124°10'44.685785"W | -66.343 | 0.99993689 | 5/8" IR W/FHWA ALUM CAP | |
| 21102 | 753626.861 | 3947513.844 | 13.544 | 43°40'32.776390"N | 124°10'54.772451"W | -69.436 | 0.99993707 | 5/8" IR W/FHWA ALUM CAP | |
| 21103 | 753557.278 | 3945842.767 | 18.357 | 43°40'31.363814"N | 124°11'17.448335"W | -64.757 | 0.99993679 | 5/8" IR W/FHWA ALUM CAP | |
| 21104 | 752943.273 | 3945248.318 | 16.806 | 43°40'25.046838"N | 124°11'25.161501"W | -66.356 | 0.99993659 | 5/8" IR W/FHWA ALUM CAP | |
| 21105 | 752218.010 | 3944673.951 | 19.418 | 43°40'17.640669"N | 124°11'32.534510"W | -63.788 | 0.99993616 | 5/8" IR W/FHWA ALUM CAP | |
| 21106 | 751531.568 | 3944213.153 | 17.358 | 43°40'10.666876"N | 124°11'38.386553"W | -65.885 | 0.99993596 | 5/8" IR W/FHWA ALUM CAP | |
| 21107 | 751087.339 | 3943295.032 | 19.205 | 43°40'05.883620"N | 124°11'50.599923"W | -64.113 | 0.99993567 | 5/8" IR W/FHWA ALUM CAP | |
| 21108 | 750637.435 | 3943053.360 | 15.129 | 43°40'01.339043"N | 124°11'53.614699"W | -68.209 | 0.99993568 | 5/8" IR W/FHWA ALUM CAP | |
| 21109 | 750358.656 | 3942661.526 | 14.624 | 43°39'58.417447"N | 124°11'58.773209"W | -68.746 | 0.99993558 | 5/8" IR W/FHWA ALUM CAP | |
| C181 | 753676.075 | 3946324.678 | 15.603 | 43°40'32.745485"N | 124°11'10.968133"W | -67.472 | 0.99993698 | Brass cap |
File details come from the government source that posted it. Updated .