crla201801_control-points.xlsx
XLSX spreadsheet 41 KB Posted
- Solicitation number
- 69056723R000010
About this file
This Excel file contains a Survey Control point list for the Cleetwood Trail project at Crater Lake National Park, Oregon. The document provides detailed geospatial data for 14 survey control points, including state plane coordinates, geographic coordinates, elevations, and point descriptions. Each point is marked with a 2" aluminum cap on a 5/8" rebar, with precise latitude and longitude measurements. The survey was conducted in October 2016, using the Oregon South State Plane Coordinate System (NAD83 2011) and NGVD29 vertical datum. The project is associated with NPS PMIS No. 264912 and NPS Drawing No. 186271, with coordinate measurements using International Foot units and a combined scale factor of 0.99959236.
View the file
Other files
Show all 38
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: | NPS CRLA 2018(1) | |||
| NPS PMIS / | ||||
| Drawing No: | NPS PMIS No. 264912 |
NPS Drwg. No. 186271
| Designed by: | NPS | |||
| 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 | 14 | rows w/data | OK - no spaces in data |
| Max. row/table | 40 | 14 | data rows | Warnings: |
| 40 | rows/table | |||
| PROJECT :Cleetwood Tral |
DATE OF FIELD WORK : 10/2016
PROJECT UNITS :International Foot COORDINATE SYSTEM : Oregon south SPCS NAD83 2011
EPOCH DATE : 2010.0000
VERTICAL DATUM : NGVD29 based on USGS lake Level gauge 11492200
| 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:\pw-work\d0382103\[crla201801_Survey Control_D.01.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 19-Nov-2024 11:47 AM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
PROJECT :Cleetwood Tral
DATE OF FIELD WORK : 10/2016
PROJECT UNITS :International Foot COORDINATE SYSTEM : Oregon south SPCS NAD83 2011
| STATE PLANE COORDINATES | GEO COORDINATES | |||||||||||||
| 3.0 | POINT | |||||||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | Description | NOTE: | |||||||
| 1 | 482528.476 | 4497684.789 | 6823.930 | 42°58'46.91143"N | 122°04'58.99566"W | 2" Alum cap on 5/8" Rebar | 1. | To precisely check distances between points as measured on the ground, inverse the state plane coordinates and divide the computed distance by .99959236, the calculated average combined scale factor for project. | ||||||
| 2 | 482406.691 | 4497516.203 | 6775.556 | 42°58'45.67714"N | 122°05'01.23238"W | 2" Alum cap on 5/8" Rebar | ||||||||
| 3 | 482308.440 | 4497457.161 | 6700.611 | 42°58'44.69575"N | 122°05'02.00157"W | 2" Alum cap on 5/8" Rebar | ||||||||
| 4 | 482259.138 | 4496880.444 | 6622.715 | 42°58'44.10101"N | 122°05'09.74653"W | 2" Alum cap on 5/8" Rebar | ||||||||
| 5 | 482106.562 | 4496508.041 | 6548.977 | 42°58'42.52442"N | 122°05'14.71686"W | 2" Alum cap on 5/8" Rebar | ||||||||
| 6 | 481537.746 | 4496002.240 | 6429.056 | 42°58'36.81180"N | 122°05'21.37519"W | 2" Alum cap on 5/8" Rebar | ||||||||
| 7 | 481519.985 | 4496007.129 | 6415.552 | 42°58'36.63731"N | 122°05'21.30489"W | 2" Alum cap on 5/8" Rebar | ||||||||
| 8 | 481860.867 | 4496490.406 | 6380.225 | 42°58'40.09453"N | 122°05'14.89141"W | 2" Alum cap on 5/8" Rebar | ||||||||
| 9 | 481879.432 | 4496677.438 | 6367.359 | 42°58'40.31290"N | 122°05'12.38040"W | 2" Alum cap on 5/8" Rebar | ||||||||
| 10 | 481875.275 | 4496770.171 | 6324.975 | 42°58'40.28919"N | 122°05'11.13200"W | 2" Alum cap on 5/8" Rebar | ||||||||
| 11 | 481793.872 | 4496658.638 | 6276.626 | 42°58'39.46435"N | 122°05'12.61147"W | 2" Alum cap on 5/8" Rebar | ||||||||
| 12 | 481347.080 | 4496192.831 | 6182.804 | 42°58'34.96443"N | 122°05'18.76296"W | 2" Alum cap on 5/8" Rebar | ||||||||
| 13 | 481183.286 | 4495971.884 | 6193.471 | 42°58'33.30533"N | 122°05'21.69300"W | 2" Alum cap on 5/8" Rebar | ||||||||
| 14 | 481146.977 | 4495986.936 | 6192.328 | 42°58'32.94954"N | 122°05'21.48128"W | 2" Alum cap on 5/8" Rebar | ||||||||
| 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 :Cleetwood Tral
DATE OF FIELD WORK : 10/2016
PROJECT UNITS :International Foot COORDINATE SYSTEM : Oregon south SPCS NAD83 2011
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| 1 | 482528.476 | 4497684.789 | 6823.930 | 42°58'46.91143"N | 122°04'58.99566"W | N/A | 0.99959236 | 2" Alum cap on 5/8" Rebar | |
| 2 | 482406.691 | 4497516.203 | 6775.556 | 42°58'45.67714"N | 122°05'01.23238"W | N/A | 0.99959236 | 2" Alum cap on 5/8" Rebar | |
| 3 | 482308.440 | 4497457.161 | 6700.611 | 42°58'44.69575"N | 122°05'02.00157"W | N/A | 0.99959236 | 2" Alum cap on 5/8" Rebar | |
| 4 | 482259.138 | 4496880.444 | 6622.715 | 42°58'44.10101"N | 122°05'09.74653"W | N/A | 0.99959236 | 2" Alum cap on 5/8" Rebar | |
| 5 | 482106.562 | 4496508.041 | 6548.977 | 42°58'42.52442"N | 122°05'14.71686"W | N/A | 0.99959236 | 2" Alum cap on 5/8" Rebar | |
| 6 | 481537.746 | 4496002.240 | 6429.056 | 42°58'36.81180"N | 122°05'21.37519"W | N/A | 0.99959236 | 2" Alum cap on 5/8" Rebar | |
| 7 | 481519.985 | 4496007.129 | 6415.552 | 42°58'36.63731"N | 122°05'21.30489"W | N/A | 0.99959236 | 2" Alum cap on 5/8" Rebar | |
| 8 | 481860.867 | 4496490.406 | 6380.225 | 42°58'40.09453"N | 122°05'14.89141"W | N/A | 0.99959236 | 2" Alum cap on 5/8" Rebar | |
| 9 | 481879.432 | 4496677.438 | 6367.359 | 42°58'40.31290"N | 122°05'12.38040"W | N/A | 0.99959236 | 2" Alum cap on 5/8" Rebar | |
| 10 | 481875.275 | 4496770.171 | 6324.975 | 42°58'40.28919"N | 122°05'11.13200"W | N/A | 0.99959236 | 2" Alum cap on 5/8" Rebar | |
| 11 | 481793.872 | 4496658.638 | 6276.626 | 42°58'39.46435"N | 122°05'12.61147"W | N/A | 0.99959236 | 2" Alum cap on 5/8" Rebar | |
| 12 | 481347.080 | 4496192.831 | 6182.804 | 42°58'34.96443"N | 122°05'18.76296"W | N/A | 0.99959236 | 2" Alum cap on 5/8" Rebar | |
| 13 | 481183.286 | 4495971.884 | 6193.471 | 42°58'33.30533"N | 122°05'21.69300"W | N/A | 0.99959236 | 2" Alum cap on 5/8" Rebar | |
| 14 | 481146.977 | 4495986.936 | 6192.328 | 42°58'32.94954"N | 122°05'21.48128"W | N/A | 0.99959236 | 2" Alum cap on 5/8" Rebar |
File details come from the government source that posted it. Updated .