airport-codes
airport-codes copied to clipboard
Most recent datahub.io published version has encoding errors in CSV
The most recent CSV file available on https://datahub.io/core/airport-codes (from ~6 months ago) has unicode encoding errors.
One example, from a diff of an older version to the latest one:
-MMCC,small_airport,Ciudad Acuña New International Airport,1410,NA,MX,MX-COA,Ciudad Acuña,MMCC,ACN,EFN,"29.332899, -101.098998"
+MMCC,small_airport,Ciudad Acuña New International Airport,1410,NA,MX,MX-COA,Ciudad Acuña,MMCC,ACN,EFN,"-101.098998, 29.332899"
Looks like the source input was treated as Latin-1 rather than UTF-8?
I just ran the the process script on an M1 Mac and the row looks like this after the script completed:
MMCC,small_airport,Ciudad Acuña New International Airport,1410,NA,MX,MX-COA,Ciudad Acuña,MMCC,ACN,EFN,"29.333662, -101.100555"