olym115-1_control-points.xlsx
XLSX spreadsheet 43 KB Posted
- Solicitation number
- 69056725B000015
About this file
This Excel file is a Survey Control Point List for a National Park Service (NPS) project to repair storm damage on Mora Road in Olympic National Park, Washington. The document contains precise geospatial survey data for 20 control points, including state plane coordinates, geographic coordinates, elevations, and combined factors. Each control point is marked with a 5/8" iron rod with an FHWA aluminum cap, with point numbers ranging from 19101 to 23307, and two additional points labeled RIALTO1 and RIALTO2.
The survey was conducted with Washington North State Plane Coordinate System (NAD83 2011), using orthometric elevations based on NAVD88 GEOID18, with an epoch date of 2010. The project's coordinate system is WA83/2011-NF NSRS11, using US Survey Feet as the project units. The final survey adjustment date was 5/4/2023, with multiple field work dates, suggesting a comprehensive geospatial mapping effort to support the storm damage repair project on Mora Road.
View the file
Other files
Show all 27
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: | Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines. | ||
| Project: | WA NP OLYM 115(1) | ||
| NPS PMIS / |
Drawing No:
| Designed by: | WFLHD_Survey | |||
| Date: | 1/1904 | |||
| Checked by: | WFLHD_Survey | |||
| Date: | 1/1904 | |||
| First sheet #: | D.1 | 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 | 21 | rows w/data | OK - no spaces in data |
| Max. row/table | 40 | 21 | data rows | Warnings: |
| 40 | rows/table | |||
| PROJECT :Repair Storm Damage on Mora Road |
DATE OF FIELD WORK :Multiple entries
DATE OF FINAL ADJUSTMENT : 5/4/2023
COORDINATE SYSTEM : Washington North SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18
EPOCH DATE : 2010.0000
CADD COORDINATE SYSTEM : WA83/2011-NF NSRS11(NAD83/2011) Washington, North Zone, US Foot
PROJECT UNITS : US Survey Foot
| 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.1 | 3 | 1 | OK | |
| Sheet (2) | Undefined | FALSE | 1 | ||
| Sheet (3) | Undefined | FALSE | 1 | ||
| Sheet (4) | Undefined | FALSE | 1 | ||
| Sheet (5) | Undefined | FALSE | 1 | ||
| Sheet (6) | Undefined | FALSE | 1 | ||
| Sheet (7) | Undefined | FALSE | 1 | ||
| Sheet (8) | Undefined | FALSE | 1 | ||
| Sheet (9) | Undefined | FALSE | 1 | ||
| Sheet (10) | Undefined | FALSE | 1 | ||
| Sheet (11) | Undefined | FALSE | 1 | ||
| Sheet (12) | Undefined | FALSE | 1 | ||
| Sheet (13) | Undefined | FALSE | 1 | ||
| Sheet (14) | Undefined | FALSE | 1 | ||
| Sheet (15) | Undefined | FALSE | 1 | ||
| Sheet (16) | Undefined | FALSE | 1 | ||
| Sheet (17) | Undefined | FALSE | 1 | ||
| Sheet (18) | Undefined | FALSE | 1 | ||
| Sheet (19) | Undefined | FALSE | 1 | ||
| Sheet (20) | Undefined | FALSE | 1 | ||
| Total Sheets: | 1 | 0 | sheets missing |
Revised: 15 June 2015
Sheet
| Sheet Information | ||||||||||||
| Sheet num: | D.1 | Filename | 0 | |||||||||
| Sheet name: | Sheet | C:\MyFiles\Projects_2023\Washington\Rialto_Beach_Mora Road\field\Infinity\Mora_rd_Rialto_Beach_allcontrol\Exported Data\[Mora_rd_Rialto_Beach_controlsheet.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 24-Jul-2023 8:43 AM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
PROJECT :Repair Storm Damage on Mora Road DATE OF FIELD WORK :Multiple entries DATE OF FINAL ADJUSTMENT : 5/4/2023 COORDINATE SYSTEM : Washington North SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18
EPOCH DATE : 2010.0000
CADD COORDINATE SYSTEM : WA83/2011-NF NSRS11(NAD83/2011) Washington, North Zone, US Foot PROJECT UNITS : US Survey Foot
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||||||||
| 3.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| 19101 | 358659.096 | 714008.203 | 22.685 | 47°55'15.122518"N | 124°36'47.187173"W | -53.7628 | 0.9999507099 | 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. | |||||
| 19102 | 358699.481 | 713786.898 | 31.961 | 47°55'15.413360"N | 124°36'50.461616"W | -44.4907 | 0.9999502622 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 19112 | 359097.946 | 709998.935 | 34.168 | 47°55'17.501504"N | 124°37'46.298167"W | -42.3572 | 0.9999501257 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23101 | 358147.775 | 714801.256 | 22.148 | 47°55'10.466385"N | 124°36'35.189171"W | -54.2974 | 0.999950813 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23102 | 358174.110 | 714445.176 | 23.889 | 47°55'10.553562"N | 124°36'40.429755"W | -52.5638 | 0.9999507287 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23103 | 358427.204 | 714187.132 | 22.324 | 47°55'12.923388"N | 124°36'44.396146"W | -54.127 | 0.9999507639 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23201 | 358769.376 | 709205.726 | 36.155 | 47°55'13.876577"N | 124°37'57.692106"W | -40.4 | 0.9999500923 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23202 | 358789.343 | 708945.149 | 29.213 | 47°55'13.946465"N | 124°38'01.527732"W | -47.3475 | 0.999950423 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23203 | 358733.986 | 708488.032 | 16.544 | 47°55'13.178052"N | 124°38'08.190844"W | -60.0291 | 0.9999510416 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23204 | 358848.638 | 707979.361 | 13.816 | 47°55'14.060185"N | 124°38'15.733234"W | -62.7653 | 0.9999511576 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23205 | 359224.467 | 707840.335 | 16.285 | 47°55'17.696960"N | 124°38'18.044653"W | -60.2868 | 0.9999509789 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23206 | 358502.191 | 707849.055 | 24.048 | 47°55'10.581672"N | 124°38'17.392681"W | -52.5481 | 0.9999507275 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23301 | 358741.738 | 713576.354 | 32.180 | 47°55'15.727845"N | 124°36'53.579614"W | -44.2752 | 0.9999502467 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23302 | 358823.496 | 712926.920 | 15.451 | 47°55'16.218821"N | 124°37'03.162244"W | -61.0166 | 0.9999510383 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23303 | 358945.353 | 712502.679 | 23.126 | 47°55'17.214144"N | 124°37'09.471520"W | -53.3474 | 0.9999506554 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23304 | 359075.083 | 712272.576 | 23.859 | 47°55'18.381230"N | 124°37'12.939579"W | -52.6155 | 0.9999506012 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23305 | 359392.902 | 711689.306 | 17.311 | 47°55'21.230794"N | 124°37'21.722718"W | -59.1666 | 0.9999508671 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23306 | 359472.840 | 710914.138 | 15.959 | 47°55'21.642051"N | 124°37'33.148266"W | -60.5322 | 0.9999509256 | 5/8” IR w/FHWA ALUM CAP | |||||||
| 23307 | 359462.506 | 710526.525 | 13.148 | 47°55'21.351702"N | 124°37'38.825085"W | -63.3525 | 0.9999510651 | 5/8” IR w/FHWA ALUM CAP | |||||||
| RIALTO1 | 358911.430 | 709826.182 | 35.066 | 47°55'15.578913"N | 124°37'48.696451"W | -41.4696 | 0.9999501151 | 5/8” IR w/FHWA ALUM CAP | |||||||
| RIALTO2 | 358850.538 | 709732.383 | 33.953 | 47°55'14.933035"N | 124°37'50.027858"W | -42.5869 | 0.9999501792 | 5/8” IR w/FHWA ALUM 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 |
PROJECT :Repair Storm Damage on Mora Road DATE OF FIELD WORK :Multiple entries
DATE OF FINAL ADJUSTMENT : 5/4/2023
COORDINATE SYSTEM : Washington North SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 GEOID18
EPOCH DATE : 2010.0000
CADD COORDINATE SYSTEM : WA83/2011-NF NSRS11(NAD83/2011) Washington, North Zone, US Foot
PROJECT UNITS : US Survey Foot
| PROJECT COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| 19101 | 358659.096 | 714008.203 | 22.685 | 47°55'15.122518"N | 124°36'47.187173"W | -53.763 | 0.99995071 | 5/8” IR w/FHWA ALUM CAP | |
| 19102 | 358699.481 | 713786.898 | 31.961 | 47°55'15.413360"N | 124°36'50.461616"W | -44.491 | 0.99995026 | 5/8” IR w/FHWA ALUM CAP | |
| 19112 | 359097.946 | 709998.935 | 34.168 | 47°55'17.501504"N | 124°37'46.298167"W | -42.357 | 0.99995013 | 5/8” IR w/FHWA ALUM CAP | |
| 23101 | 358147.775 | 714801.256 | 22.148 | 47°55'10.466385"N | 124°36'35.189171"W | -54.297 | 0.99995081 | 5/8” IR w/FHWA ALUM CAP | |
| 23102 | 358174.110 | 714445.176 | 23.889 | 47°55'10.553562"N | 124°36'40.429755"W | -52.564 | 0.99995073 | 5/8” IR w/FHWA ALUM CAP | |
| 23103 | 358427.204 | 714187.132 | 22.324 | 47°55'12.923388"N | 124°36'44.396146"W | -54.127 | 0.99995076 | 5/8” IR w/FHWA ALUM CAP | |
| 23201 | 358769.376 | 709205.726 | 36.155 | 47°55'13.876577"N | 124°37'57.692106"W | -40.400 | 0.99995009 | 5/8” IR w/FHWA ALUM CAP | |
| 23202 | 358789.343 | 708945.149 | 29.213 | 47°55'13.946465"N | 124°38'01.527732"W | -47.348 | 0.99995042 | 5/8” IR w/FHWA ALUM CAP | |
| 23203 | 358733.986 | 708488.032 | 16.544 | 47°55'13.178052"N | 124°38'08.190844"W | -60.029 | 0.99995104 | 5/8” IR w/FHWA ALUM CAP | |
| 23204 | 358848.638 | 707979.361 | 13.816 | 47°55'14.060185"N | 124°38'15.733234"W | -62.765 | 0.99995116 | 5/8” IR w/FHWA ALUM CAP | |
| 23205 | 359224.467 | 707840.335 | 16.285 | 47°55'17.696960"N | 124°38'18.044653"W | -60.287 | 0.99995098 | 5/8” IR w/FHWA ALUM CAP | |
| 23206 | 358502.191 | 707849.055 | 24.048 | 47°55'10.581672"N | 124°38'17.392681"W | -52.548 | 0.99995073 | 5/8” IR w/FHWA ALUM CAP | |
| 23301 | 358741.738 | 713576.354 | 32.180 | 47°55'15.727845"N | 124°36'53.579614"W | -44.275 | 0.99995025 | 5/8” IR w/FHWA ALUM CAP | |
| 23302 | 358823.496 | 712926.920 | 15.451 | 47°55'16.218821"N | 124°37'03.162244"W | -61.017 | 0.99995104 | 5/8” IR w/FHWA ALUM CAP | |
| 23303 | 358945.353 | 712502.679 | 23.126 | 47°55'17.214144"N | 124°37'09.471520"W | -53.347 | 0.99995066 | 5/8” IR w/FHWA ALUM CAP | |
| 23304 | 359075.083 | 712272.576 | 23.859 | 47°55'18.381230"N | 124°37'12.939579"W | -52.616 | 0.99995060 | 5/8” IR w/FHWA ALUM CAP | |
| 23305 | 359392.902 | 711689.306 | 17.311 | 47°55'21.230794"N | 124°37'21.722718"W | -59.167 | 0.99995087 | 5/8” IR w/FHWA ALUM CAP | |
| 23306 | 359472.840 | 710914.138 | 15.959 | 47°55'21.642051"N | 124°37'33.148266"W | -60.532 | 0.99995093 | 5/8” IR w/FHWA ALUM CAP | |
| 23307 | 359462.506 | 710526.525 | 13.148 | 47°55'21.351702"N | 124°37'38.825085"W | -63.353 | 0.99995107 | 5/8” IR w/FHWA ALUM CAP | |
| RIALTO1 | 358911.430 | 709826.182 | 35.066 | 47°55'15.578913"N | 124°37'48.696451"W | -41.470 | 0.99995012 | 5/8” IR w/FHWA ALUM CAP | |
| RIALTO2 | 358850.538 | 709732.383 | 33.953 | 47°55'14.933035"N | 124°37'50.027858"W | -42.5869 | 0.99995018 | 5/8” IR w/FHWA ALUM CAP |
File details come from the government source that posted it. Updated .