<!DOCTYPE qgis PUBLIC ‘http://mrcc.com/qgis.dtd’ ‘SYSTEM’>

dbname=‘base aurca’

host=localhost

port=5432

key=‘uid’ estimatedmetadata=true checkPrimaryKeyUnicity=‘1’

table=“(SELECT row_number() over () AS uid,* FROM (WITH pop_pivot

AS ( SELECT c.code_insee, MAX(CASE WHEN p.an = ‘2010’ THEN p.p_pop END) AS pop_2010, MAX(CASE WHEN p.an = ‘2015’ THEN p.p_pop END)

AS pop_2015, MAX(CASE WHEN p.an = ‘2021’ THEN p.p_pop END)

AS pop_2021, c.geom FROM “BDTOPO”.communes c JOIN “INSEE”.pop_insee_rp_hist p ON p.codgeo = c.code_insee

WHERE c.code_insee IN (‘78208’, ‘78297’, ‘78356’, ‘78423’, ‘78621’, ‘78644’, ‘78688’)

AND p.an IN (‘2010’, ‘2015’, ‘2021’)

GROUP BY c.code_insee, c.geom )

SELECT code_insee, pop_2010, pop_2015, pop_2021, pop_2015 - pop_2010

AS var_2010_2015, pop_2021 - pop_2015 AS var_2015_2021,

ROUND( 100 * (POWER(pop_2015::numeric / NULLIF(pop_2010, 0), 1.0 / 5) - 1), 2 )

AS tc_am_2010_2015,

ROUND( 100 * (POWER(pop_2021::numeric / NULLIF(pop_2015, 0), 1.0 / 6) - 1), 2 ) AS tc_am_2015_2021, geom FROM pop_pivot )

AS subq_1 )”

(geom) pop_insee_rp_hist et communes_bdtopo

FRA

dataset

taux de croissance moyenne annuelle de la population 2010 - 2015

Cette couche contient des informations telles que le taux de croissance annuelle moyenne et la variation de population, retraçant l’évolution démographique des communes membres du PLUi de Saint-Quentin-en-Yvelines pour les années 2010, 2015 et 2021

(sources : INSEE 2010/2015/2021, BDtopo 2024)

évolution des population

postal

1 rue de pascal sagna 
  <city>Perpignan</city>
  <administrativearea></administrativearea>
  <postalcode>66100</postalcode>
  <country>France</country>
</contactAddress>
<name>Abdou Guene</name>
<organization>AURCA</organization>
<position>gestionnaire de données</position>
<voice>07 54 23 97 33</voice>
<fax></fax>
<email>abdou.guenelahad@aurca.org</email>
<role>custodian</role>

Historique de la données

type="Created"/>

value="2025-07-04T00:00:00"

type="Published"/>

value="2025-08-01T00:00:00"

type="Revised"/>

value="2025-08-06T00:00:00" type="Superseded"/> 0

libre Open Data Commons Public Domain Dedication and Licence PROJCRS[“RGF93 / Lambert-93”,

BASEGEOGCRS[“RGF93”,

DATUM[“Reseau Geodesique Francais 1993”,

ELLIPSOID[“GRS 1980”,6378137,298.257222101,

LENGTHUNIT[“metre”,1]]],PRIMEM[“Greenwich”,0,

ANGLEUNIT[“degree”,0.0174532925199433]],ID[“EPSG”,4171]],

CONVERSION[“Lambert-93”,

METHOD[“Lambert Conic Conformal (2SP)”,ID[“EPSG”,9802]],

PARAMETER[“Latitude of false origin”,46.5,

ANGLEUNIT[“degree”,0.0174532925199433],ID[“EPSG”,8821]],

PARAMETER[“Longitude of false origin”,3,

ANGLEUNIT[“degree”,0.0174532925199433],ID[“EPSG”,8822]],

PARAMETER[“Latitude of 1st standard parallel”,49,

ANGLEUNIT[“degree”,0.0174532925199433],ID[“EPSG”,8823]],

PARAMETER[“Latitude of 2nd standard parallel”,44,

ANGLEUNIT[“degree”,0.0174532925199433],ID[“EPSG”,8824]],

PARAMETER[“Easting at false origin”,700000,

LENGTHUNIT[“metre”,1],ID[“EPSG”,8826]],

PARAMETER[“Northing at false origin”,6600000,

LENGTHUNIT[“metre”,1],ID[“EPSG”,8827]]],CS[Cartesian,2],

AXIS[“easting (X)”,east,ORDER[1],

LENGTHUNIT[“metre”,1]],

AXIS[“northing (Y)”,north,ORDER[2],

LENGTHUNIT[“metre”,1]],

USAGE[SCOPE[“Engineering survey, topographic mapping.”],

AREA[“France - onshore and offshore, mainland and Corsica.”],

BBOX[41.15,-9.86,51.56,10.38]],

ID[“EPSG”,2154]] +proj=lcc +lat_0=46.5 +lon_0=3 +lat_1=49 +lat_2=44 +x_0=700000 +y_0=6600000 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs 145 2154 EPSG:2154 RGF93 / Lambert 93 lcc EPSG:7019 false