Taking Core Products a Step Further

1. Taking Core Products a Step Further USG Software and Customized Applications

2. USG Tools • Data Model Independent Tools for ArcGIS • Downstream Trace Report • Phase Change Tool • Custom Queries • FP Tool • Field Generator

3. Downstream Trace Report • Based on a user selected start point • Runs a downstream trace • Reports the number of connected consumers and the cumulative transformer kVA • Requires your ArcGIS system to have a geometric network.

4. Phase Change Tool • Based on a user selected start point • Runs a downstream trace • Changes the conductor and equipment phases from the selected start point downstream. • Requires your ArcGIS system to have a geometric network Before After

5. Custom Queries • Create and save custom attribute queries • Increases productivity by saving queries that the end user uses on a regular basis • Can be configured to allow users to enter a parameter or criteria value each time they are executed.

6. FP Tool • Feature Placement Tool • Select and save snapping criteria for every feature layer in the map • Select a feature type to place and begin placing features. • Saves time by turning a multi-step process into one step.

7. Field Generator • Extension for ArcCatalog • Add identical fields to one or more tables in a geodatabase • User can specify the field properties • A value can be specified to be populated in that field for all of the existing records in the table(s)

8. Customized Applications • Plotting Routines (Map Book Creation) • Importing CIS data to the GIS System • Importing Equipment data from the USG Maintenance Programs • Power Fail Analysis • Not Logged in 4 Days Report • Peak Usage Downstream Trace • Transformer Sizing Application

9. Plotting Routine • Automate the creation of map books • Ability to zoom to a specific location at a specific scale • Fills in all the necessary title block information • Print out or print to file one or multiple map book pages

10. Importing CIS data • Customer and service information imports from CIS exports • Reduces data entry for consumer fields • Allows for symbology to reflect current consumer data such as disconnected status and load management CIS Text File Export GIS Consumer Feature After Import

11. Importing Equipment Data • Equipment data and maintenance records recorded in USG Maintenance Programs • Data is then imported into the GIS System • Reports show the difference between the Maintenance Programs and the GIS System

12. Power Fail Analysis • Turtle Data is integrated with the GIS system • Turtle meter status is updated for all consumers • Symbology on the map is based on the consumer’s Turtle meter status • Any consumer with a ‘Powered Down’ status shows up on the map in red

13. Not Logged in 4 Days • Turtle Data is integrated with the GIS system • Reports meters and consumer information for meters that haven’t logged in the last 4 days

14. Peak Usage Downstream Trace • Based on a user selected start point • Runs a downstream trace • Report the consumers peak usage for seven days and the total peak usage for the consumers

15. Transformer Sizing Application • Analyze the size of transformers compared to the peak loads of consumers fed from those transformers • Integrates GIS, CIS and Turtle meter data • Creates a report of transformers and consumer load

16. Presented by Jennifer Mahrer Programming Assistant jmahrer@usgweb.com a www.usgweb.com www.adelinestaking.com