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

Quantitative Revolution in Geography

The Quantitative Revolution was a major change in Geography during the 1950s and 1960s. It introduced mathematical, statistical and scientific methods to understand geographical phenomena. Before this revolution, geographers mainly described places, regions, landscapes and differences between areas. After the revolution, they increasingly used numerical data, statistical analysis, mathematical models and theories to explain why geographical patterns occur and how they may change. For example: Traditional approach: Describe the distribution of population in different regions. Quantitative approach: Use statistical methods to identify population patterns, explain the factors influencing population distribution and predict future population growth. The revolution helped establish Geography as a spatial science, focusing on the location, distribution, relati...
Post a Comment
Read more

Satellite Remote Sensing: Concepts and Imaging Systems

  Satellite remote sensing relies on detectors (sensors) that measure reflected/emitted electromagnetic radiation from the Earth. How sensors collect data depends on: Spectral coverage → Multispectral (few bands), Hyperspectral (hundreds), Thermal, Microwave. Detector type → Discrete detectors, linear arrays, or area arrays. Scanning mechanism → Scanning mirrors (whiskbroom) vs. linear arrays (pushbroom). Multispectral Imaging Using Discrete Detectors and Scanning Mirrors (Whiskbroom scanners) Principle : A single detector (or a few detectors) measures radiation one pixel at a time. A scanning mirror sweeps across-track (perpendicular to the satellite path) to build up the image line by line. The forward motion of the satellite provides the along-track dimension. Known as a whiskbroom scanner . Characteristics : Good calibration stability. Narrow instantaneous field of view (IFOV). Susceptible to mechanical wear (moving ...
Post a Comment
Read more

Spectral Signature vs. Spectral Reflectance Curve

Spectral Signature  A spectral signature is the unique pattern in which an object: absorbs energy reflects energy emits energy across different wavelengths of the electromagnetic spectrum. ✔ Key Points Every natural and man-made object on Earth interacts with sunlight differently. These interactions produce a distinct pattern , just like a "fingerprint". Sensors on satellites record these patterns as digital numbers (DN values) . These patterns help to identify and differentiate objects such as vegetation, soil, water, snow, buildings, minerals, etc. ✔ Examples of Spectral Signatures Healthy vegetation → High reflectance in NIR , strong absorption in red Water → Strong absorption in NIR and SWIR , low reflectance Dry soil → Gradual increase in reflectance from visible to NIR Snow → High reflectance in visible , low in SWIR ✔ Why Spectral Signature Matters It allows: Land cover classification Chan...
Post a Comment
Read more

Geometric Correction

When satellite or aerial images are captured, they often contain distortions (errors in shape, scale, or position) caused by many factors — like Earth's curvature, satellite motion, terrain height (relief), or the Earth's rotation . These distortions make the image not properly aligned with real-world coordinates (latitude and longitude). 👉 Geometric correction is the process of removing these distortions so that every pixel in the image correctly represents its location on the Earth's surface. After geometric correction, the image becomes geographically referenced and can be used with maps and GIS data. Types  1. Systematic Correction Systematic errors are predictable and can be modeled mathematically. They occur due to the geometry and movement of the satellite sensor or the Earth. Common systematic distortions: Scan skew – due to the motion of the sensor as it scans the Earth. Mirror velocity variation – scanning mirror moves at a va...
Post a Comment
Read more

RADIOMETRIC CORRECTION

  Radiometric correction is the process of removing sensor and environmental errors from satellite images so that the measured brightness values (Digital Numbers or DNs) truly represent the Earth's surface reflectance or radiance. In other words, it corrects for sensor defects, illumination differences, and atmospheric effects. 1. Detector Response Calibration Satellite sensors use multiple detectors to scan the Earth's surface. Sometimes, each detector responds slightly differently, causing distortions in the image. Calibration adjusts all detectors to respond uniformly. This includes: (a) De-Striping Problem: Sometimes images show light and dark vertical or horizontal stripes (banding). Caused by one or more detectors drifting away from their normal calibration — they record higher or lower values than others. Common in early Landsat MSS data. Effect: Every few lines (e.g., every 6th line) appear consistently brighter or darker. Soluti...
Post a Comment
Read more