Le portail francophone de la géomatique

install spatial;
load spatial;
COPY (
             WITH inscrits AS (
                 SELECT code_commune, sum(inscrits) as tot_inscrits
                 FROM 'https://data-pipeline-open.s3.sbg.io.cloud.ovh.net/elections/general_results.parquet' WHERE id_election = '2026_muni_t1' GROUP BY code_commune
             ), geo_ign_commune AS (
                 SELECT code_insee, nom_officiel, nom_officiel_en_majuscules, population, geometrie
                 FROM 'https://data.geopf.fr/telechargement/download/ADMIN-EXPRESS-COG/ADMIN-EXPRESS-COG_4-0__GEOPARQUET_WGS84G_FRA_2026-01-01/commune.parquet'
             )
             SELECT CAST(code_insee AS VARCHAR) AS code_insee, CAST(nom_officiel AS VARCHAR) AS nom_officiel, CAST(nom_officiel_en_majuscules AS VARCHAR) AS nom_officiel_en_majuscules, CAST(tot_inscrits AS INT64) AS tot_inscrits, CAST(population AS INT64) AS population, geometrie FROM geo_ign_commune
             LEFT JOIN inscrits
             ON code_commune = code_insee
         )
         TO 'stats_elections_inscrits_2026_t1.gpkg'
         WITH (FORMAT GDAL, DRIVER 'GPKG', SRS 'EPSG:4326');