—
GEO PASSAGE
—
This file presents all the changes in communal geography from 1968 to 2022.
A change in geography consists of the merger or division of one or more municipalities.
Dictionary of variables:
Former municipality: INSEE code of the former municipality
New municipality: INSEE code of the new municipality
Year: year of change of geography of the municipality
COM: INSEE code of municipalities in geography 2022
User Guide:
1. In cell D2, paste the following formula: “=IERREUR(RECHERCHEV(E2;A:B;2;FALSE);E2)”
2. Set the formula to cell D45000 (or maximum number of communes possible)
3. In cell E2, paste the column of common codes in previous geography
4. In cell F2, paste the column of data corresponding to this ancient geography
5. In cell I2, paste the following formula: “=SUM.SI($D:$D;$H2;F:F)”
6. Set the formula to the last common code of column H.
(if last common code in H35001, then stretch to I35001)
7. Column I represents data from previous geography in geography 2022.
Build on reliable and scalable technology
FAQ
Frequently Asked Questions
Some basic informations about API Store ®.
Operation and development of APIs are currently fully funded by company Apitalks and its usage is for free.
Yes, you can.
All important information such as time of last update, license and other information are in response of each API call.
In case of major update that would not be compatible with previous version of API, we keep for 30 days both versions so you will have enough time to transfer to new version. We will inform you about the changes in advance by e-mail.