Skip to main content
GIS-Schools GIS-Schools
Step-by-step tutorial

Working with PostGIS By using pgAdmin and QGIS DB Manager

28 Feb, 20241 min read0 commentsLearn Spatial Databases with PostGIS and QGIS
Lesson guide

Tutorial details

Language
English
Level
Beginner

Take this in-depth tutorial and informal training course on managing spatial data to the next level with comprehensive instruction for how PostGIS seamlessly integrates using pgAdmin and Qgis DB Manager. If you are a beginner or expert, this guide could walk through with every steps to work on PostGIS programming and even querying techniques as next level.

Learn how you can work with this powerful feature of the pgAdmin (pre v4) and QGIS DB Manager tool in a very helpful way to deal with your spatial data, run some awesome analysis and make yourself more productive. It does a great job of explaining everything from How to import and export data, etc, all the way up to executing complex queries.

Come along with us for the ride to realize even more in your spatial data projects. Does not really matter if you are a GIS professional, developer or just interested into world of geospatial data.

Lesson downloads

Tutorial resources

Download the files attached to this published lesson.

Muhammad Sohail
Written by

Muhammad Sohail

Web Developer

I am a highly skilled GIS Specialist with a proven track record of delivering high-quality GIS solutions to clients. My expertise in GIS software development, geodatabase design and management, data analysis and visualization, remote sensing, GIS training and support, and GIS consulting. With my technical skills, critical thinking, and business acumen, I am confident in my ability to provide excellent GIS services to clients and deliver results that exceed their expectations.

Continue learning
Discussion

Comments

0

No comments yet. Start the discussion.

Join the discussion

Leave a reply

Your email address will not be published. Required fields are marked.

Play List

  1. How to Install PostgreSQL | Learn Spatial Databases with PostGIS and QGIS
  2. How to Install PostGIS | Learn Spatial Databases with PostGIS and QGIS
  3. How to Import/Export Shapefile into Databases with PostGIS Manager
  4. How to Import / Export Shapefile from QGIS DB Manager into PostGIS
  5. Working with PostGIS By using pgAdmin and QGIS DB ManagerCurrent lesson
  6. PostgreSQL Backup and Restore Spatial Database with PGAdmin4
  7. Postgres: SQL SELECT Statement
  8. PostgreSQL: The WHERE clause
  9. Aggregate functions and the GROUP BY clause
  10. Multi Table Joins in PostgreSQL
  11. The CASE Statement, DataType and Operators in Postgres
  12. Spatial Reference ID and Geometry Field in PostGIS
  13. Spatial Queries - Working with Geometries PostGIS
  14. Measurements Area, Length in PostGIS
  15. Find latitude, Longitude (X,Y) from Multi-Geometry in PostGIS
  16. How to Handel Spatial Relationships of GIS Objects in PostGIS
  17. Spatial Joins with Multi-Table in PostGIS
  18. Geometry Processing Functions and Spatial Joins in PostGIS
  19. Create Spatial Tables and Add Geometry Columns in PostGIS with QGIS
  20. How to Create Spatial and Attribute Indexes in PostGIS with QGIS
  21. How to Add Geometry to a Feature Using the INSERT Statement in PostGIS with QGIS