ora-dot126-1_control.xlsx
XLSX spreadsheet 43 KB Posted
- Solicitation number
- 69056725B000002
About this file
This document appears to be a survey control point list in Excel format for the "OR FLAP DOT 126(1), Blue Pool Safety and Access Enhancement Project". The file contains information on 19 survey control points, including their state plane coordinates, geographic coordinates, elevations, and descriptions. The project details indicate it is located in Oregon, using the Oregon North SPCS NAD83 2011 coordinate system and the NAVD88 vertical datum. The project units are in International feet. The document also provides some instructions on how to use the file to insert the survey control point information into a plan sheet.
The related federal contract opportunity is for the "OR FLAP DOT 126(1), Blue Pool Safety and Access Enhancement Project", with a solicitation number of 69056725B000002. The project is being procured by the Department of Transportation Federal Highway Administration, a civilian agency. No additional details on the specific products, services, response dates, award dates, pricing terms, or set asides are provided in the information given.
View the file
Other files
Show all 17
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 DOT 126(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 :Blue Pool Safety and Access Enhancement Project |
DATE OF FIELD WORK : July/August 2021 CADD COORDINATE SYSTEM : OR83/2011-NIF NSRS11(NAD83/2011) Oregon, North Zone, Intn'l Foot
COORDINATE SYSTEM : Oregon North SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 based on Geoid18
EPOCH DATE : 2010.0000
PROJECT UNITS : International 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:\pw-work\d0508620\[Blue_Pool_Controlsheet.xlsx]Sheet | ||||||||||
| Reference: | Time | |||||||||||
| 22-Jul-2024 10:05 AM | ||||||||||||
| Begin Column: | A | B | C | D | E | F | G | H | I |
PROJECT :Blue Pool Safety and Access Enhancement Project DATE OF FIELD WORK : July/August 2021 CADD COORDINATE SYSTEM : OR83/2011-NIF NSRS11(NAD83/2011) Oregon, North Zone, Intn'l Foot COORDINATE SYSTEM : Oregon North SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 based on Geoid18
EPOCH DATE : 2010.0000
PROJECT UNITS : International foot
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||||||||
| 3.0 | POINT | ||||||||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||||||||
| HEIGHT | COMBINED | ||||||||||||||
| FACTOR | DESCRIPTION | NOTE: | |||||||||||||
| 21101 | 229821.061 | 7800168.249 | 2159.389 | 44°17'11.629189"N | 122°02'05.648930"W | 2087.9173 | 0.9999123251 | 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. | |||||
| 21102 | 230186.345 | 7800574.842 | 2168.771 | 44°17'15.311883"N | 122°02'00.155839"W | 2097.3185 | 0.9999116042 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21103 | 230592.789 | 7801169.283 | 2185.383 | 44°17'19.436038"N | 122°01'52.091321"W | 2113.9611 | 0.9999105051 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21104 | 231034.616 | 7801682.904 | 2205.694 | 44°17'23.894266"N | 122°01'45.146581"W | 2134.2978 | 0.9999092053 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21105 | 231382.202 | 7802078.457 | 2229.092 | 44°17'27.399889"N | 122°01'39.799956"W | 2157.7161 | 0.9999078286 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21201 | 230771.157 | 7800838.305 | 2174.111 | 44°17'21.135107"N | 122°01'56.687106"W | 2102.6783 | 0.9999109191 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21202 | 230887.996 | 7800746.172 | 2181.520 | 44°17'22.271404"N | 122°01'57.983952"W | 2110.0824 | 0.9999104817 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21203 | 231066.793 | 7800819.753 | 2183.927 | 44°17'24.050455"N | 122°01'57.019194"W | 2112.4943 | 0.9999102356 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21204 | 231373.138 | 7800875.907 | 2189.671 | 44°17'27.085526"N | 122°01'56.327216"W | 2118.2471 | 0.9999097377 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21205 | 231602.831 | 7801012.480 | 2193.908 | 44°17'29.378865"N | 122°01'54.509826"W | 2122.4921 | 0.9999093664 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21206 | 231737.049 | 7801011.922 | 2196.414 | 44°17'30.703899"N | 122°01'54.552480"W | 2124.9997 | 0.9999091494 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21207 | 231924.768 | 7801141.922 | 2198.662 | 44°17'32.581589"N | 122°01'52.814454"W | 2127.255 | 0.9999089039 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21208 | 232129.063 | 7801202.301 | 2201.332 | 44°17'34.609901"N | 122°01'52.037722"W | 2129.9299 | 0.9999086274 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21209 | 232447.979 | 7801300.406 | 2205.594 | 44°17'37.776926"N | 122°01'50.772246"W | 2134.1996 | 0.9999081913 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21210 | 232679.441 | 7801385.264 | 2208.769 | 44°17'40.078034"N | 122°01'49.666054"W | 2137.3808 | 0.9999078709 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21211 | 232882.109 | 7801404.084 | 2211.858 | 44°17'42.082503"N | 122°01'49.460128"W | 2140.4732 | 0.9999075766 | 5/8" IR W/FHWA ALUM CAP | |||||||
| 21212 | 232909.241 | 7801561.898 | 2216.219 | 44°17'42.379891"N | 122°01'47.297809"W | 2144.8405 | 0.9999073461 | 5/8" IR W/FHWA ALUM CAP | |||||||
| BP101 | 229516.809 | 7799648.806 | 2152.875 | 44°17'08.527796"N | 122°02'12.708816"W | 2081.3816 | 0.9999128665 | 5/8" IR W/FHWA ALUM CAP | |||||||
| BP102 | 229631.568 | 7799901.148 | 2155.794 | 44°17'09.708198"N | 122°02'09.270561"W | 2084.3107 | 0.9999126393 | 5/8" IR W/FHWA ALUM CAP | |||||||
| BP103 | 231933.420 | 7802364.541 | 2267.441 | 44°17'32.895486"N | 122°01'36.010782"W | 2196.0833 | 0.999905592 | MAG NAIL & WASHER | |||||||
| BP104 | 232436.692 | 7802560.551 | 2303.409 | 44°17'37.900879"N | 122°01'33.447135"W | 2232.0652 | 0.999903506 | MAG NAIL & WASHER | |||||||
| 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 :Blue Pool Safety and Access Enhancement Project DATE OF FIELD WORK : July/August 2021 CADD COORDINATE SYSTEM : OR83/2011-NIF NSRS11(NAD83/2011) Oregon, North Zone, Intn'l Foot
COORDINATE SYSTEM : Oregon North SPCS NAD83 2011 VERTICAL DATUM : Orthometric elevations based on the NAVD88 based on Geoid18
EPOCH DATE : 2010.0000
PROJECT UNITS : International foot
| STATE PLANE COORDINATES | GEO COORDINATES | ||||||||
| POINT | |||||||||
| NUMBER | NORTH | EAST | ELEVATION | LATITUDE | LONGITUDE | ELLIPSOID | |||
| HEIGHT | COMBINED | ||||||||
| FACTOR | DESCRIPTION | ||||||||
| 21101 | 229821.061 | 7800168.249 | 2159.389 | 44°17'11.629189"N | 122°02'05.648930"W | 2087.917 | 0.99991233 | 5/8" IR W/FHWA ALUM CAP | |
| 21102 | 230186.345 | 7800574.842 | 2168.771 | 44°17'15.311883"N | 122°02'00.155839"W | 2097.319 | 0.99991160 | 5/8" IR W/FHWA ALUM CAP | |
| 21103 | 230592.789 | 7801169.283 | 2185.383 | 44°17'19.436038"N | 122°01'52.091321"W | 2113.961 | 0.99991051 | 5/8" IR W/FHWA ALUM CAP | |
| 21104 | 231034.616 | 7801682.904 | 2205.694 | 44°17'23.894266"N | 122°01'45.146581"W | 2134.298 | 0.99990921 | 5/8" IR W/FHWA ALUM CAP | |
| 21105 | 231382.202 | 7802078.457 | 2229.092 | 44°17'27.399889"N | 122°01'39.799956"W | 2157.716 | 0.99990783 | 5/8" IR W/FHWA ALUM CAP | |
| 21201 | 230771.157 | 7800838.305 | 2174.111 | 44°17'21.135107"N | 122°01'56.687106"W | 2102.678 | 0.99991092 | 5/8" IR W/FHWA ALUM CAP | |
| 21202 | 230887.996 | 7800746.172 | 2181.520 | 44°17'22.271404"N | 122°01'57.983952"W | 2110.082 | 0.99991048 | 5/8" IR W/FHWA ALUM CAP | |
| 21203 | 231066.793 | 7800819.753 | 2183.927 | 44°17'24.050455"N | 122°01'57.019194"W | 2112.494 | 0.99991024 | 5/8" IR W/FHWA ALUM CAP | |
| 21204 | 231373.138 | 7800875.907 | 2189.671 | 44°17'27.085526"N | 122°01'56.327216"W | 2118.247 | 0.99990974 | 5/8" IR W/FHWA ALUM CAP | |
| 21205 | 231602.831 | 7801012.480 | 2193.908 | 44°17'29.378865"N | 122°01'54.509826"W | 2122.492 | 0.99990937 | 5/8" IR W/FHWA ALUM CAP | |
| 21206 | 231737.049 | 7801011.922 | 2196.414 | 44°17'30.703899"N | 122°01'54.552480"W | 2125.000 | 0.99990915 | 5/8" IR W/FHWA ALUM CAP | |
| 21207 | 231924.768 | 7801141.922 | 2198.662 | 44°17'32.581589"N | 122°01'52.814454"W | 2127.255 | 0.99990890 | 5/8" IR W/FHWA ALUM CAP | |
| 21208 | 232129.063 | 7801202.301 | 2201.332 | 44°17'34.609901"N | 122°01'52.037722"W | 2129.930 | 0.99990863 | 5/8" IR W/FHWA ALUM CAP | |
| 21209 | 232447.979 | 7801300.406 | 2205.594 | 44°17'37.776926"N | 122°01'50.772246"W | 2134.200 | 0.99990819 | 5/8" IR W/FHWA ALUM CAP | |
| 21210 | 232679.441 | 7801385.264 | 2208.769 | 44°17'40.078034"N | 122°01'49.666054"W | 2137.381 | 0.99990787 | 5/8" IR W/FHWA ALUM CAP | |
| 21211 | 232882.109 | 7801404.084 | 2211.858 | 44°17'42.082503"N | 122°01'49.460128"W | 2140.473 | 0.99990758 | 5/8" IR W/FHWA ALUM CAP | |
| 21212 | 232909.241 | 7801561.898 | 2216.219 | 44°17'42.379891"N | 122°01'47.297809"W | 2144.841 | 0.99990735 | 5/8" IR W/FHWA ALUM CAP | |
| BP101 | 229516.809 | 7799648.806 | 2152.875 | 44°17'08.527796"N | 122°02'12.708816"W | 2081.382 | 0.99991287 | 5/8" IR W/FHWA ALUM CAP | |
| BP102 | 229631.568 | 7799901.148 | 2155.794 | 44°17'09.708198"N | 122°02'09.270561"W | 2084.311 | 0.99991264 | 5/8" IR W/FHWA ALUM CAP | |
| BP103 | 231933.420 | 7802364.541 | 2267.441 | 44°17'32.895486"N | 122°01'36.010782"W | 2196.083 | 0.99990559 | MAG NAIL & WASHER | |
| BP104 | 232436.692 | 7802560.551 | 2303.409 | 44°17'37.900879"N | 122°01'33.447135"W | 2232.0652 | 0.99990351 | MAG NAIL & WASHER |
File details come from the government source that posted it. Updated .