I cannot find the SGID table I am using in Open SGID

[steveoh]

The problem

I have a project or code that references SGID tables and I cannot find the same table in the Open SGID.

The reason

The Open SGID uses all lower case table names; It is a PostgreSQL convention. We also snake cased words instead of camel cased. For example, DominantVegetation became dominant_vegetation.

Refer to the table mapping document to find, replace, and update data references in projects and code.

The layer you are looking for might not be in the table mapping since AGRC trimmed down what layers reside in the SGID. We shelved layers and made others static. You can read about the process in the SGID Product Relaunch Update blog post and the Where is the SGID going section of an older blog post.

Since not all tables were migrated from the SGID to the Open SGID, you may need to use our shelved or static ArcGIS Online services or replace the outdated and unmaintained data with a higher quality source.

Example

1. I have a project referencing SGID10.BIOSCIENCE.DominantVegetation. Update the table reference to use opensgid.biosciense.dominant_vegetation. Be careful to inspect the attributes as they are also lower case and snake cased.
2. I have a project referencing SGID10.BIOSCIENCE.BeaverRestorationAssessment. This dataset was shelved. Use Utah Beaver Restoration Assessment from ArcGIS Online.
3. I have a project referencing SGID10.BIOSCIENCE.Habitat_Bison. This dataset was removed since it was not current. Search for a new source. Consider the DWR sourced data.