EFGS has experience of providing trainings for European statisticians in GIS and geodata. In 2012, 2013 and 2014 EFGS gave GIS courses within the framework of the European Statistical Training Programme (ESTP). ESTP is to provide European statisticians the opportunity to participate in international training courses, workshops and seminars at postgraduate level.

Courses under the ESTP have a truly international dimension to meet the challenges of comparable statistics at European and international level. Courses focus on harmonised European concepts and legislation, as well as the implementation practices at national level.

The programme is coordinated by Eurostat. Courses are delivered either at Eurostat premises in Luxembourg or in national training sites of EU and European Free Trade Association (EFTA) countries.

EFGS has provided the following courses:

ESTP 2014: GIS in Statistics and Preparations for INSPIRE Reporting Obligations, Oslo, Norway

GIS course

Programme, presentations and photos.

ESTP Course 7th to 9th of May 2014

Programme, Presentations and photos.

Title: GIS in Statistics and Preparations for INSPIRE Reporting Obligations

Preliminary programme as of 24th of April 2014

Wednesday 7th of May:

Introduction and production of data Morning session, theory

09.00-09.15 Welcome to Statistics Norway Torstein Arne Bye, Statistics Norway

09.15-10.00 Opening and rounds of introduction Anne S Trolie, Statistics Norway

10.00-10.30 GIS and the Statistical Production Chain The process in a NSI for contributing to the GEOSTAT 2011 grid Ola Nordbeck, Statistics Norway

10.30-11.00 How to produce population gridded data following the aggregation approach (based on register data) Ola Nordbeck, Statistics Norway

11.00-12.30 How to produce population gridded data following the hybrid approach (based on various data sources as register data, land use data etc.) Arslan Ahmedov, Statistics Bulgaria

12.30-13.15 Lunch

Afternoon session, practical work

13.15-13.30 Brief introduction to Hands-on exercise: Production of gridded population statistics Ola Nordbeck, Statistics Norway

14.00-15.30 Production of gridded population statistics

Find the manual here: http://www.efgs.info/geostat/1B/frontpage/appendix1-production-procedures-bottom-up

For toolbox example developed in the course (click here) Ola Nordbeck, Erik Engelien, Statistics Norway

15.30-16.30 Automatisation of the grid production Ola Nordbeck Ola Nordbeck, Statistics Norway

17.45 Cultural event

20.30 Dinner

Thursday 8th of May:

Preparations for Inspire Reporting Obligations

Morning session

09.00-11.00 Inspire for Statistical Offices Find INSPIRE Data Specification on Population Distribution* and on Statistical Units** Arvid Lillethun, Norwegian Mapping Authority

11.00-12.00 ArcGIS for Inspire Olav Kavli, GEODATA AS (ESRI-Distributor)

For more info: http://www.esri.com/software/arcgis/arcgis-for-inspire

12.00-12.45 Lunch

Afternoon session

12.45-15.00 Harmonisation in ArcGIS For exercise (click here) Olav Kavli, GEODATA AS (ESRI-Distributor)

15.00-17.00 Inspire metadata in ArcGIS Olav Kavli, GEODATA AS (ESRI-Distributor)

Friday 9th of May, Spatial analyses:

Morning session

09.00-09.30 Introduction to spatial analyses Erik Engelien, Statistics Norway

09.30-10.00 Introduction to Hands-on exercise Erik Engelien, Statistics Norway

10.00-12.00 Hands-on exercise (Accessibility studies) For developed toolbox (click here)

12.00-12.45 Lunch

Afternoon session

12.45-13.15 Presentation of results Participants

13.15-14.15 How to automatise the hands-on exercise Erik Engelien, Ola Nordbeck, Participants

14.15-14.30 Summing up and closing down Ola Nordbeck, Statistics Norway

14.30-15.00 Closing session – Evaluation of the course Anne S Trolie, Statistics Norway

* http://inspire.jrc.ec.europa.eu/documents/Data_Specifications/INSPIRE_DataSpecification_SU_v3.0.pdf

** http://inspire.jrc.ec.europa.eu/documents/Data_Specifications/INSPIRE_DataSpecification_PD_v3.0.pdf

ESTP 2013: Use of GIS - Representing statistics on thematic maps Basic Level, Kongsvinger, Norway

ESTP 2013 GIS course

Travel information and Pictures from the course

Geographic Information Systems: Use of GIS in NSIs

– Representing statistics on thematic maps Basic Level

Participants

*Modul: Introduction to GIS at NSIs*
A01	09:15 – 09:30	Opening. Mr Per Morten Holt
A02	09:30 – 10:00	Introduction and practical information. Mr Anne S Trolie
A03	10:00 – 11:00	Introduction to EFGS and GIS. Mr Vilni Verner Holst Bloch
	11:00 – 11:15	Break
A04	11:15 – 12:00	Communicating statistics on maps- thematic mapping and geovisualization Mrs Diana Makarenko-Piirsalu
	12:00 – 13:00	Lunch
A05	13:00 – 14:30	Basic steps in gvSIG. Hands on exercises. Mrs Diana Makarenko-Piirsalu
	14:30 – 14:45	Break
A06	14:45 – 16:15	Map elements and map design. Hands on Exercise. Mrs Diana Makarenko-Piirsalu
	16:15	Cultural event
	18:30 – 21:30	Statistics Norway gives a get together dinner at Skansgården
*Wednesday, March 6*		*Modul: First steps in building a map* *Modul: Experience sharing, geostatistical units and introduction to software*
B01	09:00 – 10:00	Principles of symbolisation and generalisation. Mrs Diana Makarenko-Piirsalu
	10:00 – 10:15	Break
B02	10:15 – 12:00	Choropleth mapping technique and data classification methods – Hands on exercises Mrs Diana Makarenko-Piirsalu
	12:00 – 13:00	Lunch
B03	13.00 – 14.30	Dot and proportional symbol mapping technique – Hands on Exercise Mrs Diana Makarenko-Piirsalu
	14:30 – 14:45	Break
B04	14.45 – 16.30	Presentation of results of hands on exercise and discussion . Mrs Diana Makarenko-Piirsalu

*Thursday, March 7*		*Modul: Thematic mapping techniques and summing up/evaluation/closing of course*
C01	09:00 – 10:00	Using proper technique for representing statistics on maps – case study Mrs Diana Makarenko-Piirsalu
	10:00 – 10:15	Break
C03	10:15 – 12:00	Discussion on thematic mapping techniques – Group work Mrs Diana Makarenko-Piirsalu
	12:00 – 13:00	Lunch
C04	13:00 – 14:30	Sharing geodata with others, discovering geodata – An introduction to INSPIRE Mr Ekkehard Petri
	14:30 – 14:45	Break
C05	14:45 – 15:30	Creating metadata on spatial data – hands – on exercise. Mr Ekkehard Petri
E03	15:30 – 15:40	Summing up. Mrs Diana Makarenko-Piirsalu
E04	15:40 – 16:00	Closing session – Evaluation of the course. Mrs Anne S Trolie

ESTP 2012: Use of GIS for making statistics in a production environment, Oslo, Norway

ESTP2012

Geographic Information Systems (GIS): Use of GIS for making statistics in a production environment


	Mon March 26	Modul: Introduction to GIS, Geostatistics, INSPIRE, Business model
	Time	Topic	Lecturer
	09:00 – 09:15	Registration	Ms Ingvild Møller
A01	09:15 – 09:30	Opening	Mr Olav Ljones
A02	09:30 – 10:00	Introduction and practical information.	Mr Vilni Verner Holst Bloch
A03	09:30 – 10:00	Introduction to EFGS	Mr Lars Henrik Backer
	11:00 – 11:15	Break
A04	11:15 – 12:00	General introduction to Geographic Information Systems (GIS) and its use in NSI	Ms Diana Makarenko-Piirsalu
	12:00 – 13:00	Lunch
A05	13:00 – 14:30	INSPIRE : Data, metadata and tools	Mr Ekkehard Petri
	14:30 – 14:45	Break
A06	14:45 – 16:15	Business models and geostatistics	Mr Erik Sommer
	16:15	Sightseeing at the Opera house
	18:30	Statistics Norway gives a get together dinner
	Tue March 27	Modul: Experience sharing, geostatistical units and introduction to software
B01	09:00 – 12:00	Bulgaria – Sharing experience	Ms Irina Dudova
B02		Croatia – Sharing experience	Mr Branko Crkvencic
B03		Denmark – Sharing experience	Ms Birgit Nielsen
B04		Luxembourg – Sharing experience	Mr Oliver Heiden
B05		Finland – Sharing experience	Ms Nicola Brun
B06		Germany – Sharing experience	Ms Melanie Bodenseh and Ms Halina Stepien
B07		Hungary – Sharing experience	Ms Karolina Barth
B08		Ireland – Sharing experience	Ms Fiona O’Callaghan
B09		Italy – Sharing experience	Ms Pina Grazia Ticca, Ms Marianna Mantuano and Mr Stefano Mugnoli
B10		Norway – Sharing experience	Ms Ida Skivenes and Mr Tekie Tesfagaber Ghebre
B11		Poland – Sharing experience	Mr Marek Pieniążek
B12		Romania – Sharing experience	Mr Vîrdol Daniel
B13		Slovakia – Sharing experience	Mr Ondrej Zahn
B14		Slovenia – Sharing experience	Ms Mojca Merc, Mr Matjaž Jeran and Ms Tina Zupanič
B15		Spain – Sharing experience	Mr Ignacio Duque Rodriguez
B16		Sweden – Sharing experience	Mr Florian Stamm
B17		Turkey – Sharing experience	Ms. Şeyma Özcan Yavuzoğlu
	12:00 – 13:00	Lunch
B18	13.00 – 14.00	Introduction to geo-statistical units	Mr Oliver Heiden
	14:00 – 14:15	Break
B19	14.15 – 14.45	Types of classifications (function/purpose) and their field of application. Classification tools	Mr Oliver Heiden
B20	14.45 – 16.30	Introduction to OS GIS desktop software gvSIG and GI services	Mr Vilni Verner Holst Bloch
	Wed March 28	Modul: Data capture, spatial analyses and methods of grid statistics harmonisation
C01	09:00 – 10:30	Hands-on practice “Basic functions of gvSIG”	Ms Diana Makarenko-Piirsalu
	10:30 – 10:45	Break
C02	10:45 – 11:15	Data capture in production of geostatistics	Ms Diana Makarenko-Piirsalu
C03	11:15 – 11:45	Data quality and coverage	Mr Vilni Verner Holst Bloch
	11:45 – 12:45	Lunch
C04	12:45 – 13:45	Hands-on exercise: Assessing the data quality and coverage (data)	Mr Vilni Verner Holst Bloch
C05	13:45 – 14:15	Methods of producing gridded statistics and methods used to harmonise statistics on grid	Mr Vilni Verner Holst Bloch
C06	14:15 – 15.00	Introduction to spatial analyses and tools	Ms Diana Makarenko-Piirsalu
	15.00 – 15.15	Break
C07	15:15 – 16:45	Hands-on exercise: Spatial analyses of gridded statistics, knowledge generation and use of multiple sources (data)	Ms Diana Makarenko-Piirsalu

	Thur March 29	Modul: Web GIS and data dissemination
D01	09:00 – 09:30	Georeferencing	Mr Vilni Verner Holst Bloch
D02	9:30 – 10:00	Hands-on exercise: Georeferencing	Mr Vilni Verner Holst Bloch
	10:00 – 10:15	Break
D03	10:15 – 12:00	Hands-on exercise: Spatial analyses of gridded statistics, knowledge generation and use of multiple sources	Ms Diana Makarenko-Piirsalu
	12:00 – 13:00	Lunch
D04	13:00 – 13:30	Introduction to the web GIS and Dissemination of results, maps and figures	Mr Ola Erik Nordbeck
D05	13:30 – 15:00	Hands-on exercise: Geostatistical units. Classification	Mr Oliver Heiden
	15:00	Spare time at the participants’ own disposal
	Fri March 30	Modul: Trends and research…
E01	09:00 – 10:00	Hands-on exercise: Dissemination	Mr Ola Erik Nordbeck
E02	10:00 – 10:30	Trends and research	Ms Diana Makarenko-Piirsalu
	10:30 – 10:45	Break
E03	10:45 – 11:30	Summing up – Tour de Table	Mr Vilni Verner Holst Bloch
E04	11:30 – 12:00	Closing session – Evaluation of the course.	Mr Vilni Verner Holst Bloch / Ingvild Møller
	12:00 – 13:00	Lunch

Training