Description

Install, create and operate a Postgis spatial database

Who is this training for ?

For whom ?

Be familiar with the Windows environment and database management systems or have followed database training offered by IDGEO.

Prerequisites

GIS engineers and technicians, database administrators

Training objectives

Store and manipulate spatial data in a free and efficient database management system Manipulate the SQL query language in its spatial dimension

Training program

• Spatial databases
  • OGC Principles and Standards
  • Types of Spatial Data
• PostGIS
  • Installation
  • Creating a spatial database
• Importing data into PostGIS
  • With the interface offered by QGIS
• PostGIS links and GIS software
  • Visualizing and manipulating PostGIS data in QuantumGIS
  • MAPINFO/PostGIS link and ArcGIS/PostGIS links
• The MAPINFO/PostGIS link and the ArcGIS/PostGIS link
  • Query geographic objects
  • Spatial queries
  • Buffer zones
• Create objects by queries: Spatial analyzes
  • The creation of new data layers by dynamic crossing
• Fill a geometric column with x,y coordinates
  • ST_POINT
• Managing projections in PostGIS
  • ST_Transform() vs UpdateGeometrySRID
• Storing and manipulating raster images in PostGIS
  • Import images into a PostGIS table
  • Manipulating images