I have a large amount of data in Excel spreadsheets.

I have been converting that data into Attribute tables to use in ArcMap.

The data includes:

  • names of locations
  • geo-location
  • descriptions of each location

I need to find an easy way that users, with only basic knowledge of ArcMap, can query the information in the tables and plot only the locations that meet the query parameters on the map, excluding the remaining data.

What would be a good way of going about this, without having to write a script?

  • 1
    You're asking the impossible here -- Flexible, dynamic, customizable, easy to use, and without scripting? – Vince Nov 28 '18 at 2:39
  • 1
    If you data is stored in tables only, then you probably have to Add XY Data first, in order to view the geography described in your tables. – FSimardGIS Nov 28 '18 at 2:55

I think what you are describing is the use case for definition queries:

When you specify a dataset that you want to draw as a map layer, you often only want to draw some of the features in the dataset. In these situations, you can define a query expression to select a subset of features for the layer display. This is referred to as a definition query.

Not the answer you're looking for? Browse other questions tagged or ask your own question.