All Questions
Tagged with database-design postgresql
3 questions with no upvoted or accepted answers
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 ...
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 ...