Skip Navigation

Class Sessions and Assignments - 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

Youtube Videos:
What is GIS?  https://www.youtube.com/watch?v=-ZFmAAHBfOU
Geographic Information Systems:  https://www.youtube.com/watch?v=9V_Mz7NDy3o
ArcGIS Basics
https://www.youtube.com/watch?v=ekmyWkAP4eI
https://www.youtube.com/watch?v=OmFKLTqQhkY
https://www.youtube.com/watch?v=uWYY0h-9g4M
https://www.youtube.com/watch?v=DkGmRv5cHlQ
https://www.youtube.com/watch?v=XGiVChKdQjM
https://www.youtube.com/watch?v=VRa0xnPP87M
ArcPy
https://www.youtube.com/watch?v=ge_U_w0PcFM
ArcMap Add_Ins
– Basics:  https://www.youtube.com/watch?v=bn9DnK-lc-s
– Combo_Box:  https://www.youtube.com/watch?v=S78v_NH4tO0

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
  • 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
Week 12 Tuesday4/18/17
Week 12 Thursday4/20/17
Week 13 Tuesday4/25/17
  • Work on GIS Team Project Assignment 2.
Week 13 Thursday4/27/17

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.

 


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


Back to Class Sessions and Assignments