GEOSPATIAL DATABASE DESIGN AND DEVELOPMENT

GEOG 574

Course Description

Introduces the basic concepts, techniques and methodologies for designing and implementing a spatial database to prepare for professional work as a GIS designer, analyst, specialist or researcher. Design conceptual spatial database models and implement them within specific spatial data management systems (DBMS). Covers basic SQL database language and the latest developments in database systems (e.g. NoSQL database) for managing and mining spatial big data such as social media datasets and GPS trajectories.

Prerequisties

GEOG 170 , GEOG 370 , CIVENGR/ENVIRST/GEOG 377 or graduate/professional standing

Satisfies

GEOG 777 and GEOG 778

Credits

Offered

Fall

Grade Point Average

3.81

0.06% from Historical

Completion Rate

100%

1.87% from Historical

A Rate

84.09%

-2.97% from Historical

Class Size

51.72% from Historical

Instructors (2025 Fall)

Sorted by ratings from Rate My Professors

Similar Courses

CAPSTONE IN GIS DEVELOPMENT

GEOG 777

Covers practical and challenging cases in GIS which require programming and other GIS development skills (such as geospatial algorithm development and implementation). Cases cover the wide spectrum of GIS development projects in the GIS professions ranging from GIS data management, advanced spatial analysis, spatial database development and web/mobile programming, to cartography/geovisualization. Focuses on integration of skills from other courses into a GIS development project.

AN INTRODUCTION TO GEOGRAPHIC INFORMATION SYSTEMS

CIVENGR/ENVIRST/GEOG 377

Design, implementation and use of automated procedures for storage, analysis and display of spatial information. Covers data bases, information manipulation and display techniques, software systems and management issues. Case studies.

GEOSPATIAL WEB AND MOBILE PROGRAMMING

GEOG 576

Covers the programming concepts and skills for understanding construction and implementation of high quality spatial web portal and mobile Apps to support geospatial data access, analysis, sharing, and synthesis over the internet. Builds on basic programming experience.

ADVANCED GEOCOMPUTING AND GEOSPATIAL BIG DATA ANALYTICS

GEOG 573

Geospatial big data is an extension of big data with an emphasis on the geospatial component. It is used to describe large volumes of georeferenced data about various aspects of the environment and society captured by millions of environmental and human sensors. An introduction to the theory, techniques, and analytical methods for geospatial big data. Methods for storing, processing, analyzing, and visualizing various types of geospatial big data using advanced Python programming will be introduced. Designed for students who have programming experience and want to reinforce their programming skills and learn AI and machine learning methods for solving geospatial big data problems.

PRACTICUM IN GIS DEVELOPMENT

GEOG 778

Develop the ability to conceive and manage a real-world GIS development project, and to design a plan for solving the project.