B-51193 Attachment D As Built Drawings and GIS Data Submittal.pdf

Illinois Department of Innovation and Technology

B-51193 REBID II Fiber Construction Services - North Region Attachment D As-Built Drawings and GIS Data Submittal

1.1.1 As -Built Drawings and GIS Data Submittal

1. Documentation Submittal

Vendor shall produce and submit Record Construction Drawings, an Electronic Data Location File, and

Geographical Information System Point and Shape Files to DoIT within thirty (30) days of contract/project completion that describe in detail the as-built condition of the work. DoIT will utilize these submittals to assemble and implement fiber optic statewide system record location parameters.

DoIT will not accept the fiber until this data is provided in appropriate detail as stated above.

a. Record Construction Drawings

The Record Construction Drawings (RCD’s) shall represent the full set of Construction Drawings that have been “red-lined” by the Vendor to show the actual construction performed. The location of the installed conduit and fiber optic cable, including the cable’s fiber count number, shall be indicated on the RCD’s noting the distance of the fiber optic cable and conduit from and referenced to permanent landmarks that include such lines or points as fences, edges of pavement, bridges, underpasses, pedestals, sidewalks, and limits of rights-of-way, among others.

The Vendor shall measure and record the offsets (the distance from the cable or conduit to a physical reference point) on a line perpendicular to the fiber’s or conduit’s longitudinal axis (i.e. the running line) points along the fiber or conduit of one hundred feet (100 ft) or less to the physical reference points and wherever changes in the offset distance and direction of the running line have occurred.

The Vendor shall indicate on the RCD’s the depth of the installation as at finished grade (e.g. 0”) or below finished grade (e.g. - 48”), changes from the proposed construction and notes referencing any special construction such as steel plating, insulation barriers, concrete encasement, and an irregular depth of installation, among others. The Vendor shall record on the RCD’s, the fiber cable’s “sequential” at each splice point and handhole wall.

b. Electronic Data Routing and Location File

The Electronic Data Routing and Location File shall contain a comprehensive set of GPS data location points and recorded in a GPS data table identified by construction package number. The text in the header of the table shall be oriented vertically and shall contain the following 13 columns:

Col. A: Point No. Col. E: Elevation – IL SPC E/W Col. I: Means of Construction

Col. B: Point Code Col. F: Date of Data Col. J: Depth of Install

Col. C: Nothing – IL SPC E/W Col. G: Time of Data Col. K: Latitude

Col. D: Easting – IL SPC E/W Col. H: 000 or Lat # Col. L: Longitude

Col. M: GPS File Name

The content and form of data entered within columns C, D, E, K and L shall be directly entered in the content and form as well as logged into the GPS equipment by which the data was acquired.

Each data point acquired shall be uniquely numbered and shall contain the information necessary to populate each cell of each column in the data point row. The data shall be acquired using calibrated GPS locating equipment recording sub-foot accuracy and utilizing the appropriate state plane coordinate system. Data points acquired shall include, at a minimum, the running line of the fiber or conduit installation every 100 feet, any change of direction of such running line, handholes, manholes, warning markers, warning posts, splice points, locate posts, the start and end of each type of construction, and other pertinent construction features in order to delineate the completed work in the DoIT intended GIS system.

The Vendor shall indicate, in a separate table, the GPS equipment and its manufacturer and model/ serial number that were used to acquire the data. GPS equipment shall be calibrated every 90 days for the term of this agreement.

Point Codes within the GPS Data Table shall be noted as follows:

HHA Handhole type A

HHB Handhole type B

HHC Handhole type C

MHD Manhole type D

FO12 Fiber Optic 12 Count

FO24 Fiber Optic 24 Count

FO48 Fiber Optic 48 Count

FO96 Fiber Optic 96 Count

FO144 Fiber Optic 144 Count

FO288 Fiber Optic 288 Count

FO384 Fiber Optic 384 Count SPL Fiber Optic Splice

ENT Fiber Optic Building Entrance

POP Point of Presence

PAC Fiber Optic Point along Curve

WP Warning Post

LP Locate Post

WS Warning Sign

BP Bore Pit

RR1 RR Crossing 1-1/4 “ HDPE @ 10’ Min.

RR2 RR Crossing 2” Galvanized Steel Conduit

BA Bridge Attachment

Abbreviations for the Means of Construction within the GPS Data Table shall be noted as:

DB Direct Bury

OC Open Cut

DBR Directional Bore

RDB Bore Road

BRX Bore River Crossing

UGT Underground Tunnel Installation

FXC Place fiber in existing conduit

RR1 RR Crossing 1-1/4 “ HDPE @ 10’ Min.

RR2 RR Crossing 2”Galvanized Steel Conduit

BA Bridge Attachment

c. Geographical Information System Point Files

For each section of data collection, submit 3 GPS point files of all points taken. Each of the 3 files will be named according to the following nomenclature:

1. CSV file specifying the geodetic position in latitude and longitude: PP_NNNN_YYYY_MM_DD_LL

2. CSV file specifying the grid position in Illinois State Plane East Zone Coordinates:

PP_NNNN_YYYY_MM_DD_ILSPE

3. GPS Receiver raw data file: PP_NNNN_YYYY_MM_DD_RAW Where:

PP denotes Package Number

NNNN denotes Sequential Number of the data

All sequences shall follow in order of the stationing depicted on the Construction Drawings.

YYYY denotes Year the data was acquired

MM denotes Month the data was acquired

DD denotes Date the data was acquired

LL denotes Longitude and Latitude data

ILSPE denotes Illinois State Plane East Zone Coordinate data

PATH Shape Files Attribute Fields

RAW denotes Raw data

d. Geographical Information System Shape Files

Vendor shall provide ESRI format Shape files of the constructed fiber path that include 1) Fiber path, 2)

Handholes and manholes, and 3) Customer Site entry locations. The following nomenclature and attribute fields shall be used:

Nomenclature for Fiber Path: PP_PATH_ASBLT_YYMMDD

Attribute Field Description Data Type Data Field Properties

PackageNum 2 digit Package # Integer 2 digits: 00

BackBNum Back Bone # Integer Always 000

LateralNum Lateral Number: 010, 017 Integer 3 digits: 000

StrandCnt Strand Count : 012, 144 Integer 3 digits: 000

Length Length of segment in feet from splice to splice Integer 5 digits: 00,000

Constr Means of Construction: DB, OC, DBR, RDB Text 3 characters: AAA

Depth Depth of Installation in inches Integer 3 digits: 000

Nomenclature for Handholes and Manholes: PP_HHMH_ASBLT_YYMMDD

HHMH Shape File Attribute Fields:

Attribute Field Description Data Type Data Field Properties

PackageNum 2 digit Package # Integer 2 digits: 00

ID Handhole / Manhole # shown on Construction Drawings, blank if none shown Integer 3 digits: 000

Splice 1 = splice location 0 = no splice Integer I digit: 0

HMTYPE Handhole Type: A, B, C, or Manhole Type: D Integer 3 digits: 000

Nomenclature for Customer Sites: PP_SITE_ASBLT_YYMMDD

Customer Site Shape File Attribute Fields:

Attribute Field Description Data Type Data Field Properties

PackageNum 2 digit Package # Integer 2 digits: 00

CustID Customer ID # on Construction Drawings Integer 4 digits: 0000

Name Site Name Text 50 characters

Address Address of Customer Site Text 50 characters

Where:

PP denotes package number

YY denotes year the data was acquired

MM denotes month the data was acquired

DD denotes date the data was acquired

PATH is the label indicating the file is a path. Enter as shown.

ASBLT is the label indicating the file is an as-built. Enter as shown.

HHMH is the label indicating the file is for a handhole or manhole. Enter as shown.

SITE is the label indicating the file is for a customer site. Enter as shown.