Marco and the Geographic Transformation
Welcome back to another edition of Ask Marco! Okay, sorry. I meant #MarcoMonday. This isn’t the beginnings of a "Dear Abby" column…or is it?
We are continuing our path down the Data Diagnosis Q + A road this week by meandering into geographic transformation territory. We will cover spatial references in a future post, but for now…let’s figure out the best method for answering the following question:
How many maps are using non-standard geographic transformations?
Whether you are looking for a count or specifics of the Map Documents using geographic transformations, Integrated Marco Commander is the way to go. With the help of the marco document tool, you can pull a variety of details – bookmarks, spatial reference, etc. Shown below in the Integrated Marco Mystic interface, this tool does not require additional run options (such as the specification of file types) to successfully pull these details.
Once this tool is run against your Marco Database, the GEOGRAPHIC_TRANSFORMATION table within the database will be populated with all of the answers to your wildest questions. Let’s take a second to dissect these answers, shall we?
The GEOGRAPHIC_TRANSFORMATION table provides you with the ID values for CONTAINER, DATA_FRAME, and GEOG_TRANS. The most valuable pieces of information here is CONTAINER. This, of course, only holds value if you actually want to know which Map Documents to which this list refers. The ID values provided may be mapped back to those outlined in the CONTAINER table.
Other than that, the name of the geographic transformation is provided for obvious reasons. Where’s the fun in knowing your Map Documents are using transformations if you don’t know what they are? This allows you to assess what the most commonly used types are and which ones deviate from the norm.
Want just a number rather than the nitty gritty deets? This table reports only those files that match this criteria so you are guaranteed to have a count that is representative of your data inventory.
When it comes to analyzing your inventory, you can certainly “count” on Marco.
Does this solution include all the details you would wish to gather during this process? If not, what other pieces of information would you like to pull coupled with geographic transformations?
About This Series
In the coming weeks, we will explore ways in which to answer these common questions and get the most out of your spatial data. Want to jump ahead and tackle these for yourself? Follow the links below or view the cheatsheet here.
- Week 1 - What user is responsible for the most broken map documents and layer files? Hint, Gerta may be the culprit.
- Week 2 - What are the most commonly referenced datasets in broken map documents? Heat maps are friends, not foes.
- Week 3 - How do I find which datasets are associated with specific keywords? Take matchmaking to a new level.
- Week 4 - What maps have not been access for more than five weeks? Data age is just a number.
- Week 5 - How many maps are using non-standard geographic transformations? Maybe more than you think.
- Week 6 - What are the extents for the most used datasets? For all extents and purposes, it's a must-know.
- Week 7 - What data matches x and y terms? Get your search on.