OR DOT 20(3)_Survey_Control_USG.xlsx
XLSX spreadsheet 39 KB Posted
- Solicitation number
- 69056721B000007
About this file
This file contains survey control point data and coordinates for the Upper Sunken Grade Slide Repair project in Oregon. It lists six survey control points by number, northing and easting state plane coordinates, elevation, latitude and longitude, ellipsoid height, and combined factor. It also provides project information including the project name, date of field work, project units in international feet, coordinate system as Oregon North SPCS NAD83 (2011) Epoch 2010.0000, and vertical datum as orthometric elevations based on NAVD88 GEOID12b.
The related federal contract opportunity is solicitation number 69056721B000007 for the OR DOT 20(3)/US 20 Upper Sunken Grade Slide Repair project from the Department of Transportation Federal Highway Administration. The solicitation and documents are attached. The opportunity type is listed as a solicitation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| OR DOT 20(3).pdf | ||
| BidSum OR DOT 20(3).pdf | ||
| QA_06-04-2021_2.pdf | ||
| QA_06-04-2021.pdf | ||
| Amendment A002.pdf | ||
| Amendment A001.pdf | ||
| OR DOT 20(3)_XS_USG.pdf | ||
| OR DOT 20(3)_Earthwork_VolRpt_USG.PDF | ||
| OR DOT 20(3)_XS_LSG.pdf | ||
| OR DOT 20(3)_Earthwork_VolRpt_LSG.PDF | ||
| IFB OR DOT 20(3).pdf | ||
| OR_DOT_20(3)_Plans.pdf | ||
| OR DOT 20(3)_Compiled_ESCP_Final.pdf | ||
| DXF and XML files.zip | ZIP file | |
| OR_DOT_20(3)_SUP_USG.PDF | ||
| OR DOT 20(3)XS_DRAINAGE.PDF | ||
| OR DOT 20(3)_USG Final Geotech Report GR 22-20 Rev 2 signed.pdf | ||
| OR_DOT_20(3)_SUP_LSG.PDF | ||
| OR DOT 20(3)_Survey_Control_LSG.xlsx | XLSX spreadsheet |
Show all 19
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: | DOT 20( ) | ||
| NPS PMIS / |
Drawing No:
| Designed by: | WFLHD Survey | |||
| Date: | 1/1904 | |||
| Checked by: | WFLHD Survey | |||
| Date: | 1/1904 | |||
| First sheet #: | A.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 | 6 | rows w/data | OK - no spaces in data |
| Max. row/table | 40 | 6 | data rows | Warnings: |
| 40 | rows/table | |||
| PROJECT :Upper Sunken Grade |
DATE OF FIELD WORK : November 2018
PROJECT UNITS : International Foot COORDINATE SYSTEM : Oregon North SPCS NAD83 (2011)
EPOCH DATE :2010.0000
VERTICAL DATUM :Orthometric Elevations based on the NAVD88 GEOID12b
| 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 | A.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: | A.1 | Filename | 0 | |||||||||
| Sheet name: | Sheet | c:\pw-work\d0390093\[Upper_Sunken_Grade_Controlsheet.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 3-Mar-2021 10:46 AM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
PROJECT :Upper Sunken Grade DATE OF FIELD WORK : November 2018 PROJECT UNITS : International Foot COORDINATE SYSTEM : Oregon North SPCS NAD83 (2011)
EPOCH DATE :2010.0000
VERTICAL DATUM :Orthometric Elevations based on the NAVD88 GEOID12b
| Upper Sunken Grade Site | |||||||||||||||
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||||||||
| 3.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| 18301 | 274026.640 | 7751395.330 | 2198.990 | 44°24'18.348825"N | 122°13'28.945635"W | 2126.4148 | 0.9998810888 | 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. | |||||
| 18302 | 274217.878 | 7751540.504 | 2210.682 | 44°24'20.267445"N | 122°13'27.002526"W | 2138.115 | 0.9998804071 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 18303 | 274506.983 | 7751694.565 | 2229.754 | 44°24'23.154134"N | 122°13'24.965748"W | 2157.1967 | 0.9998793109 | H&T | |||||||
| 18304 | 274609.778 | 7752072.820 | 2247.053 | 44°24'24.248641"N | 122°13'19.786514"W | 2174.5138 | 0.9998784136 | H&T | |||||||
| 18305 | 274613.651 | 7752429.347 | 2266.062 | 44°24'24.361890"N | 122°13'14.877450"W | 2193.5391 | 0.9998774973 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 18306 | 274574.445 | 7752567.825 | 2272.925 | 44°24'24.003942"N | 122°13'12.958787"W | 2200.4081 | 0.999877192 | 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 | |||||||||
| 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 :Upper Sunken Grade DATE OF FIELD WORK : November 2018
PROJECT UNITS : International Foot COORDINATE SYSTEM : Oregon North SPCS NAD83 (2011)
EPOCH DATE :2010.0000
VERTICAL DATUM :Orthometric Elevations based on the NAVD88 GEOID12b
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| 18301 | 274026.640 | 7751395.330 | 2198.990 | 44°24'18.348825"N | 122°13'28.945635"W | 2126.415 | 0.99988109 | 5/8" IR W/FHWA ALUM CAP | |
| 18302 | 274217.878 | 7751540.504 | 2210.682 | 44°24'20.267445"N | 122°13'27.002526"W | 2138.115 | 0.99988041 | 5/8" IR W/FHWA ALUM CAP | |
| 18303 | 274506.983 | 7751694.565 | 2229.754 | 44°24'23.154134"N | 122°13'24.965748"W | 2157.197 | 0.99987931 | H&T | |
| 18304 | 274609.778 | 7752072.820 | 2247.053 | 44°24'24.248641"N | 122°13'19.786514"W | 2174.514 | 0.99987841 | H&T | |
| 18305 | 274613.651 | 7752429.347 | 2266.062 | 44°24'24.361890"N | 122°13'14.877450"W | 2193.539 | 0.99987750 | 5/8" IR W/FHWA ALUM CAP | |
| 18306 | 274574.445 | 7752567.825 | 2272.925 | 44°24'24.003942"N | 122°13'12.958787"W | 2200.408 | 0.99987719 | 5/8" IR W/FHWA ALUM CAP |
File details come from the government source that posted it. Updated .