290 likes | 657 Views
Quality Evaluation Process in eTOD Database. Ing. Jaroslav ZEMEK, CSc. Annotation. Presentation : Quality evaluation process in eTOD ( electronic terrain and obstacle data) Database Panelist: Jaroslav Zemek – RIGTC Zdiby, CZ
E N D
QualityEvaluationProcess in eTODDatabase Ing. Jaroslav ZEMEK, CSc.
Annotation • Presentation: Qualityevaluationprocess in eTOD (electronicterrainandobstacle data) Database • Panelist: Jaroslav Zemek – RIGTC Zdiby, CZ • Thepresentationwillinformabouttheachievementsof RIGTC Zdiby - CZ, in thesolutionoftheproject "The Assurance and Assessment ofAerial Obstacles Quality". ThisprojectwassolvedfortheCzech Ministry ofTransportation in 2009 and 2010. Itrepresentsthefirstpracticalapplicationofthe ISO 19100 SeriesforGeographicinformation in aviation branch. Theprimaryaimofthis Project was to developthe technology forspecification, ensuring, assessmentandpublishingthequalityoftheaerialobstacle data in accordancewithCommissionRegulation (EC) Nr. 73/2010, ICAO Annex 15, nationallegislationandwithallkeystandardsandnormsof ISO 19100 Series - Geographicinformation related to quality andmetadata. EuroGeographics QKEN webinar
Content EuroGeographics QKEN webinar Project „Database of Aerial Obstacles“ (eTOD) Key documents, working groups and platforms for eTOD quality issues e-TOD Quality and Integrity requirements, Quality elements and criteria used Responsibilities of participating bodies Database of Aerial Obstacles and Geospatial Data Quality Philosophy Preconditions and processes for Quality and Integrity achievement Software for Quality and Integrity assessment Presentation of Quality assesment results Further development
Project „Database of Aerial Obstacles“ • Contractwith the Czech Ministry of Transportation (MT) • Joint team led by RIGTC consisting of specialists from MT, Aeronautical Information Services (AIS), Ministry of Defence (Geo, AF), surveyor of company operating the Prague – Ruzyně Airport • Solution in 2009 - 2010, eTOD – only „aerialobstacles“ (AO) • WPs: • - development of proven data gathering technologies compliant with Q and I requirements • - generation, administrationand update of database • - development of proven technology of Q and I assessment • - development of technology of positional accuracy assessment of aeronautical charts • Research and development, design, testing, validationofmethodologyandtechnologies meeting thequalityand integrity requirements • Documentationandresults are stored in „e-Projekty“ at MT CZ (CG942-064-910) and in RIGTC library EuroGeographics QKEN webinar
Key documents for the Project • Commission Regulation (EU) No 73/2010 • Czech legistation (Aviation Act No 49/1997 Sb, Regulation No 108/1997 Sb.) • ICAO Annex 15 – (CZ Aviation Instruction L 15) • ČSN ISO 19100 Series - Geographic information • 19113 - Quality principles • 19114 - Quality evaluation procedures • 19115 - Metadata • 19131 - Data Product Specification • 19138 - Data quality measures • 19157 - draft for consolidation of the above ISOs. • EuroControl: Terrain and Obstacle Data Manual - Draft 1 of 2010 • EuroControl WGs and platforms: eTOD, ADQ, CHAIN, AIXM • Instructions and guides of COSMC for field survey (CZ NMCA) EuroGeographics QKEN webinar
Database of Aerial Obstacles - eTOD • Web application (technologies ASP.NET and C#, NET framework 2.0, XML) • Browsers IE 7.0 and FireFox 3.6 or higher versions (Chrome, Opera ) • User dialogue in Czech language (English is being prepared) • Database MySQL • Focus on security, integrity, controled access and strict historization • All important changes are logged (what, when, whom, why - history of changes) • Time Slices • Deleting of data may be prohibited (optional) • Coding catalogues, data item description and gazetteer are in CZ and ENG • Data is described by metadata (about data set, about feature) • Metadata contains results of Quality, Integrity and Consistency checks (CRC 32Q) and are updated dynamically • Information on obstacles is accesible on web via user friendly forms EuroGeographics QKEN webinar
Database of Aerial Obstacles - eTOD • Basic functionalities: • Setting up (options, parametres for quality checks, etc.) • Import and export (digital forms on web, off-line in exchange format XML) • Viewing, filtering, searching, sorting and editing of obstacle data • Quality checks (loggs, protocols, history) • Digital photos viewing • Actions available (icons): depending on authorization (admin, editor, user) • Full info incl. digital photos • Editing • - application, logical and database checks are carried out before acceptance of each change • - historization and logging of all changes • Back-up (by standard MySQL tools or by tools of Application layer) • Time Slices and comprehensive History EuroGeographics QKEN webinar
eTOD - Quality and Integrity Requirements EuroGeographics QKEN webinar
eTOD - Quality and Integrity Requirements • Numerical requirements for Obstacle data EuroGeographics QKEN webinar
eTOD - Quality and Integrity Requirements • Numerical requirements - ICAO Annex 15 (Accuracy, Resolution, Integrity level, Confidence level, Periodicity……..) • Ability to determine the data origin (institution – persons, methods, procedures) • Credibility of originators and data providers • Level of assurance of data availability before its effective start date/time till effective end date/time • Documentation (description of requiremets, methods, procedures, assessment, personal – traceability) • Declaration of data usability for particular application EuroGeographics QKEN webinar
eTOD - Quality and Integrity Requirements • Argumentation and evidence to show, that: • Accuracy and resolution requirements are met at data origination • Origin and change history for each data item is available for audits • Data is complete or missing items are declared • All processes (data origination, production, storage, handling, processing, transfer or distribution) for each data item are defined and are adequate for assigned integrity level • All personnel is proffessionally skilled • Maintenance of each obstacle data is secured throughout its lifetime • System of error reporting and efficient feedback from users are established …… EuroGeographics QKEN webinar
Responsibilities of participating bodies • Implementation of Quality Management System within participating organizations (ISO 9001:2008) • Adequate proffessional skills and moral quality of personnal (courses and training for ISO 19100 Series, methodology, security clearance ….) • Participation at elaboration of DPS according to ISO 19131 • Strict application of binding documentation (EU, Eurocontrol, ICAO, CZ_legislation, aviation regulations L15 etc.) • Secured data transfer (application of CRC 32Q method ), database integrity and database access only for authorized subjects • Close cooperation of all subjects (originators, database administration, data providers, data users …), regular feedback… EuroGeographics QKEN webinar
Spatial Data Quality Philosophy • Data Product Specification • Spatial Data Quality Elements/Sub-elements • Accuracy (Positional, Thematic, Temporal) • Resolution of data • Integrity • Traceability • Completeness (Commission, Ommission) • Logical consistency (Format, Conceptual, Domain, Topological consistency) • Data Quality Evaluation Procedure • Data Quality Reporting/Metadata Data quality philosophy consists of the following four topics: EuroGeographics QKEN webinar
Spatial Data Quality Philosophy • Data Product Specification EuroGeographics QKEN webinar
Spatial Data Quality Philosophy • Data Quality Evaluation Procedure EuroGeographics QKEN webinar
Spatial Data Quality Philosophy • Data Quality Reporting/Metadata EuroGeographics QKEN webinar
Quality plans EuroGeographics QKEN webinar
Software for eTOD Quality Assessment • Basic principles for calculations and Quality assessment • Quality scope • Quality measures • Quality assessment procedures • Quality results • Type of quality results values • Quantitative Quality assessment and presentation of results • Reports from Quality checks • Records in Metadata of database and Metadata of feature • Non-quantitative Quality assessment and presentation of aggregate results • Historization of the Quality assessment • Periods for Quality assessment EuroGeographics QKEN webinar
Information on Aerial Obstacles EuroGeographics QKEN webinar
Dynamic filtering EuroGeographics QKEN webinar
Time Slice EuroGeographics QKEN webinar
Quality checks EuroGeographics QKEN webinar
Detailed Report from Quality check EuroGeographics QKEN webinar
History of Quality checks EuroGeographics QKEN webinar
Metadata about Database of Aerial Obstacle EuroGeographics QKEN webinar
Conclusions – future development • Technology: • is proven by the users and is compatible with recent system of AIS of the Czech Republic • is ready for application without significant financial bardens • will consolidate several AO databases being operated recently in CZ into unified, central and standardized one • will satisfy user needs for next about 5 years • creates the solid base for further development (DIGEST and FACC, AIXM v. 5.1, UUID etc.) • Proposals for future development: • Streamlining of technologies, field survey of data with higher level of integrity (10-5), wireless field data transfer , optimization of processes, additional functionalities for Quality checks etc. • Integration of eTOD with other state information systems and GIS, databases and registers • Full exchangability with European Aeronautical Database (EAD) • Application of new digital geospatial data, especially from laser scanning of CZ territory • English language localization • Questions? EuroGeographics QKEN webinar
Mr. Jaroslav ZEMEKVÚGTK v.v.i.Ústecká 98250 66 ZdibyCzechRepubliccell: +420 602 754 192 jaroslav.zemek@vugtk.cz