[scripts] Multiple INSEE codes

[albertvillanova]

While adding population to cantons, 2 of them gave error:

ERROR: to_population_value does not contain INSSE code: 6261 : Q1617540 : canton d'Outreau
ERROR: to_population_value does not contain INSSE code: 6273 : Q1725198 : canton de Douvrin

due to the fact that these 2 cantons have multiple INSEE codes.

[albertvillanova]

These 2 cantons changed its INSEE code in 2015:

• Outreau: 6262 -> 6236
• Douvrin: 6273 -> 6223

Current implementation of the script to get the INSEE code:

• take the code with preferred rank
• take the last inserted code

TODO:

• Fix these 2
• Verify if there are other cantons with multiple INSEE codes
• Verify if there are other divisions (municipalities, districtes) with multiple INSEE codes

[albertvillanova]

There are 4 cantons with multiple INSEE codes:

• Outreau: 6262 -> 6236
• Douvrin: 6273 -> 6223
• Lillers: 6233 -> 6231 [THIS has used wrongly 6233: the last inserted is the previous one]!
• Bandraboua: 97602 -> 97601 [the last inserted is the current one]

# Cantons with INSEE code with end_time
SELECT ?item ?label_ca ?label_fr ?insee_end_time_date ?insee_code
WHERE {
  ?item p:P31 ?st .  # instance_of
  ?st ps:P31 wd:Q18524218 .  # canton_of_france_from_2015    # Q484170 .  # commune_of_france   

  OPTIONAL{?st pq:P580 ?start_time_date}
  FILTER(IF(BOUND(?start_time_date), ?start_time_date <= "2019-01-01"^^xsd:dateTime, true))

  OPTIONAL{?st pq:P582 ?end_time_date}
  FILTER(IF(BOUND(?end_time_date), ?end_time_date > "2019-01-01"^^xsd:dateTime, true))

  ?item p:P2506 ?st_insee .  # insee_canton_code
  ?st_insee ps:P2506 ?insee_code .

  ?st_insee pq:P582 ?insee_end_time_date

  OPTIONAL{ ?item rdfs:label ?label_ca filter (lang(?label_ca) = "ca"). }
  OPTIONAL{ ?item rdfs:label ?label_fr filter (lang(?label_fr) = "fr"). }
}
LIMIT 10

[albertvillanova]

There are cantons with multiple INSEE codes without end_time:

• Bouéni [Q2936679]:
  • 97604
  • 97602 [point_in_time: 2017-01-01]

[albertvillanova]

As first solution, I have updated current INSEE code rank to preferred.