![Page 1: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/1.jpg)
CONNECT. TRANSFORM. AUTOMATE.
No pressure, but the Workbench needs fixing so the co-worker can go have her baby...
Bruce HaroldProduct Manager, Esri
![Page 2: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/2.jpg)
Where does Esri use FME technology?
Report or Story?
Show of hands please
![Page 3: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/3.jpg)
Your Next 20 19 Minutes Journey
Ordinary World Call to Adventure Refusal of the Call Meeting with the Mentor Crossing the Threshold Tests, Allies and Enemies Approach the Innermost Cave Ordeal Reward The Road Back Resurrection Return with the Elixir Better World
![Page 4: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/4.jpg)
Ethos, Logos, Pathos
Project an image of credibility Then go prove it Win hearts and minds
Get more work to do….
![Page 5: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/5.jpg)
Patterns in FME Use Cases - Formats
Spreadsheets DBase OGC Formats CAD CSV (the optimists
spreadsheet) Custom (weird)
structures
XML (what are they thinking?)
JSON RSS Directories of Data URLs The baby is coming
![Page 6: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/6.jpg)
Patterns in FME Use Cases - Functions
Cross Database Joins
Casting Data Types Lists & Cardinality Vertical Datum Coordinate
Rounding NULL handling
SDE Updating Feature Granularity Binary Attributes Change Detection Concatenation Expressions REST/URL handling
![Page 7: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/7.jpg)
The Dreaded Functionality Gap
Change is guaranteed Change always meets resistance It is hard to design for change Luckily, our software is complete and perfect
Except for…
![Page 8: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/8.jpg)
Sometimes it’s a judgment call
Field Map ControlModelbuilder
![Page 9: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/9.jpg)
Baby Story
Baby needed TestFilter
![Page 10: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/10.jpg)
Community Maps
![Page 11: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/11.jpg)
Community Maps
Crowd to Cloud Authoritative Data for:
Streets, Topography, Imagery, Hydrography Esri supply the data model Contributor sends data regularly Contributor data is Change Detected (FME!) Adds, Deletes go to SDE Version, gets posted Map tile cache refreshed
![Page 12: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/12.jpg)
Community Maps Processing
Contributor ID: {B0BEE756-A683-4700-ACCE-9585A07559C4}
![Page 13: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/13.jpg)
Community Maps Processing
![Page 14: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/14.jpg)
Community TIGER
Census Bureau project to harvest: Streets with Address Ranges Address Points (Multiple Dwelling Units) Local Government Boundaries
39,000 Local Governments Quality Control Steps – Data Reviewer
Interesting combination of DR workspace & DI Change Detect, De-dupe, Compress, Load to SDE
![Page 15: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/15.jpg)
Community TIGER Workflows
http://geocoding.geo.census.gov/geocoder/
![Page 16: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/16.jpg)
Community TIGER
ETL Tools
![Page 17: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/17.jpg)
3D Work
Bulk 3D Geometry Creation, Editing 3D Geometry Comparisons Next Generation 3D Geocoding
![Page 18: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/18.jpg)
Aeronautical Charting Example
FMW is 36Mb 110 Bookmarks 1000+Transformers
![Page 19: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/19.jpg)
Professional Services
Handling Excel, DBase, CSV without stress Eliminate need for scripting in Python
Join Excel
Read CSV
![Page 20: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/20.jpg)
Professional Services Cont’d
Example Multiple DBase Join
7 x Dbase JoinersRead File GDB
![Page 21: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/21.jpg)
On the Slab in the Lab
Thread Pool
![Page 22: No pressure, but the Workspace needs fixing so the coworker can go have her baby](https://reader035.vdocuments.us/reader035/viewer/2022070318/55796d92d8b42a3a5c8b4eb5/html5/thumbnails/22.jpg)
The Perfect Workspace
Generic Format + Dynamic Schema + Python