Skip to content

Home

Jump to bottom
Mie Winstrup edited this page May 23, 2017 · 17 revisions

Purpose of the plugin:

A QGIS plugin to ease handling of metadatainformation for new and existing tables in Postgresdatabase.

How does it work?

Adding metadata to a new file:

The dialogbox to enter metadatainformation is automatically launched when a new file is added to a database with the import function in DB Manager or created as a new file with DB Manager.

Adding metadata to an existing file:

Metadata information to existing tables can be added with the Metadata-Db-linker-tool from either the Plugin-menu or with the Metadata-Db-linker-button. In the dialogue box, navigate to the file to which you want to add metadatainformation and enter the metadata-information.

Changing metadata of an existing file:

Metadata information to existing tables can be changed with the Metadata-Db-linker-tool from either the Plugin-menu or with the Metadata-Db-linker-button. In the dialogue box, navigate to the file to which you want to edit metadatainformation and enter the new metadata-information.

Installation of metadatafunctionality-plugin:

The plugin is available from QGIS official plugin-repository. Open the Plugin-repository in QGIS and search for 'Metadata-db-linker'. It is currently tagged as experimental, hence you need to have allowed experimental plugins in your QGIS repository-search.

It can also be installed from GitHub (however a bit more complicated):

  1. Save the plugin in the QGIS-plugin folder, on windows-machines often in C:\Users\USERNAME.qgis2\python\plugins

  2. Install the plugin in your QGIS respository

The metadata-plugin is now added to the Plugins-'faneblad' and a button is added. The metadata plugin consists of two dialogue boxes - the dialogue box to enter the metadata information and a dialogue box to specificy the database where the table in which metadata is stored and the required connection information to the database.

[Picture would be good here]

To get started - the first time:

  1. Create a table to store metadata in a postgresdatabase. The table needs to follow a specific structure - to create a table you can use the sql found under 'Database definition' in the Metadata-Db-linker Settings-dialoguebox.

  2. In the Metadata-Db-linker Settings-dialoguebox, specify the connection (host, port, username) to the database in which the metadata is stored. Test the connection to the table with 'Test Connection'.

Clone this wiki locally