Tuesday, 6 December 2016

Editing metadata in PostGIS database?


I have imported several Shapefiles into PostgreSQL+PostGIS database. However, it seems that the database doesn't support metadata. I can't find a way to visit or edit metadata for the datasets. I don't know how to add attributes for the dataset (like author, time of creation, time of last edit, creator's affiliations, telephone number, etc.).


Is it possible to add or edit these data into PostGIS database?


EDIT: This question should remain open (i.e. no answer should be accepted).
EDIT2: I strongly oppose the opinion that metadata should be handled by the database designer or maintainer. Metadata is not arbitrarily designed. It has standards, which won't change in a specified occasion. Either the GIS platform or the DBMS should help end users implement metadata handling mechanics, including database design following given national or industry standards, reading and writing metadata in a user-friendly interface, and extensibility to customize fields. Even though people are still allowed to design a metadata table all from scratch, they simply tend to use predefined metadata schemas (which will be compatible to national and industry standards, with less or no errors than designing a table from scratch).




Answer



I have found the following text in the official document:



Metadata are currently saved in the project file. It can also be saved as an .XML file alongside file based layers or in a local .sqlite database for remote layers (e.g. PostGIS).



So QGIS does behave as ArcGIS did and provides a good complement to PostGIS. I think this is the answer I'm searching for.


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...