PostGIS Módulo I

Explore the power of PostGIS, the robust spatial database extension for PostgreSQL! This course dives deep into leveraging geospatial data with PostGIS, enabling you to work with a wide range of geographic information, including satellite imagery, drone data, maps, and routes.

You'll learn everything from importing spatial data into PostGIS to advanced data editing using QGIS, the leading open-source Geographic Information System (GIS) software. Gain a competitive edge with PostGIS's unique capabilities, often exceeding those of competitors like Oracle Spatial and SQL Server Spatial.

Key Topics Covered:

• Geometry Types: Master working with various geometry types, including Points, LineStrings, Polygons, MultiPoints, MultiLineStrings, MultiPolygons, and GeometryCollections.
• Spatial Operators: Discover powerful spatial operators to calculate crucial geospatial measurements such as area, distance, length, and perimeter.
• Spatial Set Operations: Learn to perform complex spatial operations like union, difference, symmetric difference, and buffers (leveraging GEOS).
• Spatial Indexing: Understand and utilize R-tree-over-GiST indexes for significantly faster spatial queries.
• Index Selectivity: Optimize query performance with index selectivity for efficient handling of mixed spatial and non-spatial queries.
• Performance Optimization: Explore how PostGIS's optimized geometry and indexing implementation minimizes disk and memory usage, enabling faster query execution by leveraging RAM.
• Standards Compliance: Understand that PostGIS is "implementing the specified standard" for "Simple Features for SQL".

No prior SQL knowledge is required to benefit from this course. Unlock the potential of location-based data with PostGIS and QGIS!