PostGIS spatial relationships ST_Intersects example ST_Within PostGIS PostGIS spatial queries difference between ST_Intersects and ST_Within PostGIS geometry functions ST_Contains vs ST_Within

6 May 20263 May 2026 Atilio Francois No Comments

Postgis

[EN]ST_Intersects vs ST_Within: Understanding Spatial Relationships in PostGIS

When working with PostGIS, understanding spatial relationships between geometries is essential for building efficient queries. Two of the most widely used functions—ST_Intersects and ST_Within—are often confused, yet they serve different purposes. In this guide, you’ll learn…

Atilio Francois on How to develop an application with pgrouting in Windows (1)25 August 2025
You're right — since 2019 Geofabrik no longer provides plain `.osm` files, only the compressed `.osm.pbf` format. The tool **osm2pgrouting**…
Simon on How to develop an application with pgrouting in Windows (1)25 August 2025
The osm downloads don't appear to be available, just osm.pfb And osm2pgrouting on Windows doesn't like pbf "not well formed…
Arno on Portable version of QGis 3.32.021 August 2025
I just want to thank you. It works.
Atilio Francois on Portable version of QGis 3.32.015 May 2025
What is the link between the qgis update and the portable version? A portable version cannot be updated; it must…
Hugo on Portable version of QGis 3.32.014 May 2025
For me, the error message complaining that qgis_app.dll is missing started appearing following the most recent QGIS update.

Blog GIS & Territories

Tag: PostGIS spatial relationships ST_Intersects example ST_Within PostGIS PostGIS spatial queries difference between ST_Intersects and ST_Within PostGIS geometry functions ST_Contains vs ST_Within

[EN]ST_Intersects vs ST_Within: Understanding Spatial Relationships in PostGIS