Table of Contents
The ESPON Database Portal offers the possibility to search among hundreds of indicators produced by ESPON Projects.
The search query user interface allows policy makers or scientists to quickly find indicators adapted to support policy development in relation to the aim of territorial cohesion. The datasets included in the search interface cover the entire European ESPON Area (European Union + Switerland, Liechtenstein, Iceland and Norway; and sometimes Candidate Countries also) at various geographical levels (NUTS or city levels).
Since the query interface has been designed so to be the easiest and the most accessible as possible, whatever the profile of the user is (policy maker, scientist), the background process to respond to user's requests is very complex. Indeed, depending on his profile, the expectations regarding the results, and the way to proceed it may differ. This chapter describes the database search/query suer interface of the ESPON Database Portal. This search interface aims at performing simple and complex requests on the ESPON Database, via several dimensions and approaches.
Basically, the user can launch different kind of queries, based on different criterion:
Themes search: the semantics of the query concerns the themes associated with the indicators existing in the ESPON Database (Transport and Accessibility, Population and living conditions for instance).
Policy search: the semantics of the query concerns European Spatial Planning framework documents (Territorial Agenda, EU2020 for instance).
Projects search: the semantics of the query concerns the ESPON projects that originated most of the contents of the ESPON Database.
Keywords search: the semantics of the query concerns the keywords associated with the indicators of the ESPON Database and/or the names of the indicators.
In Figure 2.1, the Book icon at the first line of the component is a shortcut to the overview page. This "overview" is also accessible via the menu "Search - Overview". This "Overview" page (Figure 2.4) proposes of the contents of the entire ESPON Database. Also, the folder icon linking to the Basket page, shows the number of items currently present into the user's basket.
The principle of the search query is the following:
Choose the main semantic criteria, by theme, project, policy or keyword.
Launch the search (magnifying glass icon ).
Reduce the number of results with the different filters shown in Figure 2.2:
DATA criterion allow to query indicators by their statistical properties (typology, count data, etc.) or by the dataset type they belong: thematic table or time-series.
WHERE criterion allow to select specific study areas (EU28, ESPON Area, a given country). The completeness calculation depends on the study area chosen. It is also possible to choose a specific territorial level (NUTS, UMZ, FUE or MUA).
WHAT criterion allow to add a complementary semantic criteria (policy, project or theme, depending on the first chosen semantic criteria)
WHEN criterion allow to specify a period or year.
Relaunch the search (click the magnifying glass icon).
Consult metadata of results.
Add to basket the indicators you want to collect, or download them individually, or encompassed in their original dataset.
When at least one semantic criteria is chosen (one keyword/indicator, theme, project or policy report), the user is able to launch a search request on the ESPON Database by clicking the magnifying glass button.
The page resulting from a search request is represented in Figure 2.3.
The layout of this page contains the following components:
The Query filters area appears in the left column below the Query summary area It is composed of additional search criteria, produced dynamically depending on the semantic criteria chosen. It allows the user to affine the search results on three dimensions, explained below.
The Search results table appears in the right column below the Query summary area, taking about 3/4 of the frame width. It lists the indicators found in the ESPON Database according to the criteria and filters specified by the user.
The Search navigation bar appears immediately below the search results table. It lets the user to ajust the visual aspects of the search results table and to navigate inside the list of the indicators found.
The Search results table contains the list of indicators matching the semantic criteria and the filters specified by the user. It can be illustrated by Figure 2.3. The header of the table provides information about its columns:
The Indicator column gives the name of the indicator matching the criteria.
The Years column indicates the (perid of) time to which correspond the values of the indicator.
The Spatial column contains the information about the type of spatial/statistical nomenclature of the indicator values.
The Level column shows the level of the units of the statistical nomenclature, for which the result entry is produced. This column contains values only when the nomenlcature referenced in the previous column is hierarchical.
The Completeness column indicates the completeness of data for this search result.
The last column of the search results table contains shortcut icons allowing to save the result into the Basket, download it directly or open a tab with the metadata of the result entry.
Each row in the Search result table corresponds to an indicator existing into the ESPON Database, to a single time value of this indicator, for a sinlge version and level of nomenclature.