PostGIS is a popular spatial database that has been widely used by GIS users. Today, I am going to show you how to import a PostGIS table into ArcMap. Before we jump into it, you may want to take a look at how to install and configure PostGIS. I made some quick tutorials to install PostGIS on various systems below.
After you have installed and configured the PostGIS database, we are ready to proceed to the next steps.
Steps to Import PostGIS Table into ArcMap
In this tutorial, I am using ArcMap version 10.7.1 with Data Interoperability license.
Step 1. Open ArcMap
Step 2. Go to Arc Toolbox and expand the Data Interoperability Tools. Double-Click Quick Import from the Data Interoperability Tools. You may or may not have this tool. Please check your license to make sure you have the proper license.
From the Quick Import window, click the small button next to the Input Dataset.
Select PostGIS on the Format section. And then select or create your PostGIS connection. Please refers to the following link to build a PostGIS server on a Linux machine, in case you need it.
Install PostGIS on Ubuntu Linux
You will also need to specify the output/staging geodatabase. The following video will show you how to create a new PostGIS Connection in ArcMap 10.7.
Thank you for reading this article. If you found this to be useful, please consider sharing this post. Thank you.