search

etalab / geohisto

[UNMAINTAINED] Historic information for French regions, counties, overseas collectivities and towns based on INSEE and Wikipedia data, exported as (re)usable CSV files.
Other
28 stars 1 forks source link

Sylvains-Lès-Moulins case: it’s its own successor #29

Closed Tristramg closed 7 years ago

Tristramg commented 7 years ago

Detailed Description

The city has itself as successor and the new city isn’t referenced.

Maybe it is caused by a double change (merge and name change) ?

Current result

grep "^COM27693@1972-10-01" towns.csv 
COM27693@1972-10-01,27693,1972-10-01 00:00:00,2015-12-31 23:59:59,Sylvains-les-Moulins,COM27693@1972-10-01,COM27178@1942-01-01;COM27688@1942-01-01;COM27693@1942-01-01;COM27693@1972-10-01,DEP27@1860-07-01,1207,311

A total of 7 towns have the same problem:

grep "^\(COM[0-9]\{5\}@[0-9-]\{10\}\),.*,\1," towns.csv

Correct result

COM27693@1972-10-01,27693,1972-10-01 00:00:00,2015-12-31 23:59:59,Sylvains-les-Moulins,COM27693@2016-01-01,COM27178@1942-01-01;COM27688@1942-01-01;COM27693@1942-01-01;COM27693@2016-01-01,DEP27@1860-07-01,1207,311
COM27693@2016-01-01,27693,2016-01-01 00:00:00,9999-12-31 23:59:59,Sylvains-Lès-Moulins,,COM27693@1972-10-01,DEP27@1860-07-01,1207,321

Link to INSEE page

https://www.insee.fr/fr/metadonnees/cog/commune/COM27693-sylvains-les-moulins

Other with the same problem:

Tristramg commented 7 years ago

Merci!