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

Chisa, Butry-sur-Oise, Toussus-le-Noble: unknown successor #27

Closed jdesboeufs closed 7 years ago

jdesboeufs commented 7 years ago

Chisa has a successor which is not in the dataset. Should be Corse splitting related.

cat data/towns.csv | grep COM2B366@1976-01-01

COM20366@1947-04-12,20366,1947-04-12 00:00:00,1975-12-31 23:59:59,Chisa,COM2B366@1976-01-01,,DEP20@1860-07-01,NULL,410

A side-effect is an erroneous id for the second occurrence of Chisa.

cat data/towns.csv | grep Chisa

COM20366@1942-01-01,20366,1976-01-01 00:00:00,9999-12-31 23:59:59,Chisa,,,DEP20@1860-07-01,NULL,200
COM20366@1947-04-12,20366,1947-04-12 00:00:00,1975-12-31 23:59:59,Chisa,COM2B366@1976-01-01,,DEP20@1860-07-01,NULL,410
jdesboeufs commented 7 years ago

Original output was: Record COM2B366@1976-01-01 not found

jdesboeufs commented 7 years ago

Other cases:

Record COM2B366@1976-01-01 not found ~ Chisa
Record COM95120@1968-01-01 not found ~ Butry-sur-Oise
Record COM78620@1969-11-29 not found ~ Toussus-le-Noble
rhanka commented 7 years ago

Ces cas ne sont bien que trois. L'impact est également que les successeurs des prédécesseurs de ces communes sont incomplets : Chisa / COM20366@1942-01-01 n'a pas COM2B366@1976-01-01 comme successeur alors que c'est bien la commune actuelle. De plus, COM20366@1942-01-01 est indiqué comme ayant une end_date de 9999-12-31 23:59:59 ce qui est faux (commune non valide).