search

cristan / improved-un-locodes

UN/LOCODE dataset, but with more and actually reliable coordinates
4 stars 1 forks source link

Data inconsistency in csv file #6

Open msalsi opened 2 weeks ago

msalsi commented 2 weeks ago

Hi, I found the following rows in the csv file with inconsistent coordinates syntax. There is a floating point number instead of the unlocodes DDDMM 5-digit style.

['+', 'BT', 'CCS', 'Chuchungsa', 'Chuchungsa', '14', '', '--3--6--', '2307', '', '26.9826N 88.9391E', '', 'N/A', 'N/A'] ['+', 'BT', 'LMZ', 'Lhamoizingkha', 'Lhamoizingkha', '22', '', '--3--6--', '2307', '', '26.7096N 89.8477E', '', 'N/A', 'N/A'] ['+', 'BT', 'NYP', 'Nyonpaling', 'Nyonpaling', '14', '', '--3--6--', '2307', '', '26.8180N 89.2250E', '', 'N/A', 'N/A'] ['+', 'BT', 'PZT', 'Pelzomthang (Nganglam)', 'Pelzomthang (Nganglam)', '45', '', '--3--6--', '2307', '', '26.8044N 91.2647E', '', 'N/A', 'N/A'] ['+', 'BT', 'PDL', 'Pendenling', 'Pendenling', '14', '', '--3--6--', '2307', '', '26.8128N 89.1903E', '', 'N/A', 'N/A'] ['+', 'BT', 'PRL', 'Phuntsho Raptenling', 'Phuntsho Raptenling', '45', '', '--3--6--', '2307', '', '26.7982N 91.5377E', '', 'N/A', 'N/A'] ['+', 'BT', 'SMR', 'Samrang\xa0', 'Samrang\xa0', '45', '', '--3-----', '2307', '', '26.8779N 91.8276E', '', 'N/A', 'N/A'] ['+', 'BT', 'YPT', 'Yangphelthang', 'Yangphelthang', '14', '', '--3--6--', '2307', '', '26.9374N 89.0233E', '', 'N/A', 'N/A']

cristan commented 14 hours ago

Created the CoordinatesDecimal column. I'll think about what to do with the UN/LOCODE format: make all coordinates in the Coordinates column the UN/LOCODE degrees format, or add another column dedicated for this.

Note to self: SASAL is also problematic. It has 2444N 05045 as coordinates which should be 2444N 05045E.