ASSEMBLY OF FRANCE METROPOLITAN OPEN STREET MAP: GEOPACKAGE AND SQL FORMAT

Here you will find an assembly of the open street map in metropolitan france.
The geopackage version also contains data from neighbouring countries (border regions except espagne).
The the.qgz project allows the geopackage data to be opened with the busy style and hacking depending on the zoom level.
video presenting this data gpkg and QGIS:
https://www.youtube.com/watch?v=R6O9cMqVVvM&t=6s
The version.sql is characterised by an additional attribute for each geometric entity: The INSEE code
This data will be updated on a monthly basis.

INSTRUCTIONS FOR DECLARING GPKG DATA:
Download all files and rename as follows:

OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214_001.zip — > OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214.zip.001
OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214_002.zip — > OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214.zip.002
OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214_003.zip — > OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214.zip.003
OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214_004.zip — > OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214.zip.004

or if you know the batch back to create a.bat file containing this (or you rename the renowned file. txt as rename.bat):

pushd “% ~ DP0”
REN OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214_001.zip OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214.zip.001
REN OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214_002.zip OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214.zip.002
REN OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214_003.zip OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214.zip.003
REN OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214_004.zip OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214.zip.004

and launch.bat by double clicking on it (the batch must be in the same place as the zip files)

Then right-click on the OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214_001.zip file and have it extracted to “OSM_QGZ_GPKG_ET_FRONTALIER_PRDG_FXX_ED214_001\” with your pressure relief software.
There is no need to click on 002, 003, 004. Opening file.001 opens all other parts of the archive

For version.sql, the procedure is the same:
rename
OSM_SQL_FXX_PRDG_D000_ED214_001.zip to OSM_SQL_FXX_PRDG_D000_ED214.zip.001
OSM_SQL_FXX_PRDG_D000_ED214_002.zip to OSM_SQL_FXX_PRDG_D000_ED214.zip.002
OSM_SQL_FXX_PRDG_D000_ED214_003.zip to OSM_SQL_FXX_PRDG_D000_ED214.zip.003
Then carry out pressure relief