Application of GIS in Water Network Systems

Introduction to PostgreSQL and PostGIS, installing and configuring the software, and connecting GISWATER with QGIS

Module Topics

• Introduction to PostgreSQL and PostGIS
• Installing and configuring PostgreSQL and PostGIS
• Installing GISWATER and setting up the database
• Connecting GISWATER with QGIS
• Database management basics for GISWATER

Activities

1. Step-by-step PostgreSQL and PostGIS installation
2. GISWATER installation and configuration
3. Creating and connecting to a GISWATER database
4. Setting up QGIS for GISWATER integration
5. Basic database operations for water network data

Learning Outcomes

• Successfully install and configure all required software
• Create and configure a GISWATER database
• Connect QGIS to GISWATER database
• Perform basic database operations for water network data

Assessment

Weekly Assignment

Practical exercise applying the concepts learned in this module. Due at the end of the week.

Module Quiz

Multiple-choice quiz covering the theoretical aspects of the module. Must be completed before moving to the next module.

Overview of GIS applications in water distribution, role of GIS in water resource planning and management, and understanding GISWATER features and benefits.

Module Topics

• Overview of GIS applications in water distribution
• Role of GIS in water resource planning and management
• Understanding GISWATER: Features and benefits
• Case studies of successful GIS implementation in water utilities

Activities

• 1.Introduction to water network components in GIS
• 2.Exploring example water network datasets
• 3.Analyzing GIS applications in different water utility scenarios
• 4.Group discussion on GIS benefits for water management

Learning Outcomes

• Understand the role of GIS in water network management
• Recognize the potential benefits of GISWATER implementation
• Identify key water network components for GIS representation
• Appreciate the value of spatial data in water resource planning

Assessment

Weekly Assignment

Practical exercise applying the concepts learned in this module. Due at the end of the week.

Module Quiz

Multiple-choice quiz covering the theoretical aspects of the module. Must be completed before moving to the next module

Introduction to spatial data in GISWATER, creating and managing network layers, and digitizing pipelines, nodes, reservoirs, and valves.

Module Topics

• Introduction to spatial data in GISWATER
• Creating and managing water network layers
• Digitizing pipelines, nodes, reservoirs, and valves
• Importing and exporting GIS data
• Quality control for digitized water networks

Activities

1. Creating a new water network project in GISWATER
2. 2.Digitizing water mains and service connections
3. Adding network nodes, valves, and other features
4. Importing data from CAD or other GIS formats
5. Quality checking digitized networks

Learning Outcomes

• Create a complete water network model in GISWATER
• Digitize all required network elements accurately
• Import existing data from various formats
• Implement quality control procedures for network data

Assessment

Weekly Assignment

Practical exercise applying the concepts learned in this module. Due at the end of the week.

Module Quiz

Multiple-choice quiz covering the theoretical aspects of the module. Must be completed before moving to the next module.