mobile design tool pole inspection via gis · sun v880 8 by 32 4 sde oracle instances wan web...
TRANSCRIPT
![Page 1: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/1.jpg)
EGUG 2004
![Page 2: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/2.jpg)
Southern Company120,000 square miles
Alabama Power1,370,479 Georgia Power
2,000,000
Gulf Power393,858
MississippiPower
193,000
SavannahElectric139,826
![Page 3: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/3.jpg)
Hurricane IVANAlabama Power825,000
60%
Georgia Power400,000
20%
Gulf Power364,000
92%
Mississippi70,00036%
![Page 4: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/4.jpg)
Southern Company Distribution Production Architecture
Laptops/TabletPCs
XP Desktops
Citrix Farm – Dell 4 by 8
Sun V8808 by 32
4 SDE Oracle Instances
WAN
Web ServerDell 2 by 2
ArcIMS App.Server
Dell 2 by 2
Current Environment
ORACLE 9i 64 bitArcGIS 8.3.1ArcFM 8.3.1
![Page 5: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/5.jpg)
Southern Company Distribution Production Architecture
Pilot Conversion Production
Alabama Power
Savannah Electric
Mississippi Power
Gulf Power
Georgia Power
ArcINFO7.x
ArcINFO7.x
SDE
Oracle
Oracle
April 2005
June 2005
July 2005
AutoCad
AutoCad ?
![Page 6: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/6.jpg)
• Headquartered in Birmingham, Alabama
• 1.3 million customers• 44,500 square mile service territory
• 300 GIS Field Users• ArcMap and ArcFM delivered via Citrix• View and Query only• Centralized Posting and Data
Management
Alabama Power Company
Electric Distribution GIS
![Page 7: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/7.jpg)
Pole Inspection via GISMark Swindall
Simple Mobile Design ToolMichael Cleland
![Page 8: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/8.jpg)
Pole Inspection via GIS
Mark SwindallPrincipal Engineer – Power Delivery Methods and
Systems Alabama Power Company
![Page 9: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/9.jpg)
Pole Inspection at APC•1.6 million distribution poles
•Eight year inspection cycle
•200,000 plus poles inspected per year
On PAPER maps!
![Page 10: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/10.jpg)
Pole Inspection at APC••Pole Inspections are directed by personnel Pole Inspections are directed by personnel within each operating region, and reported to a within each operating region, and reported to a corporate levelcorporate level
••Inspection areas are established by either map Inspection areas are established by either map or by feederor by feeder
••OSMOSE numbers the polesOSMOSE numbers the poles
••The sheet number/pole number is on the The sheet number/pole number is on the invoice invoice
••Reconciliation is manual between the map and Reconciliation is manual between the map and invoiceinvoice
![Page 11: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/11.jpg)
OSMOSE Fastgate•Utilizing Shape files, APC can now provide GIS data to OSMOSE
•Feeder data including poles, circuits, and other equipment can be emailed to OSMOSE
•Data is processed and sent to field personnel
![Page 12: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/12.jpg)
With a little help from our friends…
•Viable option to send electronic data to OSMOSE
•Select only desired layers
•Export tool developed by MESA Solutions utilized
![Page 13: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/13.jpg)
Feeder Selection
•Primary & Secondary poles
selected
•Roads
•Subs, xfr, all switches
•200 scale map grid
![Page 14: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/14.jpg)
OSMOSE Fastgate Mobile• Utilizing Windows CE field device for
APCo project:– Uses our data for existing poles– GPS positioning of poles not in data– Visual survey of equipment &
attachments– Spacing and clearance – QA/QC processing in the field
![Page 15: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/15.jpg)
Import ProcessInspection
Data
Import &Reconcile
SDE
ReportingSystem
Map Objects
![Page 16: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/16.jpg)
Import & Reconcile
•Data is received via email in an Access .mdb file
•Imported into edit session via MESA tool
![Page 17: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/17.jpg)
Import & Reconcile•First the data is inspected•for validity against SDE
•Report produces table
•The table drives the Map Document Symbology
![Page 18: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/18.jpg)
Import & Reconcile
•Inspection Record…FIF
•Pole attribute different
•Equipment discrepancy
![Page 19: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/19.jpg)
Import & Reconcile
![Page 20: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/20.jpg)
Post to SDEThe valid data is nowPosted to SDE
•The Pole Inspection data will be kept in history for the 8 year cycle
![Page 21: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/21.jpg)
SDE
InspectionData
Import &Reconcile
ReportingSystem
Map Objects
Reporting System
![Page 22: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/22.jpg)
Reporting System
![Page 23: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/23.jpg)
Reporting System
![Page 24: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/24.jpg)
Reporting System
![Page 25: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/25.jpg)
Reporting System
![Page 26: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/26.jpg)
Reporting System
![Page 27: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/27.jpg)
Successes•No more plotting maps for inspection crews
•No manual numbering of poles
•No manual matching of maps to paper invoices
•More efficiency in the field – a single device/no maps
•Automated reconciliation of billing information
•Easier reporting to management
![Page 28: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/28.jpg)
Simple Mobile Design Tool
Mike ClelandPrincipal Engineer – Power Delivery Methods and
Systems Alabama Power Company
![Page 29: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/29.jpg)
• Test hardware
• Simulate a mobile desktop environment
• Demonstrate mobile GIS functionality
• Evaluate user adaptability to tablet PC’s
• Focus on simplicity
• Limit investment
• Leverage existing knowledge
Project Field Evaluation of Tablet PC’s
![Page 30: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/30.jpg)
• Show the potential of GIS in the field
Opportunities and Issues
• Needed a GIS tool, with more than display and query• Personnel already familiar with the ESRI draw tool
Opportunity
Issues
• More efficiency desired• Which required tool specialization • We had to keep it simple
But …
![Page 31: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/31.jpg)
The Result
This Standard tool: Becomes This:
![Page 32: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/32.jpg)
Simple Design/Implementation Approach
• Works with PGDB• Designed a tool to automate symbol selection• Uses existing graphics capability of ArcMap • Allows continued use of the ESRI drawing tool
The project was done with MESA Solutions, Inc.Completed and ready for testing in a few days.
![Page 33: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/33.jpg)
Work Order
![Page 34: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/34.jpg)
Redlining
![Page 35: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/35.jpg)
Planning Palette
![Page 36: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/36.jpg)
Planning
![Page 37: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/37.jpg)
Successes
• It showed the wisdom of deploying a simple tool• It spawned additional similar tools• Users requested that it be implemented on Citrix
for the desktop
The Tablet Tool was a success!
Sometimes Simple is better!
![Page 38: Mobile Design Tool Pole Inspection Via GIS · Sun V880 8 by 32 4 SDE Oracle Instances WAN Web Server Dell 2 by 2 ArcIMS App. Server Dell 2 by 2 Current Environment ORACLE 9i 64 bit](https://reader033.vdocuments.us/reader033/viewer/2022060706/6071f399f8e8861fc17923da/html5/thumbnails/38.jpg)
Questions?