Geog482/582 Autumn 2017
Assignment 6
Implementing and Documenting the Geodatabase Development

Introduction

In this assignment, you will complete the implementationof the geodatabase for green infrastructure system and document the entire development process. Upon the completion of this assignment, you should have accomplished the following tasks.

●Create feature datasets in your geodatabase, and finding and adding data to your feature datasets that are important to green infrastructure system.

●Creating subtype, domain, relationship, topology, or geometric network that are necessary to your feature dataset and/or feature classes.

●Creating, editing and updating metadata for your datasets.

●Creating a geodatabase schema

●Publishing feature service to a web application.

There are five deliverables to the final product in assignment 6. All students in a group will receive the same score resulting from the assessment of each part.

1.Status Report 1: Problem Statement and Database Design (5 points)

Problem statement
A reasonably complete project description includes:

●A background problem statement of 1/2 to 1 page describing the scope and content of the specific project.

●An annotated bibliography of literature references related to background issues connected to the project consisting of at least five literature references.

●A well-formed research question with connection to the question 1 appearing on the Dept of Ecology’s Puget Sound Watershed Characterization land page as described in Assignment 4. Situate the research question with the background problem statement for your particular project.

●A list of feature datasets and feature classes within each to be used in the project.Remember that “nouns within the research question” tend to be feature classes and/or feature datasets.

Database design

This report will consist of two items:

●Table that contains four columns: feature datasets, feature classes within each feature dataset, definitions of feature classes, and data sources.

●A geodatabase schema diagram showing all feature datasets, feature classes, and other spatial and attribute data.

2. Status Report 2: Operations Design (5 points)

Refined geodatabase schema diagram with a table of attributes for each of the feature classes, plus all the relationships of feature datasets, feature classes, relationships, domains, subtypes, topologies, and/or geometric networks.

  1. Final Project Presentation- See below (10 points)

4.Final Project Report– See Below (30 points)

5.Student Peer Evaluation– See Below (required for course grade)

Assignment 6 Grading

Assignment 6 is worth 50 points of your final class grade. The components of the project deliverables and the points possible for each piece are as follows:

Assignment description / Points
Status Report 1 / 5
Status Report 2 / 5
Final Project Presentation / 10
Final Project Report / 30
Peer Evaluation – required for course grade
TOTAL: / 50

Geography 482/582 GIS Data Management

Final Project Presentation

Presentations that communicate the breadth and depth of your findings are an important part of the learning experience. The following is an example outline to follow for your final project presentation. You might choose a different outline, but have a good reason for doing so. We recommend that you use a PowerPoint. You have 10 minutes for this presentation plus 2 minute for Q&A. A transition time is needed as well, so please be prompt. All members of the group are to present some portion.

A project presentation evaluation sheet used for evaluation is provided on the second page. You should observe that evaluation sheet outline mirrors the presentation outline. If you decide to use a different outline, it would be best to consider how that different outline covers the minimum as set out below.

Your presentation material will likely be briefer than your report material (see other document for final report outline). If you consider what is to be in the final report, then excerpt from that, you will be in a position to be most effective with creating materials.

1.Introduction

- "Show" and "state" the title of the project.

- "Show" and "introduce" group name and members involved in the project.

If title is not long, the list of group member names could be a part of the title slide.

- State the project purpose/goal. What did the group intend to accomplish?

2. Project Method

- Describe the source data sets you used. From where were they acquired?

- Describe the steps that you used to develop the geodatabase.

- Describe the major challenges.

3. Findings / Results (note how this differs from method as this is outcome)

- Show your geodatabase schema diagram (but whatever is shown should be readable)

- Show any ArcGIS Diagrammer views if you think they portray the schema content.

- Show maps representing your geodatabase content.

4.Conclusions

- What generalizations do you draw from this data processing activity?

For example: Does your geodatabase make sense to support your problem statement, and in particular research question, why? What are some other data that you think could be useful and suitable for your geodatabase, but they are not available for you to use – at least not at this time or this search?

5.Recommendations

- What recommendations do you have for others?

For example: What would you suggest to others if they were to undertake a similar project? What would be the next steps for follow-up to the project if this is not the end of this topic?

Geography 482/582 GIS Data Management

Project Presentation Evaluation – 10 points

Group:______Name:______

Name:______Name:______

_____1. IntroductionGraphicVerbal Statement

Title of Project

Participant introductions:

Problem Statement / Project Purpose

_____2. Project Method

Resources used (data, software, hardware, outside help):

Overview of processes performed:

_____3. Findings/Results

New information generated; where maps/graphics used to depict results?

_____4. Conclusions

Generalizations drawn

_____5. Recommendations

Suggestions to others

Geography 482/582 GIS Data Management- Final Project Report Outline

Reports that communicate the breadth and depth of your findings are an important part of the learning experience. The following is an example outline to follow for your final project report that mirrors your presentation. You might choose a different outline, but have a good reason for doing so, as departures form the outline will be graded as if they are better ideas than the outline. Your presentation material will undoubtedly be briefer that your final report material. If you consider what is to be in the final report, then excerpt from that, you will be in a position to use materials for both.

A project report evaluation sheet used by instructors is provided below. If you decide to use a different outline, it would be best to consider how that different outline presents the material in a better way.

Title page

- State the project title from a substantive perspective. Titling the report “final project” does not

provide the appropriate information, so please, please do not do that.

- State names of group members

- State course name

- State the due date of report

Abstract

- Describe the need for your project information (outcomes of your project) based on problem

statement.

- Describe the project purpose as in “what did the group intend to accomplish to address a need”.

- Describe the results/accomplishments

- Describe who might best make use of the information.

1. Introduction

- Describe the project purpose.

- Provide background information based on your literature sources. Be sure to include reference

citations.

- State the problem statement (including research question) that clarifies the focus of the project.

- Describe who might benefit from resulting information in your project.

- Overview what is to come in the remainder of the report, e.g. one sentence about each major

section to come.

2. Project Method

- Describe the source data sets you used. From where were they acquired?

- Describe the steps that you used to develop the geodatabase in detail, including how you might

have manipulated the data. This would be the lineage of the data as would be described in

metadata for your geodatabase.

- A diagram to depict process workflow is always helpful here.

- Describe what software tools were used to develop the information content of the project. Was

a web site used for team coordination purposes.

- How was metadata developed? Was metadata available? Did you use it and/or refine it for this

project?

- Describe major challenges in the project work steps.

3. Findings: Results and Discussion (note how this differs from method)

3.1 Results

- Describe the results of your work activity – the end results.

- To portray results, you could show the maps representing the data in your geodatabase.

3.2 Discussion of Results

- Discuss the major implications of your results. Who should care about the results?

- Your results might or might not be what were intended. Discuss the differences of the expected

results versus actual results.

4.Conclusions and Recommendations

Conclusions are NOT the same as recommendations. You need to articulate both. These are two subsections of section 4, Section 4.1 and 4.2.

4.1 Conclusions: What generalizations do you draw from this data processing activity?

For example: How does your geodatabase support your problem statement? What are some other data that you think they are very useful and suitable for your geodatabase but they are not available for you to use?

4.2 Recommendations: What recommendations do you have for others?

For example: What would you suggest to others if they were to undertake a similar study? What would be the next steps for carrying through on the study if this is not the end of this topic?

5. References

All citations made in the body of the report should be listed in this section.

6. Appendices

Include tchnical information needed to orient the reader, e.g. the metadata descriptions should appear in this section.

Geography 482/582 GIS Data Management- Project Report Evaluation

Group:______Name:______

Name:______Name:______

______Title page

- Project title from a substantive perspective.

- State names of group members, course name, due date of report

______Abstract

- Need for your project information (outcomes of your project) based on problem statement.

- Project purpose as in “what did the group intend to accomplish to address a need.

- Results/accomplishments

- Use of the information.

_____1. Introduction

- Project purpose.

- Background information based on literature sources.

- Problem statement (including research question) that clarifies the focus of project.

- Who might benefit from resulting information in your project.

- Overview of remainder of the report

_____2. Project Method

- Source data sets you used acquired form where?

- Steps used to develop the geodatabase, including manipulationof the data.

- Diagram depicting workflow.

- Software tools used, e.g. for metadata development.

- Major challenges in the project work steps.

_____3. Findings: Results and Discussion

3.1 Results

- Results of work activity – the end results.

- Depiction of results, e.g., maps representing the data in geodatabase.

3.2 Discussion of Results

- Major implications of your results. Who should care about the results?

- Differences of the expected results versus actual results.

_____4.Conclusions and Recommendations

4.1 Conclusions:

Generalizations drawn from data processing activity?

4.2 Recommendations:

Recommendations for others?

_____5. References

All citations made in the body of the report should be listed in this section.

_____6. Appendices

Technical information needed to orient the reader, e.g. metadata descriptions.

Other comments:

Geography 482/582 GIS Data Management

Student Peer Evaluation - Required for a Final Grade

Student Name:______Student Number:______

Project name:______

Please complete the following evaluation questions and return to Prof. Nyerges.

Thank you.

Please circle the appropriate rating number for each of the following issues:

1) Rate group effort as a whole:

1 2 3 4 5

waynot justmoreway

tooenoughrightthantoo

littleenoughmuch

2) Rate individual contributions (for as many group members in group)

a. Your own contribution:

1 2 3 4 5

waynot justmoreway

tooenoughrightthantoo

littleenoughmuch

b. PLEASE provide name of other member______and rate contribution

1 2 3 4 5

waynot justmoreway

tooenoughrightthantoo

littleenoughmuch

c. PLEASE provide name of other member ______and rate contribution

1 2 3 4 5

waynot justmoreway

tooenoughrightthantoo

littleenoughmuch

d. PLEASE provide name of other member ______and rate contribution

1 2 3 4 5

waynot justmoreway

tooenoughrightthantoo

littleenoughmuch

e. PLEASE provide name of other member ______and rate contribution

1 2 3 4 5

waynot justmoreway

tooenoughrightthantoo

littleenoughmuch

Explanation of Ratings: