Task #6107

Project WP #654: WP6 - Supporting Blue Economy: VREs Development [Months: 1-30]

Project Task #656: T6.2 Strategic Investment analysis and Scientific Planning/Alerting VRE [Months: 1-30]

Project Activity #1633: Blue Economy VRE#2 Software Implementation, Integration and Deployment (Stage 2)

Task #6101: Geospatial Analytics & Alerting Platform Implementation (Stage 2)

Layer database table in geoanalytics platform

Added by Dimitris Katris over 2 years ago. Updated about 2 years ago.

Status:ClosedStart date:Dec 02, 2016
Priority:NormalDue date:
Assignee:Nikolas Laskaris% Done:




Create a new database table called Layer that will contain essential metadata for the available layers.

Shapes belonging to a layer should reference the records of this table. A foreign key constraint should not be created because shapes may reside in different dbs when the system runs in clustered mode.

The postgis plugin creates also a table called layer in topology schema so we may have to consider using a different name.


#1 Updated by Dimitris Katris over 2 years ago

The layer should be linked with the vre that it belongs to

#2 Updated by Nikolas Laskaris over 2 years ago

  • % Done changed from 0 to 30
  • Status changed from New to In Progress

The following tables have been created:
* Layer
* LayerReplication
* LayerTenant
We are performing a heavy restructuring of the database, and there is some work still to be done (hibernate mapping redirections, layers names redirections not geoservers, etc).
I'll provide additional information since we have finalized the changes and get sure that it runs smoothly.

#3 Updated by Dimitris Katris about 2 years ago

  • % Done changed from 30 to 100
  • Status changed from In Progress to Closed

Also available in: Atom PDF