Re: [Qgis-user] QGIS: Export Metadata from postgis tables to shp?
Hi, >From the PgMetadata plugin, you can export a single metadata sheet to PDF, HTML or DCAT. You can also export your full catalog (the last button in the dock, then you can "save as" your new layer). It's possible to improve the PgMetadata plugin by saving the layer metadata when the user is clicking "save as" on a layer which is stored in postgresql. PgMetadata is a "small" PG schema, so it's easy to extract information we need. How to retrieve data from PgMetadata in another application : https://docs.3liz.org/qgis-pgmetadata-plugin/user-guide/advanced/ The database schema : https://docs.3liz.org/qgis-pgmetadata-plugin/database/relationships.html Le mer. 1 déc. 2021 à 21:28, celati Laurent a écrit : > Thanks a lot for your really usefull reply. > I just make a try and it works well. > Now, i have to make a test/check with metadata produced with the plugin > pgmetadata. > > > Le mer. 1 déc. 2021 à 16:52, DelazJ a écrit : > >> Hi Laurent, >> >> Starting from 3.20, you may want to test >> https://qgis.org/en/site/forusers/visualchangelog320/index.html#feature-persist-layer-metadata-in-vector-file-exports >> if I understand your need. >> >> Regards, >> Harrissou >> >> Le mer. 1 déc. 2021 à 16:16, celati Laurent a >> écrit : >> >>> Good afternoon, >>> >>> With qgis, the description of a data seems to be available for filling >>> and consultation via the 'information' and 'metadata' tabs in "LAYER >>> PROPERTIES". There seem to be bridges between postgis and qgis. For >>> example, when I fill the "Comment" field of a table with pgadmin, the >>> content of the description is visible with qgis in the "Information" menu >>> in the Comment line and in the Abstract line. The description is also >>> visible in the "Metadata" menu in the Summary section / Identification tab. >>> >>> For some postgis tables, I have also described the data thanks to the >>> usefull Pgmetadata plugin. >>> >>> My need would be to be able to export these different data descriptions >>> during exports from these postgis tables toward files in shp format for >>> example. That these descriptions be kept during the export. Is it possible? >>> If yes, which tools / resources would exist? >>> >>> Thanks a lot. >>> ___ >>> Qgis-user mailing list >>> Qgis-user@lists.osgeo.org >>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >>> >> ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS: Export Metadata from postgis tables to shp?
Thanks a lot for your really usefull reply. I just make a try and it works well. Now, i have to make a test/check with metadata produced with the plugin pgmetadata. Le mer. 1 déc. 2021 à 16:52, DelazJ a écrit : > Hi Laurent, > > Starting from 3.20, you may want to test > https://qgis.org/en/site/forusers/visualchangelog320/index.html#feature-persist-layer-metadata-in-vector-file-exports > if I understand your need. > > Regards, > Harrissou > > Le mer. 1 déc. 2021 à 16:16, celati Laurent a > écrit : > >> Good afternoon, >> >> With qgis, the description of a data seems to be available for filling >> and consultation via the 'information' and 'metadata' tabs in "LAYER >> PROPERTIES". There seem to be bridges between postgis and qgis. For >> example, when I fill the "Comment" field of a table with pgadmin, the >> content of the description is visible with qgis in the "Information" menu >> in the Comment line and in the Abstract line. The description is also >> visible in the "Metadata" menu in the Summary section / Identification tab. >> >> For some postgis tables, I have also described the data thanks to the >> usefull Pgmetadata plugin. >> >> My need would be to be able to export these different data descriptions >> during exports from these postgis tables toward files in shp format for >> example. That these descriptions be kept during the export. Is it possible? >> If yes, which tools / resources would exist? >> >> Thanks a lot. >> ___ >> Qgis-user mailing list >> Qgis-user@lists.osgeo.org >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >> > ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS: Export Metadata from postgis tables to shp?
Hi Laurent, Starting from 3.20, you may want to test https://qgis.org/en/site/forusers/visualchangelog320/index.html#feature-persist-layer-metadata-in-vector-file-exports if I understand your need. Regards, Harrissou Le mer. 1 déc. 2021 à 16:16, celati Laurent a écrit : > Good afternoon, > > With qgis, the description of a data seems to be available for filling and > consultation via the 'information' and 'metadata' tabs in "LAYER > PROPERTIES". There seem to be bridges between postgis and qgis. For > example, when I fill the "Comment" field of a table with pgadmin, the > content of the description is visible with qgis in the "Information" menu > in the Comment line and in the Abstract line. The description is also > visible in the "Metadata" menu in the Summary section / Identification tab. > > For some postgis tables, I have also described the data thanks to the > usefull Pgmetadata plugin. > > My need would be to be able to export these different data descriptions > during exports from these postgis tables toward files in shp format for > example. That these descriptions be kept during the export. Is it possible? > If yes, which tools / resources would exist? > > Thanks a lot. > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] QGIS: Export Metadata from postgis tables to shp?
Good afternoon, With qgis, the description of a data seems to be available for filling and consultation via the 'information' and 'metadata' tabs in "LAYER PROPERTIES". There seem to be bridges between postgis and qgis. For example, when I fill the "Comment" field of a table with pgadmin, the content of the description is visible with qgis in the "Information" menu in the Comment line and in the Abstract line. The description is also visible in the "Metadata" menu in the Summary section / Identification tab. For some postgis tables, I have also described the data thanks to the usefull Pgmetadata plugin. My need would be to be able to export these different data descriptions during exports from these postgis tables toward files in shp format for example. That these descriptions be kept during the export. Is it possible? If yes, which tools / resources would exist? Thanks a lot. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user