IMPLEMENTING A MULTI- DEPARTMENTAL UTILITY GIS SYSTEM
IMPLEMENTING A MULTIDEPARTMENTAL UTILITY GIS SYSTEM
FLORENCE UTILITIES
LAUDERDALE COUNTY • ELECTRIC, GAS, WATER AND WASTEWATER • COUNTY ABOUT 690 SQUARE MILES • APPROXIMATELY 46,700 ELECTRIC, 21,500 WATER AND 17,000 GAS CUSTOMERS • GIS FULLY OPERATIONAL JUNE 2002
BRIEFING OUTLINE REASONS/BENEFITS INVENTORY PHASE CONNECTIVITY PHASE IMPLEMENTATION PHASE INTEGRATION PHASE
REASONS/BENEFITS • ACCURATELY LOCATE CUSTOMERS • DISPATCH MANAGEMENT • LOCATING FACILITIES AND EQUIPMENT • IMPROVE CURRENT METHODOLOGY (WORKORDER MANAGEMENT) • ALL DEPARTMENTS UTILIZING SIMILAR SOFTWARE AND BASE-MAPS • IMPROVE SYSTEM ANALYSIS AND PLANNING • DISTRIBUTION CONNECTIVITY
Baker GeoResearch - GEOLINKS
University of North Alabama
PREPERATION FOR INVENTORY • REPLACE OLD RURAL ROUTE SYSTEM NOW USE STREET NUMBER AND ROAD NUMBER OR NAME METHOD • EACH CUSTOMER ASSIGNED UNIQUE ADDRESS (KEY TO PROJECT) • GPS DATABASE • GIS DATABASE • METHODOLOGY AND EQUIPMENT
LANDBASE
ROADS OF COUNTY GPS’d BY CONTRACTOR IS OUR BASE MAP
GPS • GLOBAL POSITIONING SYSTEM • DEVELOPED BY DEPARTMENT OF DEFENSE • CONSTELLATION OF 24 SATELLITES • PINPOINT POSITIONS 24 HRS A DAY • TRIANGULATION IS THE BASIS OF THE SYSTEM
GPS ERROR SOURCES SATELLITE CLOCKS
SELECTIVE AVAILABILITY
EPHEMERIS
ATMOSPHERIC DELAYS
RECEIVER CLOCKS, ETC.
MULTIPATHING
WHAT IS DIFFERENTIAL GPS? • COOPERATION
BETWEEN TWO
STATIONARY SATELLITE (GPS)
RECEIVERS • STATIONARY SATELLITE TIES MEASUREMENTS INTO SOLID LOCAL REFERENCE • REFERENCE RECEIVER WORKS BACKWARDS USING POSITION TO CALCULATE TIMING
FIELD RECEIVER
• TIMING DIFFERENCES IS ERROR OR DELAY IN SIGNAL • DGPS MORE ACCURATE
REFERENCE RECEIVER
DGPS INVENTORY • USED 12 CHANNEL SATLOC REAL-TIME DGPS SYSTEM WITH GEOLINK SOFTWARE • PEN BASED COMPUTER USED TO FIELD INVENTORY • ELECTRICAL CONNECTIVITY FROM SUBSTATION TO METERS • CUSTOMER BILLING DATA • ACCOUNT NUMBER TIE BETWEEN CUSTOMER DATABASE AND GEOGRAPHICAL POSITION
DGPS PROCESSING • POST PROCESSING • FIRST QC OF ELECTRONIC REPRESENTATION • DGPS FILE TRANSLATED TO SHAPEFILE
WHAT IS GIS? “An organized collection of computer hardware, software, geographic data, and personnel designed to efficiently capture, store, update, manipulate, analyze, and display all forms of geographically referenced information”. (Understanding GIS—The ArcInfo Method, ESRI)
IF YOU WERE TO TAKE OUT THE REFERENCES TO GEOGRAPHIC DATA YOU WILL FIND THAT THE DEFINITION IS VERY SIMILAR TO THAT OF A DATABASE
A FEATURE UNIQUE TO A GIS IS ITS ABILITY TO DO “DATA-LINKAGE” USING LOCATION AS THE COMMON KEY
GIS DURING INVENTORY PHASE • MERGED DGPS DATA • HELPED TO KEEP TRACK OF WHERE WE WERE AND WHERE WE HAD TO GO • USED SYMBOLOGY TO QUALITY CONTROL • LOCATE MISSING DATA AREAS • EASY TO EDIT DATA WHEN IN SHAPEFILE FORMAT USING ARCVIEW OR ARCMAP • ELECTRIC UNDERGROUND BUILT IN ARCVIEW
ELECTRIC & GAS DEPT COLLECTION TOTALS
ELECTRIC DEPARTMENT
GAS DEPARTMENT
TOTAL GPS
184124 POINTS
TOTAL GPS
8009 POINTS
TOTAL SKETCH
104615 LINES/POINTS
TOTAL SKETCH
11547 POINTS
TOTAL UGFAC
4022 POINTS
TOTAL POINTS
19556
TOTAL POINTS
292761
NUMBER OF DAYS 334
NUMBER OF DAYS 605 DAILY AVG
304 POINTS
DAILY AVG
58.55 POINTS
MODELING THE DATA • MOVE TRANSFORMERS, SWITCHS, LIGHTS, GUYS OFF OF POLES BUT KEEP ASSOCIATION WITH POLE. • ASSOCIATE FEATURES. FOR EXAMPLE CUSTOMERS WITH TRANSFORMERS AND CONDUCT LINE. SWITCHES WITH CONDUCT LINE AND POLES. • SNAP CONDUCT LINES TO POLES AND UGFAC. • SUBSTATIONS DRAWN TO FIT MODEL. • SYMBOLOGY
AFTER
BEFORE
PRIMARY SECONDARY
TRANSFORMER
POLE
CUSTOMER
LIGHT
CONNECTIVITY • ENSURE CONDUCT LINE HAVE NO OPEN ARCS. • LOOK FOR PHASE DIFFERENCES/PROBLEMS. • CHECK FOR DE-ENERGIZED LINES. • EVERY CUSTOMER GOES TO PROPER TRANS. • EVERY CUSTOMER AND TRANSFORMER GOES TO PROPER CONDUCT LINE. • ALL SWITCHES ARE CORRECT POLE AND CONDUCT LINE AND PROPERLY OPENED OR CLOSED. • RUN TRACING PROGRAM TO ENSURE SUBSTATION CONNECTIVITY BEGINNING TO END.
MISSED AND NEW DATA • ENTERED IN THREE YEARS OF WORKORDERS. • GPS AND DRAW NEW SUBDIVISIONS. • GPS AND DRAW MISSED TAPS. • FINISH ELECTRIC UNDERGROUND AREAS. • GAS AND WATER/WASTERWATER CONNECT VALVES WITH PIPES AND DRAW IN SERVICE LINES. • GAS AND WATER/WASTEWATER ADD IN CUSTOMERS AND ASSOCIATE TO PIPE.
1.5.43 1.5.16 1.5.43 1.5.43 1.5.16 1.5.16 1.5.43 1.5.43 1.5.16 1.5.43 1.5.43 1.5.43 1.5.16 1.5.43 1.5.16 1.5.43 1.5.43 1.5.43 1.5.16 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43
TOTALS 29 29 27 CURRENT UAI PROGRAMS INSTALLATIONS GROUP # ELECTRIC 14 * FUTURE UAI PROGRAMS SQL SEATS GAS 10 GROUP NUM FUT TOT WATER 4 ELECTRIC 14 2 16 SERVER 1 GAS 10 2 12 TYPE # WATER 4 2 6 DESKTOP 20 SERVER 1 0 1 LAPTOP 9 29 6 35 TOTALS
7
X
X
X X X
X
X X X X X X X X X X X X X X
X X
X
X
X
X
6
X X X X
FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD
X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
DOMAIN FLOUTIL FLOGAS-PD
# 15 14
uaARCi uaFM uaNVServer uaPE
Version 1.2.4 1.2.4 1.5.5 1.5.29
20
MERGE
WINDOWS 2000
1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15
DOMAIN
1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.039 1.039 1.039 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39
ARCVIEW
Chester Richey Allen Caddell Ben Crane Chip Rasch David Harper Don Heupel Dispatch Op Jeff McDonald Derek Pigg Chester Richey Will Harper Jerry Ford Mary McDuffa Richard Morrissey Steve Ford Chip Daniel Melonie Burns Gas Laptop Gas Laptop Gas Laptop Gas Laptop Gas Laptop John Moody Sam Rhodes Stan Pruitt Larry Grace Larry Grace Water Foreman Walter Salter
SP2 UPDATE
Administrator Acaddell BCrane1 Crasch Dharper Dheupel Dispatch Jeffmc13 DPigg GISmgr Wharper JFord MMcDuffa RMorrissey Sford Cdaniel Mburns GIS3 Servicetrk1 Servicetrk2 Servicetrk3 Servicetrk4 John srhodes Spruitt Lgrace Lgrace Wforeman Wsalter
UAFM
UASYSMON
SER ELE ELE ELE ELE ELE ELE ELE ELE ELE ELE ELE ELE ELE ELE GAS GAS GAS GAS GAS GAS GAS GAS GAS GAS WAT WAT WAT WAT
UADISPATCH
NAME
UAFIELD
NTID
UASUBSCRIBE
UAFLO1 D ACADDELL D BCRANE1 D CRASCH4300 D DAVIDHARPER D DHEUPEL D DISPATCH D GIS D GISIBM D GISMGR D HARPER D JFORD D MCDUFFA D RMORRISSEY2 L SFORD D CDANIEL-LT L GASDISPATCH D GIS3 L GSERVICETRK1 L GSERVICETRK2 L GSERVICETRK3 L GSERVICETRK4 L JOHN D SRHODESLT L SPRUITT D WATERGIS L WATERGIS2 D WFOREMAN D WSALTER D
GROUP
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
TYPE
COMPUTER
12:44am 12:30am 12:41am 12:46am 12:40am 12:10am 12:46am 12:31am 12:31am 12:29am 12:35am 12:03am 12:44am 12:46am 12:06am 12:11am 12:46am 12:08am 12:12am 12:17am 12:18am 12:22am 12:56am 12:20am 12:08am 12:08am 12:15am 12:54am
EDITING
WEB APPS
DATABASE EDITING
e-REPORTS uaNET
WORKORDER
UPDATES
DATABASE MAINTENANCE
& SECURITY
GPS GIS IMAGES
GIS DATABASE INQUIRY uaPROGRAMS
uaPROGRAMS
SQL TABLES
TRUCK
TROUBLE
MAPS
CALL
INTERACTIVE VOICE RESPONCE PHONE SYSTEM
CIS DATABASE
uaFIELD - WORKORDER • PERFORM FIELD EDITING, JOB ESTIMATION, MATERIAL ORDERING, JOB TRACKING AND SCHEDULING • EDIT AND MAINTAIN GIS ON A WORK ORDER BASIS OR DIRECTLY UPDATE EXISTING MAPS • ENTER AND UPDATE DATA USING INTELLIGENT DATA ENTRY FORMS • PRODUCE STANDARD STAKING PLOTS AND INVENTORY SHEETS • CREATE WORK ORDERS IN THE FIELD UTILIZING PORTABLE PCs • UPDATING OF BASE FILES • USES SQL SERVER DATABASE
uaFIELD - TRUCK MAPPING • PORTABLE COMPUTERS IN FOREMAN’S TRUCK • ACCESS TO SYSTEM INFORMATION • UPDATE CUSTOMER AND EQUIPMENT DATA IN THE FIELD • COMMON MAP GRID SYSTEM
POWER OUTAGES BEFORE • STAFF ANSWERS PHONES GETS DATA FROM CUSTOMER • DIRECTIONS HARD TO INTERPRET • EXTENT OF OUTAGE IN HEAD OR STICKY NOTES • AT CONCLUSION OF OUTAGE RETURN CALLS TO VERIFY
uaDISPATCH - TROUBLE CALL • OUTAGE MANAGEMENT SYSTEM WORKING DIRECTLY WITH GIS DATABASE • LOCATE CUSTOMERS ON A MAP • INTEGRATES FULLY WITH AT&T CONVERSANT AUTOMATED PHONE SYSTEM • PREDICTION ALGORITHM TO DETERMINE A POSSIBLE FAILED DEVICE AND SERVICE AREA • ALLOW THE USER TO PERFORM OUTAGE ANALYSIS • CREW MANAGEMENT AND OUTAGE REPORTS
CONVERSANT IVR SIMS PACKAGE
DISPATCH
TROUBLE TICKET
GIS SERVER
AS 400
NETWORK PRINTER
CUSTOMER DATA
SQL SERVER
CURRENT AND FUTURE PROJECTS • INTEGRATION OF GIS DATA WITH SERVICE CREWS AND CSR (ELECTRIC DEPT) • STREAMLINE CURRENT PROGRAMS TO MAKE USE OF GIS DATA (ALL DEPTS) • WORKORDER INTEGRATION • MILSOFT INTEGRATION • SCADA INTEGRATION • BE ABLE TO UPDATE AS400 DATABASE WITH GIS DATABASE
FLORENCE UTILITIES
LAUDERDALE COUNTY • ELECTRIC, GAS, WATER AND WASTEWATER • COUNTY ABOUT 690 SQUARE MILES • APPROXIMATELY 46,700 ELECTRIC, 21,500 WATER AND 17,000 GAS CUSTOMERS • GIS FULLY OPERATIONAL JUNE 2002
BRIEFING OUTLINE REASONS/BENEFITS INVENTORY PHASE CONNECTIVITY PHASE IMPLEMENTATION PHASE INTEGRATION PHASE
REASONS/BENEFITS • ACCURATELY LOCATE CUSTOMERS • DISPATCH MANAGEMENT • LOCATING FACILITIES AND EQUIPMENT • IMPROVE CURRENT METHODOLOGY (WORKORDER MANAGEMENT) • ALL DEPARTMENTS UTILIZING SIMILAR SOFTWARE AND BASE-MAPS • IMPROVE SYSTEM ANALYSIS AND PLANNING • DISTRIBUTION CONNECTIVITY
Baker GeoResearch - GEOLINKS
University of North Alabama
PREPERATION FOR INVENTORY • REPLACE OLD RURAL ROUTE SYSTEM NOW USE STREET NUMBER AND ROAD NUMBER OR NAME METHOD • EACH CUSTOMER ASSIGNED UNIQUE ADDRESS (KEY TO PROJECT) • GPS DATABASE • GIS DATABASE • METHODOLOGY AND EQUIPMENT
LANDBASE
ROADS OF COUNTY GPS’d BY CONTRACTOR IS OUR BASE MAP
GPS • GLOBAL POSITIONING SYSTEM • DEVELOPED BY DEPARTMENT OF DEFENSE • CONSTELLATION OF 24 SATELLITES • PINPOINT POSITIONS 24 HRS A DAY • TRIANGULATION IS THE BASIS OF THE SYSTEM
GPS ERROR SOURCES SATELLITE CLOCKS
SELECTIVE AVAILABILITY
EPHEMERIS
ATMOSPHERIC DELAYS
RECEIVER CLOCKS, ETC.
MULTIPATHING
WHAT IS DIFFERENTIAL GPS? • COOPERATION
BETWEEN TWO
STATIONARY SATELLITE (GPS)
RECEIVERS • STATIONARY SATELLITE TIES MEASUREMENTS INTO SOLID LOCAL REFERENCE • REFERENCE RECEIVER WORKS BACKWARDS USING POSITION TO CALCULATE TIMING
FIELD RECEIVER
• TIMING DIFFERENCES IS ERROR OR DELAY IN SIGNAL • DGPS MORE ACCURATE
REFERENCE RECEIVER
DGPS INVENTORY • USED 12 CHANNEL SATLOC REAL-TIME DGPS SYSTEM WITH GEOLINK SOFTWARE • PEN BASED COMPUTER USED TO FIELD INVENTORY • ELECTRICAL CONNECTIVITY FROM SUBSTATION TO METERS • CUSTOMER BILLING DATA • ACCOUNT NUMBER TIE BETWEEN CUSTOMER DATABASE AND GEOGRAPHICAL POSITION
DGPS PROCESSING • POST PROCESSING • FIRST QC OF ELECTRONIC REPRESENTATION • DGPS FILE TRANSLATED TO SHAPEFILE
WHAT IS GIS? “An organized collection of computer hardware, software, geographic data, and personnel designed to efficiently capture, store, update, manipulate, analyze, and display all forms of geographically referenced information”. (Understanding GIS—The ArcInfo Method, ESRI)
IF YOU WERE TO TAKE OUT THE REFERENCES TO GEOGRAPHIC DATA YOU WILL FIND THAT THE DEFINITION IS VERY SIMILAR TO THAT OF A DATABASE
A FEATURE UNIQUE TO A GIS IS ITS ABILITY TO DO “DATA-LINKAGE” USING LOCATION AS THE COMMON KEY
GIS DURING INVENTORY PHASE • MERGED DGPS DATA • HELPED TO KEEP TRACK OF WHERE WE WERE AND WHERE WE HAD TO GO • USED SYMBOLOGY TO QUALITY CONTROL • LOCATE MISSING DATA AREAS • EASY TO EDIT DATA WHEN IN SHAPEFILE FORMAT USING ARCVIEW OR ARCMAP • ELECTRIC UNDERGROUND BUILT IN ARCVIEW
ELECTRIC & GAS DEPT COLLECTION TOTALS
ELECTRIC DEPARTMENT
GAS DEPARTMENT
TOTAL GPS
184124 POINTS
TOTAL GPS
8009 POINTS
TOTAL SKETCH
104615 LINES/POINTS
TOTAL SKETCH
11547 POINTS
TOTAL UGFAC
4022 POINTS
TOTAL POINTS
19556
TOTAL POINTS
292761
NUMBER OF DAYS 334
NUMBER OF DAYS 605 DAILY AVG
304 POINTS
DAILY AVG
58.55 POINTS
MODELING THE DATA • MOVE TRANSFORMERS, SWITCHS, LIGHTS, GUYS OFF OF POLES BUT KEEP ASSOCIATION WITH POLE. • ASSOCIATE FEATURES. FOR EXAMPLE CUSTOMERS WITH TRANSFORMERS AND CONDUCT LINE. SWITCHES WITH CONDUCT LINE AND POLES. • SNAP CONDUCT LINES TO POLES AND UGFAC. • SUBSTATIONS DRAWN TO FIT MODEL. • SYMBOLOGY
AFTER
BEFORE
PRIMARY SECONDARY
TRANSFORMER
POLE
CUSTOMER
LIGHT
CONNECTIVITY • ENSURE CONDUCT LINE HAVE NO OPEN ARCS. • LOOK FOR PHASE DIFFERENCES/PROBLEMS. • CHECK FOR DE-ENERGIZED LINES. • EVERY CUSTOMER GOES TO PROPER TRANS. • EVERY CUSTOMER AND TRANSFORMER GOES TO PROPER CONDUCT LINE. • ALL SWITCHES ARE CORRECT POLE AND CONDUCT LINE AND PROPERLY OPENED OR CLOSED. • RUN TRACING PROGRAM TO ENSURE SUBSTATION CONNECTIVITY BEGINNING TO END.
MISSED AND NEW DATA • ENTERED IN THREE YEARS OF WORKORDERS. • GPS AND DRAW NEW SUBDIVISIONS. • GPS AND DRAW MISSED TAPS. • FINISH ELECTRIC UNDERGROUND AREAS. • GAS AND WATER/WASTERWATER CONNECT VALVES WITH PIPES AND DRAW IN SERVICE LINES. • GAS AND WATER/WASTEWATER ADD IN CUSTOMERS AND ASSOCIATE TO PIPE.
1.5.43 1.5.16 1.5.43 1.5.43 1.5.16 1.5.16 1.5.43 1.5.43 1.5.16 1.5.43 1.5.43 1.5.43 1.5.16 1.5.43 1.5.16 1.5.43 1.5.43 1.5.43 1.5.16 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43 1.5.43
TOTALS 29 29 27 CURRENT UAI PROGRAMS INSTALLATIONS GROUP # ELECTRIC 14 * FUTURE UAI PROGRAMS SQL SEATS GAS 10 GROUP NUM FUT TOT WATER 4 ELECTRIC 14 2 16 SERVER 1 GAS 10 2 12 TYPE # WATER 4 2 6 DESKTOP 20 SERVER 1 0 1 LAPTOP 9 29 6 35 TOTALS
7
X
X
X X X
X
X X X X X X X X X X X X X X
X X
X
X
X
X
6
X X X X
FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOUTIL FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD FLOGAS-PD
X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
DOMAIN FLOUTIL FLOGAS-PD
# 15 14
uaARCi uaFM uaNVServer uaPE
Version 1.2.4 1.2.4 1.5.5 1.5.29
20
MERGE
WINDOWS 2000
1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15 1.5.15
DOMAIN
1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.039 1.039 1.039 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39 1.0.39
ARCVIEW
Chester Richey Allen Caddell Ben Crane Chip Rasch David Harper Don Heupel Dispatch Op Jeff McDonald Derek Pigg Chester Richey Will Harper Jerry Ford Mary McDuffa Richard Morrissey Steve Ford Chip Daniel Melonie Burns Gas Laptop Gas Laptop Gas Laptop Gas Laptop Gas Laptop John Moody Sam Rhodes Stan Pruitt Larry Grace Larry Grace Water Foreman Walter Salter
SP2 UPDATE
Administrator Acaddell BCrane1 Crasch Dharper Dheupel Dispatch Jeffmc13 DPigg GISmgr Wharper JFord MMcDuffa RMorrissey Sford Cdaniel Mburns GIS3 Servicetrk1 Servicetrk2 Servicetrk3 Servicetrk4 John srhodes Spruitt Lgrace Lgrace Wforeman Wsalter
UAFM
UASYSMON
SER ELE ELE ELE ELE ELE ELE ELE ELE ELE ELE ELE ELE ELE ELE GAS GAS GAS GAS GAS GAS GAS GAS GAS GAS WAT WAT WAT WAT
UADISPATCH
NAME
UAFIELD
NTID
UASUBSCRIBE
UAFLO1 D ACADDELL D BCRANE1 D CRASCH4300 D DAVIDHARPER D DHEUPEL D DISPATCH D GIS D GISIBM D GISMGR D HARPER D JFORD D MCDUFFA D RMORRISSEY2 L SFORD D CDANIEL-LT L GASDISPATCH D GIS3 L GSERVICETRK1 L GSERVICETRK2 L GSERVICETRK3 L GSERVICETRK4 L JOHN D SRHODESLT L SPRUITT D WATERGIS L WATERGIS2 D WFOREMAN D WSALTER D
GROUP
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
TYPE
COMPUTER
12:44am 12:30am 12:41am 12:46am 12:40am 12:10am 12:46am 12:31am 12:31am 12:29am 12:35am 12:03am 12:44am 12:46am 12:06am 12:11am 12:46am 12:08am 12:12am 12:17am 12:18am 12:22am 12:56am 12:20am 12:08am 12:08am 12:15am 12:54am
EDITING
WEB APPS
DATABASE EDITING
e-REPORTS uaNET
WORKORDER
UPDATES
DATABASE MAINTENANCE
& SECURITY
GPS GIS IMAGES
GIS DATABASE INQUIRY uaPROGRAMS
uaPROGRAMS
SQL TABLES
TRUCK
TROUBLE
MAPS
CALL
INTERACTIVE VOICE RESPONCE PHONE SYSTEM
CIS DATABASE
uaFIELD - WORKORDER • PERFORM FIELD EDITING, JOB ESTIMATION, MATERIAL ORDERING, JOB TRACKING AND SCHEDULING • EDIT AND MAINTAIN GIS ON A WORK ORDER BASIS OR DIRECTLY UPDATE EXISTING MAPS • ENTER AND UPDATE DATA USING INTELLIGENT DATA ENTRY FORMS • PRODUCE STANDARD STAKING PLOTS AND INVENTORY SHEETS • CREATE WORK ORDERS IN THE FIELD UTILIZING PORTABLE PCs • UPDATING OF BASE FILES • USES SQL SERVER DATABASE
uaFIELD - TRUCK MAPPING • PORTABLE COMPUTERS IN FOREMAN’S TRUCK • ACCESS TO SYSTEM INFORMATION • UPDATE CUSTOMER AND EQUIPMENT DATA IN THE FIELD • COMMON MAP GRID SYSTEM
POWER OUTAGES BEFORE • STAFF ANSWERS PHONES GETS DATA FROM CUSTOMER • DIRECTIONS HARD TO INTERPRET • EXTENT OF OUTAGE IN HEAD OR STICKY NOTES • AT CONCLUSION OF OUTAGE RETURN CALLS TO VERIFY
uaDISPATCH - TROUBLE CALL • OUTAGE MANAGEMENT SYSTEM WORKING DIRECTLY WITH GIS DATABASE • LOCATE CUSTOMERS ON A MAP • INTEGRATES FULLY WITH AT&T CONVERSANT AUTOMATED PHONE SYSTEM • PREDICTION ALGORITHM TO DETERMINE A POSSIBLE FAILED DEVICE AND SERVICE AREA • ALLOW THE USER TO PERFORM OUTAGE ANALYSIS • CREW MANAGEMENT AND OUTAGE REPORTS
CONVERSANT IVR SIMS PACKAGE
DISPATCH
TROUBLE TICKET
GIS SERVER
AS 400
NETWORK PRINTER
CUSTOMER DATA
SQL SERVER
CURRENT AND FUTURE PROJECTS • INTEGRATION OF GIS DATA WITH SERVICE CREWS AND CSR (ELECTRIC DEPT) • STREAMLINE CURRENT PROGRAMS TO MAKE USE OF GIS DATA (ALL DEPTS) • WORKORDER INTEGRATION • MILSOFT INTEGRATION • SCADA INTEGRATION • BE ABLE TO UPDATE AS400 DATABASE WITH GIS DATABASE
