--- title: "#postgis articles | Hashnode" description: "Explore 12 articles tagged #postgis on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/postgis" --- Tag # #postgis 12 posts · 6 followers [Ivan Chernoknizhnikov](https://hashnode.com/@treamz) · [2d ago](https://hashnode.com/posts/mapping-free-street-parking-from-open-data-with-postgis-and-mapkit/6af5f8025b27ac30aa1ef9cc) ### [Mapping free street parking from open data with PostGIS and MapKit](https://treamz.hashnode.dev/mapping-free-street-parking-from-open-data-with-postgis-and-mapkit?utm_source=hashnode&utm_medium=feed) Turning cities' paid-parking data into likely-free kerbs with PostGIS, why OSM parking tags fail outside Germany, and drawing them in SwiftUI Map. 11 min read · [treamz.hashnode.dev](https://treamz.hashnode.dev/mapping-free-street-parking-from-open-data-with-postgis-and-mapkit?utm_source=hashnode&utm_medium=feed) [Uanik](https://hashnode.com/@uanik) · [Aug 23](https://hashnode.com/posts/haversine-vs-postgis-a-small-experiment-with-1-million-locations/6a8b2107cc3aaecd3702e11f) ### [Haversine vs PostGIS: A Small Experiment with 1 Million Locations](https://uanik.hashnode.dev/haversine-vs-postgis-a-small-experiment-with-1-million-locations?utm_source=hashnode&utm_medium=feed) I compared Haversine and PostGIS for finding nearby providers across 1 million locations using PostgreSQL. 4 min read · [uanik.hashnode.dev](https://uanik.hashnode.dev/haversine-vs-postgis-a-small-experiment-with-1-million-locations?utm_source=hashnode&utm_medium=feed) [samueltoh](https://hashnode.com/@propertyxray) · [Jun 21](https://hashnode.com/posts/point-in-polygon-one-postgis-query-for-geofencing-zones-and-spatial-lookups/6a37b7c1d4df69dc09424bd8) ### [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 3 min read · [samueltoh.hashnode.dev](https://samueltoh.hashnode.dev/point-in-polygon-one-postgis-query-for-geofencing-zones-and-spatial-lookups?utm_source=hashnode&utm_medium=feed) [Ioan Istrate](https://hashnode.com/@tripvento) · [Feb 12](https://hashnode.com/posts/scaling-200-cities-by-deleting-90-percent-of-my-database/698dddb1e0320cfed7b87f4f) ### [Scaling to 200+ Cities by Deleting 90% of My Database](https://blog.tripvento.com/scaling-200-cities-by-deleting-90-percent-of-my-database?utm_source=hashnode&utm_medium=feed) Most startups scale by throwing more hardware at the problem. I scaled by rethinking what to store. 8 min read · [blog.tripvento.com](https://blog.tripvento.com/scaling-200-cities-by-deleting-90-percent-of-my-database?utm_source=hashnode&utm_medium=feed) [George Silva](https://hashnode.com/@george-silva) · [Apr 3, 2025](https://hashnode.com/posts/efficient-methods-for-generating-zonal-statistics-in-gis/67ee9272cf2280139e975b5a) ### [Efficient Methods for Generating Zonal Statistics in GIS](https://dev.metageo.xyz/efficient-methods-for-generating-zonal-statistics-in-gis?utm_source=hashnode&utm_medium=feed) Operating at Scale 6 min read · [dev.metageo.xyz](https://dev.metageo.xyz/efficient-methods-for-generating-zonal-statistics-in-gis?utm_source=hashnode&utm_medium=feed) [Advena](https://hashnode.com/@Advena) · [Mar 26, 2025](https://hashnode.com/posts/heavy-map-visualizations-fundamentals-for-web-developers/67e4470ae5d6531b44551cad) ### [Heavy Map Visualizations Fundamentals for Web Developers](https://advena.hashnode.dev/heavy-map-visualizations-fundamentals-for-web-developers?utm_source=hashnode&utm_medium=feed) A Web Developer’s Guide to Handling Large Maps – Learn how to efficiently integrate complex map data into your web app. 55 min read · [advena.hashnode.dev](https://advena.hashnode.dev/heavy-map-visualizations-fundamentals-for-web-developers?utm_source=hashnode&utm_medium=feed) [Hidayatullah](https://hashnode.com/@mrday) · [Feb 28, 2025](https://hashnode.com/posts/konversi-data-geojson-ke-postgresql-menggunakan-jupyter-notebook/67c1988f2ee00e46d71d7f24) ### [Konversi data GeoJSON ke PostgreSQL menggunakan Jupyter Notebook.](https://blog.dayat.web.id/konversi-data-geojson-ke-postgresql-menggunakan-jupyter-notebook?utm_source=hashnode&utm_medium=feed) pada kali ini kita mencoba mengexport data GeoJSON ke PostgreSQL menggunakan Jupyter Notebook. Pastikan kita sudah menginstall module yang dibutuhkan, yang berada di import pada kode. Berikut kode fullnya. import geopandas as gpd from sqlalchemy impo... 4 min read · [blog.dayat.web.id](https://blog.dayat.web.id/konversi-data-geojson-ke-postgresql-menggunakan-jupyter-notebook?utm_source=hashnode&utm_medium=feed) [Jakub Konieczny](https://hashnode.com/@jkonieczny) · [Jan 28, 2025](https://hashnode.com/posts/earth-is-flat-locally-and-globally-in-a-way/6798d900df32285db4754e7b) ### [Earth is flat. Locally. And globally (in a way)](https://jkonieczny.hashnode.dev/earth-is-flat-locally-and-globally-in-a-way?utm_source=hashnode&utm_medium=feed) About different approaches to storing coordinates 18 min read · [jkonieczny.hashnode.dev](https://jkonieczny.hashnode.dev/earth-is-flat-locally-and-globally-in-a-way?utm_source=hashnode&utm_medium=feed) [Alexander Arlund Nørgaard](https://hashnode.com/@alexnorgaard) · [Sep 11, 2024](https://hashnode.com/posts/building-an-events-application-choosing-the-right-tools/66e17820efbb1c21b841e9de) ### [Building an Events Application: Choosing the right tools](https://alexnorgaard.hashnode.dev/building-an-events-application-choosing-the-right-tools?utm_source=hashnode&utm_medium=feed) So much water has flowed under the bridge since my last blog post. Mind you that I have been working quite a lot on this project, I just didn't get around to write about it. So, let's pick up where we left off! In my last post I talked about some of ... 6 min read · [alexnorgaard.hashnode.dev](https://alexnorgaard.hashnode.dev/building-an-events-application-choosing-the-right-tools?utm_source=hashnode&utm_medium=feed) [vansh Kapoor](https://hashnode.com/@Vanshkapoor) · [May 31, 2024](https://hashnode.com/posts/unlocking-the-secret-how-to-find-nearby-restaurants-in-seconds/6659e52ebe0ec54394344eb2) ### [Unlocking the secret: How to Find Nearby Restaurants in Seconds!](https://vanshkapoor.hashnode.dev/unlocking-the-secret-how-to-find-nearby-restaurants-in-seconds?utm_source=hashnode&utm_medium=feed) SYSTEM DESIGN: Creating proximity server using PostgreSQL. 6 min read · [vanshkapoor.hashnode.dev](https://vanshkapoor.hashnode.dev/unlocking-the-secret-how-to-find-nearby-restaurants-in-seconds?utm_source=hashnode&utm_medium=feed)