ora-grant24-2_control-points.xlsx
XLSX spreadsheet 42 KB Posted
- Solicitation number
- 69056723B000021
About this file
This document appears to be an Excel file containing survey control point data for the OR FLAP GRANT 24(2), Granite Hill Road Reconstruction, Phase II project. The file provides the state plane coordinates, geographic coordinates, elevations, and descriptions for 18 survey control points located throughout the project area. The project is being managed by the Federal Highway Administration, and the field work was conducted in August 2019. The coordinate system is the Oregon North State Plane Coordinate System, NAD83 2011 with an epoch date of 2010.0000, and the vertical datum is the NAVD88 geoid. This control point data is likely to be used for the design, construction, and quality control of the Granite Hill Road Reconstruction project.
The related federal contract opportunity is for the OR FLAP GRANT 24(2), Granite Hill Road Reconstruction, Phase II project. The solicitation number is 69056723B000021, and it is an Invitation for Bids (IFB) issued by the Federal Highway Administration. The project involves the reconstruction of Granite Hill Road, Phase II. The IFB, plans, physical data, and construction contract administration documents are provided as attachments.
View the file
Other files
Show all 41
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: | FLAP GRANT 24(2) | ||
| 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 | 15 | rows w/data | OK - no spaces in data |
| Max. row/table | 40 | 15 | data rows | Warnings: |
| 40 | rows/table | |||
| PROJECT :Granite Hill Phase 2 |
DATE OF FIELD WORK : August 2019
PROJECT UNITS : International foot COORDINATE SYSTEM : Orgeon 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 | 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\Oregon\Granite_Hill\[Granite_Hill_2019_controlsheet.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 2-Feb-2023 2:45 PM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
PROJECT :Granite Hill Phase 2 DATE OF FIELD WORK : August 2019 PROJECT UNITS : International foot COORDINATE SYSTEM : Orgeon North SPCS NAD83 2011
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||||||||
| 3.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| 19101 | 411063.041 | 8762239.436 | 4952.423 | 44°46'25.225932"N | 118°20'33.708639"W | 4896.8887 | 0.9996842688 | 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 | 411427.357 | 8761980.811 | 4934.568 | 44°46'28.890400"N | 118°20'37.157964"W | 4879.0313 | 0.9996850003 | 5/8 IR W/FHWA ALUM CAP | |||||||
| 19103 | 411664.235 | 8761854.422 | 4924.350 | 44°46'31.262013"N | 118°20'38.821915"W | 4868.8122 | 0.99968541 | 5/8 IR W/FHWA ALUM CAP | |||||||
| 19201 | 413263.290 | 8760343.866 | 4844.977 | 44°46'47.444361"N | 118°20'59.166408"W | 4789.4094 | 0.9996886709 | 5/8 IR W/FHWA ALUM CAP | |||||||
| 19202 | 413483.832 | 8760168.182 | 4840.029 | 44°46'49.667576"N | 118°21'01.520015"W | 4784.4588 | 0.9996888348 | 5/8 IR W/FHWA ALUM CAP | |||||||
| 19203 | 413641.076 | 8760054.654 | 4838.528 | 44°46'51.249614"N | 118°21'03.035524"W | 4782.9561 | 0.999688855 | 5/8 IR W/FHWA ALUM CAP | |||||||
| 19301 | 415807.651 | 8754202.579 | 4724.178 | 44°47'14.165889"N | 118°22'23.355795"W | 4668.502 | 0.9996935814 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 19302 | 415778.314 | 8753947.999 | 4721.096 | 44°47'13.942448"N | 118°22'26.895422"W | 4665.4158 | 0.9996937359 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 19303 | 415851.373 | 8753652.755 | 4717.564 | 44°47'14.740334"N | 118°22'30.961377"W | 4661.8787 | 0.9996938793 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 19401 | 416393.798 | 8750845.151 | 4689.957 | 44°47'20.822079"N | 118°23'09.683142"W | 4634.2222 | 0.9996950059 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 19402 | 416392.851 | 8750554.396 | 4677.940 | 44°47'20.887829"N | 118°23'13.714005"W | 4622.2011 | 0.999695578 | FND RPC | |||||||
| 19403 | 416423.079 | 8750266.282 | 4674.242 | 44°47'21.260602"N | 118°23'17.696960"W | 4618.4989 | 0.999695743 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 19501 | 422748.097 | 8741413.566 | 4578.468 | 44°48'25.964984"N | 118°25'18.161147"W | 4522.545 | 0.9996983121 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 19502 | 423080.469 | 8741099.233 | 4572.923 | 44°48'29.325844"N | 118°25'22.401410"W | 4516.9931 | 0.9996984754 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 19503 | 423303.976 | 8740933.418 | 4572.497 | 44°48'31.574302"N | 118°25'24.621089"W | 4516.5632 | 0.9996984278 | 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 |
PROJECT :Granite Hill Phase 2 DATE OF FIELD WORK : August 2019
PROJECT UNITS : International foot COORDINATE SYSTEM : Orgeon North SPCS NAD83 2011
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| 19101 | 411063.041 | 8762239.436 | 4952.423 | 44°46'25.225932"N | 118°20'33.708639"W | 4896.889 | 0.99968427 | 5/8 IR W/FHWA ALUM CAP | |
| 19102 | 411427.357 | 8761980.811 | 4934.568 | 44°46'28.890400"N | 118°20'37.157964"W | 4879.031 | 0.99968500 | 5/8 IR W/FHWA ALUM CAP | |
| 19103 | 411664.235 | 8761854.422 | 4924.350 | 44°46'31.262013"N | 118°20'38.821915"W | 4868.812 | 0.99968541 | 5/8 IR W/FHWA ALUM CAP | |
| 19201 | 413263.290 | 8760343.866 | 4844.977 | 44°46'47.444361"N | 118°20'59.166408"W | 4789.409 | 0.99968867 | 5/8 IR W/FHWA ALUM CAP | |
| 19202 | 413483.832 | 8760168.182 | 4840.029 | 44°46'49.667576"N | 118°21'01.520015"W | 4784.459 | 0.99968883 | 5/8 IR W/FHWA ALUM CAP | |
| 19203 | 413641.076 | 8760054.654 | 4838.528 | 44°46'51.249614"N | 118°21'03.035524"W | 4782.956 | 0.99968886 | 5/8 IR W/FHWA ALUM CAP | |
| 19301 | 415807.651 | 8754202.579 | 4724.178 | 44°47'14.165889"N | 118°22'23.355795"W | 4668.502 | 0.99969358 | 5/8" IR W/FHWA ALUM CAP | |
| 19302 | 415778.314 | 8753947.999 | 4721.096 | 44°47'13.942448"N | 118°22'26.895422"W | 4665.416 | 0.99969374 | 5/8" IR W/FHWA ALUM CAP | |
| 19303 | 415851.373 | 8753652.755 | 4717.564 | 44°47'14.740334"N | 118°22'30.961377"W | 4661.879 | 0.99969388 | 5/8" IR W/FHWA ALUM CAP | |
| 19401 | 416393.798 | 8750845.151 | 4689.957 | 44°47'20.822079"N | 118°23'09.683142"W | 4634.222 | 0.99969501 | 5/8" IR W/FHWA ALUM CAP | |
| 19402 | 416392.851 | 8750554.396 | 4677.940 | 44°47'20.887829"N | 118°23'13.714005"W | 4622.201 | 0.99969558 | FND RPC | |
| 19403 | 416423.079 | 8750266.282 | 4674.242 | 44°47'21.260602"N | 118°23'17.696960"W | 4618.499 | 0.99969574 | 5/8" IR W/FHWA ALUM CAP | |
| 19501 | 422748.097 | 8741413.566 | 4578.468 | 44°48'25.964984"N | 118°25'18.161147"W | 4522.545 | 0.99969831 | 5/8" IR W/FHWA ALUM CAP | |
| 19502 | 423080.469 | 8741099.233 | 4572.923 | 44°48'29.325844"N | 118°25'22.401410"W | 4516.993 | 0.99969848 | 5/8" IR W/FHWA ALUM CAP | |
| 19503 | 423303.976 | 8740933.418 | 4572.497 | 44°48'31.574302"N | 118°25'24.621089"W | 4516.563 | 0.99969843 | 5/8" IR W/FHWA ALUM CAP |
File details come from the government source that posted it. Updated .