Transcript database

ESPON DATABASE PROJECT
TIGER MEETING
Nicolas Lambert, Ronan Ysebaert
UMS 2414 RIATE
Why is ESPON Database Project here today?
YOU ARE IN ESPON, YOU HAVE TO FOLLOW SOME BASIC RULES…
•
•
•
•
Data
Metadata
Creation of maps
Guidelines in cartography
BUT YOU ARE NOT ALONE! ESPON DATABASE WILL HELP YOU…
• Existing information in ESPON
• Last developments of ESPON DB Project (new indicators)
• Advices for structuring your data and metadata
Beginning of the project
= Starting package
Starting
package
Delivered at the
beginning of
the project
MapKits
Maping
Guide
+
Guidance
paper
Basic
indicators
Starting package 1/3: DATA – NUTS
Registration
(Login &
Password)
FULL
ACCESS
http://database.espon.eu/database
A user
friendly
query
system
Xls file
Starting package 1/3: DATA – WORLD
ESPON Data available in the DVDROM produced in June 2010
ESPON 2013 DATABASE Project:
• Listing of countries of the World according
different classifications
• Some indicators (age pyramid, HDI index, CO2
emissions…)
ESPON 3.4.1 Database:
• Flows matrixes (trade, passengers…)
• Distance matrixes (table of belonging,
distances…)
• Country profile (Demography, GDP…)
Starting package 2/3: MAPKIT
3 formats:
ArcGis, Philcarto, Quantum Gis
For 5 types of study areas:
World
Can be
improved
on your
demand !!
Starting package 2/3: MAPKIT
3 formats:
ArcGis, Philcarto, Quantum Gis
For 5 types of study areas:
World, Euromed
Can be
improved
on your
demand !!
Starting package 2/3: MAPKIT
3 formats:
ArcGis, Philcarto, Quantum Gis
For 5 types of study areas:
World, Euromed, ESPON Area
Can be
improved
on your
demand !!
Starting package 2/3: MAPKIT
3 formats:
ArcGis, Philcarto, Quantum Gis
For 5 types of study areas:
World, Euromed, ESPON Area,
ESPON Area+ CC and Western Balkans
Can be
improved
on your
demand !!
Starting package 2/3: MAPKIT
3 formats:
ArcGis, Philcarto, Quantum Gis
For 5 types of study areas:
World, Euromed, ESPON Area,
ESPON Area+ CC and Western Balkans
Case studies (LAU2)
Can be
improved
on your
demand !!
Examples of layout
World city network, 2010
Discontinuities of GDP per capita, 2008
Examples of layout
Unemployment rate, 2010
Structural types of rural areas, 2006
Examples of layout
Population change, 2001-2006
Starting package 3/3: MAPPING GUIDE,
& GUIDANCE PAPER
MAPPING GUIDE:
CONTENTS 3 PARTS
Maps and ESPON 2013. This part
presents the content of the map-kit
tool (“European, local and global”).
All the elements that have to be
necessarily represented on each map
are described.
• Enhancing information. This part
explain how to symbolize ESPON
2013 data with the good rules of
graphic semiology.
• Maps are tool for communication.
This part insists on the fact that a
map has to deliver a clear message.
Starting package 3/3: MAPPING GUIDE,
& GUIDANCE PAPER
GUIDANCE PAPER
• Sent by ESPON CU at the beginning of the project
• Will be prabably improved in a near future with some
technical issues for managing data and metadata.
During the project
= dialog in a continuous way
Interaction with the
ESPON DB project
ESPON
DB
PROJECT
S
P
MA
TA
DA ETA
M
&
[email protected]
&
[email protected]
Possible
evolution
in a near future
(in the phase II of the project)
FAQ,
FORUM,
FILES,
….
WEB PLATFORM
ESPON
DB
PROJECT
End of the project
= Deliveries
Deliveries of
DATA, METADATA & MAPS
(1) the datafiles filled in the good way
Attribute data and eventually geometries
(2) the metadata file Inspire compliant
Currently: xls file
Soon: web form
(3) A list of your 10 best indicators
Will be enhanced in the database interface
(4) Your maps in a vector format
eps, ai, svg, …
Example of data file
Fields that have to
be filled:
Id
Geographical level
Version
Validity_start
Validity_end
Indicator1
Label1
Indicator2
Label2
…
Metadata specifications
The rules to keep in mind:
(1) the information defined at one level can
be refined at the lower level.
(2) The content of the metadata file and the
data file are strongly linked
Metadata specifications
(extends Inspire spec, iso19115)
Inheritance mechanism
DATASET LEVEL
General
information
INDICATOR LEVEL
VALUE LEVEL
More specialized
& more refined
The metadata
information has been
organized at three
different levels
establishing a
mechanism of
specialization and
refinement for the
information, specially
the quality information:
dataset, indicator
and value.
Example of metadata (dataset level)
= Dataset information
(name, date)
&
Decription of the point of contact
(name, email, role, ….)
Example of metadata (dataset level)
ESPON 2013 Database Delivery June.xls
Example of metadata (indicator level)
Code of the indicator
Name
Units
Abstract
Methodology
Classification
….
Example of metadata (indicator level)
Example of metadata (value level)
Label
Lineage
Reliability
constraints
Example of metadata (value level)
Thank you!
Questions?
[email protected]
&
[email protected]