The Open SGID is a cloud hosted, publicly available PostGIS database containing SGID data. This database complements the web services and data downloads offered on our Open Data site.

To search the SGID, please visit the SGID Index. To learn more about the SGID and the data, please visit the AGRC data page.

Before you Connect…

How to Connect

There are a variety of clients and applications that can connect to a PostgreSQL database. Here are a few of the more common applications and how to connect with them.

The username and password to use to connect to the Open SGID can be found on the Open SGID GitHub repository.

ArcGIS Desktop

  1. Open ArcCatalog and Add Database Connection.

    ArcGIS Desktop Add Database

  2. Use the following connection properties:

    ArcGIS Desktop Connection Properties

ArcGIS Pro

  1. Open the Catalog pane, right-click Databases, and select Add Database.

    ArcGIS Pro Add Database

  2. Use the following connection properties:

    ArcGIS Pro Connection Properties

DBeaver

  1. In DBeaver, click the New Database Connection button and choose PostresSQL.

    DBeaver Add Database

  2. Use the following connection properties:

    DBeaver Connection Properties

QGIS

  1. In QGIS, navigate to the Browser pane and right-click PostGIS then click New Connection....

    QGIS Add Database

  2. Use the following connection properties:

    QGIS Connection Properties

Global Mapper

  1. In Global Mapper, click File, and select Open Spatial Database.....

    Global Mapper Add Database

  2. Use the following connection properties:

    Global Mapper Connection Properties