Filter based on relationship class?

JasonCarter

Hello,

I have a feature class of point data and a CSV file containing analytical chemistry results to each point (Groundwater Wells). Both are stored in an ArcGIS Pro file geodatabase. There are multiple results, on different dates, associated with the same well (point) in the CSV file. I have created a relationship class between the feature and the CSV file that links the results to the Well. 

My question is - how can I filter the feature class points based on the analytical results? I'd like to filter by values greater than or less than a result, and then only show points that meet the criteria.

Also, is it possible to do this in ArcGIS online without hosting as a feature service? 

Thank you.

XanderBakker

Hi Jason Carter ,

Try this expression on the locations point featureclass:

CODE <SPAN class="operator token">IN</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">SELECT</SPAN> CODE <SPAN class="keyword token">FROM</SPAN> RelTbl <SPAN class="keyword token">WHERE</SPAN> FINDING <SPAN class="operator token">></SPAN> <SPAN class="number token">0.005</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

In this case CODE is the field that the relationshipclass between the points featureclass and the related table is based on. RelTbl is the name of my related table. FINDING is the field with the values.

These points (in green) will be filtered:

Which are these locations:

Validation:

Do a select by attributes on the related table with the following query:

FINDING <SPAN class="operator token">></SPAN> <SPAN class="number token">0.005</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

7 records get selected:

Select the related records:

Results in the same 3 locations: