GIS Database Development

Weeks 10 – 13: OPTION 4

GIS DATABASE DEVELOPMENT

1. MATERIALS & READINGS

You will be supplied with a student version of ArcGIS for Desktop. This is a complete version of the software, but it is a limited time license. You will also be provided with a series of ArcGIS exercises and the necessary data files.

Exercise 1: Introduction to ArcGIS (Exercise 1 Data)
Exercise 2: Working with Projections (Exercise 2 Data)
Exercise 3: Creating a Geodatabase (Exercise 3 Data)
Exercise 4: Tracking Seal Movement (Exercise 4 Data)
Exercise 5: Using Tracking Analyst Extension (Exercise 5 Data)
Exercise 6: A Simple Analysis (Exercise 6 Data)
Exercise 7: Introducing Python Scripting in ArcGIS (Exercise 3 Data)
Exercise 8: A Bangor Tour (Exercise 8 Data)

The time for completing the above exercises varies but you should plan on at least two hours per exercise.

Supplemental Reading and Resources:
ArcGIS Desktop Help available from either ArcMap or ArcCatalog
ArcGIS Resources: http://resources.arcgis.com/en/home/ especially the page on Loading Locations: http://desktop.arcgis.com/en/arcmap/10.3/tools/network-analyst-toolbox/add-locations.htm

Readings:
Working with Add_Ins in ArcMap:
http://desktop.arcgis.com/en/arcmap/latest/analyze/python-addins/sharing-and-installing-add-ins.htm
What is ArcPy:
http://desktop.arcgis.com/en/arcmap/latest/analyze/arcpy/what-is-arcpy-.htm

2. SCHEDULE & BLOG ASSIGNMENTS

Week 10 Tuesday4/4/17	Complete the following in class with CLA and instructor support and on your own outside of class as needed. Install ArcGIS Complete Exercises 1 & 2
Week 10 Thursday4/6/17	Complete Exercises 2 & 3 Review Python material on file input and output found at https://www.codecademy.com/learn/python (lesson 12) Blog Assignment: Go to https://www.ted.com/playlists/17/how_to_live_with_robots Select a minimum of two videos to watch. Name the videos you watched and provide your reflections on those videos. Comment on what worked well this week, what didn’t, and what you learned. Download the Team Project Peer Assessments handout, read it, click the url at the end of the handout, and rate a minimum of two of your past project partners. We encourage you to rate all four. (Due Sunday evening by 8:00 pm)
Week 11 Tuesday4/11/17	Complete Exercise 4 Work on GIS Team Project Assignment 1.
Week 11 Thursday4/13/17	GIS Team Project Assignment 1 on Reading Data and Displaying Features is due in class. Demonstration to other groups. Blog Assignment: Select one of the following videos, view it, and provide your reflections on the video. Lorna Goulden: The internet of things, Marco Annunziata: Welcome to the age of the industrial internet, Massimo Banzi, How Arduino is open sourcing imagination, or Rana el Kaliouby, This app knows how you feel — from the look on your face Comment on what worked well this week, what didn’t, and what you learned. (Due Sunday evening by 8:00 pm)

Week 12 Tuesday4/18/17	Install ArcMap Add-In Manager available at http://desktop.arcgis.com/en/arcmap/latest/analyze/python-addins/obtaining-the-python-add-in-wizard.htm Complete Exercises 5 & 6
Week 12 Thursday4/20/17	Learn how to set up a combo box in ArcMap ArcMap by watching https://www.youtube.com/watch?v=S78v_NH4tO0 Complete Exercises 7 & 8 Blog Assignment: Go to https://www.ted.com/playlists/135/will_drones_save_us_or_destroy Select a minimum of two videos to watch. Name the videos you watched and provide your reflections on those videos. Comment on what worked well this week, what didn’t, and what you learned. (Due Sunday evening by 8:00 pm)
Week 13 Tuesday4/25/17	Work on GIS Team Project Assignment 2.
Week 13 Thursday4/27/17	GIS Team Project Assignment 2 on Shortest Route Among Selected Sites is due in class. Blog Assignment: Go to https://www.ted.com/playlists/385/10_years_of_ted_talks?utm_source=tedcomshare&utm_medium=email&utm_campaign=tedspread Select a minimum of two videos to watch. Name the videos you watched and provide your reflections on those videos. Comment on what worked well this week, what didn’t, and what you learned. (Due Sunday evening by 8:00 pm)

As with all university courses, you should expect to spend 2 to 3 hours outside of class for every hour you spend in class.

3. TWO-WEEK PROJECT ASSIGNMENTS

GIS Team Project Assignment 1 (due at end of Week 11) – Reading Data and Displaying Features (pdf version)

Create a Python script to read a data file of a seal (preferably a harbor seal) from the following website: http://whale.wheelock.edu/whalenet-stuff/stop_cover.html. Parse the table columns: ID, DATE_TIME, LOCATION CODE, LATITUDE, LONGITUDE, all in the correct format, and output the table into a comma separated file.

Bring the file into ARCGIS and convert it to a feature class and display the seals tracks using tracking analyst.

Grading: Late project submissions result in lowering of full grade per week.

Rubric

Grade	Performance
A	The Python script works and the layout generated is correct. (A- if minor details are missing.
B	The script works, but does not generate the correct output, but it can be displayed in ArcGIS.
C	The script works, but does not generate the correct output, and it cannot be displayed in ArcGIS.
D	The project works in ArcMap, but the script does not work.
F	No project submitted meeting any of the above levels of performance within two weeks of the deadline.

GIS Team Project Assignment 2 (due at end of Week 13) – Shortest Route Among Selected Sites (pdf version)

Install the ArcGIS Add-In Manager. Create an add-in combo box that allows the user to determine which type of tour they would like. Create at least two choices; e.g. “Things to do” vs. “Things to See.” Write an ArcPy script that loads the appropriate stops into the Network Analyst window and then creates the shortest route to visit the selected sites.

Grading: Late project submissions result in lowering of full grade per week. A program that is off topic will acquire at most a B-

Rubric

Grade	Performance
A	The combo box works and the files are loaded correctly and the route created.
B	The combo box works and files are loaded but no route is created.
C	The combo box works, but no files are loaded.
D	The project works in ArcMap, but the combo box does not work.
F	No project submitted meeting any of the above levels of performance within two weeks of the deadline.

COS 120 Introduction to Programming by School of Computing and Information Science is licensed under a Creative Commons Attribution 4.0 International License.