Adding GIS Data from PostGIS databases to Arcmap 10.2

This post will demonstrate with a few simple steps how to add GIS data hosted with non-Esri databases to ArcMap 10.2.

We will be connecting to PostGIS databases(local host) and adding data from these sources as layers in ArcMap 10.2.

Launch ArcMap Desktop ( the demo is using 10.2 version)

1 – Click on the ArcCatalog icon button to open the ArcCatalog Tree

2- Scroll down to the folder marked –Database Connections. Click on the subfolder –

Add Database Connections.

*Ignore the  Connection to localhost.sde, we will be creating a fresh connection for this demo

 

p1

 

A ‘Database Connection’ dialog window will open. Fill in the credentials for the Database.

If you are using PostgreSQL 9.5 , your instance should be localhost. Once the credentials are filled,

click Add

p2

 

Once successfully connected to the database, click on the connection and the content of the

database will be displayed as attribute tables and their geography.

We select the oyo layer from our public schema in the claypoints PostGIS database.

p3

 

Next, we want to export the selected data to a shapefile that will used in ArcMap 10.2.

Right Click on the ‘claypoints.public.oyo’ – Select ‘Export’ (A) and (B) ‘To Shapefile(single)

p4

 

A Feature to Feature Class window opens. Fill in the details and Click OK.

p5

 

Once successfully created, the feature class – polygon1- is added to the Table of Contents.

p6

 

Thank you for following our blog.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s