The Open SGID is a cloud hosted, publicly available PostGIS database containing our currated SGID data. This database is one part of the SGID and 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 data categories available in the SGID, please visit the UGRC 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. Enter the connection information from the Open SGID repository:

    ArcGIS Desktop Connection Properties

ArcGIS Pro

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

    ArcGIS Pro Add Database

  2. Enter the connection information from the Open SGID repository:

    ArcGIS Pro Connection Properties

DBeaver

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

    DBeaver Add Database

  2. Enter the connection information from the Open SGID repository:

    DBeaver Connection Properties

QGIS

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

    QGIS Add Database

  2. Enter the connection information from the Open SGID repository:

    QGIS Connection Properties

Global Mapper

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

    Global Mapper Add Database

  2. Enter the connection information from the Open SGID repository:

    Global Mapper Connection Properties