Project

General

Profile

Actions

Feature #1631

closed

Join database GIS tables

Added by Alexander Watzinger over 2 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Normal
Category:
Backend
Target version:
Start date:
2022-01-20
Estimated time:

Description

Currently we are storing geometry data in 3 tables (linestring, point, polygon). We decided to:
  • Join all 3 to one table
  • Remove the GIS schema and add the new GIS table to the model schema:
Update
In the new version we dropped the gis schema and instead added a model.gis table with same fields except that instead having one geom field we now have:
  • geom_point
  • geom_linestring
  • geom_polygon

Related issues 1 (1 open0 closed)

Precedes OpenAtlas - Feature #1573: 3d geometriesAcknowledged2022-01-21Actions
Actions

Also available in: Atom PDF