– or –
Please login or register to participate.
.
 
+

klo Hi,

I'm referencing file "airbase_v8_products.pdf" available at
http://www.eea.europa.eu/[…]/airbase-the-european-air-quality-database-8

Quote:
"A 1-to-many relationship between statistics and measurement_configuration tables can be established by
using the fields station_european_code, component_code and measurement_european_group_code."

1. Looking at the tables it seems that 1-to-many relation should be between "measurement_configuration" and "statistics" instead other way around, which is easily noticed as those three fields are not unique in "statistics" table, and by common sense it looks like relation should be opposite from suggested.

2. If above is true, then we can't use "measurement_european_group_code" as key as it is not present in composite PRIMARY KEY in "measurement_configuration" table where we have only "measurement_european_code" which is different from "measurement_european_group_code".

Any suggestions?

Thanks

Rating
0
Last discussed by EEA
Jan 21, 2015 11:00 AM
+

ctisch Hi, I've downloaded EEA airbase interpolated pollution data from here: http://www.eea.europa.eu/[…]/interpolated-air-quality-data-2 This is the latest data and available from 2006 to 2011. However, if I click the link for older versions (e.g. 26 Aug 2008) 2005 data becomes available (http://www.eea.europa.eu/[…]/interpolated-air-quality-data-1). Is there a reason why the 2005 data is not available in the latest published version? Is 2005 data accurate? Many thanks, Catherine

Rating
0
Last discussed by ctisch
Dec 18, 2014 11:22 AM
+

BjoernBo Dear EEA staff,

I have downloaded "Pollutant release and transfer register" from here
http://www.eea.europa.eu/da[…]egister-e-prtr-regulation-9
The information section says that the databset contains data from 2007 to 2012 (availability varies from country to country). But I could not find any hint within the dataset which observation belongs to which year. Or does the dataset provide accumulated emissions for all available year? Is the "pollutant release and transfer register" available as timeseries? For my research it would great to see how emission changed from year to year.

Thank you very much for your help.

Kind regards
Björn Borchert

Rating
0
Last discussed by BjoernBo
Dec 15, 2014 04:05 PM
 
Loading