Integrate it in PgMetadata

[mdouchin]

Thanks a lot for this work. Would you mind if we integrate it in the plugin ?

[jbdesbas]

Sur no problem 😃 . I will be glad if this work can help. Be aware that some parts of code are specific to our current needs and may not fit for generic use :

Add WFS/WMS endpoint :

pgmetadata-inspire/v_dataset_as_inspire.sql

Lines 150 to 190 in 7e1d4c5

	XMLELEMENT(NAME "gmd:distributionInfo",
	XMLELEMENT(NAME "gmd:MD_Distribution",
	XMLELEMENT(NAME "gmd:transferOptions",
	XMLELEMENT(NAME "gmd:MD_DigitalTransferOptions", --Liens de la fiches + liens du geoserveur g2f
	links.agg_lk,
	XMLELEMENT(NAME "gmd:onLine", --WMS Geo2france
	XMLELEMENT(NAME "gmd:CI_OnlineResource",
	XMLELEMENT(NAME "gmd:linkage",
	XMLELEMENT(NAME "gmd:URL",'https://www.geo2france.fr/geoserver/cen_hdf/ows')
	),
	XMLELEMENT(NAME "gmd:name",
	XMLELEMENT(NAME "gco:CharacterString", 'cen_hdf:'||d.table_name)
	),
	XMLELEMENT(NAME "gmd:protocol",
	XMLELEMENT(NAME "gco:CharacterString", 'OGC:WMS')
	),
	XMLELEMENT(NAME "gmd:description",
	XMLELEMENT(NAME "gco:CharacterString", d.abstract)
	)
	)
	),
	XMLELEMENT(NAME "gmd:onLine", --WFS Geo2france
	XMLELEMENT(NAME "gmd:CI_OnlineResource",
	XMLELEMENT(NAME "gmd:linkage",
	XMLELEMENT(NAME "gmd:URL",'https://www.geo2france.fr/geoserver/cen_hdf/ows')
	),
	XMLELEMENT(NAME "gmd:name",
	XMLELEMENT(NAME "gco:CharacterString", 'cen_hdf:'||d.table_name)
	),
	XMLELEMENT(NAME "gmd:protocol",
	XMLELEMENT(NAME "gco:CharacterString", 'OGC:WFS')
	),
	XMLELEMENT(NAME "gmd:description",
	XMLELEMENT(NAME "gco:CharacterString", d.abstract)
	)
	)
	)
	)
	)
	)
	)

Please also take not that a Not Planned (NOP) publication frequency will we translated as completed. All others values are mapped to onGoing.

pgmetadata-inspire/v_dataset_as_inspire.sql

Lines 82 to 87 in 7e1d4c5

	XMLELEMENT(NAME "gmd:status",
	XMLELEMENT(NAME "gmd:MD_ProgressCode", XMLATTRIBUTES (CASE
	WHEN d.publication_frequency = 'NOP' THEN 'completed'
	ELSE 'onGoing' END AS "codeListValue" ,
	'http://standards.iso.org/iso/19139/resources/gmxCodelists.xml#MD_ProgressCode' AS "codeList"))
	), --Parti-pris ?