• iii

Spatial Data Diagnosis: Finding the Next Big Hit on an Enterprise Network

Blog series on reviewing spatial data and identifying broken files and issues, including finding data that matches x and y key terms.

By nature, we like simplicity. We like being able to find an answer to a question almost as soon as we think it. (Thanks, Google!) We also like for everything to have its precise place…Okay, perhaps that is just some of us.

Spatial data does not always have a defined place. I know that sounds ludicrous considering the meaning of “spatial”, but the inclusion of metadata and tags can only take us so far when finding the perfect place for these files. What data is alike? What data references the same term or location? These are great starting places when it comes to finding this home. Unfortunately, making these connections can take time and considerable effort – especially if working with many files.

What data matches x and y key terms?

This question, of course, is easily answered within Integrated Marco Mystic where you can perform searches for these terms and keywords against your data inventory. What about for those instances where you want to challenge yourself and dig a little deeper? It is fairly simple when you approach your quest from a categorization perspective. The playing ground? Integrated Marco Commander.


Although this process can be run in Integrated Marco Mystic as well, the method to your madness is up to you. To answer the question posed with either application, the marco categorize tool is the key. This method utilizes a spreadsheet containing definition categories to wrangle those datasets whose metadata and details match each term.

View of Excel spreadsheet that categorizes spatial data into specific key terms.

If this spreadsheet looks intimidating, do not be alarmed. It doesn't bite. Pinky promise. Here, you define those classes and categories you wish to hunt for, matching them with any data types as well as any words/terms to include (or even exclude). You help find homes for the data on your call.


Get “cat”-d up? Sorry, horrible joke. Let me rephrase that – Did you get your categories? Results can be generated as either an Access database table or series of Excel files. Both are advantageous for their own reasons.