All Questions
4 questions
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,
...
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 ...
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 ...
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 ...