OpenOne ESRI-based GIS

OpenOne's GIS System runs on ESRI's ArcGIS Desktop 9.1-3 and fully integrates with OpenOne Financial and Customer Information Systems.

This integration means you will only have to enter data into one system, there is no need to main-tain data in separate CIS, FIS, Mapping and Outage systems, they are all one.

OpenOne GIS provides a search tool for the OpenOne Oracle database for queries such as: map, meter, service order, and staking sheet numbers.

This allows you to easily find information in the "Maps" that engineers or CSRs require. It also makes updates and staking easier. You can quickly find the information you are looking for.

With this GIS System construction assembly information is pulled directly from FIS. It also reads and writes CIS data and FIS project and staking sheet information.

This makes it easier to maintain accurate inventory levels and engineering reports. You know what you have and where it is.

• ESRI GIS Features (+)

Provides tools to automate drawing, including:

• Match existing feature's feeder, phase and conductor
• Customizable snapping environments: easier to correctly connect things, which makes the model less error prone
• Automatic map numbering keeps track of service location numbers to avoid duplicate numbering and confusion
• Automatic boundary assignment keeps services up-to-date. For example, if districts of any sort change they will be updated in their records automatically
• Moving a location moves all associated lines and equipment: keeps everything connected properly when moving things around
• Buffer staking sheet automatically means quick and efficient loading of staking sheets
• Supports detailed equipment tracking by manufacturer/serial number for improved inventory maintenance
• Provides location and service history for equipment so you can tell what and who was at each location even after it is gone.

In addition to ATS's integration with ESRI's GIS system, we provide the facilities for the customization of and extensions to the basic ESRI ArcMAP application:

• GIS users are able to log into our financial and customer information systems from within the GIS application. The system then allows you to identify discrepancies in mapping of services and security lights as well as update engineering analysis and outage system connectivity models that include ATS's outage system, ABB's CADOPS OMS and FeederAll engineering analysis, Milsoft's WindMil and Dispatch OMS and other Multispeak compliant systems.
• A default automatic location numbering module is provided. When new facilities are placed, this module populates the location number based on the coordinate position. Customized numbering modules can be implemented using any COM capable development tool, such as Visual Basic or Visual Studio .Net. Different parts of your service area can have entirely different location numbering systems.
• A dockable window is available to display staking sheets from the Partner jobs database. Jobs in the Partner system can be drawn into the ATS GIS automatically.
• Our ESRI-based GIS system expands on the integration features of the mapping system. In addition to the list of projects that is available in the mapping system, GIS users have access to the list of construction units that were used on each project. Each construction unit can be configured to draw into the desired ESRI feature class and have its attributes populated in the GIS. All features in the GIS that have a corresponding data element in the Financial or CIS system have direct links into the core business table. Any change in the GIS that affects a business table is posted automatically.
• The system provides tools for validating the electric connectivity model. Connectivity loops and disconnected features can easily be identified and corrected.

• Mapping Features (+)

OpenOne is based on AutoCAD 2000+ and fully integrated with AutoCAD through ActiveX automation. The system runs in AutoCAD's process space and supports AutoCAD's multiple document interface, so more than one map can be open at one time. Mapping standards are set through the database, so no programming is required to implement most existing (paper) mapping systems. Both layer assignments and symbol assignments are configured in the database. Standard symbols can be replaced and/or customized. Map symbols can be substituted automatically when a piece of equipment is replaced by one of a different type. Values from the database can be assigned to attributes of symbols on maps, and updated automatically. And understood values can be configured to minimize map congestion.

When a map location is identified by a database query, the map(s) needed to display the information are loaded automatically. Engineering changes that require updating multiple maps automatically propagate across map boundaries and enlargement levels (phasing updates, for example).

Most map grid systems are supported and any number of grid levels is allowed. OpenOne supports multiple map scales and enlargement map naming convention is configurable throughout the database. OpenOne also interfaces to most engineering analysis packages today, such as Milsoft Windmill and ABB FeederAll.

ATS developed its AutoCAD mapping system in parallel with the customer information system. Mapping operators have direct access to the project and service order lists that have been routed to them in the ATS financial and CIS systems.

OpenOne integrates directly with Partner Software's staking system. Both the graphical and tabular data can be imported automatically from a Partner's staking database into the ATS mapping system.