All Questions
Tagged with database-design postgresql
6 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,
...
- 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 ...
- 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 ...
- 2,770
1
vote
0
answers
46
views
GIS Workorder System [closed]
First off, these questions are relevant:
https://dba.stackexchange.com/questions/7900/pros-and-cons-of-having-one-table-per-entity-vs-having-a-shared-table-with-an-e/7907#7907
https://dba....
- 414
0
votes
1
answer
6k
views
Adding a column of WKT format in the table (postgreSQL)
I want to include this column of data that are in WKT format (they are mostly straight lines). What data type should I use?
I need to create this database for mapping. There are about 30000 features ...
- 77
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 ...
- 363