(Click Category to List Courses)
38 - IT-D Information Technology - Databases and Related Technologies
IT-D 255 - Spatial Database Management with PostGIS
Code | Start Date | Duration | Venue | |
---|---|---|---|---|
IT-D 255 | 20 November 2023 | 5 Days | Istanbul | Registration Form Link |
IT-D 255 | 11 December 2023 | 5 Days | Istanbul | Registration Form Link |
Course Description
PostGIS adds GIS spatial types and support to PostgreSQL. It is used by Database and GIS Professionals who need to store and query both the spatial and non-spatial attributes of their data in the same queries. So the data is stored in rows and columns. Because PostGIS is a spatial database, the data also has a geometry column with data in a specific coordinate system defined by spatial reference identifier (SRID).
Course Objectives
- Learn what spatial databases are
- Learn the basics of working with PostGIS, a spatial extension of PostgreSQL
- Learn how geographical data is stored in a database
- Learn about the basic geographical functions available in PostGIS
- Learn how to write SQL queries using geographical functions
Who Should Attend?
- GIS specialists
- Anybody involved in professional work in which spatial information is needed and needs to be put in place.
Course Details/Schedule
Day 1
- PostGIS Introduction
- Introduction to Spatial Database
- Intro to PostgreSQL and PostGIS
- Components of PostGIS and how PostGIS builds on top of PostgreSQL
- Installation and setup of PostGIS
- Data Types and functions in PostGIS(an overview)
- Spatial Reference Systems
- Geometries
- PostGIS_geometry Columns metatable
- Geometry Types (points, linestrings, polygons)
- Geometry collection types (multipoints, multilinestrings, multipolygons)
- Curved geometry types and 3D geometry types
Day 2
- Organizing Spatial Data
- Spatial data storage and retrieval approaches
- Adding a geometry to a field
- Adding constraint based on geometry type
- Populating a geometry-columns tables
Day 3
- Working with Geometries
- Geometry Functions
- Spatial Queries
- Spatial Operators
- Spatial Joins and Overlays
- Spatial Indexes
- Relationships b/w geometries
- Optimizing Geometries
Day 4
- PostGIS Raster
- What is raster data
- Difference of vector and raster data
- Raster data storage, retrieval and analysis
- Raster Data Processing
- Combining raster processing with vector processing
Day 5
- Spatial Analysis and GIS Data Processing
- Techniques to solve spatial problems
- Introduction to Tools for data import and export
- PostGIS for web-based applications