Spatial Databases with PostGIS and QGIS
Details
INTRODUCTION
This course is intended to provide an introduction to spatial databases in general and PostGIS in particular to GIS professionals who are interested in expanding their skillset to multi-user enterprise level spatial databases. This course uses the latest versions of PostgreSQL, PostGIS, and QGIS.
COURSE OBJECTIVES
Upon course completion, participants should be able to:
- What a spatial database is and why you would want to use one.
- What SQL is, why you would want to use it, and how it can be applied to geospatial concepts.
- How to install PostGIS locally for development purposes and how to access a production version via a network or the internet.
- How to load your spatial data into PostGIS and access it from a variety of clients, especially QGIS
- The basics of SQL for both spatial and non-spatial queries
- How to validate data and control user access with the tools built-in to PostGIS
- Optimizing your queries for the best performance
- How to work with raster data in PostGIS
- The basics of programming custom functions with PL/pgSQL
- The basics of database administration to keep your database operating smoothly
DURATION
5 days
Outline
COURSE OUTLINE
Module 1: Introduction to QGIS
- Gain a basic conceptual understanding of cartography, GIS, and mapping
- Gain familiarity with geographic data and information, and how it's encoded within computer files
- Gain a basic familiarity with the QGIS interface
- Gain awareness of spatial reference and projection issues
- Practice opening a variety of geographic data with QGIS and viewing their attributes within QGIS
Module 2: mapping using QGIS
- Creating a Basic Map
- Classifying Vector Data
- Creating Maps
- Vector Analysis
- Rasters
- Completing the Analysis
- Plugins
- Online Resources
- QGIS Server
- Perform basic map styling
- Create and export a basic map as a static image file
Module 3: POSTGIS
- Introduction to POSTGIS
- Installation
- Applications that support PostGIS
- Creating a PostGIS database
- Loading spatial data
- Data review
- Postgis connection and settings
- Spatial reference systems settings
- Import .csv file with point location
- SQL and graphical querying
- Spatial relationships
- Spatial joins
- Spatial indexing
- Geometry constructing functions
Module 4: Advanced QGIS Processing
- Using Spatial Databases in QGIS
- Creating POSTGIS connection
- Adding POSTGIS layers
- Plot data in QGIS
- Change layer style
- Geoprocessing tools
- Geometry tools
- Processing toolbox
- Web
- Database
Module 5: Online Sources of Data
- Openstreet maps
- CartoDB
- Google earth
- Interactive and shareable maps
- Google maps, Geoserver, fusion tables and CartoDB
- Online data analysis
Schedules
Weekdays | 09:00 AM — 05:00 PM |
Weekdays | 09:00 AM — 05:00 PM |
No. of Days: | 5 |
Total Hours: | 8 |
FineResults Research Services offers training solutions to individuals, communities, governments and civil society organizations, both local and international.
We also provide application-oriented and field-based consultancy services in all aspects of research and evaluations from inception to completion. This includes research designs, designing monitoring and evaluations systems, technical reviews, programme evaluations, questionnaire validation, data collection, data capture, data analysis and report writing. FineResults Research Services is a limited company incorporated under the laws of Kenya. Its head office is in Nairobi Kenya.
The organization has a wide range of experience working with both local and international organizations in both consultancies and capacity building in Africa and beyond.
MissionA world class training and research organization for the realization of individuals, organizations and community welfare.
VisionTo provide world class training and research services that increase individuals and organizations productivity in their development role.
Our Value Statement- We cherish partnerships.
- We believe that our Training and Research Solutions can re-energise organisations by creating vision, certainty and strategic intent. ...