Not all features displaying after a join

[mguna999]

Hello,

I have a csv file containing 634 unique features (FIPS) that every time I attempt to join with a USA Counties layer, the resulting layer has only a random number of features joined (205, 535, 599, etc). I do a 'one to many' join from the target field = FIPS and the join field = FIPS. I can't make sense of why it is not a perfect match, and why the joined features are random. When I make this join on arcmap my joined layer has the correct 634 features displaying.

Please let me know if you have encountered this and how I can fix this issue.

Thank you!

MG

[jcarlson]

Is the USA Counties layer file-based, or a service?

[mguna999]

Hi Josh,

Thank you for responding, I am unfamiliar with the terms you are using. But I added the USA Counties (Generalized) layer by ESRI, through 'browse living atlas layers'.

[jcarlson]

File-based would be something on your local machine, like a shapefile or a geodatabase. If it's coming from elsewhere on the internet, it's a service.

It's possible that the service isn't loading every single feature, but just what's visible up to a limit? Looking at the layer, it doesn't seem like that would be the case, but it's hard to say.

Desktop clients like ArcMap can make successive requests to the service and cache the features so that all of them are available.

Is there any chance that you could share the CSV for someone else to try and replicate the problem? Or even just the list of FIPS codes, if the rest of the data is sensitive.

[mguna999]

Thank you for clarifying, that is very helpful.

It's hard to say if the USA counties is only loading up to a certain limit when the joins have been arbitrary in how many total features are displayed.

I have uploaded the csv being used here. The 'Total' column has been filled with fake data, the join in question was using the FIPS column as is.

Thank you,

[jcarlson · Accepted solution]

The Use current map extent box is often checked by default. Perhaps that is what's going on here?

When I run an attribute join in AGOL with your CSV and the Living Atlas' USA Counties layer, I get all 634 features in the output.

Also, with a unique input CSV and a unique FIPS field in the Counties layer, you can do a one-to-one join, there's no need for a one-to-many.

[mguna999]

Wow, thank you!

It really was as simple as unchecking the box. I was able to make the join with all 634 features displayed.

Thank you so much for your time!