create occurrence views

[andersfi]

Need to create occurrence views that aggregate occurrences across events and datasets in order to display species distribution maps etc. Examples: nofa.view_occurrence_all for all species, and nofa.view_occurrence_pike for one species. It would be extremely convenient to generate views for species by looping through the species in the occurrence table in order to avoid manually updating a number of views when wanting to change some info.

[ninsbl]

See: https://github.com/NINAnor/invafish/blob/master/QGIS_plugin/Create_NOFAVisualisation_views.sh

Might have to be adjusted a little bit, not sure...

However, keep in mind that once tables and columns are used in a view, the possibilities to modify them will be limited (e.g. you cannot drop a column that is used in a view, without dropping the view in advance (or DROP CASCADE)....

[JakobMiksch]

There are already some views created:

Can we close this?