Skip to main content

Geographic DBMS


A Relational Database Model stores data in the form of tables.
Each table contains:

  • Rows → Individual records

  • Columns → Attributes or fields

Tables can be connected using common fields called keys.

Terminologies

1. Table

A collection of related data arranged in rows and columns.

Example:

IDNamePopulation
1Palakkad130000
2Thrissur315000

2. Row (Record)

Represents one feature or entry.

👉 Example
"Palakkad" is one record.

3. Column (Field / Attribute)

Represents one property of data.

👉 Example
Population is a field.

4. Primary Key

A unique field used to identify each record.

👉 Example
ID column.

5. Foreign Key

A field used to connect two tables.

 Example in GIS (QGIS / ArcGIS)

Suppose you have:

Table 1: District Boundary Layer

District_IDDistrict_Name
1Palakkad
2Malappuram

Table 2: Rainfall Data

District_IDRainfall
12200 mm
22800 mm

👉 Both tables share District_ID

Using this field, GIS joins rainfall data to district maps.

Where Used in GIS

  • Attribute tables of shapefiles

  • Linking census data

  • Spatial analysis with external datasets

Geographic DBMS Extensions

A Geographic DBMS Extension adds spatial capability to normal databases.

Normal database → Stores text and numbers
Geographic DBMS → Stores maps, shapes, coordinates

✅ Why It Is Needed

GIS deals with spatial objects like:

  • Points

  • Lines

  • Polygons

  • Raster images

A normal database cannot store or analyse them properly.

✅ Examples of Geographic DBMS Extensions

DatabaseGIS Extension
PostgreSQLPostGIS
OracleOracle Spatial
SQL ServerSpatial Extension

✅ Important Terminologies

1. Geometry

Shape of spatial feature.

Examples:

  • Point → School location

  • Line → Road

  • Polygon → District boundary

2. Spatial Index

Improves speed of spatial queries.

Example:
Finding nearest hospital quickly.

3. Spatial Query

Query based on location.

Example:
"Find all villages within 5 km from river."

✅ Example in QGIS

QGIS uses PostGIS database.

👉 You can store:

  • Road network

  • Land use layers

  • Satellite data

👉 Example Query:
Find all agricultural lands near rivers.

✅ Example in ArcGIS

ArcGIS uses:

  • File Geodatabase

  • Enterprise Geodatabase

They store spatial data with advanced indexing and topology rules.

3. SQL in GIS

✅ Simple Meaning

SQL (Structured Query Language) is used to:

✔ Retrieve data
✔ Filter data
✔ Analyse data
✔ Update data

✅ Basic SQL Commands

1. SELECT → Get data

Example:

SELECT * FROM districts;

👉 Shows all districts.

2. WHERE → Filter data

Example:

SELECT * FROM districts  WHERE Population > 200000;

👉 Shows only high population districts.

3. JOIN → Combine tables

Example:

SELECT districts.Name, rainfall.Amount  FROM districts  JOIN rainfall  ON districts.ID = rainfall.ID;

4. SQL in GIS (Spatial SQL)

GIS uses special spatial functions.

✅ Spatial SQL Terminologies

1. ST_Within

Checks if one feature lies inside another.

Example:
Find houses inside flood zone.

2. ST_Intersects

Checks if two features overlap.

Example:
Find roads crossing rivers.

3. ST_Distance

Finds distance between two objects.

Example:
Distance from school to hospital.

✅ Example in QGIS (Using DB Manager or Expression Builder)

SELECT *  FROM landuse  WHERE ST_Area(geometry) > 10000;

👉 Finds large land parcels.

✅ Example in ArcGIS (Select by Attributes)

"Population" > 100000

✅ Example (Select by Location)

👉 Select villages within 2 km from river.

ArcGIS automatically runs spatial SQL behind the scene.

5. Real Life GIS Workflow Example

Suppose you want to analyse Flood Risk Areas

Step 1 – Store Data

Store rivers, rainfall, and land use in spatial database.

Step 2 – Use Relational Model

Link rainfall table with district boundaries.

Step 3 – Use Geographic DBMS

Store spatial shapes of rivers and villages.

Step 4 – Use SQL

Query villages near river and heavy rainfall zones.

6. Difference Summary

ConceptPurpose
Relational DatabaseOrganizes attribute data
Geographic DBMS ExtensionStores spatial objects
SQL in GISQueries and analyses data

7. Simple Concept Connection

👉 Relational Database
Stores attribute tables.

👉 Geographic DBMS
Stores spatial data.

👉 SQL
Controls and analyses both.

8. Example From Your Field (Geography / GIS Research)

You can use these concepts in:

  • Landslide mapping

  • Urban expansion studies

  • Climate data analysis

  • Crime mapping

  • Poverty mapping


Comments

Post a Comment

Popular posts from this blog

History of GIS

1. 1832 - Early Spatial Analysis in Epidemiology:    - Charles Picquet creates a map in Paris detailing cholera deaths per 1,000 inhabitants.    - Utilizes halftone color gradients for visual representation. 2. 1854 - John Snow's Cholera Outbreak Analysis:    - Epidemiologist John Snow identifies cholera outbreak source in London using spatial analysis.    - Maps casualties' residences and nearby water sources to pinpoint the outbreak's origin. 3. Early 20th Century - Photozincography and Layered Mapping:    - Photozincography development allows maps to be split into layers for vegetation, water, etc.    - Introduction of layers, later a key feature in GIS, for separate printing plates. 4. Mid-20th Century - Computer Facilitation of Cartography:    - Waldo Tobler's 1959 publication details using computers for cartography.    - Computer hardware development, driven by nuclear weapon research, leads to broader mapping applications by early 1960s. 5. 1960 - Canada Geograph...
Post a Comment
Read more

Supervised Classification

Image Classification in Remote Sensing Image classification in remote sensing involves categorizing pixels in an image into thematic classes to produce a map. This process is essential for land use and land cover mapping, environmental studies, and resource management. The two primary methods for classification are Supervised and Unsupervised Classification . Here's a breakdown of these methods and the key stages of image classification. 1. Types of Classification Supervised Classification In supervised classification, the analyst manually defines classes of interest (known as information classes ), such as "water," "urban," or "vegetation," and identifies training areas —sections of the image that are representative of these classes. Using these training areas, the algorithm learns the spectral characteristics of each class and applies them to classify the entire image. When to Use Supervised Classification:   - You have prior knowledge about the c...
Post a Comment
Read more

History of GIS

The history of Geographic Information Systems (GIS) is rooted in early efforts to understand spatial relationships and patterns, long before the advent of digital computers. While modern GIS emerged in the mid-20th century with advances in computing, its conceptual foundations lie in cartography, spatial analysis, and thematic mapping. Early Roots of Spatial Analysis (Pre-1960s) One of the earliest documented applications of spatial analysis dates back to  1832 , when  Charles Picquet , a French geographer and cartographer, produced a cholera mortality map of Paris. In his report  Rapport sur la marche et les effets du cholĂ©ra dans Paris et le dĂ©partement de la Seine , Picquet used graduated color shading to represent cholera deaths per 1,000 inhabitants across 48 districts. This work is widely regarded as an early example of choropleth mapping and thematic cartography applied to epidemiology. A landmark moment in the history of spatial analysis occurred in  1854 , when  John Snow  inv...
Post a Comment
Read more

Representation of Spatial and Temporal Relationships

In GIS, spatial and temporal relationships allow the integration of location (the "where") and time (the "when") to analyze phenomena across space and time. This combination is fundamental to studying dynamic processes such as urban growth, land-use changes, or natural disasters. Key Concepts and Terminologies Geographic Coordinates : Define the position of features on Earth using latitude, longitude, or other coordinate systems. Example: A building's location can be represented as (11.6994° N, 76.0773° E). Timestamp : Represents the temporal aspect of data, such as the date or time a phenomenon was observed. Example: A landslide occurrence recorded on 30/07/2024 . Spatial and Temporal Relationships : Describes how features relate in space and time. These relationships can be: Spatial : Topological (e.g., "intersects"), directional (e.g., "north of"), or proximity-based (e.g., "near"). Temporal : Sequential (e....
Post a Comment
Read more

GIS: Real World and Representations - Modeling and Maps

Geographic Information Systems (GIS) serve as a bridge between the real world and digital representations of geographic phenomena. These representations allow users to store, analyze, and visualize spatial data for informed decision-making. Two key aspects of GIS in this context are modeling and maps , both of which are used to represent real-world geographic features and phenomena in a structured, analyzable format. Let's delve into these concepts, terminologies, and examples in detail. 1. Real World and Representations in GIS Concept: The real world comprises physical, tangible phenomena, such as landforms, rivers, cities, and infrastructure, as well as more abstract elements like weather patterns, population densities, and traffic flow. GIS allows us to represent these real-world phenomena digitally, enabling spatial analysis, decision-making, and visualization. The representation of the real world in GIS is achieved through various models and maps , which simplify...
Post a Comment
Read more