- TypeWorkshop
- Location Nairobi, Kenya
- Date 17-01-2022 - 28-01-2022
Education/Teaching/Training/Development
Research/Science
Computer/Technology
INTRODUCTION
PostGIS is an open source software program that adds support for geographic objects to the PostgreSQL object-relational database. PostGIS follows the Simple Features for SQL specification from the Open Geospatial Consortium (OGC). Technically PostGIS was implemented as a PostgreSQL's external extension. PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications. It can handle workloads ranging from small single-machine applications to large Internet-facing applications (or for data warehousing) with many concurrent users; on macOS Server, PostgreSQL is the default database and it is also available for Microsoft Windows and (supplied in most distributions). The main purpose of the training is to equip the trainers with skills that will enable them handle cross-platform operations between the inter-operable software.
OBJECTIVES:
The participant(s) should be able to perform the following upon successful completion of the training:
· Create and administer spatial databases
· Distinguish between, spatial and classic databases
· Import and export spatial data
· Perform both basic and complex queries
· Perform spatial functions
· Connect databases to GIS software
DURATION
10 days
Requirements
SQL language and GIS knowledge
COURSE OUTLINE
MODULE 1
MODULE 2
· Installation and Configuration PostGIS
· From stackbuilder
· PostGIS template presentation
· Create a spatial database
MODULE 3
· Vector (point, line, polygons)
· Raster
· WKT, WKB
· Spatial SQL
MODULE 4
· Import a spatial dataset
MODULE 5
· More complex queries, spatial joins (intersections, etc.)
MODULE 6
· Shp2pgsql (command line) and useful parameters
· PostGIS Shapefile and DBF Loader
MODULE 7
· Open layers from PostGIS
· Privileges management (read, write, update, insert, delete) on GIS
data
MODULE 8
· Relational model theory
· Basics on tables, primary keys, attributes
· The different models (Conceptual data Model, Relational
· model)
· Creation of a Database
MODEL 9
· Create tables, views
· Constraints management (primary and foreign keys)
· Simple queries with graphic composer
MODULE 10
· Roles and group of users
· Grant and revoke privileges to users
· Import / Export Data and Backup / Restore
· Import from attribute tables (Excel, CSV, text files, etc.)
· Export from database to Excel
***************************
TRAINING CUSTOMIZATION
This training can also be customized for your institution upon request. You can also have it delivered your preferred location.
For further inquiries, please contact us through Mobile: +254 732 776 700 or Email: [email protected]
REQUIREMENTS
Participants should be reasonably proficient in English. During the trainings, participants should come with their own laptops.
TRAINING FEE
The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.
ACCOMMODATION
Accommodation is arranged upon request. For reservations contact us through Mobile: +254732776700 or Email: [email protected]
Fahari Palace Apartments, along Church Road, Nairobi Kenya
+254 732 776 700 +254 732 776 700