Bulk Updating Coordinate Systems


Batch Import - Table of Contents

In previous videos, we grouped projects by coordinate systems and then imported the files in Submissions based on projects that share a common coordinate system.

However, in historical gINT projects, it was common to not consistently record the coordinate system.

If that is the case, you may need a different approach to try to assign the correct coordinate systems to projects.

This article provides an example of one approach using OpenGround Professional's Bulk Update Coordinate Systems Tool to update the coordinate systems based on other project metadata.

Example

First, we will create a "dummy" Unknown coordinate system. In this case, we have used the PROJ.4 string of a coordinate system that we know was commonly used by projects in our gINT archive:

 

We then imported a batch of gINT Projects using the Unknown coordinate system:

 

In this batch of gINT projects, we know that we typically used NAD83 State Plane coordinate systems. And we conveniently have alternative Project metadata that we can use to help determine what coordinate system was likely used for these projects, in particular the "Location of site":

 

We will then use the "Location of site" to filter the Project grid and then use Bulk Update Coordinate System to apply our "best guess" of the coordinate system used.

First, we'll filter to projects in Exton, Pennsylvania, select all the projects, and update to use the NAD83 Pennsylvania South coordinate system:

 

We'll then do similar filtering for projects in Ocean City, New Jersey and updating to the NAD83 New Jersey coordinate system:

 

The result is that we now have "best guess" coordinate systems assigned for these projects:

Disclaimer

This is a simplified example, and this approach will not guarantee every project uses the correct coordinate system (nor necessarily be practical for every organization's archive). Your organization will need to assess the suitability of this approach for your purposes and have sufficient quality control procedures in place.