Mastering PostGIS

Udemy - Mastering PostGIS

https://WebToolTip.com

Published 6/2025
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Language: English | Duration: 8h 3m | Size: 2.35 GB

From Fundamentals to Advanced Spatial Analysis

What you'll learn
Introduction to PostgreSQL, PostGIS, and pgAdmin
Step-by-step installation and configuration for a smooth start
Learn how to create and manage databases using both pgAdmin (GUI) and the command line interface (CLI).
Understand how to design and manage spatial and non-spatial tables effectively
Upload and manage Shapefiles,GeoJson data and CSV files in your PostGIS databaseConnect and manage your spatial database using QGIS and GeoServer
Learn key concepts like normalization, primary/foreign keys, and relational models for efficient data structuring
Explore vector geometry, raster, and other spatial data types
Upload Shapefiles using both CLI (psql) and pgAdmin’s Import/Export Wizard
Import GeoJSON data into your spatial database
Load KML/KMZ files using the ogr2ogr utility
Import raster data using raster2pgsql for spatial analysis.
Work with Coordinate Reference Systems (CRS) and SRID functions
Write effective SQL queries for spatial and non-spatial data
Perform inserts, updates, and deletions on spatial records
Use spatial joins and spatial relationship queries to extract meaningful insights
Apply spatial indexing, VACUUM, and ANALYZE for optimized performance
Learn how to boost query performance using GiST (Generalized Search Tree) indexes in PostGIS.
Connect and manage your spatial database using QGIS and GeoServer
Dynamically connect PostGIS with web mapping library to insert, query, and display spatial data on interactive maps

Requirements
No prior experience with spatial databases is needed — this course starts from the basics
Basic knowledge of databases or SQL is helpful but not mandatory
A computer with internet access
Willingness to install free software like PostgreSQL, PostGIS, pgAdmin, GeoServer and QGIS