Project Experience

EXCAVATION REPORT PROJECT

 

  • Scanned over 200,000 handwritten documents and extracted pertinent customer information into a searchable database. 

  • Organized packaging, pick-up, delivery and return of documents from 14 divisions across NYS.

  • Prepared documents for scanning including unpacking, removing paper clips and staples, sorting and organizing documents into common form types.

  • Scanned documents into .pdf formatted electronic files.

  • Uploaded files to the cloud for storage and subsequent processing.

  • Submitted files and customized templates to our on-line key data extraction partner.

  • Exported and formatted data for client including manual entry as needed for data unable to be electronically transferred                     

MANHOLE SURVEY/UTILITY ROUTE & VERIFICATION

 

  • Verified thousands of utility lines by analyzing and comparing paper based manhole detail sheets, field captured digital images and SAP databases.

  • Created accurate, multilayer AutoCAD manhole drawings.

  • Validated current and alternative client routing paths for new utilities.

  •  

 

GAS FACILITIES ENHANCEMENT PROJECT A

 

Scope: The Gas Facilities Enhancement Project (GFEP) updated existing Gas Asset (Mains, Services and Valves) data in client’s asset management system (SAP), linking the SAP Functional Location (FLOC) and Equipment ID to the Gas GIS mapping model.

 

Objective: This project was designed to provide the proper tax base of assets and accurate SAP equipment records for Fixed Asset, Engineering and Operation department needs.

 

Results:

  • Verified, updated and created GIS and SAP records by analyzing field data including

    As-Builts and service orders.  Project completed on schedule with 98% accuracy.

  • Analyzed over 1,715 raster image (paper) maps.

  • Updated and created 73,881 SAP records. 

  • Populated GIS data set with corresponding SAP FLOC and Equipment ID. 

  • Delivered service and main information to enable accuracy in designs, maintenance inspections and reporting to governing agencies.

 

 

SAP DATA CONVERSION & DATA CLEANSING PROJECT

 

Client had undergone a system migration, which resulted in inaccurate data. Records were corrected in the new system format and missing information was added.  Historical hard copy records were validated and converted manually for data that was not transferred during migration or hadn’t existed in the previous system.

  • Phase 1:  Converted 28,000+ Manhole/Handhole detail sheets from electronic and paper files into the SAP database. Preliminary steps involved analyzing and data scrubbing existing Functional locations (FLOCS) and equipment records. New records were then created for underground structures, devices, and conductors.

  • Phase 2:  Building on records developed in Phase 1, converted 20,000 conduit detail sheets from both electronic and paper files into SAP database. Conduit/duct equipment records were linked to their corresponding FLOCS created in phase 1. 

  • Phase 3:  14,000 Isolated Sheets (Maps) of Underground Residential Developments and Overhead Poles with isolated conductors were converted from paper maps into the SAP database. FLOCS and equipment records were created for underground and overhead structures, devices, conductors and conduits/ducts.

 

ROUTING ANALYSIS
 

ICS was tasked with researching alternative underground routes using existing structures in order to minimize new construction costs. Routing analysis was provided as part of the ongoing operation and maintenance of underground pilot/circuit networks.

 

Process:  Research and analyze potential routes utilizing:

  • Client’s historical detail drawings.

  • Maps (Underground Raster and GIS/SmartMap).
  • Asset management records (SAP).

 

In addition to the proposed routes, possible barriers to the selected routing were identified and potential solutions offered.  The areas of concern included:

  • Need for new construction due to lack of available conduits.
  • Conduit condition due to age and material.
  • Size of conduit vs. size of cable.
  • Proximity to existing pilot cables.

 

Results:

ICS provided detailed electronic and hardcopies of proposed route(s) from station to station through existing structures, using empty conduits and the most direct route available.  The deliverable package included detailed areas of concern with solutions to mitigate the issues identified.  ICS worked with the client after the initial proposed routes were field checked to update routing package as required.

 

 

 

DAY-TO-DAY BUSINESS SUPPORT

 

  • Provide customer with on-site Administrative Support and Document Control.  Date stamp & scan Work Orders and field notes upon receipt.  Upload electronic copies to customer files.  Assign unique report number to hard copy documents and log for tracking.  Assign to Master Data for completion.  Locate hard copy records (maps, reports, field notes, drawings) in files for Master Data reference. File hard copy documents when research and/or Master Data are complete.  Process historic Work Orders and field notes, creating electronic files, uploading to customer files; store hard copies for archiving.

  • Provide daily Electric Master Data Support for upkeep of client’s SAP asset management system.  Create and maintain equipment records from field As-Builts (paper drawings) for distribution and transmission lines.  Convert field construction drawings into AutoCAD for underground projects.

  • Provide daily Gas Master Data Support for upkeep of client’s SAP asset management system.  Create and maintain equipment records from field As-Builts for gas services and mains.

  • Provide underground gas and electric facilities Planning Maps from customer resources to fulfill requests from the NYS-Dig Safe program.  Provide electronic file to requestor.

  • Maintain and validate SmartMap and SAP records based on Field Distribution Line Inspections.  Research data provided from the field, identify discrepancies, amend SAP and send to appropriate department for map corrections.

  • Based on the monthly Connection Object report received from the customer, align individual electric meters with appropriate transformers to support billing accuracy and reliability.

 

MAPPING PROJECTS

 

  • Convert Electric As-Builts for transmission and distribution projects into SmartMap from SAP work order transactions.

  • Convert Gas As-Builts for transmission and distribution projects to update raster images.

  • Converted 174 circuits (4 kV & 11 kV) from paper Primary Maps to electronic files in AutoCAD and delivered in .pdf files. On-going circuit map maintenance.

 

 

INFRARED/THERMOGRAPHY PROJECT SUPPORT

 

Scope:  Follow overhead electric circuits from station to station to distinguish rural and off road access to enhance efficiency of infrared surveys.

 

Objective:  Determine mileage of rural and off road cable by circuit.

 

Results:

  • Calculated thousands of miles of cable based on client criteria for several hundred circuits. 

  • Developed patrol maps for subcontractor including mileage notation and identification of protective devices.

  • Upon request, research and provide customer counts for Level I defects found during Line Inspections in real time. 

  • Work closely with subcontractor to provide maps per desired locations and schedule. 

  • Provide monthly quality control checks of subcontractor invoices for client.

 

 

GIS GAS CONVERSION PROJECT

 

Scope:  The Gas Conversion Project updated existing GIS data and added missing data to create a single operational mapping system for the client’s companies through the transfer of all current GTX gas mapping data into the ArcFM GIS system.  Existing data was verified and amended in ArcFM by analyzing and converting TIFF/Raster images to a GIS format. 

 

Objective:  Verify GIS location of current and future mains, services and features resulting in improved accuracy, including accurate linking of SAP customer service records to the correct main.

 

Review over 7000 paper and TIFF images, interpret and capture the required attributes for key equipment and reference points:  mains, tracer wire boxes, drips, pipe casings, dimensions, test tubes, valves, services, right of ways and structures.

 

Data Sources:

  • 3500 TIFF (Raster Images) Gas Map

  • 500 Paper TIFF, AutoCAD Regulator Drawings

  • 3200 TIFF Corrosion Maps

  • Archived As-Builts

  • 2000+ Gas Service Orders

  • Customer GIS table/link

  • County and City Tax maps

  • Available GPS coordinates for existing equipment

 

Results:

  • Fully converted and Georeferenced maps

  • Added all necessary equipment dimensions and buildings shown on raster images

  • Using GIS layers with the correct feature classes, created and edited key equipment and reference points

  • Used supplied GPS coordinates to geographically place features in correct locations  

  • Geographically aligned features using dimensions identified on operating maps, aerial photography, tax maps, and regulator station drawings.

  • Updated customer attachments to edited or replaced main

  • Fully converted corrosion data from corrosion maps and existing cathodic protection points

  • Updated and Added Records:

    • 100,000 Distribution mains & 2,500 Transmission mains

    • 11,600 Valves, 20,000 Tracer Wire Boxes, 1700 Drips

    • 2,000 Services

    • 6,500 Pipe Casings

    • 150,000 Dimensions

© 2023 by Strategic Consulting. Proudly created with Wix.com