a web platform for the visualisation and the dissemination ... · pdf filea web platform for...
TRANSCRIPT
A WEB PLATFORM FOR THE VISUALISATION AND THE DISSEMINATION OF
STATISTICAL DATA AND GEOSPATIAL ANALYSIS
Alessandro Capezzuoli
Emanuela Recchini
ESS Visualisation Workshop Valencia Spain May 17-18 2016
wwwstatvieweu
ESS Vision 2020 directions for National Statistical Offices
1
3
4
5
2
Concluding remarks
A tool for visualisation dissemination and geospatial analysis STATVIEW
Data visualisation webgis and statistical data
Data dissemination formats standards and methods
A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
1 ESS Vision 2020 directions for National Statistical Offices
The UN Fundamental Principles of Official Statistics and the European Statistics Code of Practice provide a crucial guidance in achieving the ESS Vision 2020 In fact an essential role in supporting analysis and decision making is played first of all by statistical information that is produced under strict conditions and quality criteria for both outputs and processes In this respect highest quality can be found in information derived from data that are produced under the statistical programme of a given country or an international organization (Official Statistics)
Introductory remarks
As highlighted in the ESS Vision 2020 Official statistics have always strived to adapt to major developments in society and the economy The ever increasing availability of data is a trend that is of strategic relevance for official statistics There is a need to assess and interpret the meaning of these data in an intelligent and interactive fashion
1 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
1 ESS Vision 2020 directions for National Statistical Offices
In order to deliver ESS Vision 2020 five key areas have been identified Their formulations are centered around a number of specific points Key area 3 - New data sources
We base our statistical products and services on both traditional surveys and newer sources including administrative data geospatial and where possible big data New data sources complement the existing ones and help us to improve the quality of our products
Key area 4 - Efficient and robust statistical processes
We will intensify our collaboration hellip also by sharing tools hellip
Key area 5 - Dissemination and communication on European statistics We recognise that different user groups have different needs and capabilities both in terms of products and dissemination channels and we will address this diversity by offering a variety of output channels and services
Solicited by ESS National Statistical Offices (NSOs) have started exploring new technology-driven areas when dealing with very large amount of data and are developing suitable tools for the integration of different types of information and its dissemination ie platforms for data storage analysis and visualisation
Keywords in the ESS Vision 2020
2 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
If you have an apple and I have an apple and we exchange these apples then you and I will still each have one
apple But if you have an idea and I have an idea and
we exchange these ideas then each of
us will have two ideas
(George Bernard Shaw)
If you have a single data and I have a single data and we exchange these data then all have two data
2 Data dissemination formats standards and methods
bull The role of National Statistical Offices
2 Data dissemination formats standards and methods Introductory remarks
bull Data dissemination and visualisation in the Internet Era
bull Data sharing at the basis of knowledge
bull Challenges measurement description and representation of statistical data
4 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
2 Data dissemination formats standards and methods Statistics data flow
1 - Acquisition
2 - Treatment
3 - Dissemination
5 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
eXtensible Markup Language
Javascript Object Notation
JSON CAN BE USED BY
Programming languages
Frameworks for graphical and cartographic representations
bull Javascript bull Ajax bull PHP bull JSP bull PYTHON
bull NodeJS bull Openlayers bull Leaflet bull RaphaelJS bull D3JS
6 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The XML format relies on the use of a Service Oriented Architecture - SOA
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
The JSON format relies on the use of a Resource Oriented Architecture - ROA
- is not a standard is just an architecture style for designing networked applications - is a lightweight alternative to mechanisms like RPC (Remote Procedure Calls) and Web Services (SOAP WSDL etc) - is a service concept that may be summarized by the CRUD principles
Representational State Transfer (REST)
7 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats REST vs NO REST 2 Data dissemination formats standards and methods
8 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
WITHOUT REST WITH REST
RESTful - Systems conforming to the REST constraints SOAP ndash Simple Objects Access Protocol
REST WEBSERVICES
Architectures for data visualisation 2 Data dissemination formats standards and methods
Can be used as Application Programming Interface (API)
9 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Italian National Institute of Statistics (Istat) uses several channels for data dissemination
The Istat experience Data dissemination in Official statistics
An example ISTAT ACCIDENTS DATA
The single exit point for exchanging and supplying data to Eurostat and other institutional subjects through the SDMX format
ISTAT a web channel allowing data downloading in several formats (csv excel etc)
A set of API REST to disseminate data in the JSON-STAT format
3 Data visualisation webGIS and statistical data
Istat like other NSOs uses the JSON-STAT format for its data dissemination
10 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA An example from Statistics Sweden
3 Data visualisation webGIS and statistical data
11 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Istat datawarehouse is conceived on the basis of the multi-dimensional array of data OLAP Cube (On-Line Analytical Processing)
JSON-STAT SDMX ODATA The Istat Datawarehouse
The OLAP Cube is characterized by bull Dimensions ndash ie the dimensional
spreadsheets containing the descriptive attributes of the measures (Province Region gender date of birth etc) The faces of the cube contain the dimensions while each cell contains the value related to the intersection of dimensions
bull Measures ndash describe the qualitative aspects of a given event
3 Data visualisation webGIS and statistical data
12 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
ESS Vision 2020 directions for National Statistical Offices
1
3
4
5
2
Concluding remarks
A tool for visualisation dissemination and geospatial analysis STATVIEW
Data visualisation webgis and statistical data
Data dissemination formats standards and methods
A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
1 ESS Vision 2020 directions for National Statistical Offices
The UN Fundamental Principles of Official Statistics and the European Statistics Code of Practice provide a crucial guidance in achieving the ESS Vision 2020 In fact an essential role in supporting analysis and decision making is played first of all by statistical information that is produced under strict conditions and quality criteria for both outputs and processes In this respect highest quality can be found in information derived from data that are produced under the statistical programme of a given country or an international organization (Official Statistics)
Introductory remarks
As highlighted in the ESS Vision 2020 Official statistics have always strived to adapt to major developments in society and the economy The ever increasing availability of data is a trend that is of strategic relevance for official statistics There is a need to assess and interpret the meaning of these data in an intelligent and interactive fashion
1 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
1 ESS Vision 2020 directions for National Statistical Offices
In order to deliver ESS Vision 2020 five key areas have been identified Their formulations are centered around a number of specific points Key area 3 - New data sources
We base our statistical products and services on both traditional surveys and newer sources including administrative data geospatial and where possible big data New data sources complement the existing ones and help us to improve the quality of our products
Key area 4 - Efficient and robust statistical processes
We will intensify our collaboration hellip also by sharing tools hellip
Key area 5 - Dissemination and communication on European statistics We recognise that different user groups have different needs and capabilities both in terms of products and dissemination channels and we will address this diversity by offering a variety of output channels and services
Solicited by ESS National Statistical Offices (NSOs) have started exploring new technology-driven areas when dealing with very large amount of data and are developing suitable tools for the integration of different types of information and its dissemination ie platforms for data storage analysis and visualisation
Keywords in the ESS Vision 2020
2 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
If you have an apple and I have an apple and we exchange these apples then you and I will still each have one
apple But if you have an idea and I have an idea and
we exchange these ideas then each of
us will have two ideas
(George Bernard Shaw)
If you have a single data and I have a single data and we exchange these data then all have two data
2 Data dissemination formats standards and methods
bull The role of National Statistical Offices
2 Data dissemination formats standards and methods Introductory remarks
bull Data dissemination and visualisation in the Internet Era
bull Data sharing at the basis of knowledge
bull Challenges measurement description and representation of statistical data
4 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
2 Data dissemination formats standards and methods Statistics data flow
1 - Acquisition
2 - Treatment
3 - Dissemination
5 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
eXtensible Markup Language
Javascript Object Notation
JSON CAN BE USED BY
Programming languages
Frameworks for graphical and cartographic representations
bull Javascript bull Ajax bull PHP bull JSP bull PYTHON
bull NodeJS bull Openlayers bull Leaflet bull RaphaelJS bull D3JS
6 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The XML format relies on the use of a Service Oriented Architecture - SOA
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
The JSON format relies on the use of a Resource Oriented Architecture - ROA
- is not a standard is just an architecture style for designing networked applications - is a lightweight alternative to mechanisms like RPC (Remote Procedure Calls) and Web Services (SOAP WSDL etc) - is a service concept that may be summarized by the CRUD principles
Representational State Transfer (REST)
7 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats REST vs NO REST 2 Data dissemination formats standards and methods
8 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
WITHOUT REST WITH REST
RESTful - Systems conforming to the REST constraints SOAP ndash Simple Objects Access Protocol
REST WEBSERVICES
Architectures for data visualisation 2 Data dissemination formats standards and methods
Can be used as Application Programming Interface (API)
9 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Italian National Institute of Statistics (Istat) uses several channels for data dissemination
The Istat experience Data dissemination in Official statistics
An example ISTAT ACCIDENTS DATA
The single exit point for exchanging and supplying data to Eurostat and other institutional subjects through the SDMX format
ISTAT a web channel allowing data downloading in several formats (csv excel etc)
A set of API REST to disseminate data in the JSON-STAT format
3 Data visualisation webGIS and statistical data
Istat like other NSOs uses the JSON-STAT format for its data dissemination
10 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA An example from Statistics Sweden
3 Data visualisation webGIS and statistical data
11 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Istat datawarehouse is conceived on the basis of the multi-dimensional array of data OLAP Cube (On-Line Analytical Processing)
JSON-STAT SDMX ODATA The Istat Datawarehouse
The OLAP Cube is characterized by bull Dimensions ndash ie the dimensional
spreadsheets containing the descriptive attributes of the measures (Province Region gender date of birth etc) The faces of the cube contain the dimensions while each cell contains the value related to the intersection of dimensions
bull Measures ndash describe the qualitative aspects of a given event
3 Data visualisation webGIS and statistical data
12 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
1 ESS Vision 2020 directions for National Statistical Offices
The UN Fundamental Principles of Official Statistics and the European Statistics Code of Practice provide a crucial guidance in achieving the ESS Vision 2020 In fact an essential role in supporting analysis and decision making is played first of all by statistical information that is produced under strict conditions and quality criteria for both outputs and processes In this respect highest quality can be found in information derived from data that are produced under the statistical programme of a given country or an international organization (Official Statistics)
Introductory remarks
As highlighted in the ESS Vision 2020 Official statistics have always strived to adapt to major developments in society and the economy The ever increasing availability of data is a trend that is of strategic relevance for official statistics There is a need to assess and interpret the meaning of these data in an intelligent and interactive fashion
1 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
1 ESS Vision 2020 directions for National Statistical Offices
In order to deliver ESS Vision 2020 five key areas have been identified Their formulations are centered around a number of specific points Key area 3 - New data sources
We base our statistical products and services on both traditional surveys and newer sources including administrative data geospatial and where possible big data New data sources complement the existing ones and help us to improve the quality of our products
Key area 4 - Efficient and robust statistical processes
We will intensify our collaboration hellip also by sharing tools hellip
Key area 5 - Dissemination and communication on European statistics We recognise that different user groups have different needs and capabilities both in terms of products and dissemination channels and we will address this diversity by offering a variety of output channels and services
Solicited by ESS National Statistical Offices (NSOs) have started exploring new technology-driven areas when dealing with very large amount of data and are developing suitable tools for the integration of different types of information and its dissemination ie platforms for data storage analysis and visualisation
Keywords in the ESS Vision 2020
2 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
If you have an apple and I have an apple and we exchange these apples then you and I will still each have one
apple But if you have an idea and I have an idea and
we exchange these ideas then each of
us will have two ideas
(George Bernard Shaw)
If you have a single data and I have a single data and we exchange these data then all have two data
2 Data dissemination formats standards and methods
bull The role of National Statistical Offices
2 Data dissemination formats standards and methods Introductory remarks
bull Data dissemination and visualisation in the Internet Era
bull Data sharing at the basis of knowledge
bull Challenges measurement description and representation of statistical data
4 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
2 Data dissemination formats standards and methods Statistics data flow
1 - Acquisition
2 - Treatment
3 - Dissemination
5 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
eXtensible Markup Language
Javascript Object Notation
JSON CAN BE USED BY
Programming languages
Frameworks for graphical and cartographic representations
bull Javascript bull Ajax bull PHP bull JSP bull PYTHON
bull NodeJS bull Openlayers bull Leaflet bull RaphaelJS bull D3JS
6 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The XML format relies on the use of a Service Oriented Architecture - SOA
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
The JSON format relies on the use of a Resource Oriented Architecture - ROA
- is not a standard is just an architecture style for designing networked applications - is a lightweight alternative to mechanisms like RPC (Remote Procedure Calls) and Web Services (SOAP WSDL etc) - is a service concept that may be summarized by the CRUD principles
Representational State Transfer (REST)
7 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats REST vs NO REST 2 Data dissemination formats standards and methods
8 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
WITHOUT REST WITH REST
RESTful - Systems conforming to the REST constraints SOAP ndash Simple Objects Access Protocol
REST WEBSERVICES
Architectures for data visualisation 2 Data dissemination formats standards and methods
Can be used as Application Programming Interface (API)
9 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Italian National Institute of Statistics (Istat) uses several channels for data dissemination
The Istat experience Data dissemination in Official statistics
An example ISTAT ACCIDENTS DATA
The single exit point for exchanging and supplying data to Eurostat and other institutional subjects through the SDMX format
ISTAT a web channel allowing data downloading in several formats (csv excel etc)
A set of API REST to disseminate data in the JSON-STAT format
3 Data visualisation webGIS and statistical data
Istat like other NSOs uses the JSON-STAT format for its data dissemination
10 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA An example from Statistics Sweden
3 Data visualisation webGIS and statistical data
11 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Istat datawarehouse is conceived on the basis of the multi-dimensional array of data OLAP Cube (On-Line Analytical Processing)
JSON-STAT SDMX ODATA The Istat Datawarehouse
The OLAP Cube is characterized by bull Dimensions ndash ie the dimensional
spreadsheets containing the descriptive attributes of the measures (Province Region gender date of birth etc) The faces of the cube contain the dimensions while each cell contains the value related to the intersection of dimensions
bull Measures ndash describe the qualitative aspects of a given event
3 Data visualisation webGIS and statistical data
12 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
1 ESS Vision 2020 directions for National Statistical Offices
In order to deliver ESS Vision 2020 five key areas have been identified Their formulations are centered around a number of specific points Key area 3 - New data sources
We base our statistical products and services on both traditional surveys and newer sources including administrative data geospatial and where possible big data New data sources complement the existing ones and help us to improve the quality of our products
Key area 4 - Efficient and robust statistical processes
We will intensify our collaboration hellip also by sharing tools hellip
Key area 5 - Dissemination and communication on European statistics We recognise that different user groups have different needs and capabilities both in terms of products and dissemination channels and we will address this diversity by offering a variety of output channels and services
Solicited by ESS National Statistical Offices (NSOs) have started exploring new technology-driven areas when dealing with very large amount of data and are developing suitable tools for the integration of different types of information and its dissemination ie platforms for data storage analysis and visualisation
Keywords in the ESS Vision 2020
2 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
If you have an apple and I have an apple and we exchange these apples then you and I will still each have one
apple But if you have an idea and I have an idea and
we exchange these ideas then each of
us will have two ideas
(George Bernard Shaw)
If you have a single data and I have a single data and we exchange these data then all have two data
2 Data dissemination formats standards and methods
bull The role of National Statistical Offices
2 Data dissemination formats standards and methods Introductory remarks
bull Data dissemination and visualisation in the Internet Era
bull Data sharing at the basis of knowledge
bull Challenges measurement description and representation of statistical data
4 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
2 Data dissemination formats standards and methods Statistics data flow
1 - Acquisition
2 - Treatment
3 - Dissemination
5 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
eXtensible Markup Language
Javascript Object Notation
JSON CAN BE USED BY
Programming languages
Frameworks for graphical and cartographic representations
bull Javascript bull Ajax bull PHP bull JSP bull PYTHON
bull NodeJS bull Openlayers bull Leaflet bull RaphaelJS bull D3JS
6 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The XML format relies on the use of a Service Oriented Architecture - SOA
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
The JSON format relies on the use of a Resource Oriented Architecture - ROA
- is not a standard is just an architecture style for designing networked applications - is a lightweight alternative to mechanisms like RPC (Remote Procedure Calls) and Web Services (SOAP WSDL etc) - is a service concept that may be summarized by the CRUD principles
Representational State Transfer (REST)
7 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats REST vs NO REST 2 Data dissemination formats standards and methods
8 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
WITHOUT REST WITH REST
RESTful - Systems conforming to the REST constraints SOAP ndash Simple Objects Access Protocol
REST WEBSERVICES
Architectures for data visualisation 2 Data dissemination formats standards and methods
Can be used as Application Programming Interface (API)
9 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Italian National Institute of Statistics (Istat) uses several channels for data dissemination
The Istat experience Data dissemination in Official statistics
An example ISTAT ACCIDENTS DATA
The single exit point for exchanging and supplying data to Eurostat and other institutional subjects through the SDMX format
ISTAT a web channel allowing data downloading in several formats (csv excel etc)
A set of API REST to disseminate data in the JSON-STAT format
3 Data visualisation webGIS and statistical data
Istat like other NSOs uses the JSON-STAT format for its data dissemination
10 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA An example from Statistics Sweden
3 Data visualisation webGIS and statistical data
11 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Istat datawarehouse is conceived on the basis of the multi-dimensional array of data OLAP Cube (On-Line Analytical Processing)
JSON-STAT SDMX ODATA The Istat Datawarehouse
The OLAP Cube is characterized by bull Dimensions ndash ie the dimensional
spreadsheets containing the descriptive attributes of the measures (Province Region gender date of birth etc) The faces of the cube contain the dimensions while each cell contains the value related to the intersection of dimensions
bull Measures ndash describe the qualitative aspects of a given event
3 Data visualisation webGIS and statistical data
12 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
If you have an apple and I have an apple and we exchange these apples then you and I will still each have one
apple But if you have an idea and I have an idea and
we exchange these ideas then each of
us will have two ideas
(George Bernard Shaw)
If you have a single data and I have a single data and we exchange these data then all have two data
2 Data dissemination formats standards and methods
bull The role of National Statistical Offices
2 Data dissemination formats standards and methods Introductory remarks
bull Data dissemination and visualisation in the Internet Era
bull Data sharing at the basis of knowledge
bull Challenges measurement description and representation of statistical data
4 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
2 Data dissemination formats standards and methods Statistics data flow
1 - Acquisition
2 - Treatment
3 - Dissemination
5 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
eXtensible Markup Language
Javascript Object Notation
JSON CAN BE USED BY
Programming languages
Frameworks for graphical and cartographic representations
bull Javascript bull Ajax bull PHP bull JSP bull PYTHON
bull NodeJS bull Openlayers bull Leaflet bull RaphaelJS bull D3JS
6 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The XML format relies on the use of a Service Oriented Architecture - SOA
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
The JSON format relies on the use of a Resource Oriented Architecture - ROA
- is not a standard is just an architecture style for designing networked applications - is a lightweight alternative to mechanisms like RPC (Remote Procedure Calls) and Web Services (SOAP WSDL etc) - is a service concept that may be summarized by the CRUD principles
Representational State Transfer (REST)
7 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats REST vs NO REST 2 Data dissemination formats standards and methods
8 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
WITHOUT REST WITH REST
RESTful - Systems conforming to the REST constraints SOAP ndash Simple Objects Access Protocol
REST WEBSERVICES
Architectures for data visualisation 2 Data dissemination formats standards and methods
Can be used as Application Programming Interface (API)
9 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Italian National Institute of Statistics (Istat) uses several channels for data dissemination
The Istat experience Data dissemination in Official statistics
An example ISTAT ACCIDENTS DATA
The single exit point for exchanging and supplying data to Eurostat and other institutional subjects through the SDMX format
ISTAT a web channel allowing data downloading in several formats (csv excel etc)
A set of API REST to disseminate data in the JSON-STAT format
3 Data visualisation webGIS and statistical data
Istat like other NSOs uses the JSON-STAT format for its data dissemination
10 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA An example from Statistics Sweden
3 Data visualisation webGIS and statistical data
11 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Istat datawarehouse is conceived on the basis of the multi-dimensional array of data OLAP Cube (On-Line Analytical Processing)
JSON-STAT SDMX ODATA The Istat Datawarehouse
The OLAP Cube is characterized by bull Dimensions ndash ie the dimensional
spreadsheets containing the descriptive attributes of the measures (Province Region gender date of birth etc) The faces of the cube contain the dimensions while each cell contains the value related to the intersection of dimensions
bull Measures ndash describe the qualitative aspects of a given event
3 Data visualisation webGIS and statistical data
12 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
bull The role of National Statistical Offices
2 Data dissemination formats standards and methods Introductory remarks
bull Data dissemination and visualisation in the Internet Era
bull Data sharing at the basis of knowledge
bull Challenges measurement description and representation of statistical data
4 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
2 Data dissemination formats standards and methods Statistics data flow
1 - Acquisition
2 - Treatment
3 - Dissemination
5 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
eXtensible Markup Language
Javascript Object Notation
JSON CAN BE USED BY
Programming languages
Frameworks for graphical and cartographic representations
bull Javascript bull Ajax bull PHP bull JSP bull PYTHON
bull NodeJS bull Openlayers bull Leaflet bull RaphaelJS bull D3JS
6 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The XML format relies on the use of a Service Oriented Architecture - SOA
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
The JSON format relies on the use of a Resource Oriented Architecture - ROA
- is not a standard is just an architecture style for designing networked applications - is a lightweight alternative to mechanisms like RPC (Remote Procedure Calls) and Web Services (SOAP WSDL etc) - is a service concept that may be summarized by the CRUD principles
Representational State Transfer (REST)
7 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats REST vs NO REST 2 Data dissemination formats standards and methods
8 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
WITHOUT REST WITH REST
RESTful - Systems conforming to the REST constraints SOAP ndash Simple Objects Access Protocol
REST WEBSERVICES
Architectures for data visualisation 2 Data dissemination formats standards and methods
Can be used as Application Programming Interface (API)
9 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Italian National Institute of Statistics (Istat) uses several channels for data dissemination
The Istat experience Data dissemination in Official statistics
An example ISTAT ACCIDENTS DATA
The single exit point for exchanging and supplying data to Eurostat and other institutional subjects through the SDMX format
ISTAT a web channel allowing data downloading in several formats (csv excel etc)
A set of API REST to disseminate data in the JSON-STAT format
3 Data visualisation webGIS and statistical data
Istat like other NSOs uses the JSON-STAT format for its data dissemination
10 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA An example from Statistics Sweden
3 Data visualisation webGIS and statistical data
11 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Istat datawarehouse is conceived on the basis of the multi-dimensional array of data OLAP Cube (On-Line Analytical Processing)
JSON-STAT SDMX ODATA The Istat Datawarehouse
The OLAP Cube is characterized by bull Dimensions ndash ie the dimensional
spreadsheets containing the descriptive attributes of the measures (Province Region gender date of birth etc) The faces of the cube contain the dimensions while each cell contains the value related to the intersection of dimensions
bull Measures ndash describe the qualitative aspects of a given event
3 Data visualisation webGIS and statistical data
12 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
2 Data dissemination formats standards and methods Statistics data flow
1 - Acquisition
2 - Treatment
3 - Dissemination
5 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
eXtensible Markup Language
Javascript Object Notation
JSON CAN BE USED BY
Programming languages
Frameworks for graphical and cartographic representations
bull Javascript bull Ajax bull PHP bull JSP bull PYTHON
bull NodeJS bull Openlayers bull Leaflet bull RaphaelJS bull D3JS
6 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The XML format relies on the use of a Service Oriented Architecture - SOA
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
The JSON format relies on the use of a Resource Oriented Architecture - ROA
- is not a standard is just an architecture style for designing networked applications - is a lightweight alternative to mechanisms like RPC (Remote Procedure Calls) and Web Services (SOAP WSDL etc) - is a service concept that may be summarized by the CRUD principles
Representational State Transfer (REST)
7 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats REST vs NO REST 2 Data dissemination formats standards and methods
8 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
WITHOUT REST WITH REST
RESTful - Systems conforming to the REST constraints SOAP ndash Simple Objects Access Protocol
REST WEBSERVICES
Architectures for data visualisation 2 Data dissemination formats standards and methods
Can be used as Application Programming Interface (API)
9 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Italian National Institute of Statistics (Istat) uses several channels for data dissemination
The Istat experience Data dissemination in Official statistics
An example ISTAT ACCIDENTS DATA
The single exit point for exchanging and supplying data to Eurostat and other institutional subjects through the SDMX format
ISTAT a web channel allowing data downloading in several formats (csv excel etc)
A set of API REST to disseminate data in the JSON-STAT format
3 Data visualisation webGIS and statistical data
Istat like other NSOs uses the JSON-STAT format for its data dissemination
10 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA An example from Statistics Sweden
3 Data visualisation webGIS and statistical data
11 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Istat datawarehouse is conceived on the basis of the multi-dimensional array of data OLAP Cube (On-Line Analytical Processing)
JSON-STAT SDMX ODATA The Istat Datawarehouse
The OLAP Cube is characterized by bull Dimensions ndash ie the dimensional
spreadsheets containing the descriptive attributes of the measures (Province Region gender date of birth etc) The faces of the cube contain the dimensions while each cell contains the value related to the intersection of dimensions
bull Measures ndash describe the qualitative aspects of a given event
3 Data visualisation webGIS and statistical data
12 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
eXtensible Markup Language
Javascript Object Notation
JSON CAN BE USED BY
Programming languages
Frameworks for graphical and cartographic representations
bull Javascript bull Ajax bull PHP bull JSP bull PYTHON
bull NodeJS bull Openlayers bull Leaflet bull RaphaelJS bull D3JS
6 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The XML format relies on the use of a Service Oriented Architecture - SOA
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
The JSON format relies on the use of a Resource Oriented Architecture - ROA
- is not a standard is just an architecture style for designing networked applications - is a lightweight alternative to mechanisms like RPC (Remote Procedure Calls) and Web Services (SOAP WSDL etc) - is a service concept that may be summarized by the CRUD principles
Representational State Transfer (REST)
7 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats REST vs NO REST 2 Data dissemination formats standards and methods
8 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
WITHOUT REST WITH REST
RESTful - Systems conforming to the REST constraints SOAP ndash Simple Objects Access Protocol
REST WEBSERVICES
Architectures for data visualisation 2 Data dissemination formats standards and methods
Can be used as Application Programming Interface (API)
9 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Italian National Institute of Statistics (Istat) uses several channels for data dissemination
The Istat experience Data dissemination in Official statistics
An example ISTAT ACCIDENTS DATA
The single exit point for exchanging and supplying data to Eurostat and other institutional subjects through the SDMX format
ISTAT a web channel allowing data downloading in several formats (csv excel etc)
A set of API REST to disseminate data in the JSON-STAT format
3 Data visualisation webGIS and statistical data
Istat like other NSOs uses the JSON-STAT format for its data dissemination
10 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA An example from Statistics Sweden
3 Data visualisation webGIS and statistical data
11 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Istat datawarehouse is conceived on the basis of the multi-dimensional array of data OLAP Cube (On-Line Analytical Processing)
JSON-STAT SDMX ODATA The Istat Datawarehouse
The OLAP Cube is characterized by bull Dimensions ndash ie the dimensional
spreadsheets containing the descriptive attributes of the measures (Province Region gender date of birth etc) The faces of the cube contain the dimensions while each cell contains the value related to the intersection of dimensions
bull Measures ndash describe the qualitative aspects of a given event
3 Data visualisation webGIS and statistical data
12 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
The XML format relies on the use of a Service Oriented Architecture - SOA
W3C open standard formats XML vs JSON 2 Data dissemination formats standards and methods
The JSON format relies on the use of a Resource Oriented Architecture - ROA
- is not a standard is just an architecture style for designing networked applications - is a lightweight alternative to mechanisms like RPC (Remote Procedure Calls) and Web Services (SOAP WSDL etc) - is a service concept that may be summarized by the CRUD principles
Representational State Transfer (REST)
7 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
W3C open standard formats REST vs NO REST 2 Data dissemination formats standards and methods
8 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
WITHOUT REST WITH REST
RESTful - Systems conforming to the REST constraints SOAP ndash Simple Objects Access Protocol
REST WEBSERVICES
Architectures for data visualisation 2 Data dissemination formats standards and methods
Can be used as Application Programming Interface (API)
9 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Italian National Institute of Statistics (Istat) uses several channels for data dissemination
The Istat experience Data dissemination in Official statistics
An example ISTAT ACCIDENTS DATA
The single exit point for exchanging and supplying data to Eurostat and other institutional subjects through the SDMX format
ISTAT a web channel allowing data downloading in several formats (csv excel etc)
A set of API REST to disseminate data in the JSON-STAT format
3 Data visualisation webGIS and statistical data
Istat like other NSOs uses the JSON-STAT format for its data dissemination
10 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA An example from Statistics Sweden
3 Data visualisation webGIS and statistical data
11 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Istat datawarehouse is conceived on the basis of the multi-dimensional array of data OLAP Cube (On-Line Analytical Processing)
JSON-STAT SDMX ODATA The Istat Datawarehouse
The OLAP Cube is characterized by bull Dimensions ndash ie the dimensional
spreadsheets containing the descriptive attributes of the measures (Province Region gender date of birth etc) The faces of the cube contain the dimensions while each cell contains the value related to the intersection of dimensions
bull Measures ndash describe the qualitative aspects of a given event
3 Data visualisation webGIS and statistical data
12 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
W3C open standard formats REST vs NO REST 2 Data dissemination formats standards and methods
8 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
WITHOUT REST WITH REST
RESTful - Systems conforming to the REST constraints SOAP ndash Simple Objects Access Protocol
REST WEBSERVICES
Architectures for data visualisation 2 Data dissemination formats standards and methods
Can be used as Application Programming Interface (API)
9 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Italian National Institute of Statistics (Istat) uses several channels for data dissemination
The Istat experience Data dissemination in Official statistics
An example ISTAT ACCIDENTS DATA
The single exit point for exchanging and supplying data to Eurostat and other institutional subjects through the SDMX format
ISTAT a web channel allowing data downloading in several formats (csv excel etc)
A set of API REST to disseminate data in the JSON-STAT format
3 Data visualisation webGIS and statistical data
Istat like other NSOs uses the JSON-STAT format for its data dissemination
10 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA An example from Statistics Sweden
3 Data visualisation webGIS and statistical data
11 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Istat datawarehouse is conceived on the basis of the multi-dimensional array of data OLAP Cube (On-Line Analytical Processing)
JSON-STAT SDMX ODATA The Istat Datawarehouse
The OLAP Cube is characterized by bull Dimensions ndash ie the dimensional
spreadsheets containing the descriptive attributes of the measures (Province Region gender date of birth etc) The faces of the cube contain the dimensions while each cell contains the value related to the intersection of dimensions
bull Measures ndash describe the qualitative aspects of a given event
3 Data visualisation webGIS and statistical data
12 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
RESTful - Systems conforming to the REST constraints SOAP ndash Simple Objects Access Protocol
REST WEBSERVICES
Architectures for data visualisation 2 Data dissemination formats standards and methods
Can be used as Application Programming Interface (API)
9 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Italian National Institute of Statistics (Istat) uses several channels for data dissemination
The Istat experience Data dissemination in Official statistics
An example ISTAT ACCIDENTS DATA
The single exit point for exchanging and supplying data to Eurostat and other institutional subjects through the SDMX format
ISTAT a web channel allowing data downloading in several formats (csv excel etc)
A set of API REST to disseminate data in the JSON-STAT format
3 Data visualisation webGIS and statistical data
Istat like other NSOs uses the JSON-STAT format for its data dissemination
10 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA An example from Statistics Sweden
3 Data visualisation webGIS and statistical data
11 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Istat datawarehouse is conceived on the basis of the multi-dimensional array of data OLAP Cube (On-Line Analytical Processing)
JSON-STAT SDMX ODATA The Istat Datawarehouse
The OLAP Cube is characterized by bull Dimensions ndash ie the dimensional
spreadsheets containing the descriptive attributes of the measures (Province Region gender date of birth etc) The faces of the cube contain the dimensions while each cell contains the value related to the intersection of dimensions
bull Measures ndash describe the qualitative aspects of a given event
3 Data visualisation webGIS and statistical data
12 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
The Italian National Institute of Statistics (Istat) uses several channels for data dissemination
The Istat experience Data dissemination in Official statistics
An example ISTAT ACCIDENTS DATA
The single exit point for exchanging and supplying data to Eurostat and other institutional subjects through the SDMX format
ISTAT a web channel allowing data downloading in several formats (csv excel etc)
A set of API REST to disseminate data in the JSON-STAT format
3 Data visualisation webGIS and statistical data
Istat like other NSOs uses the JSON-STAT format for its data dissemination
10 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA An example from Statistics Sweden
3 Data visualisation webGIS and statistical data
11 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Istat datawarehouse is conceived on the basis of the multi-dimensional array of data OLAP Cube (On-Line Analytical Processing)
JSON-STAT SDMX ODATA The Istat Datawarehouse
The OLAP Cube is characterized by bull Dimensions ndash ie the dimensional
spreadsheets containing the descriptive attributes of the measures (Province Region gender date of birth etc) The faces of the cube contain the dimensions while each cell contains the value related to the intersection of dimensions
bull Measures ndash describe the qualitative aspects of a given event
3 Data visualisation webGIS and statistical data
12 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
JSON-STAT SDMX ODATA An example from Statistics Sweden
3 Data visualisation webGIS and statistical data
11 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The Istat datawarehouse is conceived on the basis of the multi-dimensional array of data OLAP Cube (On-Line Analytical Processing)
JSON-STAT SDMX ODATA The Istat Datawarehouse
The OLAP Cube is characterized by bull Dimensions ndash ie the dimensional
spreadsheets containing the descriptive attributes of the measures (Province Region gender date of birth etc) The faces of the cube contain the dimensions while each cell contains the value related to the intersection of dimensions
bull Measures ndash describe the qualitative aspects of a given event
3 Data visualisation webGIS and statistical data
12 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
The Istat datawarehouse is conceived on the basis of the multi-dimensional array of data OLAP Cube (On-Line Analytical Processing)
JSON-STAT SDMX ODATA The Istat Datawarehouse
The OLAP Cube is characterized by bull Dimensions ndash ie the dimensional
spreadsheets containing the descriptive attributes of the measures (Province Region gender date of birth etc) The faces of the cube contain the dimensions while each cell contains the value related to the intersection of dimensions
bull Measures ndash describe the qualitative aspects of a given event
3 Data visualisation webGIS and statistical data
12 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
The JSON-stat format is a simple lightweight JSON format for data dissemination It is based on a cube model that arises from the evidence that the most common form of data dissemination is the tabular form
JSON-STAT SDMX ODATA The JSON-stat format
In this cube model datasets are organized in dimensions Dimensions are organized in categories
JSON-stat has been the starting point for the development of StatVIEW
3 Data visualisation webGIS and statistical data
13 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
JSON-STAT SDMX ODATA Open data utilisation
3 Data visualisation webGIS and statistical data
bull Considerable evolution of dissemination and visualisation of data from official statistics
bull Proliferation of tools for data
visualisation and cartographic analysis (Tableau Microstrategy Spago BI etc)
hellip nevertheless hellip
14 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
The potential of georeferenced spatial data
is still underutilized
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
JSON-STAT SDMX ODATA 3 Data visualisation webGIS and statistical data
The potential of georeferenced spatial data is still underutilized
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
JSON-STAT SDMX ODATA WebGIS and statistical data platform
Data dissemination and cartographic visualisation
Dynamic territorial analysis
Production of ad hoc applications for analysis and treatment of specific phenomena
Data integration using REST (or SOAP) webservices and a standard for data representation (eg JSON-STAT) differently usable by a relational database designed on the basis of an EntityndashRelationship model
Reaching a wider and more diversified audience in as much as they satisfy numerous needs of analysis
3 Data visualisation webGIS and statistical data
15 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
4 A tool for visualisation dissemination and geospatial analysis
StatVIEW is a web GIS and statistical data platform comprising
1) Map Server and a geospatial database (Geoserver Postgres PostGIS)
2) Different data sources (datawarehouse webservices database etc)
3) Interrogation engine and user interface WMS
WFS WCS
StatVIEW
bull Highly scalable system o Supports different data sources (database files webservices)
o Supports different models for open data sources (SDMX DDI JSON-STAT)
o Supports different formats for open data sources (XML JSON)
bull Source output in JSON-stat format
16 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
JSON-STAT SDMX ODATA 4 A tool for visualisation dissemination and geospatial analysis
StatVIEW (wwwstatvieweu) allows users to carry out operations normally included in GIS Desktop and WebGIS systems
Buffering
Network analysis
Topology Overlay
17 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
Architecture
4 A tool for visualisation dissemination and geospatial analysis
18 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
4 A tool for visualisation dissemination and geospatial analysis
DENSITY MAP A density map for vehicles involved in road accidents
Dimensions associated to the dataset
Representation type (cartographic graphic table)
Customize the research
19 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
DYNAMIC GRAPH
A dynamic graph for vehicles involved in road accidents
4 A tool for visualisation dissemination and geospatial analysis
20 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
4 A tool for visualisation dissemination and geospatial analysis
A table for vehicles involved in road accidents realized with JSON-STAT Table Browser
TABLE
21 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
OVERLAY Map - residence permits of non-EU citizens
A tool for visualisation dissemination and geospatial analysis
By selecting the layers and for example a different base map or a different color shade or a different partition (quartile quintile) it is possible to get a different visualisation leading to a different interpretation of the phenomenon The customization depends on the layers available in the chosen map
Another layer creates via a geospatial query a bubble chart representing the number of the georeferenced organizations active in the territory
One layer contains the georeferenced organizations providing assistance to migrants
22 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
A tool for visualisation dissemination and geospatial analysis
By using an OSRM (Open Source Routing Machine) routing algorithm it is possible to obtain the shortest route to a geo-localised point in the map server used by StatVIEW (eg hospital police station etc) from any point in the map as well as the respective travel time
Routing
23 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
4 A tool for visualisation dissemination and geospatial analysis
The dimension of the arrows gives an idea of volumes the thicker the arrow the greater the flow
Changes of residence for foreign citizens to and from Italian Provinces It is possible to represent inflows and outflows to and from a given territorial border
INTERNAL FLOW
It is possible to set the maximum distance or the distance range for the desired flows For example we may be interested in visualizing the flows within 100 km from a given Province or within a distance ranging 100-300 km
24 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN REGIONS
This example shows the evolution of employment data at the regional level
25 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
4 A tool for visualisation dissemination and geospatial analysis
ITALIAN MUNICIPALITIES
This example shows the Romanian citizens who are resident in the Italian Lazio Region at the municipal level
26 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
4 A tool for visualisation dissemination and geospatial analysis
In the example a pyramid graph showing the age of foreign citizens resident in Italy compared to that of resident Italian citizens
PYRAMID GRAPH The standardization of the sourcesrsquo output allows the creation of ad hoc plugins for the generalized visualisation of multi-source graphs or dashboards
27 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
4 A tool for visualisation dissemination and geospatial analysis AD HOC WEB APPLICATION
The case of management of immigration centres provides an example of how StatVIEW thanks to the support of geospatial database allows users to develop ad hoc applications The map indicates the position of immigration centres The colours indicate the number of available accommodations (red = no accommodation available orange = few accommodations available green = many accommodations available) By clicking on the marker of an immigration centre an interested user (like for example a Prefecture) can book a certain number of accommodations in order to equally distribute immigrants In a reserved area it is possible to insert a new immigration centre (eg Via Diego Cadello 9 Cagliari Italy Lat 39238140 Lng 9118743) that thanks to the geospatial database will be immediately visualized on the map
28 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
A tool for visualisation dissemination and geospatial analysis
HEATMAP
29 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Heatmap of private museums monuments and archeological areas in Italy
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
A tool for visualisation dissemination and geospatial analysis
CLUSTERING
30 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
Marker clusters of private museums monuments and archeological areas in Italy
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
With the support of StatVIEW it is easier for research work to analyze a specific phenomenon overlay different layers to describe several phenomena as a whole and quickly monitor the evolution of different phenomena at the same time
5 Concluding remarks
This helps to highlight the possible connections between phenomena or the impacts that the phenomena under investigation have on each other thus facilitating the analysis and the drafting of proper and early-warning advice for decision making
According to the ESS Vision 2020 developing an ESS that engages users proactively and meets their demands in a cost-efficient and responsive manner is one aim of the EU agenda A web platform such as StatVIEW is along these lines In providing high quality information StatVIEW is time saving and cost-effective It represents a useful open source tool that can be conveniently shared among NSOs for analyzing visualizing and sharing statistical and cartographic data in a machine-readable format
31 A web platform for the visualisation and the dissemination of statistical data and geospatial analysis Alessandro Capezzuoli Emanuela Recchini ndash ESS Visualisation Workshop Valencia Spain May 17-18 2016
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-
alessandrocapezzuoliistatit emanuelarecchiniistatit
THANK YOU FOR YOUR ATTENTION
FOR ANY QUESTIONS
CONTACT US
- Diapositiva numero 1
- Diapositiva numero 2
- Diapositiva numero 3
- Diapositiva numero 4
- Diapositiva numero 5
- Diapositiva numero 6
- Diapositiva numero 7
- Diapositiva numero 8
- Diapositiva numero 9
- Diapositiva numero 10
- Diapositiva numero 11
- Diapositiva numero 12
- Diapositiva numero 13
- Diapositiva numero 14
- Diapositiva numero 15
- Diapositiva numero 16
- Diapositiva numero 17
- Diapositiva numero 18
- Diapositiva numero 19
- Diapositiva numero 20
- Diapositiva numero 21
- Diapositiva numero 22
- Diapositiva numero 23
- Diapositiva numero 24
- Diapositiva numero 25
- Diapositiva numero 26
- Diapositiva numero 27
- Diapositiva numero 28
- Diapositiva numero 29
- Diapositiva numero 30
- Diapositiva numero 31
- Diapositiva numero 32
- Diapositiva numero 33
- Diapositiva numero 34
- Diapositiva numero 35
-