110 likes | 271 Views
Network for a European Forest Information Service (NEFIS). WP 4: EFI data sets Solsona, 22.03.04 Andreas Schuck European Forest Institute. EFI Data sets. Long term forest resources data 1950-1990 (LTFRdb) (note: TBFRA 2000 is also available under LTFRAdb at EFI)
E N D
Network for a European Forest Information Service (NEFIS) WP 4: EFI data sets Solsona, 22.03.04 Andreas Schuck European Forest Institute European Forest Institute
EFI Data sets • Long term forest resources data 1950-1990 (LTFRdb) • (note: TBFRA 2000 is also available under LTFRAdb at EFI) • EU socio economic data • Forest products and trade flow data 1962-2001(2002) • Forest Research Capacities in Europe (18 countries) • optional: Database on Forest Disturbances in Europe European Forest Institute
Data availibility • All data sets are available through the WWW • data is in SQL database • Interface programmed in PHP • most data can be extracted in .CSV • extraced results from all db’s are query based Data format • statistical datasets • text based (metadatabase) European Forest Institute
Data structure Data ID reporting country partner country year .... Product ID name .... • Relational database structures • Each db has its own individual structure based on the given data • Example forest products trade flow data Country group ID name .... Country group member Group ID Country ID Country ID name .... European Forest Institute
Interface – LTFRAdb (1) European Forest Institute
Interface Forest Products Trade Flow db European Forest Institute
Regional forest resource and socio-economic statistics in European Union countries (db) European Forest Institute
Forest research capcities in 18 European countries European Forest Institute
Polygon maps Problem with time series (change of country borders); What would be a technical solution (Sergey; Simo) European Forest Institute
Is the visualisation toolkit sufficient for your purposes? Generally speaking : yes Time series: EFIS VTK did not fully satisfy in particular with regards to time series; Recent version of CommonGIS has many advanced features in particular in working with time series European Forest Institute
Further features that should be included? • Metadata display as ‘pop-up’ window should be always available when working with datasets • Print options? • Polygon map building (in particular related to time series data) • Options for loading different data sets into the EFIS/CommonGis (e.g. socio economic data and forest resources or trade data from two individual data sources for use in one application) • Edit function for attribute names • System allows to calculate new values and display or use them for further processing; function for extracting all values to other programme (e.g. excel)? European Forest Institute