openaq / openaq-api-v2

OpenAQ API
https://api.openaq.org
39 stars 9 forks source link

Some country names are duplicates #2

Open sruti opened 3 years ago

sruti commented 3 years ago
sruti commented 3 years ago

Looked into this further and what's happening is that the locations where the country names are CE, CS etc are coming from EPA Airnow for US Embassy locations (and they use a different two letter country code rather than the ISO format). CE = Sri Lanka for example, whereas the ISO code is LK.

I don't think there's anything we can or should do to fix this at the API level. If anything, we should filter out the Embassy locations on ingest because we get them directly from the Department of State in another adapter. Issue #675 in openaq-fetch has some discussion on this.

I'm going to leave this issue up for informational purposes but re-word the title and edit the labels so it's clearer

russbiggs commented 1 year ago

@majesticio The issue here is ISO-3166-2 vs FIPS-10 https://www.geodatasource.com/resources/tutorials/international-country-code-fips-versus-iso-3166/