---
title: "Discussion on \" Point-in-polygon: one PostGIS query for geofencing, zones, and spatial lookups\" | Hashnode"
description: "Discussion on \" Point-in-polygon: one PostGIS query for geofencing, zones, and spatial lookups\". One PostGIS query (ST_Intersects) handles point-in-polygon: geofencing, delivery zones, spatial lookups, even flood checks. With GeoJSON examples"
url: "https://hashnode.com/posts/point-in-polygon-one-postgis-query-for-geofencing-zones-and-spatial-lookups/6a37b7c1d4df69dc09424bd8"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Point-in-polygon: one PostGIS query for geofencing, zones, and spatial lookups](https://samueltoh.hashnode.dev/point-in-polygon-one-postgis-query-for-geofencing-zones-and-spatial-lookups?utm_source=hashnode&utm_medium=feed)

One PostGIS query (ST\_Intersects) handles point-in-polygon: geofencing, delivery zones, spatial lookups, even flood checks. With GeoJSON examples

Jun 21 · 3 min read · samueltoh.hashnode.dev  
Read the article

-   [#postgis](https://hashnode.com/tag/postgis)
-   [#postgressql](https://hashnode.com/tag/postgressql)
-   [#sql](https://hashnode.com/tag/sql)
-   [#tutorial](https://hashnode.com/tag/tutorial)
-   [#gis](https://hashnode.com/tag/gis)

## Written by

[samueltoh](https://hashnode.com/@propertyxray)

@propertyxray · Melbourne, Australia

  
[View profile](https://hashnode.com/@propertyxray)

Founder of Property X-Ray. I write about spatial data, PostGIS, and AI agents.

Solo founder of Property X-Ray (propertyxray.com.au), a data hub for Queensland property due diligence. I build with Node and use PostGIS heavily for it. Love writing about spatial data, open data, and turning messy public datasets into clear answers.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.