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

Atmospheric Window

The atmospheric window in remote sensing refers to specific wavelength ranges within the electromagnetic spectrum that can pass through the Earth's atmosphere relatively unimpeded. These windows are crucial for remote sensing applications because they allow us to observe the Earth's surface and atmosphere without significant interference from the atmosphere's constituents. Key facts and concepts about atmospheric windows: Visible and Near-Infrared (VNIR) window: This window encompasses wavelengths from approximately 0. 4 to 1. 0 micrometers. It is ideal for observing vegetation, water bodies, and land cover types. Shortwave Infrared (SWIR) window: This window covers wavelengths from approximately 1. 0 to 3. 0 micrometers. It is particularly useful for detecting minerals, water content, and vegetation health. Mid-Infrared (MIR) window: This window spans wavelengths from approximately 3. 0 to 8. 0 micrometers. It is valuable for identifying various materials, incl...
Post a Comment
Read more

Energy Interaction with Atmosphere and Earth Surface

In Remote Sensing , satellites record electromagnetic radiation (EMR) that is reflected or emitted from the Earth. Before reaching the sensor, radiation interacts with: The Atmosphere The Earth's Surface These interactions control how satellite images look and how we interpret them. I. Interaction of EMR with the Atmosphere When solar radiation travels from the Sun to the Earth, four main processes occur: 1. Absorption Definition: Absorption occurs when atmospheric gases absorb radiation at specific wavelengths and convert it into heat. Main absorbing gases: Ozone (O₃) → absorbs Ultraviolet (UV) Carbon dioxide (CO₂) → absorbs Thermal Infrared Water vapour (H₂O) → absorbs Infrared Concept: Atmospheric Windows These are wavelength regions where absorption is very low, allowing radiation to pass through the atmosphere. Remote sensing depends on these windows. For example, satellites like Landsat 8 use visible, near-infrared, and thermal bands located in atmospheric windows. 2. Trans...
Post a Comment
Read more

Platforms in Remote Sensing

In remote sensing, a platform is the physical structure or vehicle that carries a sensor (camera, scanner, radar, etc.) to observe and collect information about the Earth's surface. Platforms are classified mainly by their altitude and mobility : Ground-Based Platforms Definition : Sensors mounted on the Earth's surface or very close to it. Examples : Tripods, towers, ground vehicles, handheld instruments. Applications : Calibration and validation of satellite data Detailed local studies (e.g., soil properties, vegetation health, air quality) Strength : High spatial detail but limited coverage. Airborne Platforms Definition : Sensors carried by aircraft, balloons, or drones (UAVs). Altitude : A few hundred meters to ~20 km. Examples : Airplanes with multispectral scanners UAVs with high-resolution cameras or LiDAR High-altitude balloons (stratospheric platforms) Applications : Local-to-regional mapping ...
Post a Comment
Read more

Scattering

Scattering 
Post a Comment
Read more

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