utilities industry success stories with fme
DESCRIPTION
Find out how different utilities around the world are using FME, including several case studies and guest presenters from Georgia Power.TRANSCRIPT
Utilities Industry Success Stories with FME
Oct 2014
Jeff DeWitt, Renato Salvaleon & Paul Schneider,Georgia PowerMark Stoakes, Safe Software Inc.
Agenda
Introductions
Examples from Georgia Power
Examples from around the world
Q&A
Today’s presenters
Paul
Jeff
Renato
Mark
Questions?
Steve
What we do.
Data Inclusion & Task Diversity
A diversity tasks for utilitiesThe inclusion of many formats for utilities
• Electric Transmission & Distribution• Gas Transmission & Distribution• Water & Sewer Distribution• Landbase
Poll?
• Where are you primarily working :– Electric– Gas– Water– Land management– Other…
Data Inclusion: Formats for UtilitiesDatabase & GIS formats
GE Smallworld Intergraph G/Technology ESRI Geodatabase & Schneider ArcFM AutoCAD Map 3d Enterprise (TopoBase) Bentley Electric Oracle Spatial Legacy formats:
Intergraph FRAMME VISION* (AUD) MGE
Data Inclusion: Formats for Utilities
CAD formats AutoCAD (many versions) AutoCAD Map 3D Bentley MicroStation
Others… JSON (CGI M3i ) ASCII (Oracle NMS MP ) CIM XML Other:
MultiSpeak, PLSCad (XML), CYME, GME, KML
FME for a Diversity of Tasks for Utilities• Data migration from a legacy GIS or CAD• Synchronising across GIS databases• Tying into external systems – asset management• Location Intelligence / Economic Development• CAD & GIS round trips• Connect real-time systems: DMS / OMS etc.• Data Validation• Working with Geometric Networks• Real-time GPS & Mobile
Georgia Power Overview• The largest subsidiary of Southern Company• Investor-owned, tax-paying utility • Over 8,500 employees • 2.4 million customers• Serves 155 of the
state’s 159 counties
Working with Text Files
• Converts text file and updates data in Oracle SDE database
• Parses text data into separate fields and combines data from nearby text lines
• Source data
Jeff DeWitt,[email protected]
Georgia Power
XML to SDE• Converts XML data file to SDE Oracle feature
class• Uses XML mapping document .xmp file to
parse data• Determines data that has been added,
updated, or deleted and writes appropriate changes directly to SDE
• Source data and mapping file
SDE to Email• Reads feature class from SDE Oracle database
and sends filtered records via email• Uses XML Templater to format email and HTML
Python Emailer to generate email
• Emails send out data to contacts in format they can easily update and return
GeoRSS for new Issues
Ad Hoc
• ESRI Data to KMZ for display in Google Earth
• General Data Conversions
Environmental Best Practices for Transmission facility projects
Renato [email protected]
Georg1a Power
http://georgiapowerland.maps.arcgis.com/home/
CONNECT. TRANSFORM. AUTOMATE.
Environmental Best Practices for Transmission facility projects… GIS to CAD workflow with too many handoffs
Vendor Submittal
•Submits field collected data in GIS personal geodatabase format
Environmental Specialist
•Uses ArcMap•QCs the data•Weeds out unwanted data using Object IDs of each feature class
•Loads data in to SDE
GIS Analyst
•Converts data from CAD to GIS from SDE
Mapper• Adds Env
data to the plan QA
QA
QA
CONNECT. TRANSFORM. AUTOMATE.
FME enters into the picture… to automate the pieces
Vendor Submittal
•Submits field collected data in GIS personal geodatabase format
Environmental Specialist
•QCs the data•Weeds out unwanted data using Object IDs of each feature class
•Loads data in to SDE using FME.
GIS Analyst
•Converts data from CAD to GIS from SDE using FME
Mapper• Adds Env
data to the plan
QA
QA
QA
CONNECT. TRANSFORM. AUTOMATE.
SimplifyRemove the GIS Analyst from the submittal process
Vendor Submittal
•Submits field collected data in GIS personal geodatabase format
Environmental Specialist
•QCs the data•Weeds out unwanted data using Object IDs of each feature class
•Runs one FME workspace
Mapper• Adds Env data to the plan
GIS Analyst
Supports the workspace
CONNECT. TRANSFORM. AUTOMATE.
A Simplified, Automated task… using a single workspace
Vendor Submittal
Excel report
SDE data load
DXF Output
CONNECT. TRANSFORM. AUTOMATE.
Added QC for GIS data load … to prevent duplicate data loads for project
DXF Output
CONNECT. TRANSFORM. AUTOMATE.
QC Transformers … prevent project features to be duplicated in SDE
CONNECT. TRANSFORM. AUTOMATE.
Added MapTextLabeller… for more visually appealing labels and save time for the drafter
Without MapTextLabeller
With MapTextLabeller
CONNECT. TRANSFORM. AUTOMATE.
An improved tool to complete the task… using a single workspace but with QC and better CAD labels
Vendor Submittal
Excel report
SDE data load with duplicate checker
DXF Output with MapTextLabeller
Create harmony between data and applications
Q&A
Poll?• Who’s using FME
ATMOS Energy Corporation
One of the country’s largest natural-gas only distributors
3 million customers in 9 states
Marcin GoreckiGIS Specialist, Atmos Energy
Full Presentation
Problem:Migrate from a drawing based CAD platform to the GE Smallworld GIS
Goal: Transfer CAD to GIS with minimum data loss
Looks simple, but the devil is in the custom transformer details…- Snap and clean-up- Create areas- Match text
and more…
Validate:
Check the outcome in the Smallworld GIS: Important part of
checking outcome is also checking for data in editor window in SW
Of course the same process works the other way. Atmos are able to transform Smallworld objects to AutoCAD.
But that’s a story for another day…
For more information:
– [email protected]– Atmos Energy
Larry Wiebe GIS Data Specialist,
Manitoba [email protected]
Fire Proximity Awareness
Full Presentation
Pull daily fire maps from FTP site
Defined a set of critical electric/gas infrastructure
TransmissionStationsDistributionCommunicationsConstruction Corridor
Add real-time weather
Create clear, clean maps with symbology for fire locations and infrastructure
Weather Conditions
Display:
Display:
Supporting Data
Crew Location
Crew History:
Crew location points gathered every 5 minutes
UTC = temps universel coordonné
• Crew Tracks: Assembles points into lines based on UTC date/time sequence
• Time stampsassign UTC start and end times
Summary• Fire Proximity Awareness– Location Intelligence– Consolidate a diverse range of datasets – Appropriate transformation to simplify the data
analysis– Output to a suitable format for presentation &
display
Effective ESRI Geometric Network Tracing with FME
Established in 1889
355,000 Electric Customers
21,700 miles electric lines
314,000 Gas Customers
7,670 miles gas pipe
8 Hydro Facilities
GIS users since 1992
FME users since 2004
Vancouver, BC
Erika Jacobs, Avista [email protected]
Full Presentation
Effective ESRI Geometric Network Tracing with FME
Problem Find all customers downstream of
gas fittings that must be replaced and notify them of
impending workSolution
FME’s Network Topology Calculator
Effective ESRI Geometric Network Tracing with FME
Be selective– Service pipe only– Selected work area
polygons– Filter by material
and installation date
Prep the data– Split complex edges– Clean data• Everything coincident• No self-intersects
Effective ESRI Geometric Network Tracing with FME
Create the Network
Match Points to NetworkAssign Network_IDs to tees and metersFind Downstream meters
Effective ESRI Geometric Network Tracing with FME
Other Examples• Find Number of Meters
served by each Gas Pressure Zone
• Find Emergency Shut-off Islands
• Network Health Checks
• Isolated Steel Pipe
Create harmony between data and applications
Q&A
More Brilliant User Presentations…Synchronizing AutoCAD® Map 3D Enterprise with
ESRI® ArcSDE®, Drew Burgasser, CAD Masters
ENMAX Supporting Processes and Improving GIS Data Workflows with FME, Sophie Duan & Terry
Magnusson , ENMAX Power Corp.
FME: Solutions for Utilities
Thank you! Jeff, Renato, Paul, Georgia Power
[email protected]@[email protected]
Mark, Safe Software Inc.
Free FME Trainingwww.safe.com/trainingwww.safe.com/support