How to load a Postgres / Postgis layer in ArcMap

To ensure that everything worked out fine, we will
load the new Postgres layer in ArcGIS.

Open ArcGis and the Catalog
window .  

Double-
click Add Database Connection.

At Database Platform select PostgreSQL.

Instance is the address of your
server
( in this example we use the local
server ).

In Authentication Type, select Database authentication.

Enter the Postgres username and password.

Check the Postgis Database, in this case, postgis_22_sample.

Click OK

A new connection appears in the Database connections
  

Under
this connection you find
all
the tables included in
the postgres database , with the name of the database (postgis_22_sample), the database
(eg public) and the name of the table.  

For each geographical layer, you have two
occurrences: one for the table and another for the geographic
layer.

Click and drag the second occurrence of the layer that we
just created (ouessantclc_l93) to the legend window.

The layer appears in
ArcMap ( if everything worked ok ).

Leave a Reply

Your email address will not be published. Required fields are marked *