Geospatial Issue - US county-equivalent plotting issue

Hi, I’m trying to plot a map at US county level and some of my data includes county-equivalent areas.

I’m encountering an issue when plotting for American Samoa and Northern Mariana Islands - the county-equivalent values are not recognised and thus skipped by the map. In addition, Rota Municipality in Northern Mariana Islands weirdly show up in Virgin Islands.

Any advice for resolving the issue? I’ve set up the geospatial hierarchy between country, state and county name. At state-level, the visualisation worked perfectly. The issue only occurred when switching to county level.

Thanks for the help!

Example of dataset and their associated issues:

1 Like

Hi @Tianhe - Is it possible to raise a request to AWS Customer support team so that they can check this geospatial data issue. To raise the request, please follow the link - Creating support cases and case management - AWS Support

Regards - Sanjeeb

2 Likes