Advanced Geographic Information System (GIS) and DBMS

Course Contents

Lectures: 45 Hours
Exercise: 35 Hours
Year: III
Semester: V

Chapter 1: Review of Basic GIS Concepts [7 hrs]

1.1 Recap of Fundamental GIS Concepts

• Data types: Vector and Raster
• Spatial data models
• Coordinate systems and projections

1.2 Data Integration and Transformation

• Combining data from different sources
• Coordinate transformations and datum shifts

1.3 Data Quality and Accuracy

• Data standards
• Data quality
• Uncertainty and accuracy in GIS

Chapter 2: Advanced Spatial Analysis Techniques [10 hrs]

2.1 Vector Data Analysis

• Measurement and classification analysis
• Neighbourhood analysis, overlay analysis, connectivity analysis
• Spatial operations (clip, intersect, union, buffer, etc.)

2.2 Raster Data Analysis

• Local operations (single raster, reclassification, multiple raster)
• Neighbourhood operations
• Zonal operations
• Raster data extraction

2.3 Data Conversion

• Vector to raster conversion
• Raster to vector conversion
• Data interoperability

2.4 Spatial Queries

• Attribute-based queries
• Geometric-based queries
• Spatial queries based on selected features

2.5 Spatial Statistics and Interpolation Methods

Chapter 3: Spatial Database Management [6 hrs]

3.1 Relational Databases in GIS

• Introduction to database concepts
• Relational database management systems

3.2 Spatial Database Design

• Designing tables for spatial data
• Indexing and optimizing spatial queries

3.3 SQL for GIS

• Spatial SQL queries
• Spatial functions in SQL

Chapter 4: Spatial Decision Support System (SDSS) [5 hrs]

• Concept and components of SDSS
• Spatial decision-making frameworks
• Multi-criteria decision analysis (MCDA) techniques
• Implementation of SDSS using GIS tools and models
• Case studies of SDSS application in engineering projects

Chapter 5: Geospatial Modeling and Simulation [3 hrs]

• Introduction to geospatial modeling
• Types of GIS models
• Process of GIS modeling
• Application of geospatial modeling in engineering and environmental studies

Chapter 6: Online GIS/Volunteered Geographic Information [4 hrs]

• Introduction to Online GIS and VGI
• Understanding crowdsourcing and citizen science in the context of VGI
• Introduction to Mobile GIS and applications
• Real-world applications of online GIS and VGI in various domains (e.g., urban planning, environmental management, disaster response, etc.)

Chapter 7: Application of GIS [6 hrs]

• Process of application of GIS in solving real-world scenarios (Disaster management, Network analysis, surface analysis, Hydrological analysis, environmental monitoring, etc.)

Chapter 8: Emerging Trends in GIS [4 hrs]

• Integration of remote sensing data with GIS
• Machine learning and AI in GIS
• Integration of IoT and sensor network in GIS
• Blockchain technology in GIS

Tutorial & Practical: (35 hrs)

1. Topographical Map Preparation

• Database schema
• Georeferencing scanned topographical map
• Digitizing map features
• Adding attributes to point, line, and polygon features
• Topological rule and editing of spatial data
• Visualization of topographical map

2. Map Projection and Coordinate Transformation

• Define projection
• Setting data frame’s map projection
• Coordinate transformation of data from one datum to another

3. Vector Data Analysis

• Measurement and classification analysis
• Neighbourhood analysis
• Overlay analysis
• Geometric and attribute selection
• Spatial query based on selected features
• Spatial operations (clip, intersect, union, buffer, reclassification, overlay)
• Vector to raster conversion

4. Raster Data Analysis

• Reclassification
• Neighbourhood operations
• Zonal operations
• Raster data extraction
• Raster to vector conversion

5. Model Builder and Model Evaluation

• Quick tour of Model Builder interface
• Essential Model Builder vocabulary
• Create a model for a case in GIS

6. Use and Operating OpenStreetMap

• Editing and contributing in OpenStreetMap
• Downloading data
• Online and offline mapping

7. Application of GIS

• Multi-criteria evaluation for site selection
• Disaster mapping (landslide susceptibility, flood susceptibility, watershed delineation, viewshed analysis, network analysis, etc.)