reproject metadata bounds to wgs84

[pvgenuchten]

in order to facilitate comparison of spatial extent of metadata records, would be good to reproject the geometries to a common coordinate system, in order to reproject, the CRS information should be parsed. Unfortunately many records use a non conventional method to describe CRS.

• extract crs
• match CRS to known list of CRS (epsg.io api?)
• if no crs is provided, assume 4326
• extract bounds
• reproject bounds
• if projection fails, skip geometry
• return projected geometry

Can be set up as a script to run as a CI-CD process, input is a database column, results are written to the same column

[pvgenuchten]

Also to consider is to keep as a warning on the metadata record that the bound information is not parseable