wa-a2015025_control_points.xlsx
XLSX spreadsheet 181 KB Posted
- Attached to
- WA PACIFIC 2015(2) Public Access Enhancement to Willapa National Wildlife Refuge Phase II
- Solicitation number
- 69056721B000010
About this file
This document contains a survey control point list and associated federal contract opportunity for public access enhancements to the Willapa National Wildlife Refuge Phase II project. The survey control point list includes coordinates for several survey control points in the project area formatted for inclusion in design plans. It notes the coordinate system used and process for scaling the combined mapping coordinates. The related federal contract opportunity is solicitation number 69056721B000010 from the Department of Transportation Federal Highway Administration seeking proposals to improve public access at the Willapa National Wildlife Refuge as part of the second phase of that project. No further details are provided on the products, services, response dates or other terms of the opportunity in the attached documents.
View the file
Other files
Show all 26
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: | WA | Note: If there is more than one project number, use <ALT><ENTER> to insert page break for additional lines. | |
| Project: | PACIFIC 2015(2) | ||
| NPS PMIS / |
Drawing No:
| Designed by: | Pacific County and PAX | |||
| Date: | 1/1904 | |||
| Checked by: | WFLHD Survey | |||
| Date: | 1/1904 | |||
| First sheet #: | D.8 | 1.0 | ||
| Title block text: | SURVEY CONTROL | |||
| Show Totals? | TRUE | |||
| Data location: | Assumed Data | Worksheet found | ||
| Data begins in col: | A | |||
| Min. rows/table | 5 | 3.0 | ||
| Base sheet name: | Sheet | 7 | rows w/data | OK - No spaces in data |
| Max. row/table | 36 | 7 | data rows | Warnings: |
| 36 | rows/table | |||
| PROJECT : Willapa National Wildlife Refuge phase II |
DATE OF FIELD WORK :Multiple Entries
PROJECT UNITS : US SURVEY FOOT
COORDINATE SYSTEM : Assumed (scaled to project datum) VERTICAL DATUM : Based on NAVD88 GEOID12b
| Sheet Names | |||||
| Input the names of the worksheets in the order you would like the sheets numbered. | |||||
| Worksheet Name | Sheet | Header1 row | Header2 row | Sheet Number | Notes |
| Sheet | D.8 | 3 | FALSE | 8 | OK |
| Sheet (2) | Undefined | FALSE | FALSE | 8 | |
| Sheet (3) | Undefined | FALSE | FALSE | 8 | |
| Sheet (4) | Undefined | FALSE | FALSE | 8 | |
| Sheet (5) | Undefined | FALSE | FALSE | 8 | |
| Sheet (6) | Undefined | FALSE | FALSE | 8 | |
| Sheet (7) | Undefined | FALSE | FALSE | 8 | |
| Sheet (8) | Undefined | FALSE | FALSE | 8 | |
| Sheet (9) | Undefined | FALSE | FALSE | 8 | |
| Sheet (10) | Undefined | FALSE | FALSE | 8 | |
| Sheet (11) | Undefined | FALSE | FALSE | 8 | |
| Sheet (12) | Undefined | FALSE | FALSE | 8 | |
| Sheet (13) | Undefined | FALSE | FALSE | 8 | |
| Sheet (14) | Undefined | FALSE | FALSE | 8 | |
| Sheet (15) | Undefined | FALSE | FALSE | 8 | |
| Sheet (16) | Undefined | FALSE | FALSE | 8 | |
| Sheet (17) | Undefined | FALSE | FALSE | 8 | |
| Sheet (18) | Undefined | FALSE | FALSE | 8 | |
| Sheet (19) | Undefined | FALSE | FALSE | 8 | |
| Sheet (20) | Undefined | FALSE | FALSE | 8 | |
| Total Sheets: | 1 | 0 | sheets missing |
Revised: 15 June 2015
Sheet
| Sheet Information | |||||||||||||
| Sheet num: | D.8 | Filename | |||||||||||
| Sheet name: | Sheet | C:\MyFiles\Projects_2020\Washington\Willapa_Refuge\9-21-2020_entry\control sheet\[WA_Pacific_2015(2)_controlsheet.xlsx]Sheet | |||||||||||
| Reference: | Time | ||||||||||||
| 15-Dec-2020 4:08 PM | |||||||||||||
| Begin Column: | A | B | C | D | E | A | B | C | D | E |
PROJECT : Willapa National Wildlife Refuge phase II DATE OF FIELD WORK :Multiple Entries
PROJECT UNITS : US SURVEY FOOT
| PROJECT COORDINATES | ||||||||||
| 3.0 | POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | DESCRIPTION | FALSE | |||||
| 52 | 394261.591 | 757689.780 | 9.844 | REBAR & CAP | ||||||
| 53 | 393749.810 | 756059.498 | 60.465 | REBAR & CAP | ||||||
| 5042 | 393689.171 | 757283.287 | 10.783 | REBAR & CAP | ||||||
| 5111 | 393123.545 | 756954.773 | 51.977 | CP | ||||||
| 5173 | 394914.001 | 758658.926 | 10.267 | 5/8" IR W/YPC | ||||||
| 5305 | 394821.666 | 757962.468 | 9.086 | REBAR & CAP | ||||||
| Hub1 | 394978.562 | 758660.110 | 10.629 | pk nail | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 | ||||||
| 0 | 0.000 | 0.000 | 0.000 | 0 |
Assumed Data PROJECT : Willapa National Wildlife Refuge phase II DATE OF FIELD WORK :Multiple Entries
PROJECT UNITS : US SURVEY FOOT
| PROJECT COORDINATES | |||||
| POINT | |||||
| NUMBER | NORTH | EAST | ELEVATION | DESCRIPTION | |
| 52 | 394261.591 | 757689.780 | 9.844 | REBAR & CAP | |
| 53 | 393749.810 | 756059.498 | 60.465 | REBAR & CAP | |
| 5042 | 393689.171 | 757283.287 | 10.783 | REBAR & CAP | |
| 5111 | 393123.545 | 756954.773 | 51.977 | CP | |
| 5173 | 394914.001 | 758658.926 | 10.267 | 5/8" IR W/YPC | |
| 5305 | 394821.666 | 757962.468 | 9.086 | REBAR & CAP | |
| Hub1 | 394978.562 | 758660.110 | 10.629 | pk nail |
The coordinates resemble State Plane coordinates, but have been scaled.
Process: Scaled the Combined mapping to ground to match the ROW mapping done by (PMX?). scaled the map (project) by using 1.000074556 for the northing and eastings, then manually moved the coordinates to match the “pinned”point J306 which remained using State plane coordinates. This was done by referencing different maps in Microstation seet he control sheet ACAD-67TH ST 6-15-17_controlsheet.xlsx for original SPCS coords image1.jpeg
File details come from the government source that posted it. Updated .