GEOG 132 - Database Management and Data Acquisition


Fall Semester 2020

Basic Course Information

Courses numbered 1 - 49 are remedial or college preparatory courses which do not apply toward an A. A. Degree and are not intended for transfer. Courses numbered 50-99 apply toward an AA Degree, but are not intended for transfer. Courses numbered 100 and higher apply toward an AA Degree and/or are intended for transfer to a four-year college or university.

CB04 Course Credit Status D - Credit - Degree Applicable
Discipline GEOG
Title Database Management and Data Acquisition
This course is part of the following cross listing

Units and Hours

Min Unit
4
Max Unit
4
Grade Option Grade/Pass/No Pass
Min Semester Hours Calculated
Hour Type Units Weekly Hours Semester Hours x 16 Weeks Semester Hours x 18 Weeks
Lecture Category - 4.00 4.00 x 16 Weeks - 64.00 x 18 Weeks - 72.00
Lab Category - 0.00 0.00 x 16 Weeks - 0.00 x 18 Weeks - 0.00
Subtotal -   4.00 x 16 Weeks - 64.00 x 18 Weeks - 72.00
Out of Class Hour -   8.00 x 16 Weeks - 128.00 x 18 Weeks - 144.00
Totals -   12.00 x 16 Weeks - 192.00 x 18 Weeks - 216.00
Max Semester Hours Calculated
Hour Type Units Weekly Hours Semester Hours x 16 Weeks Semester Hours x 18 Weeks
Lecture Category - 4.00 4.00 x 16 Weeks - 64.00 x 18 Weeks - 72.00
Lab Category - 0.00 0.00 x 16 Weeks - 0.00 x 18 Weeks - 0.00
Subtotal -   4.00 x 16 Weeks - 64.00 x 18 Weeks - 72.00
Out of Class Hour -   8.00 x 16 Weeks - 128.00 x 18 Weeks - 144.00
Totals -   12.00 x 16 Weeks - 192.00 x 18 Weeks - 216.00

Basic Skills Requirements: Appropriate Language and/or Computational Skills.

Requisites

To satisfy a prerequisite, the student must have earned a letter grade of A, B, C or P(Pass) in the prerequisite course, unless otherwise stated.

Prerequisite: (Completion of, or concurrent enrollment in): GEOG 120

Catalog Description

Course provides students with knowledge and practical experience in the fundamentals of database management, and the acquisition, conversion, and creation of spatial data within Geographic Information Systems (GIS). Topics to include strategic design, querying, modeling techniques, data appropriateness and accuracy, hardware and software requirements, conversion of digital data, creating digital data using digitizers, scanners and Global Positioning Systems (GPS), and utilization of remote sensing, photogrammetry, and web-based data. This course provides hands-on experience with database management and data acquisition using ArcGIS software.

Student Learning Outcomes

Outcome
Distinguish geographic coordinate systems from projected coordinate systems.
Explain the functions of configuring an attribute domain.

Specific Course Objectives

Objective
Upon successful completion of the course, the student will be able to:
  • Identify portals of spatial data from governmental, nonprofit, and private sources.
  • Create vector datasets using manual, interactive, and heads-up digitization techniques.
  • Analyze remote sensing images and their attributes.
  • Convert and transfer remote sensing data into a geographic information system.
  • Operate a GPS receiver and download the acquired data to a geographic information system.
  • Evaluate the quality, reliability, and functionality of acquired data sets.
  • Apply skills in converting digital data from one format to another (e.g. vectorization, rasterization).
  • Demonstrate skills in interpreting and utilizing remote sensing data.
  • Identify and describe the components of a file geodatabase and a personal geodatabase.
  • Construct and manipulate data within existing databases.
  • Create databases used for storing and organizing raster and vector data.
  • Construct basic spatial and attribute query statements within a GIS.
  • Construct and analyze spatial networks.
  • Create raster datasets using scanners and georeferenced remote sensing images.
  • Analyze field data (e.g. from GPS) and troubleshoot potential importation issue.
  • Appreciate the importance and implementation of topology in feature datasets.
  • Define basic remote sensing terminologies (e.g. temporal, spatial, spectral resolutions).
  • Describe the process that goes into creating selective GIS datasets that are currently in the public domain.
  • Perform intermediate-level geoprocessing tasks.

Methods of Instruction

Methods of Instruction may include, but are not limited to, the following:
Demonstration
Discussion
Group Projects/Activities
Learning Modules
Lecture

Content in Terms of Specific Body of Knowledge

  1. Introduction to database management
    1. Spatial database concepts and considerations
      1. Data types
      2. Tuning
      3. Indexing
      4. Security
    2. Structured query language in GIS
  2. Data conversion between CAD and GIS
    1. Georeferencing
      1. Linear transformation
    2. Attributes
      1. Query
      2. Object loader
  3. Creation of domains and subtypes
    1. Domains
      1. Coded value
      2. Range
    2. Subtypes
    3. Default values
  4. Spatial analyses
    1. Spatial statistics
      1. Mean center
      2. Standard deviational ellipse
      3. Hotspot analysis
    2. Spatial data mining
  5. Geodatabase
    1. Creation and maintenance of geodatabases
    2. Components of geodatabases
      1. Feature dataset
      2. Feature classes
  6. Data collection and creation
    1. Remote sensing
      1. UAV
      2. Photogrammetry 
    2. Sources of census, landcover, and hydrologic data
    3. Geocoding addresses
    4. Field survey techniques with GPS
      1. ArcPad
      2. Collector App
      3. Web App
    5. Cost considerations associated with acquiring and creating data
    6. Open source and web-based GIS
    7. Data digitization
      1. Automated digitization
      2. Interactive digitization

Textbooks/Resources

Textbook
Author Konecny, Gottfried
Title Remote Sensing, Photogrammetry and Geographic Information Systems
Edition
City London
Publisher Taylor and Francis
Year 2002
Author Zeiler, Michael
Title Modeling Our World: The ESRI Guide to Geodatabase Design
Edition 2nd
City Redlands
Publisher ESRI Press
Year 2010
Author Arctur, Michael; Zeiler, Michael
Title Designing Geodatabases: Case Studies in GIS Data Modeling
Edition
City
Publisher ESRI Press
Year 2004
Author Allen, David; Coffey Jeffery
Title GIS Tutorial 3: Advanced Workbook
Edition
City
Publisher Esri Press
Year 2010
Author Calvo, Kike
Title So You Want to Create Maps Using Drones
Edition
City
Publisher Blurb
Year 2016

Assignments

Students are expected to research projects and solutions as dictated by specific assignments. Students are expected to spend a minimum of three hours per unit per week in class and on outside assignments, prorated for short-term classes.
Required Reading
Students will read professional case studies that have successfully created, implemented, and maintained geodatabases. In addition, journal articles will also be assigned in order to help students decide on their semester projects.
Suggested Reading
Students are encouraged to actively conduct independent research and review online resources in order to stay current with the technology.
Required Writing
One or more assignments chosen from the following options: -Article Review (2 - 3 page essay) -Case Study Analysis (2 - 3 page essay) -Semester Project (5 - 6 page term paper)
Critical Thinking
Students will be required to critically review a case study/project that exemplified the usage of a geodatabases or relational database management system. In addition, students are asked to evaluate the appropriateness of various data sources for their semester projects.
Outside Assignments
Outside assignments will include reading texts, review of lecture notes, writing assignments, GIS computer lab assignments, and exam preparation. 8 hours per week.

Methods of Assessment

Evaluation Method
  • Exams/Tests
  • Homework
  • Papers
  • Research Projects

Open Entry/Open Exit

Open Entry / Open Exit - Not Open Entry/Open Exit

Repeatability

Is this course repeatable in accordance with Title 5 guidelines? No

Contact Person

Originator Cheung, Wing H.