Banco de Dados Espaciais

Explore the world of spatial databases with this practical course! Learn the fundamentals and gain hands-on experience with spatial data management.

This course provides a comprehensive overview of spatial database concepts and applications, covering everything from installation to more advanced techniques. We emphasize a practical approach, presenting theory to contextualize your understanding and providing exercises mirroring real-world scenarios.

While we won't delve into exhaustive detail due to the breadth of the field (with many variations possible for each function – for example, spatial functions can be executed in 4-5 different ways!), you'll learn how spatial databases work and how to diversify your approach for effective data manipulation.

Prerequisites: A basic understanding of geoprocessing and databases is recommended. You'll also need familiarity with basic SQL operations, including variations of SELECT statements and JOINs. Note: This course does not include SQL instruction in isolation.

Course Content:

• Module 01 – Theoretical Concepts of Spatial Databases:

  • What is a spatial database?
  • SGBD with spatial extensions
  • Spatial file extensions
  • Geometric data and formats
  • Map Servers and Data Input/Output

• Module 02 – Course Software:

  • Software installation for the course.

• Module 03 – Data Sources and Map Servers:

  • Data sources – Shapefiles
  • Other data sources
  • Map Servers – WFS, WMS, and WCS

• Module 04 – Connecting to QGIS:

  • Connecting QGIS to Postgres/Postgis
  • Creating spatial tables in Postgres/Postgis from QGIS

• Module 05 – Raster Data:

  • What is raster data?
  • Importing raster data into Postgres/Postgis

• Module 06 – Types of Geometric Data:

  • Geometric data types and their use in spatial tables

• Module 07 – Spatial Functions:

  • Basic concepts of spatial functions
  • Spatial Functions – Part 1
  • Spatial Functions – Part 2
  • Spatial Functions – Part 3
  • Spatial Functions – Part 4
  • Spatial Functions – Part 5
  • Spatial Functions – Part 6
  • Spatial Functions – Part 7
  • Spatial Functions – Part 8
  • Spatial Functions – Exercises

• Module 08 – Other SQL Features in Spatial Databases:

  • Geometries and Geographics
  • Spatial Joins
  • Indexes
  • Transactions
  • Roles (Roles)
  • Functions
  • Triggers
  • Space-Temporal Database

This course empowers you to effectively manage and utilize spatial data for a variety of applications.