Category "postgis"

Spatial database architecture with Apache Parquet, PostgresSQL and PostGIS on on-premises bare-metal S3/MinIo cluster

Designing storage architecture for Petabyte-scale geospatial data; starting from scratch. Creating a MinIo cluster to store the objects in S3 buckets. To store

what is the meaning of && in PostgreSQL?

In PostGIS, what is the result of the && operation between two geometries? In my mind, && returns a boolean, but does return geometry this time.

Why ST_Intersection from Postgis returns multilinestring for self-intersecting linestrings?

I am trying on PostgreSQL with the extension Postgis to get the geometry of a gps_trace that intersects a box, then i want to get one linestring for each distin

Custom SRID in Django-Leaflet

I'm having trouble specifying a custom SRID with django-leaflet. The documentation on projections isn't very detailed, and mentions only briefly: By defaul

Draw sector by center point, radius, interior angle and azymuth in postgis

I'm building a javascript application using Bing Maps API, and I would like to make up sector geometries from center points and sector parameters. I have a tabl

How to install PostGIS on Oracle Linux 6.4 x64?

I am reading the following guide http://www.postgresonline.com/journal/archives/329-An-almost-idiots-guide-to-install-PostgreSQL-9.3,-PostGIS-2.1-and-pgRouting-

PostgreSQL out of memory: Linux OOM killer

I am having issues with a large query, that I expect to rely on wrong configs of my postgresql.config. My setup is PostgreSQL 9.6 on Ubuntu 17.10 with 32GB RAM

Backend docker image does not wait until db becomes available

I am trying to docker-compose up my containers, one for backend and another one for the database (postgis). If I docker-compose up db, I see db_1 | 2021-11-23