search

openego / data_processing

(geo)data processing, database setup, data validation
GNU Affero General Public License v3.0
7 stars 5 forks source link

Display MViews in OEP #122

Open Ludee opened 7 years ago

Ludee commented 7 years ago

At some points (e.g. borders schema) we create MViews of existing tables. In eGoDP this is used to select a version or change the SRID of the geom. These "tables" are NOT displayed online atm. And they don't have (maintained) metadata.

Here are my questions for discussion:

  1. Do we want MViews to be displayed online?
  2. Which rules apply when using MViews?
  3. Do they need to be under "revision"?
lukasol commented 7 years ago

I do not think we need them to be displayed online since most (if not all?) of the data is at some point published in tables. That is for example true for the powerplant tables, which are basically just "translated" from an MView to a table.

wolfbunke commented 7 years ago

Good point but I think if a Mview is that impotent to be on the platform it should be a database table or? But maybe @MGlauer has a good idea?

gplssm commented 7 years ago

There is currently no use case for me, thus I have no opinion.