PostgreSQL Evangelist. [My Git](https://github.com/digoal/blog/blob/master/README.md)Follow
In this article, the author discusses calculating distances in projected and spherical coordinate systems in respect of geometry and geographic data using PostGIS functions.
In this short post, the author explores how to import OpenStreetMap data into a PostgreSQL database.
In this article, the author discusses optimizing spatial index-based query performance for multipolygon data in PostgreSQL.
In this article, the author discusses how to process 3D spatial data in PostgreSQL using PostGIS and SFCGAL.
In this article, the author discusses overlapping points and planes and determining their actual positions from a visual perspective in PostGIS.
In this article, we'll discuss optimizing raster data in PostgreSQL databases using the ST_Value function and describe various optimization methods.
This article discusses spatiotemporal data and its wide usage in multiple domains, such as indoor positioning, pilotless driving, and scientific research.
In this article, the author explains various features in PostgreSQL that help implement 3D city applications.
In this article, the author discusses PostgreSQL-based real-time position tracking and trace analysis in respect of express delivery companies.
In this article, the author discusses electronic fence technology based on PostgreSQL and describes its applications in various common business scenarios.
In this article, the author discusses optimizing the PostgreSQL database to overcome ride-hailing conflicts in crowded areas during peak hours.
In this article, the author discusses geometry split in PostgreSQL and describes how to use it to optimize performance in GiST index-based polygon search with example code.
This article discusses optimizing spatial search performance in PostgreSQL using ST_Contains and ST_Within to address the I/O amplification problem and CPU usage.
In this article, we explore spatial search performance and describe when to use Geohash, geometry, and geography data types along with indexes such as GiST and B-tree.
This article discusses discovering target customers using BRIN from massive e-commerce advertising data using PostgreSQL and AnalyticDB.
This article discusses how to utilize PostgreSQL to import crucial data and geometry segments from Google Earth and convert KML files into ESRI format files.
In this article, the author discusses spatiotemporal object selection and data pivoting and extensively compares PostgreSQL 10 and Greenplum in this respect with example code.
In this article, the author discusses real-time user positioning and selection using PostgreSQL. The author also discusses various design methods and optimization for performance improvements.
This article discusses the database design of an order dispatch system for ride hailing apps by using DiDi as an example.
This article discusses managing healthcare for elderly people using big data and talks about optimization methods for real-time monitoring and alerts.