MGDI

• Contact swiss topo to have access.
• Get Simon AppGate docker image
• Launch appgate.sh
• Then connect with swisstopo documentation (1st password auth then 2 fact auth) everything should be in Paulo.Amado@swisstopo.ch mail.

MGDI server is l0t7511a.lt.admin.ch

You ssh ssh 127.0.0.2x -p 2022 -L8700:127.0.0.1:8700 Tomcat runs on 8700 port.

In order to switch from 21781 to 4326 you need to :

ALTER TABLE public.xlinks ALTER COLUMN the_geom TYPE geometry(MultiPolygon, 4326) USING ST_Transform(the_geom, 4326);
ALTER TABLE public.non_validated ALTER COLUMN the_geom TYPE geometry(MultiPolygon, 4326) USING ST_Transform(the_geom, 4326);

And edit web/src/main/webapp/WEB-INF/config-spring-geocat.xml change projection of following beans :

• gn:xlinks
• gn:non_validated

Finally, change Region Map API in geocat settings.

En cas d'erreur : ERROR: type modifier is not allowed for type "geometry"

ALTER TABLE xlinks DROP CONSTRAINT enforce_srid_the_geom;
UPDATE xlinks SET the_geom = ST_Transform(the_geom, 4326);
ALTER TABLE xlinks
  ADD CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 4326);

ALTER TABLE non_validated DROP CONSTRAINT enforce_srid_the_geom;
UPDATE non_validated SET the_geom = ST_Transform(the_geom, 4326);
ALTER TABLE non_validated
  ADD CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 4326);

Dans le cas d'une base de données en postgis 1.5, il faut modifier la table geometry_columns