Topic 01: Introduction to ETL

Topic Description:

Through the use of extensions, advanced capabilities can be added to GIS software. Third-party extensions such as the ArcGIS Data Interoperability bring additional functionality of products such as FME into your GIS. This includes tools for spatial ETL, data validation, data export, workflow automation, and more. Advantages include automation of workflows, documenting processes, sharing custom tools, saving time in getting the answer to the question, and integrating with a number of systems such as Oracle spatial database, Google KML, Amazon Web Services, and more.

Slides Available Here

Learning Goals with Lecture Videos:

1. Define ETL terminology.

2. List the advantages and uses of an integrated spatial ETL.

3. Compare ArcGIS Data Interoperability to FME Desktop.

4. Explain the steps for using an integrated spatial ETL tool.

Data:

• Geo PDF

• Building Footprints

• Change Detection Workbench

Learning Objective:

Create GIS data from a CAD file using an integrated spatial ETL tool.

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 converting a GeoPDF to a Geodatabase. Visit this link here to engage with the discussion.

Click Topic 02: Advanced ETL to proceed with the next step.