Topic 02: Advanced ETL
Topic 02: Advanced ETL
Topic Description:
The use of an integrated spatial ETL allows for advanced workflows that go beyond the capabilities of built-in tools such as ModelBuilder. Functionality includes: grabbing a zip file and extracting it, reading one of the files in the zip to set parameters, concluding if there is existing data, preparing each file set to be loaded into the existing geodatabase, assigning attribute values, calculating geometry, converting units, cleaning up the data, writing it out to the geodatabase, and looping through to relate the data together in relationship classes.
Learning Goals with Lecture Videos:
Identify the components of an FME Workbench.
Compare an automated GIS workflow in Modelbuilder to an FME Workbench.
Explain the steps for creating an FME workbench.
Learning Objective:
Create a GIS workflow automation in an FME workbench.
Exercise: Make an FME Workbench
Put your new knowledge to the test:
Using the Building Permits table, compare the project addresses and remove duplicate locations, resulting in a SchoolRelatedPermits shapefile (.shp).
Repeat this workflow to find all unique addresses where demolition is occurring, resulting in a DemolitionRelatedPermits shapefile (.shp).
Be sure to add annotation and bookmarks to make the workbench more intuitive.
Save the Workbench as YYYY-MM-DD_PermitsToShp_YourName.fmw and share it in the discussion group below for feedback.
Discussion:
The goal of Discussions in this class is to collaborate and communicate with your classmates and instructor. This is your chance to ask questions, share your work for a peer review, show your progress in the Lab Demos and Exercises, and simply network with one another. Not sure how to get started? Share your opinions of this topic, demo and exercise. What did you find interesting, helpful, surprising, etc? Paste a JPG of the map in ArcGIS Pro from using the VertexCreator in FME to locate building permits issued in the last 30 days. Share your .fmw file from the exercise.
Click Topic 03: Custom ETL to proceed with the next step.
Questions? Contact: Stephanie.Long@austincc.edu