130 likes | 241 Views
Linking AirBase with geo-info Future developments of air quality information system AirBase Wim Mol European Topic Centre on Air and Climate Change (ETC/ACC) under contract to the European Environment Agency Bilthoven, The Netherlands. Contents. Linking AirBase with geo-info
E N D
Linking AirBase with geo-info Future developments of air quality information system AirBase Wim Mol European Topic Centre on Air and Climate Change (ETC/ACC) under contract to the European Environment Agency Bilthoven, The Netherlands
Contents • Linking AirBase with geo-info • Matching AirBase info with Sabe info • Matching Sabe codes and national NUTS/LAU codes • Results and feedback • Future developments of air quality information system AirBase • Matching results and linking parameters in Airbase • Results of overlays in AirBase • Integrated control of EoI and AQ questionnaires • Google Earth • Suggestions? 11th Eionet Workshop on Air Quality Okt 26-27 2006
Linking AirBase with geo-info:Matching AirBase info with Sabe info • EuroBoundaryMap (Sabe) database • European administrative units (Sabe regions with Sabe code and name) • www.eurographics.org • AirBase station coordinates • Search process to determine which station in which Sabe region 11th Eionet Workshop on Air Quality Okt 26-27 2006
Linking AirBase with geo-info: Matching AirBase info with Sabe info Match-up process: • Coarse search step based on country code and bounding box coordinates • 1-3 candidate regions for each station • More detail: point-inside-polygon computation 11th Eionet Workshop on Air Quality Okt 26-27 2006
Linking AirBase with geo-info: Matching AirBase info with Sabe info • 0 matches: • BA, CS, MK not in Sabe project • Stations with missing/zero/wrong/reversed coordinates • Inaccurate station coordinates especially stations on country borders and on islands • More matches by matching Sabe names with AirBase station/city names 11th Eionet Workshop on Air Quality Okt 26-27 2006
Linking AirBase with geo-info: Matching Sabe codes and NUTS/LAU codes • http://ec.europa.eu/comm/eurostat/ramon/nuts/lau_en.html • Linking Sabe codes with national NUTS/LAU codes: • Sabe code as (partial) combination of NUTS/LAU codes • Some countries have also local administrative codes. Matching by combining names 11th Eionet Workshop on Air Quality Okt 26-27 2006
Linking AirBase with geo-info: Results and feedback • 5585 stations in AirBase • 5292 are matched by search process • 116 are matched by combining station/city names • In total: 5408 stations are matched (97%) • Feedback EoI2006: • Checking the matching lists • Correct station coordinates 11th Eionet Workshop on Air Quality Okt 26-27 2006
Linking AirBase with geo-info:Results and feedback • City names on LAU1/LAU2 level • Linking with other databases; making overlays with population, land cover maps etc. • Combination with zone/agglomeration maps 11th Eionet Workshop on Air Quality Okt 26-27 2006
Future developments AirBase: Matching and linking parameters in Airbase • Matching parameters: Sabe code, name; refilling NUTS1/2/3 and LAU1/2 codes • Linking parameters: zone and agglomeration codes (to be defined) 11th Eionet Workshop on Air Quality Okt 26-27 2006
Future developments AirBase: Results of overlays in AirBase • GIS overlays with population and land cover maps • Results in AirBase: e.g. population numbers, city names (LAU1 or LAU2 name) 11th Eionet Workshop on Air Quality Okt 26-27 2006
Future developments AirBase: Integrated control of EoI and AQ questionnaires • Necessary meta info available in AirBase • After importing raw data, statistics and exceedances can be calculated • The export function of the DEM can be extended with the questionnaire spreadsheet prefilled with info from AirBase and the DEM • A useful help functionality to fill in the questionnaire 11th Eionet Workshop on Air Quality Okt 26-27 2006
Future developments AirBase: Google Earth • From AirView it is possible to create a GIS map in the EEA Map Service • Analogously it is also possible to create a *.kml file for Google Earth • Applications: • Checking station coordinates • Insight into station surroundings • Visualisation of statistics, exceedances etc. 11th Eionet Workshop on Air Quality Okt 26-27 2006
Future developments AirBase: Suggestions? • Suggestions? • Questions? • Remarks? 11th Eionet Workshop on Air Quality Okt 26-27 2006