Importing CSV file to XY Points and making check boxes for values in a column

10-07-2019 02:25 AM
New Contributor


I am importing a large CSV file with latitude and longitude for 15000 suppliers in ArcGis Pro. I have a column denoting what type of supplier it is, Milk, Honey and Tea.....yes there are well above 15000 suppliers of these categpries

When converting the table to plot on my map (XY Points) I want each category to be selectable in the content view so I quickly can look at only Milk suppliers for example. I prefer not to split the table into subsets for each category as I want to do calculations on the whole dataset as well.

Any tips?


1 Reply
Esri Notable Contributor

Set multiple definition queries on the same layer; one def query each for Milk, Honey, and Tea.

Filter features with definition queries—ArcGIS Pro | Documentation 

Then use the Definition Query dropdown to quickly switch between each query, or set back to <None> when you want to see/do calculations on the whole set.