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

Regional Geography, Systematic Geography, Idiographic, Nomothetic, Inductive and Deductive Approaches

T wo major ways of studying Geography : the Regional Approach and the Systematic Approach . It also explains the related ideas of idiographic vs. nomothetic and inductive vs. deductive reasoning , especially in the context of the Hartshorne–Schaefer debate . 1. Regional Geography: “All About One” Regional Geography studies one particular region in detail . A region is an area that has some degree of homogeneity (sameness) within its boundary but is also unique or different from other regions . For example, if we study Palakkad District , we may study: Relief and drainage Climate Soil Vegetation Agriculture Population Occupation Economy Culture Political characteristics The purpose is to understand the complete geographical personality of Palakkad and the relationships among its different features. Key concepts Region: A geographical area with identifiable characteristics and boundaries. Homogeneity: Si...
Post a Comment
Read more

Multispectral and Hyperspectral Imaging Systems

The main idea is how a remote-sensing sensor collects information about an area . A sensor does not simply take an ordinary photograph. It measures the electromagnetic energy reflected or emitted by objects in different wavelength bands . Depending on how many bands are measured and how the sensor collects them, different imaging systems are used. 1. Multispectral vs. Hyperspectral Multispectral imaging (MSI) records information in a limited number of relatively broad, separate spectral bands , such as blue, green, red, near-infrared and shortwave infrared. Hyperspectral imaging (HSI) records information in many narrow and usually contiguous spectral bands . Therefore, it provides a much more detailed spectral signature of each pixel. The resulting dataset is commonly called a hyperspectral data cube (hypercube) because it contains: X-axis → spatial information Y-axis → spatial information Z-axis → wavelength/spectral information Thus, hype...
Post a Comment
Read more

Discrete Detectors and Scanning mirrors Across the track scanner Whisk broom scanner.

Multispectral Imaging Using Discrete Detectors and Scanning Mirrors (Across-Track Scanner or Whisk Broom Scanner) Multispectral Imaging:  This technique involves capturing images of the Earth's surface using multiple sensors that are sensitive to different wavelengths of electromagnetic radiation.  This allows for the identification of various features and materials based on their spectral signatures. Discrete Detectors:  These are individual sensors that are arranged in a linear or array configuration.  Each detector is responsible for measuring the radiation within a specific wavelength band. Scanning Mirrors:  These are optical components that are used to deflect the incoming radiation onto the discrete detectors.  By moving the mirrors,  the sensor can scan across the scene,  capturing data from different points. Across-Track Scanner or Whisk Broom Scanner:  This refers to the scanning mechanism where the mirror moves perpendicular to the direction of flight.  This allows for t...
Post a Comment
Read more

Thermal Infrared Remote Sensing

1. Principles Thermal Infrared Remote Sensing is based on the detection of naturally emitted electromagnetic radiation from objects, rather than reflected solar energy. According to Planck's Radiation Law , all objects with a temperature above absolute zero (0 K) emit electromagnetic radiation. For Earth surface features, the peak emission lies in the Thermal Infrared (TIR) region of 3–14 μm of the electromagnetic spectrum. The amount of radiation emitted is primarily a function of surface temperature and emissivity . Sensors measure the radiant energy flux density (W/m²) , which is later converted to surface temperature using Stefan-Boltzmann's Law . 2. Radiation Properties in TIR Emissivity (ε): Ratio of radiation emitted by a surface to that emitted by a perfect blackbody at the same temperature. Natural surfaces like water (ε ≈ 0.98) have high emissivity, while bare soils and metals have lower values. Blackbody: An idealized object th...
Post a Comment
Read more

Satalite

Landsat → Land resources SPOT → High-resolution mapping IRS → Indian natural-resource mapping ASTER → Geology + thermal + DEM QuickBird → Very high spatial resolution MODIS → Daily global monitoring GOES → Weather monitoring AVHRR → Weather + vegetation + ocean AVIRIS → Hyperspectral imaging Highest spectral resolution: AVIRIS (224 narrow bands) Highest spatial resolution in this list: QuickBird (~0.61 m PAN) Highest temporal frequency: GOES (minutes) Best broad global monitoring: MODIS Indian sensors: IRS-LISS III and LISS IV Hyperspectral: AVIRIS Thermal + multispectral + DEM: ASTER abbreviations MSS – Multispectral Scanner System TM – Thematic Mapper ETM+ – Enhanced Thematic Mapper Plus GOES – Geostationary Operational Environmental Satellite AVHRR – Advanced Very High Resolution Radiometer HRV – High Resolution Visible HRVIR – High Resolution Visible and Infrared HRG – High Resolution Geometric ...
Post a Comment
Read more