PostGIS from Beginner to Advanced

Explore PostgreSQL as an open source, ACID-compliant RDBMS and the backbone of PostGIS, covering MVCC, extensibility, SQL compliance, JSON, and geospatial capabilities.

Discover how PostGIS extends PostgreSQL to store, retrieve, and analyze geospatial data. Leverage over 300 spatial functions, 3D/4D support, indexing, and seamless integration with GIS tools for web maps.

Learn core PostgreSQL data types, including numeric, text, date time, boolean, json, uuid, and PostGIS geometry and geography, and how correct types ensure data integrity and efficient storage.

Explore geometry and raster data types in PostGIS, including points, line strings, polygons, multi geometries, and rasters for elevation and land cover, along with core functions like distance and buffer.

Install PostgreSQL and PostGIS across Windows, Linux, and macOS, selecting compatible versions. Use Pgadmin or Stack Builder, and ensure compatibility to complete course exercises.

import shapefiles into postgis using pgadmin's shapefile import export manager or the shape to pgsql command line tool, with attention to 4326 wgs84 and environment setup.

Load GeoJSON data into PostGIS by installing GDAL on Windows, configuring it, and using ogr2ogr to transfer features from GeoJSON to the PostGIS database.

Learn to load KML and KMZ files into PostGIS using the GDAL/OGR2OGR tool, and manage imported geospatial data.

Learn to create a spatial database in PostgreSQL using both the command line and Pgadmin, then enable PostGIS and verify installation.

Master SQL basics for relational databases and PostGIS, covering create, insert, update, delete, select, and spatial functions like geometry from text with SRID 4326.

Master SQL joins and PostGIS spatial joins, compare inner, left, right, full, and partial joins, and apply spatial relationships like within, contains, and intersects to link geometry and attributes.

Mastering PostGIS explores regular and spatial joins, using inner, left, right, and full outer joins, plus spatial predicates like within, contains, and intersects on polygon and point data.

Explore spatial indexing in PostGIS to speed geospatial queries on points, lines, and polygons. Understand b-tree, hash, and generalized search tree indexes for bounding box, nearest neighbor, and intersections.

Discover how spatial indexing in PostGIS speeds queries by using a generalized search tree index on the location column, improving performance and reducing seq scans.

Learn how SRID defines spatial reference in PostGIS, and how to manage WGS 84 (EPSG 4326) and Web Mercator (EPSG 3857) with set SRID and transform for accurate spatial data.

Explore how to manage srid in postgis by checking, updating, and transforming spatial data to ensure correct coordinates, projections, and accurate distance queries.

Explore buffering, distance calculation, and proximity analysis in PostGIS, using buffers, distance queries, and ST_DWithin for urban planning, environmental studies, and navigation.

Master spatial analysis in PostGIS by applying a 500-meter buffer and distance calculations. Use proximity queries to rank nearest parks and parts, ensuring meters via projection for accurate results.

Explore advanced PostGIS techniques for overlay analysis, including intersection, union, and difference, plus proximity, clustering, and routing to solve real-world GIS problems.

Apply advanced spatial functions in PostGIS through hands-on queries for overlay analysis, spatial joins, nearest neighbor search, clustering, and route analysis to support urban planning and GIS decision making.

Merge and split geometries in PostGIS using union and split operations. Combine districts into provinces, or visualize parcels as unified multi polygon.