Task Sheet Series
This series supplements the Iowa State University Extension and Outreach Geospatial Technology Training Program’s workshops and short courses by providing quick and easy instructions for performing a variety of mapping, data science, analysis and data visualization tasks. You'll find the data and code used in the task sheets on the program's GitHub page.
Download Task Sheets by clicking on a publications below, these links will take you to the ISU Extension Store where you can download the publication.
Find more information at the Task Sheet Series webpage.
Deliverables:
-
ArcGIS Pro: ArcGIS and Python
In this tutorial, you will run a python script that counts the number of points within a polygon.
Reference File
-
ArcGIS Pro: Changing Text Case
This task sheet will go through the process of changing the text case using the field calculator and Python functions.
Reference File
-
ArcGIS Pro: Connecting to ArcGIS Server
In this tasksheet you will be connecting to a REST Service and downloading data.
Reference File
-
ArcGIS Pro: Connecting to Web Map Services
In this tutorial, you will be using Web Map Services (WMS) in ArcGIS Pro by connecting to the Iowa Geographic Map Server (Orthoserver).
Reference File
-
ArcGIS Pro: Creating a Layout
In this tutorial you will learn how to create and export a layout in ArcGIS Pro.
Reference File
-
ArcGIS Pro: Creating a Spatial Map Series
This task sheet will utilize the Map Series tool to create a spatial map series.
Reference File
-
ArcGIS Pro: Creating Random Points
In this tutorial, you will create random points with tools in ArcGIS Pro.
Reference File
-
ArcGIS Pro Field Calculations: Area and Length
In this tutorial, you will practice adding a field to an attribute table and learn how to calculate area and length for a given polygon or line feature.
Reference File
-
ArcGIS Pro Field Calculations: Coordinates
This task sheet will take you through the process of calculating the geometry (i.e., determining Latitude and Longitude) of the points in a shapefile.
Reference File
-
ArcGIS Pro: Generating A Service Area Layer
Generating a Service Area is one method of calculating driving distance from businesses to customers and vice versa. This task sheet will be using Network Analyst tools to calculate driving distances.
Reference File
-
ArcGIS Pro: Generating Desire Lines
The Desire Lines tool (available in the Business Analyst extension), helps to generate a series of line from each “customer” point to a desired “store” location.
Reference File
-
ArcGIS Pro: Georeferencing a Raster Dataset
This task sheet will take you through the steps of georeferencing using the georeferencing toolbar in ArcGIS Pro.
Reference File
-
ArcGIS Pro: Geotagged Photos to Point
In this tutorial you will test out the Geotagged Photos to Points tool on your own photos and learn how to match .gpx logs to photos without location metadata.
Reference File
-
ArcGIS Pro: Hillshade, Slope, and Contour
In this tutorial, you will be building on a previous project to create derived images for hillshade, slope and contour lines.
Reference File
-
ArcGIS Pro: Joining U.S. Census Data to a Shapefile
This tutorial will take you through the steps of joining county-level income data to a shapefile of Iowa counties.
Reference File
-
ArcGIS Pro: Mapping Strava GPX Data
In this task sheet, you will learn how to download a GPX file associated with an activity from Strava and import the data into ArcGIS Pro where you will visualize the location data.
Reference File
-
ArcGIS Pro: Working with Lidar Data
For this tutorial you will be processing lidar (light detection and ranging) data.
Reference File
-
ArcGIS Pro: XY Data Points
In this tasksheet you will turn a CSV file containing UTM coordinates into points on the map.
Reference File
-
Downloading and Preparing U.S. Census Data for Mapping
This task sheet will take you through the steps of downloading U.S. Census Bureau data and preparing the file for mapping using ArcGIS Pro.
Reference File
-
Downloading Iowa Lidar Data
In this tutorial, you will learn how to navigate and use the GeoTREE website to download lidar data.
Reference File
-
Essential Data Science: Introduction to Tableau Products
In this tutorial, you will learn about several popular Tableau products to help you choose which will be most helpful for your use cases.
Reference File
-
Getting Started with ArcGIS Online
In this tutorial, you will learn how to sign in and navigate an ArcGIS online map, find data through the ArcGIS Living Atlas of the World, edit symbology and layers, and save a project.
Reference File
-
Google Sheets: Import Tables and Lists from Websites
this tutorial details the process of how to use the ImportHTML formula and exporting the data to another file type.
Reference File
-
Intro to USGS topoBuilder
In this task sheet you will learn how to use the topoBuilder application to generate a customized map.
Reference File
-
QGIS: Improving Table Joins with CSVT Files
This task sheet will teach you how to manage your comma separated value (CSV) files and improve joins by creating a CSVT file.
Reference File
-
Spatial Data Science with R: An Introduction to the Tidyverse
This task sheet will briefly introduce each of the core packages of the tidyverse.
Reference File
-
Spatial Data Science with R: Filtering and Selecting Data with dplyr
In this task sheet you will install the Tidyverse packages, install a dataset containing demographic data and learn how to use dplyr to subset your data.
Reference File
-
Spatial Data Science with R: Getting Started with R and RStudio
This task sheet is the first in a series of tutorials introducing spatial data science concepts using the R programming language.
Reference File
-
Spatial Data Science with R: Importing CSV and Excel into Data Frames
In this task sheet you will learn how to import two common data file types into your R environment: comma separated value (CSV) files and Microsoft Excel spreadsheets.
Reference File
-
Spatial Data Science with R: Installing Packages with RStudio
This task sheet will show you how to install packages from CRAN and GitHub, how to load a package for use in your R session.
Reference File
-
Spatial Data Science with R: Joining Spatial Data with dplyr
This task sheet will cover a common action in geospatial workflows: using a join operation to enrich spatial data with non-spatial attribute data.
Reference File
-
Spatial Data Science with R: Mutating and Piping Data with dplyr
In this task sheet you will learn how to add new columns to a dataset with the mutate function. As well as introduce the pipe operator, %>%, which allows you to chain together functions.
Reference File
-
Spatial Data Science with R: Overview of the RStudio Interface
This task sheet will give an overview of the user interface and some key features of RStudio.
Reference File
-
Spatial Data Science with R: Plotting a Shapefile with sf
In this task sheet you will install and use the sf package in R to work with spatial data.
Reference File
