Skip to main content

All Questions

Filter by
Sorted by
Tagged with
1 vote
0 answers
148 views

Managing PostGIS many-to-many relationships between several tables with different geometry types from QGIS

I have this data set stored in a PostGIS (16+3.4) database: Each category of items being stored in its own table: CREATE TABLE public.rock ( id INT PRIMARY KEY GENERATED ALWAYS AS IDENTITY, ...
swiss_knight's user avatar
  • 10.9k
1 vote
0 answers
321 views

PostGIS: proper way to model object that follows sections of another object's path?

First, apologies if this has been asked before. I don't really know how/what to search for, and am struggling to just put this question into words. I'm trying to model aerial utilities in a PostGIS ...
Azendale's user avatar
  • 173
3 votes
0 answers
924 views

Postgis : Geometry vs 3 geom columns in single table

Requirement: There a specific requirements where I need a geometry column in table to be flexible ( It can line or point or polygon or all of it ) Justification for requirements : main concern is ...
Abhijit Gujar's user avatar
3 votes
2 answers
392 views

Traversing a PostGIS table tree

I'm developing a geospatial db for a company that operates at a number of large facilities. Its primary purpose is to help staff locate themselves and equipment within each facilities' multi-storey ...
Nick's user avatar
  • 363