Sample Projects
You are here: Home › › Services › Geographic Information System › Sample Projects
Smallworld OMS Work Order Processing
ATSI was selected to perform feature/attribute edits, quality assurance/quality control (QA/QC), and Project Management services for a large electric transmission/distribution company to maintain their Smallworld OMS (outage management system) GIS. The client’s OMS is a comprehensive GIS application that is utilized to efficiently manage all electric power devices and reduce power outage response times. The OMS is a GIS application that houses all of the client’s electrical utility system components: (poles, overhead/underground conductors, transformers, fuse cutouts, capacitor banks, recloser banks, sectionalizer banks, switch banks, stepdown banks, voltage regulators, etc.) as well as customer information. All components are spatially accurate, contain viable attribution, and are overlaid onto road network vectors, which also reside within the system, to create an interactive GIS application. In order to maintain the system’s integrity, it must be continually updated each time a component has been added, removed or altered in the real-world. ATSI is responsible for performing and maintaining all modifications and ensuring the GIS vectors maintain spatial accuracy, contain the correct feature attribution and proper topologies necessary to keep the OMS application running properly. With this very labor intensive task at hand, the client also tasked ATSI to perform all aspects of Project Management and QA/QC for this assignment to ensure project completion in an efficient and timely manner.
Remote Access
ATSI is currently performing all Smallworld OMS GIS project tasks remotely, utilizing easy to configure applications such as: VPN (Virtual Private Network), and Citrix Network Neighborhood. ATSI’s staff remotely accesses the client’s server, software and data from several distant office locations, avoiding frequent travel that would otherwise be necessary to perform an assignment of this magnitude. The ability to remotely access applications also allows the client to avoid having to provide additional office space and equipment at their facility for key OMS personnel. Using the additional functionality of web conferencing and email correspondence, ATSI is able to collaborate with the client at a moments notice, thus avoiding costly and redundant business travel. Being a large proponent of remote access, ATSI is able to provide customers with a very cost effective business plan for any application.
GIS Asset/Document Management
ATSI used GIS technology to integrate thousands of spatially related documents into a single efficient application for a large steel manufacturer. This application provides team members, managers and decision makers with simple and efficient access to all of their documents such as drawings, specs, photos, vendor cut-sheets, and operations & maintenance manuals from a desktop computer or mobile device. The system has the ability to track asset data such as maintenance records, purchase orders, inventory tracking and vendor information with the capability to also generate work orders. Early estimates show that the GIS technology implemented by ATSI for simple asset/document management and retrieval will save an end user/team member 25% of their time used searching for these critical documents.
Relational Database Management System
ATSI designed a fully functional custom RDBMS (relational database management system), to assist project managers and end users with the location and maintenance of important project documents for a large heavy industrial project. The system utilizes MS Access in conjunction with custom designed tables to track vital project information. The system also offers a hyperlink feature that allows end users quick access to project documents, such as drawings, specifications, reference drawings, photos, etc. and has the functionality to generate reports with the push of a button in several different formats; including MS Excel spreadsheets and PDF. The application was customized using Visual Basic coded user tools, graphical user interfaces, and custom SQL (Structured Query Language) queries to locate important project documents. The custom SQL queries can be accessed by the end user with buttons
located on the interface, or by inputting keywords into the system.
Relational Database Management System/Legacy CAD Data Conversion
ATSI designed a fully functional custom RDBMS (relational database management system) to assist a large industrial equipment company with managing and updating vital customer information, product information, product inventory, production schedules, historical project calculations & quotes, and legacy CAD drawings. The RDBMS, which is a MS Access application, was designed to provide a direct link to the customer’s existing accounting software, allowing for quick updates to customer account information. The system also offers a hyperlink feature that allows end users quick access to all documents in the system, and has the functionality to generate reports with the push of a button in several different formats; including MS Excel spreadsheets and Microsoft Word. The system utilizes custom SQL (Structured Query Language) queries and can be accessed by the end user with buttons located on the interface, or by inputting keywords into the system. To accompany the RDBMS application, ATSI also assisted the customer with the conversion and updating of their existing legacy CAD drawings using the AutoCAD Raster Design Suite, creating. hybrid raster/vector CAD drawings to better suit their needs, and to eliminate the storage space of large-format, hard copy drawings.
Natural Gas Pipeline and Electric Power Enterprise GIS
ATSI was selected to provide on-site and off-site GIS Analysts and Technicians to facilitate the implementation of a company-wide Enterprise GIS for a natural gas transmission/distribution pipeline and electric transmission/distribution company in New York state. An on-site Program Manager was provided to facilitate the successful implementation of this 3-year project along with an on-site GIS Data Administrator/Analyst who migrated, converted and maintained all of the data for various departments. Data preparation and conversion was performed on various legacy data sets while metadata standards were implemented and custom data models were developed. Off-site GIS Analysts and Technicians were provided to support ATSI on-site personnel and various client requests.
GIS Pipeline Integrity Mapping and Analysis
ATSI was selected to provide on-site GIS Analysts to facilitate the mapping of pipeline assets to fulfill regulatory compliance reporting under the Federal Pipeline Integrity Management Act for federal and state agencies for an international specialty gas manufacturer. Data was collected, verified and digitized to electronic GIS format from various historical documents including hard copy construction drawings then migrated into a custom database model for more accurate pipeline representations. ATSI developed an official work process, with regards to data editing, and trained customer personnel that had varying levels of GIS experience. ArcGIS and GeoFields software applications were utilized in accordance with National Pipeline Mapping System (NPMS) Standards. Additional mapping support has been provided upon request for presentations and as a planning tool for future pipeline construction. Risk analysis/modeling support has been given to ensure Federal and state regulatory compliance, as well as pipeline integrity.
GIS Pipeline Integrity Mapping and Analysis
.jpg "GIS Pipeline Integrity Mapping and Analysis")
ATSI was selected to provide on-site and off-site GIS Analysts to facilitate the implementation of regulatory compliance reporting under the Federal Pipeline Integrity Management Act for an interstate natural gas transmission/distribution pipeline company. GIS Analysts were tasked with designing a mapping system to meet the client's specific needs under stringent federal regulations. ATSI incorporated Geographic Information System (GIS) technology and custom VBA tools to reduce time spentand producea more usable mapping product integrated with the client's pipeline integrity database. Custom automated processes were designed to add high-resolution orthophotos to map documents, map pipe data and ILI data on pipeline ROW centerlines, identify and locate high consequence area (HCA) and Class Location, and create geographic location for historical leak inspection reports. The integrity of the existing data and data input were managed and maintained for the Risk Assessment Data Model and the Baseline Assessment Plan. Annual budget maps, pipeline construction maps, pipeline replacement maps, In-Line Inspection alignment sheets and Pipeline Integrity maps were created. A pipeline class location study and HCA study were compiled to determine areas of high risk along gas transmission and storage lines to comply with DOT regulations. Aerial photography, satellite imagery and GPS data were analyzed to determine proximity of houses, public facilities, gathering places and unoccupied structures to the gas line. Input was provided to assist client with selection and implementation of commercially-available pipeline integrity software. Data was converted from AutoCAD, FRAMME, various databases and hard copy legacy mapping.
Natural Gas Pipeline Enterprise GIS
ATSI was selected to provide on-site GIS Analysts and Technicians to facilitate the implementation of a company-wide Enterprise GIS for an interstate natural gas transmission and distribution pipeline company. Data preparation digitizing and conversion were performed on various data sets such as pipeline plan and profiles, strip maps, AM/FM FRAMME mapping, structures, valves, stations, road and stream crossings, pipeline corrosion and risk assessment. Supplemental control points were created based on this data to ensure that legacy data overlays are properly displayed along the pipe centerlines. Data was converted from AutoCAD, FRAMME, various databases and hard legacy mapping.
Refer a Colleague