Efficient Methods for Generating Zonal Statistics in GIS
Apr 3, 2025 · 6 min read · Zonal Statistics is the name we give to metrics extracted from rasters (rasters in the GIS world are images/matrixes), given a particular area. These metrics can be extracted for the entire raster dataset or subset according to a particular polygon. ...
Join discussion
Heavy Map Visualizations Fundamentals for Web Developers
Mar 26, 2025 · 55 min read · So, you’ve reached a point where your web application needs to display a map—not just a simple one with a single marker, but one that overlays a large dataset. Maybe the data points move, update in real time, or need to be interactive. If you’ve work...
AAivon commentedKonversi data GeoJSON ke PostgreSQL menggunakan Jupyter Notebook.
Feb 28, 2025 · 4 min read · 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...
Join discussion
Earth is flat. Locally. And globally (in a way)
Jan 28, 2025 · 18 min read · No, it’s not about any conspiracy theory about Earth being flat, but just how it is made, that we see flat maps of our globe. The challenge is that if the Earth is not flat, paper and screens are. How should we accurately store coordinates?" Through ...
Join discussionBuilding an Events Application: Choosing the right tools
Sep 11, 2024 · 6 min read · 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 ...
Join discussionUnlocking the secret: How to Find Nearby Restaurants in Seconds!
May 31, 2024 · 6 min read · In our day to day we use features like find restaurants near me or show dates near 10km, but ever wondered how does it work? Well don't worry because this blog will help you design the most scalable system to find anything within any radius. Note: W...
Join discussion
PostGIS and Heroku Postgres… Location, Location, Location!
Apr 17, 2024 · 8 min read · I’ve lost too much time fiddling around with configurations and services just to spin up a compute instance in AWS. Sometimes, I just need a production-ready environment to play around with to test out applications and ideas. With Heroku, I can get t...
Join discussionIntegrating Spatialite with Sequelize
Feb 26, 2024 · 2 min read · Sequelize ORM is a robust tool for Node.js developers, offering a streamlined interface for interacting with databases using JavaScript. It supports all major SQL relational databases, including MySQL, PostgreSQL, SQLite, Oracle, and MSSQL. Sequelize...
Join discussion