using fme to transform survey 123 data
TRANSCRIPT
![Page 1: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/1.jpg)
UsingFMEtoTransformSurvey123Data
JeffPuuri
![Page 2: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/2.jpg)
Senior GIS Consultant30 yrsUtilitiesCompliance / Integrity
• Certified Consultants• Desktop• Server
• Training Site (NL)
![Page 3: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/3.jpg)
FMEisanefficient/effectivesoftwaretoolfortransforming Survey123dataintothenativeformat ofkeybusinesssoftwareplatforms.
![Page 4: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/4.jpg)
Data Collection
![Page 5: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/5.jpg)
Fast / Easy Collection Forms
ü Simple Configuration / Publish Model
ü Configure once - Forms run on any device
![Page 6: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/6.jpg)
Case Study:Landscaping Company
![Page 7: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/7.jpg)
Alert! Surveys to Process
![Page 8: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/8.jpg)
Collecting:• Who– WorkCrew• Where– WhichJobSite• When• WorkDate• Start/StopTimes
![Page 9: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/9.jpg)
Collecting:• What• WorkPerformed• MaterialsConsumed
• 1– MRelationships• JobSiteto:• WorkCrew• Materials
![Page 10: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/10.jpg)
Survey123 LRepository Stability
Data Maintenance PlatformNative Data Source – BI Tools
![Page 11: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/11.jpg)
ArcGIS
ChangeSchema– RewritesFeatureServices
?
DataMaintenance?
?DataSourceforBITools
Issues – Survey123 with AGOL Repository
![Page 12: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/12.jpg)
ArcGIS
ChangeSchema– RewritesFeatureServices
DataMaintenance
DataSourceforBITools
FME to the Rescue!!Re
configur
e
![Page 13: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/13.jpg)
BPMN-based Workflow
![Page 14: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/14.jpg)
Initial Import + Transform: AGOL > File GDB
![Page 15: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/15.jpg)
Iterative Import + Transform: File GDB > File GDB + Excel
![Page 16: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/16.jpg)
PowerQuery QC
![Page 17: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/17.jpg)
QC Editing in ArcGIS Pro
![Page 18: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/18.jpg)
Publishing QC’d data w/ArcGIS Pro
![Page 19: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/19.jpg)
Resulting Web Map in ArcGIS Online
![Page 20: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/20.jpg)
Invoicing Totals in Excel > MailMerge Feed
![Page 21: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/21.jpg)
PowerBI Dashboard Example
<- IndividualCustomerNames->
![Page 22: Using FME to Transform Survey 123 Data](https://reader034.vdocuments.us/reader034/viewer/2022042506/5a64bbd97f8b9a4d0b8b4701/html5/thumbnails/22.jpg)
• Field-CollectedData– DirectFeed
• Auto-generateinvoices(from2daysto2hours)
• BIViewsneverbeforepossible
NextSteps
• MileageLogs– GeoEvent – BPMNAutomation
• SitePhotos- RequestforAddt’l FMEFunctionality
• TransformAttachmentsfromAGOLFeatureServices
End Result