how to enhance data transformation in mapinfo with fme
DESCRIPTION
Find out how to add powerful data transformation capabilities to your MapInfo workflows with FME. Discover how to perform flexible QA on your data and its geometries, and style your data exactly how it’s needed. You’ll also learn how to extend FME directly into MapInfo, and load or export data in 275+ formats including PDF, KML, and CSV.TRANSCRIPT
![Page 1: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/1.jpg)
How to Enhance Data Transformation in MapInfo with FME
Dean HintzSenior Analyst
Mark StoakesManager, Professional Services
![Page 2: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/2.jpg)
Who Are We?
Today’s Presenters:
Mark Stoakes,Manager, Professional Services
Dean Hintz,Senior Analyst,
Professional Services
![Page 3: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/3.jpg)
Safe Software Inc.
95+ exuberant employees
Secret HQ: Vancouver, B.C.
Thousands of happy customers, certified professionals, trainers, system integrators, and value added resellers; all around the globe!
![Page 4: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/4.jpg)
Agenda
60 Minutes FME within MapInfo Loading Data Exporting Data Transformation Demos FME Server
Follow-up Webinar recording and materials
![Page 5: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/5.jpg)
Questions are Encouraged!
We are online, ready to answer your toughest questions
To submit a question:
If we can’t get to your question during the webinar we’ll send a follow-up email.
![Page 6: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/6.jpg)
FME Technology Capabilities
Translate spatial data from one format to another
287 supported formats in FME 2012
Transform spatial data into the precise data model you need
400+ data transformation tools
The only complete spatial data transformation solution
![Page 7: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/7.jpg)
Expanded Data Support
9/2/10
1.4.7 FME 2.0
FME 2.1
FME 2.2
FME 2.3
FME 2.3a
FME 2000
FME 2000 SR-1
FME 2002
FME 2002 SR-1
FME 2003
FME 2003
X2
FME 2004
FME 2004 ICE
FME 2004 ICE3
FME 2005
FME 2006
FME 2006 GB
FME 2007
FME 2008
FME 2009
FME 2010 Beta UC Cut
FME 2010
FME 2011
FME 2012
0
50
100
150
200
250
300
917
29 3346
57 63 67
94 93 99112
123136137
154162
182191
210225
238254
265278
![Page 8: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/8.jpg)
9
Data model transformation is the cornerstone to data interoperability
Schema is front and center
Restructure: Feature Types Attribute Names Enumerated lists Geometry
IntroductionData Model Restructuring
![Page 9: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/9.jpg)
Safe Products…
![Page 10: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/10.jpg)
Poll Questions: About you!
FME use
![Page 11: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/11.jpg)
FME Desktop Components
FME Workbench
12
Use simple point and click to easily define spatial data flows to load, translate and transform your MapInfo data
Graphical authoring environment for data restructuring tasks
![Page 12: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/12.jpg)
Universal Viewer / Data Inspector
Examine and inspect your spatial data’s attributes and geometry - before, after and even during a translation
13
FME Desktop Components
![Page 13: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/13.jpg)
Poll Questions: About you!
MapInfo use
![Page 14: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/14.jpg)
FME and MapInfo
FME – MapInfo format support
Overview of FME functionality in MapInfo
Loading Data into MapInfo
Exporting data out of MapInfo
15
![Page 15: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/15.jpg)
MapInfo Formats - Files
MIF/MID Interchange format
TABMFAL
native better spatial index
MITAB open source extended (mdb, 64bit)
16
![Page 16: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/16.jpg)
MapInfo Formats - Databases
SpatialWare DatabaseOlder – 4.9 release in 2006
Other DatabasesMS SQLServer Spatial (improved in 2012)Oracle Spatial
17
![Page 17: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/17.jpg)
Universal Translator
18
DWG,EOO,SHP,DGN,SDTS,VPF To TAB/MIF or from TAB/MIF
![Page 18: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/18.jpg)
Open Universal Data
Available as of MapInfo 9 More formats Extendable with FME Limitations (error handling, transformation capabilities, volume)
19
![Page 19: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/19.jpg)
Extending MapInfo with FME
20
FME and MapInfo installed on the same machine
![Page 20: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/20.jpg)
Poll Questions: About you!
FME for MapInfo use
![Page 21: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/21.jpg)
22
Loading Data into MapInfo
CAD Non-spatial Raster Database GML, INSPIRE
![Page 22: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/22.jpg)
23
CAD to GIS: Source DWG
Drawing oriented data needs to be converted to feature based
![Page 23: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/23.jpg)
24
CAD to GIS: DWG to TAB
Build areas, join attributes, map to new schema, validate
![Page 24: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/24.jpg)
25
CAD to GIS: Result in MapInfo
Polygons with associated attribution
![Page 25: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/25.jpg)
26
GPS Roads: CSV file
X, Y coordinates with road ID
![Page 26: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/26.jpg)
27
GPS Roads: CSV Coordinates to MapInfo
Styling Approaches: ColorSetter MapInfoStyler AttributeCreator / ValueMapper
![Page 27: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/27.jpg)
28
GPS Roads: Styling Options
![Page 28: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/28.jpg)
29
MapInfo Format Attributes
mapinfo_brush_background mapinfo_brush_foreground mapinfo_brush_pattern mapinfo_brush_transparent mapinfo_pen_color mapinfo_pen_pattern mapinfo_pen_width mapinfo_symbol_* mapinfo_text_*
![Page 29: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/29.jpg)
30
GPS Roads: Styled MapInfo Output
![Page 30: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/30.jpg)
31
Raster Segmentation to MapInfo Elevation Zones
Classify, vectorize, generalize, group and style
![Page 31: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/31.jpg)
Raster Segmentation to MapInfo Elevation Zones
![Page 32: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/32.jpg)
33
Database Loading: MS SQL Server
Key column, geometry column name, style olumn, coordinate system, write mode, extents
![Page 33: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/33.jpg)
34
SQL Server – Make Table Mappable
![Page 34: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/34.jpg)
35
Set geometry and style columns
SQL Server – Make Table Mappable
![Page 35: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/35.jpg)
36
SQL Server –Mappable Table View
![Page 36: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/36.jpg)
Poll Questions: About you!
Database use with MapInfo
![Page 37: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/37.jpg)
38
INSPIRE GML Reader
![Page 38: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/38.jpg)
39
Exporting MapInfo Data
GIS to CAD GIS to Database GIS to XML GIS to consumer clients
PDF KML Publishing to a web service (FME Server)
![Page 39: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/39.jpg)
Safe Products…
![Page 40: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/40.jpg)
What is FME Server?
FME Server is a scalable platform that offers flexible spatial data distribution and loading services
Use the same FME Engine that powers FME Desktop
Transform & Share spatial data via web services
![Page 41: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/41.jpg)
Why FME Server?
How FME Server can meet your needs:
Data Distribution Data Download Service
Live Data Streams Data Streaming Service
Upload and Validation Data Upload Service
Centralize Data Transformation Job Submitter Service
![Page 42: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/42.jpg)
FME Server demonstration
![Page 43: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/43.jpg)
45
MapInfo Transportation Database: PDF Streaming
![Page 44: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/44.jpg)
MapInfo Transportation Database: PDF Streaming
![Page 45: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/45.jpg)
47
MapInfo Transportation Database: PDF Streaming
![Page 46: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/46.jpg)
48
MapInfo Transportation Database: PDF Streaming
![Page 47: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/47.jpg)
49
Transformation with FME
QA / Validation Schema Transformation
Feature Types Fields Domain codes
Geometry Transformation Cleaning Generalization Topology 2D to 3D
![Page 48: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/48.jpg)
50
CAD Validation
Duplicate IDs Valid geometry Valid value ranges Tester, GeometryValidator
![Page 49: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/49.jpg)
Data Transformation 51
Schema Mapping in FME
Feature Type Mapping in FME Workbench
Attribute Mapping in FME Workbench
Schema Mapping in FME
![Page 50: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/50.jpg)
Value Mapping
FME Data Model Restructuring: Attribute Names & Values
![Page 51: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/51.jpg)
FME SchemaMapper: INSPIRE geographic names
Name mapping
Name & value mapping
FME Workspace
![Page 52: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/52.jpg)
MapInfo Export to GML Application: INSPIRE Geographic Names Example
![Page 53: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/53.jpg)
Geographic Names: GML Result
![Page 54: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/54.jpg)
56
MapInfo Considerations
Coordinate Systems, Reprojectors & Exceptions (mapinfo_wkt.db)
Integer precision – be careful about extents Databases & CAD – QA required. Many schemas
are more restrictive requiring geometry filtering and validation before you can write
Databases – MS SQLServer 2012 – better spatial indexing, geographic type
ValueMapper, SchemaMapper for data remodeling FME Server for web services, offloading heavy
process automation, deploying GIS data and tools to non GIS users
![Page 55: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/55.jpg)
FME 2012: Multi-Processing
![Page 56: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/56.jpg)
Expanded Data Support
New Formats of FME 2012:
Google Fusion Tables Reader, Writer
INSPIRE Reader
LAZ Reader, Writer
OpenFlight Reader (enhanced Writer)
Oracle point clouds Reader, Writer
Ordnance Survey VectorMap Reader
Supermap Reader, Writer
Plus many updates (SQLServer 2012, etc)
AIS Reader
AIXM 5.1 Reader
ArcPad Reader
CAT Reader
CityGML 2.0 Reader, Writer
DataFile Reader, Writer
DirectX Reader, Writer
Free File Geodatabase API
![Page 57: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/57.jpg)
What’s Next?
Personalized web demo – [email protected] Try FME Desktop FME Server tutorial Upcoming webinars:
Intro to FME Desktop
http://safe.com/learning/webinars/
Training: Mastering FME 2012 FME Desktop on-line
– register with promo code
![Page 58: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/58.jpg)
Poll Question:
FME training
![Page 59: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/59.jpg)
Question & Answer Period
FME MapInfo
![Page 60: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/60.jpg)
What we’ve seen today: FME Loading to MapInfo FME Exports from MapInfo FME Data Transformation FME Server
Summary
![Page 61: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/61.jpg)
63
Resources
Safe.com Workbench Help Readers and Writers Transformer Reference FMEpedia: articles and examples FMEchannel on YouTube www.safe.com/support
![Page 62: How to Enhance Data Transformation in MapInfo with FME](https://reader034.vdocuments.us/reader034/viewer/2022052303/54b70a074a7959524f8b45f2/html5/thumbnails/62.jpg)
Thanks for Attending!
Webinar recording link and follow-upwill be sent to you via email
Info: [email protected]
Still have questions? www.safe.com/support Try www.fmepedia.com and search ‘mapinfo’
Additional Resources http://www.youtube.com/watch?v=dLVlSLdg580&feature=g-user-u Search you tube for “FME for MapInfo Professional”Thanks to David Eagle from 1-Spatial