UNITED WAY STL ACADEMY
  • Courses
  • Log In
  • Join Free
  • Home
  • Courses
  • GIS Essentials

Geography Goes Digital

Curriculum

  • 4 Sections
  • 16 Lessons
  • Lifetime
Expand all sectionsCollapse all sections
  • Creating a Conceptual Model
    4
    • 1.1
      Helping Computers Read Maps
      10 mins
    • 1.2
      Embracing the Model-Creation Process
      10 mins
    • 1.3
      Defining Your Map’s Contents
      10 mins
    • 1.4
      Converting Maps into Digital Formats
      10 mins
  • Understanding the GIS Data Models
    3
    • 2.1
      Examining Raster Models and Structure
      10 mins
    • 2.2
      Exploring Vector Representation
      10 mins
    • 2.3
      Dealing with Surfaces
      10 mins
  • Keeping Track of Attribute Data
    4
    • 3.1
      Knowing the Importance of Attribute Data in GIS
      10 mins
    • 3.2
      Working with Tables and Database Management Systems
      10 mins
    • 3.3
      Understanding Object-Oriented and NoSQL Systems
      10 mins
    • 3.4
      Incorporating Data Interoperability, Standards, and Security
      10 mins
  • Collecting Geographic Data
    5
    • 4.1
      Identifying Quality Data
      10 mins
    • 4.2
      Importing Data
      10 mins
    • 4.3
      Geocoding Data
      10 mins
    • 4.4
      Accessing Data with API Connections
      10 mins
    • 4.5
      Building Data about the Data
      10 mins

Working with Tables and Database Management Systems

Geography Goes Digital

Working with Tables and Database Management Systems

🕐 12 min read
The Big Question

How do database management systems help GIS professionals organize, link, and analyze vast amounts of geographic data?

Imagine trying to keep track of thousands of land parcels, each with its own set of characteristics, owners, and transaction history. With the right database tools, GIS makes this not just possible—but efficient, reliable, and scalable.

💡 Did You Know?

The first commercial relational database system launched in 1979, long before GIS was widely used. Modern geospatial databases now handle billions of spatial records every day.

A database management system (DBMS) is an essential tool for organizing, storing, and retrieving large datasets. Although traditional DBMS platforms were initially developed for nonspatial data, they have evolved to seamlessly integrate with GIS. Modern GIS software uses a relational database (RDBMS, explained in the next section) and a geospatial database, which is a database specifically designed to store and manage spatial data, to store spatial features (points, lines, and polygons) along with their descriptive attributes. Integrating GIS software and these databases ensures that your data stays organized and ready for smooth updates and analysis.

Today, geospatial databases, such as PostGIS, SQLite/GeoPackage, and Esri’s geodatabase, offer enhanced performance and advanced features, like network analysis and spatial queries. (I tell you more about spatial queries later in this chapter, and about network analysis in Chapter 14).

Database Management System (DBMS)

A software system that allows users to define, create, maintain, and control access to databases—essential for efficient data management in GIS.

Geospatial Database

A specialized database designed to store spatial features (like points, lines, polygons) and their associated attributes for GIS applications.

Structuring relational data

At the heart of GIS databases are relational tables, which organize data into rows and columns. Each row (or record) represents an individual feature such as a parcel, and each column (attribute) stores a specific type of information, such as land use category or owner, as shown in Figure 6-1.

A table representing attribute data associated with geographic features, displayed in a spreadsheet-like format. Columns represent attributes (Parcel_ID, Lucode, Status, Region, Zoning). Rows represent individual parcels. Header row is highlighted.
Relational tables organize geographic features and their attributes, providing structure for efficient data management in GIS.

A relational database gets its name from how it links data between tables using primary keys (unique identifiers) and foreign keys (references to primary keys in related tables). These keys create relationships between tables, allowing them to share information without duplicating data. This sharing of information is why you often see primary and foreign keys referred to as “shared keys.”

Why do you think it’s important to avoid duplicating data across multiple tables in a GIS database?

Primary keys are often single-column values, like a parcel identification number (such as Parcel_ID in Figure 6-1). However, you can create composite keys by combining multiple columns to ensure uniqueness, like combining an owner’s name with a street address. Databases automatically index primary keys, making searches faster by directing queries to the right data. The primary key’s index acts like a book’s table of contents, helping the database quickly find the matching row instead of scanning the entire table. This capability is especially helpful when you have a large dataset.

Two tables illustrating a database relationship in a GIS context. The upper 'Land Use' table has Parcel_ID as its primary key; the lower 'Transactions' table uses Parcel_ID as a foreign key to link transactions to parcels.
Primary and foreign keys allow different tables to connect and share information efficiently in a GIS database.

Take a look at Figure 6-2. The Land Use table lists parcels with attributes like Parcel_ID, Status, and Acres. Each row represents a different parcel, and the Parcel_ID ensures that each entry is unique.

Below the Land Use table is a Transactions table that logs sales and leases using a matching Parcel_ID as a foreign key. Because properties can be bought and sold multiple times, the foreign key is not required to be unique. Instead, it links each transaction to the relevant parcel.

Remember icon
REMEMBER

When setting up your main table, every row should represent a unique feature. Use primary keys to ensure uniqueness and foreign keys to link related data between tables.

Tip icon
TIP

A good rule of thumb for building a database is to make your tables simple and focused on a specific theme, like land ownership or zoning. Plan ahead by asking yourself, “What questions do I want this table to answer?”

Want to go deeper? The science behind database indexing

Database indexes are special lookup tables that the database search engine can use to speed up data retrieval. Instead of scanning every row, the system uses the index (like an address book) to jump straight to a record. In large GIS datasets, this can mean the difference between instant results and multi-minute waits.

Consider a scenario where two parcels have the same owner name but different locations. How would composite keys help ensure data integrity in your GIS database?

Local governments use relational GIS databases to unify zoning, tax assessment, and transaction records—empowering city planners to visualize and analyze land use changes over time.

  • You can explain the purpose of primary and foreign keys in relational tables.
  • You understand why indexing improves query performance in large GIS datasets.
⏱ 5 minutes
Activity: Build a Simple Parcel Table

Practice designing a relational table for a GIS scenario.

  1. List 5 imaginary parcels, each with a unique Parcel_ID, Status, and Zoning type.
  2. Design a second table to log transactions (sales/leases), using Parcel_ID as a foreign key.
  3. Draw arrows to show how the tables relate.

Practitioners often spend considerable time planning their database structure before entering any data—getting the relationships and keys right from the start saves countless hours down the road.

How might linking tables with foreign keys make updating or analyzing spatial data more efficient in your GIS projects?

Key Takeaway

Relational database management systems (RDBMS) and well-structured tables are the backbone of modern GIS, enabling efficient data storage, linking, and analysis through primary and foreign keys.

Integrating GIS software and these databases ensures that your data stays organized and ready for smooth updates and analysis.

Flashcard

What is a primary key in a relational database?

Tap to reveal
Answer

A unique identifier for each row in a table, ensuring that each record is distinct.

Flashcard

Define foreign key in the context of GIS databases.

Tap to reveal
Answer

An attribute in one table that links to the primary key in another table, creating a relationship between datasets.

Flashcard

Why use relational tables in a GIS?

Tap to reveal
Answer

To efficiently organize, link, and manage spatial and attribute data without unnecessary duplication.

❌ Common Misconception

Each table in a GIS database must contain every detail about each feature, even if it means repeating data.

✅ The Reality

Relational databases are designed to minimize duplication by linking tables with keys, allowing details to be stored once and referenced as needed.

Think about a project where you needed to organize a lot of information (not necessarily geographic). How might using primary and foreign keys have improved your process? What challenges do you anticipate when designing a relational database for GIS?

0 words Take your time — depth matters more than length
Key Takeaway

Using primary and foreign keys to link tables keeps GIS data organized, eliminates redundancy, and enables powerful, flexible analysis.

SHIFT

The Shift

  • Database management systems form the backbone of GIS, making massive datasets manageable and actionable.
  • Primary and foreign keys connect different tables, allowing efficient linking and analysis of spatial and attribute data.
  • Well-designed relational tables reduce data duplication, speed up queries, and support scalable GIS projects.
End of lesson Ready for the next lesson?
Continue to next lesson  →

Leave a Reply Cancel reply

Knowing the Importance of Attribute Data in GIS
Prev
Understanding Object-Oriented and NoSQL Systems
Next

© 2026 United Way STL Academy | Powered by Sejal Learning Systems.

Modal title

Main Content