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

CREATION OF SPATIAL DATA

Spatial data creation is the process of generating, organizing, and managing geographically referenced information in a Geographic Information System (GIS). It involves converting maps, satellite images, GPS observations, and field survey data into digital datasets that can be stored, analyzed, and visualized. The quality of GIS analysis depends largely on the accuracy of spatial data creation. 1. Creation of Shapefile and Geodatabase A. Shapefile A Shapefile is one of the most widely used vector data formats developed by Esri for storing geographic features. Definition A shapefile stores the geometry and attributes of geographic features such as points, lines, and polygons. Components of a Shapefile A shapefile consists of several files: .shp – Stores geometry (shape) .shx – Shape index .dbf – Attribute table .prj – Coordinate Reference System (CRS) .sbn/.sbx – Spatial index (optional) Geometry Types Point – W...
Post a Comment
Read more

Geography of Health or Medical Geography

Health Geography (also known as Medical Geography ) is a sub-discipline of Human Geography that studies the relationships between place, environment, society, and health . It examines how spatial location, environmental conditions, and social and economic factors influence human health, disease patterns, and access to healthcare services. Health geography integrates concepts from geography, epidemiology, medicine, public health, environmental science, sociology, and Geographic Information Systems (GIS) to understand and improve population health. Major Components of Health Geography Health geography is generally divided into two major branches : The Geography of Disease and Ill Health The Geography of Health Care 1. The Geography of Disease and Ill Health This branch studies the spatial distribution, determinants, and diffusion of diseases across different geographical scales, from neighborhoods to global regions. It seeks t...
Post a Comment
Read more

Nature and Scope of Geography

Geography is the scientific study of the Earth's surface, its physical features, human populations, and the interactions between people and their environment. The word Geography is derived from the Greek words Geo (Earth) and Graphien (to describe or write), meaning "description of the Earth." Modern geography goes far beyond description; it seeks to explain where phenomena occur, why they occur there, how they are spatially distributed, and how they change over time. Geography is regarded as a spatial science , an environmental science , and an integrative discipline because it bridges natural sciences, social sciences, and geospatial technologies. Nature The nature of geography refers to the characteristics and fundamental features that define the discipline. 1. Geography as a Spatial Science Terminology: Spatial Science A discipline concerned with the location, distribution, arrangement, organization, and interaction of phenomena in ...
Post a Comment
Read more

Historical Development of Geography in the Ancient Period

The Ancient Period marks the earliest stage in the evolution of geographical thought, extending from approximately 3000 BCE to the 5th century CE . During this period, geography evolved from simple descriptions of the Earth's surface to systematic scientific inquiry. Early civilizations developed geographical knowledge to meet practical needs such as navigation, trade, agriculture, military expansion, taxation, and administration . The greatest contributions came from the Mesopotamian, Egyptian, Indian, Chinese, Greek, and Roman civilizations , with the Greeks laying the foundations of scientific geography . Meaning Terminology: Historical Development Historical development refers to the gradual evolution of geographical knowledge, concepts, methods, and theories over time. Concept Geographical knowledge evolved through: Observation of the natural environment Exploration and travel Cartography (map-making) Astronomical observations ...
Post a Comment
Read more

Remote Sensing: Energy Sources, Wave Model of Electromagnetic Energy, and Quantum Theory of Electromagnetic Radiation

Remote sensing is the science of collecting information about the Earth's surface without physically touching it . It works by detecting and measuring electromagnetic radiation (EMR) that is emitted or reflected by objects. 1. Energy Sources What is an Energy Source? An energy source is anything that produces electromagnetic radiation (EMR). Without energy, remote sensing cannot detect objects. Definition Energy Source: The origin of electromagnetic energy that illuminates or is emitted by an object so that a sensor can detect it. Types of Energy Sources A. Natural Energy Source (Passive Remote Sensing) The Sun is the most important natural energy source. Produces visible light, infrared, and ultraviolet radiation. Sunlight travels through space and reaches the Earth. Objects absorb part of this energy and reflect the remaining energy. Satellites measure this reflected energy. Examples ...
Post a Comment
Read more