POPIMPACT -A2 Design and development of the data harmonisation and integration processes

[MayteTDGeograma]

1 Use Case Detailed Specification

4.2 POPIMPACT.- https://kuleuven.box.com/s/xu65hz93mkbsf12piirg4avcow0dmr3d

2 Datasets identified

Source Dataset(s)

Building layer
POCs	Layer	URL
POC001,POC002,POC003	A.ES.SDGC.BU.41900.building	http://ovc.catastro.meh.es/INSPIRE/wfsCP.aspx?
POC004	Bâtiments	https://geoservices.ign.fr/parcellaire-express-pci
POC005	A.ES.SDGC.BU.38045.building	http://ovc.catastro.meh.es/INSPIRE/wfsCP.aspx?

Population Layer
POCs	Layer	URL
POC001,POC004	JRC_POPULATION_2018	https://ec.europa.eu/eurostat/web/gisco/geodata/reference-data/population-distribution-demography/geostat
POC002	mep19_250	https://www.juntadeandalucia.es/institutodeestadisticaycartografia/datosespacialesestadisticos/index.htm
POC003	población-2019-secciones-censales-por-lustros-2	https://opendata.esri.es/datasets/ideSEVILLA::poblaci%C3%B3n-2019-secciones-censales-por-lustros-2/explore?location=37.392686%2C-5.992520%2C15.00
POC005	Poblacion	https://www.opendatalapalma.es/datasets/poblaci%C3%B3n/explore?location=28.578079%2C-17.922026%2C13.71

3 Data transformation processes

Step	Definition	Software
1	The data is loaded into postGIS	QGIS or Hale
2	The data are normalised according to the parameters collected in a parametric JSON.	postGIS
3	The population is assigned to the buildings, according to the selected method(s) and in a parametric JSON.	postGIS

JSON example :https://kuleuven.box.com/s/xxqb6i9pz16j7pl8ghrbp40cah10n9my

4 Checking the quality of datasets

• The results of the data are compared with real data of the affected area. For use case POC004.- La Palma, with data from the Canary Islands Institute of Statistics (ISTAC). 
• For the city of Seville, the results were compared with each other (POC001, POC002, POC003).

5 Optimize the semi automation process of the data harmonisation

It would be interesting if a json could be loaded in Hale Studio and the data normalised according to these parameters.

6 Data harmonisation process

• Inspire provides a very complete model for the POPIMPACT use case, however many of the attributes are not filled in because they are non-mandatory. For example number of dwellings.
• Even with the same inspire model, each country has data with different models and degree of standardisation.