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

Claunay case #4

Closed davidbgk closed 7 years ago

davidbgk commented 8 years ago

Before new-start:

➜  communes grep Claunay towns.csv 
<-,86079,La Claunay-en-Loudun,1942-01-01,1967-11-20,NULL
<-,86079,La Claunay-en-Loudun,1967-11-20,1972-04-01,NULL
➜  communes grep Roche-Rigault towns.csv 
--,86079,La Roche-Rigault,1972-04-01,2020-01-01,535

Now:

→ cat exports/towns/towns.csv | grep Claunay
860791942-01-011972-04-01,86079,Claunay-en-Loudun,1942-01-01,1972-04-01,860791972-04-011967-11-20,,NULL,110
860791967-11-201972-04-01,86079,Claunay-en-Loudun,1967-11-20,1972-04-01,860791972-04-019999-01-01,,NULL,110
→ cat exports/towns/towns.csv | grep Roche-Rigault
EMPTY
davidbgk commented 8 years ago

Current status:

→ cat exports/towns/towns.csv | grep Claunay
86079@1942-01-01,86079,Claunay-en-Loudun,1942-01-01 00:00:00,1972-03-31 23:59:59,86079@1972-04-01,,NULL,110
86079@1967-11-20,86079,Claunay-en-Loudun,1967-11-20 00:00:00,1972-03-31 23:59:59,86079@1972-04-01,,NULL,110
→ cat exports/towns/towns.csv | grep Roche-Rigault
86079@1972-04-01,86079,Roche-Rigault,1972-04-01 00:00:00,9999-12-31 23:59:59,,86033@1942-01-01;86079@1942-01-01;86079@1967-11-20,NULL,0

There is still an issue with the duplication of the Claunay town.

davidbgk commented 7 years ago

Fixed.