MGDI

(cf. swisstopo documentation, everything should be in Paulo.Amado@swisstopo.ch mail).

• Contact swiss topo to have access.
• Get Simon and Cédric's AppGate docker image (https://github.com/geoadmin/docker-appgate)
• Launch appgate.sh
• Server: appg.admin.ch
  • first connection with:
    • method: password
    • login: Firstlogin
    • pass: Firstloginpassword
  • second connection with:
    • method: Chain-Pwd-2Fact
    • login: bgdi_ctoc_...
    • pass: ...
• Double-click on the bgdi icon
• Connection/Preferences, check "show access details tab"

old (2016?) MGDI server is l0t7511a.lt.admin.ch

new (2018) MGDI server is L0T7512A.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 or create default_projection.properties in datadir with following content :

default_projection=EPSG:4326

Finally, change Region Map API in geocat settings to :

• http://129.206.228.72/cached/osm?LAYERS=osm_auto%3Aall&SERVICE=WMS&REQUEST=GetMap&VERSION=1.1.0&STYLES=default&SRS={srs}&BBOX={minx},{miny},{maxx},{maxy}&WIDTH={width}&HEIGHT={height}&FORMAT=image/png
• EPSG:4326
• 500
• 500

and activate "Enable XLink resolution" in 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