Wikidata:Property proposal/code RIVOLI

RIVOLI code

Originally proposed at Wikidata:Property proposal/Authority control

   Done: FANTOIR code (P3182) (Talk and documentation)

Description	unique code to identify French thoroughfares and places
Represents	FANTOIR (Q3066631)
Data type	External identifier
Domain	all thoroughfare (Q83620), a lot of geographic location (Q2221906) too, all in France (Q142)
Allowed values	eleven characters mostly numbers (the original code has 150 characters, I suggest to take only the 11 first like it's commonly done, the following characters are bassically historical remains, mostly blank and redundant), the 2 first are the INSEE department code (P2586) (3 first for oversee departements, always numbers except for Corse-du-Sud (Q3336): 2A and Haute-Corse (Q3334): 2B), the 3rd number is a sub-departement code, the next 3 numbers are the last 3 of INSEE municipality code (P374), the next 4 is the code for the thoroughfare itself (that the interresting part), the last one is a check digit More explanations can be found in French here or here on OpenStreetMap wiki
Example	rue Duguesclin (Q23013581) → 3502382660T
Format and edit filter validation	[0-9][0-9AB][0-9]{4}[0-9A-Z][0-9]{3}[0-9A-Z]
Source	whole file can be found on http://www.data.gouv.fr/fr/datasets/fichier-fantoir-des-voies-et-lieux-dits/ (caution, very heavy), files by departement can be found at http://www.collectivites-locales.gouv.fr/mise-a-disposition-gratuite-fichier-des-voies-et-des-lieux-dits-fantoir
Robot and gadget jobs	maybe a good candidate for Mix'n'match, import for street of Paris should be pretty easy

Motivation

This code is created and quarterly published by the Direction générale des Finances publiques (Q3029562) of the Ministry of the Economy, Finance and the Recovery (Q1416512) (the database was called RIVOLI and renamed FANTOIR but the code itself is apparently still called RIVOLI). It could be useful to improve and make more reliable items about French thoroughfares and places. Can be use to align data with other sources like OpenStreetMap who also use this code. The first characters can be used to check consistecy with other properties.

@Magnus Manske: do you think Mix'n'match can be used for this code?

Cdlt, VIGNERON (talk) 11:38, 10 September 2016 (UTC)

Discussion

1.  Support Tubezlob (🙋) 11:49, 10 September 2016 (UTC)
2.  Support --Benoît Prieur (talk) 12:45, 16 September 2016 (UTC)
3.  Support --Pymouss (talk) 20:39, 16 September 2016 (UTC)
4.  Support Cquest (talk) 16:28, 17 September 2016 (UTC) - only 9 characters are useful and commonly used. This allows linking with other datasets refering to "short" RIVOLI codes (position 1-5 then 7-10, this means 350232660 in your example). This short version is the one used for example in the National Address Database. As another OSM for example keeps 350232660T.

   Cquest that's a good remark. Are you sure about 350232660 in the National Address Database ? (352382660 seems more logic to me). I see that indeed OpenStreetMap use yet another variant : 352382660T (1-2, 4-6 - the two section together make the INSEE municipality code (P374) of Rennes (Q647) - and then 7-11), this could be a good solution. The last character is a check digit and could be very useful for internal check (but it won't work if you omit a character, that's why I prefered to keep all the 11 characters). In the end, I guess this is doesn't really matter which variant is choosen as we can easily go from one variant to shorters one and I prefer to have more than less characters on Wikidata (it's quite easy to remove a character but it's nearly impossible to add a missing character). Cdlt, VIGNERON (talk) 17:18, 17 September 2016 (UTC)

5.  Support JLZIMMERMANN (talk) 15:30, 18 September 2016 (UTC)