Central Geological Survey CGS MOEA Geological Map Database
Central Geological Survey (CGS), MOEA Geological Map Database Development and Integrated Supply System Implement Program- Geological Data Warehouse Improvement Project(2/5 ) Vito, Ko GAIAS GIS Consultant Co. , Ltd. 2009/1/23
Outline 1. Introduction to project 2. Data Warehouse System 3. Comments on Previous Project 4. Methodology and Procedures 5. Progress and Manpower 6. Expected Results 7. Budget Allocation 2
. Introduction to project Secondary-year work of NGIS Spatial Data Infrastructure Plan in Phase 3 (2008 -2012) Goals: Use advanced spatial information and information management technology to expand the original data warehouse system Digitize CGS geological data and improve processes of establishing databases and quality of data Build up a framework for National Geological Data Service System Assistance to CGS and other government agencies to use GIS geological data Enhance government’s administrative efficiency and decision making to better integration and supply of NGIS 3 Introductio
Geological Data Warehouse System Digitization of field-surveyed geological data Geological data exchange Data inquiry and one-stop service system Physical environment Geological Data Warehouse Connection with service components Integration of databases Data analysis Promotion and customer service 4
Database 資料建置 establishment Functions of Data Warehouse System Data 資料管理 management Basic geological data collecting system Free GIS + PDF E-forms for field 地質調查電子表單 survey data Geo-tag text/file/ Geo -tag 地質文件 Geo-tag Photos 現地照片 Geo-tag. Hyperlink Data digitization 資料數化建檔 Metadata 簡易版詮釋資料建檔 完整版詮釋資料建檔 Metadata(PDF version) unabridged version) (PDF) Database 收納檔案資料庫 Database(survey results) 調查成果資料庫 Open-GIS Database (ORACLE) (ORACLE ) Data 資料品質 QA/QC Open-XML Database 開放式 XML資料庫 QC(automatic) 自動化合理性檢核 QC(manual) 人 檢核 Problems & reporting 問題與回報管控系統 control system Data 資料查詢 Inquiry Data 資料流通 Transfer/Circulation Tile-acceleration 2 D platform Google 3 D platform Tile加速 Google 3 D平台 geological data 2 D平台 integrated geological data integrated 地質整合查詢系統 inquiry system WMS WFS FTP SQL SOA WS WS Upload 上架 Application. Examination 申請 審核 下載 Download On-line Supply Concept of Data Warehouse 5
Core System (internal service) Data Framework of Data Warehouse System Basic Geological Database Regional Geology division Database Structural Geology division Database Warehouse System (external service) Regional Geology division Database Structural Geology division Database SOA WMS WFS Environmental and Engineering Geology division Database Basic Geological Database Environmental and Engineering Geology division Database Integrated Inquiry System (Warehouse System) Core System Geological Resource division Database Geological Knowledge Website Geological Knowledge Web-service SOA 6 Concept of Data
Hardware Framework of Data Warehouse System Internet service Firewalls of web portals Web portals and & Internet traffic monitoring server C. G. S. Firewall internet service websites ofwebsites NGIS Detecting system Scanning server. High-speed intranet of C. G. S. Abnormal conditions General user Balanced web load User identification Server 1 for application service Server 2 fro application service Basic Geological database 7 /thematic database External storage media Concept of Data
1. Standards of Geological Data Formats 1. 1 Draft standards of basic geological data formats 1. 2 Modification of CGS data standards 1. 3 Modification of standards of geological data formats 1. 4 CGS-required work on standards of geological data formats 2. Geological Data Warehouse System 2. 1 Improvement in system framework 2. 2 Establishment of distributed databases 2. 3 One-stop web portal of geological data service 2. 4 Diversification of functions for different user groups 2. 5 On-line data analysis 2. 6 Mechanism for data exchange 2. 7 Analysis of users’ using data 2. 8 Establishment of 3 D geological databases 2. 9 Establishment of temporal geological databases 2. 10 CGS-required work on geological data warehouse system 3. Data Collection for Geological Maps 3. 1 Establishment of mobile survey systems 3. 2 Digitizing and updating of geological maps 3. 3 CGS-requires work 4. Supply of Geological Data 4. 1 Establishment of a mechanism for automatically updating geological maps 4. 2 Establishment of an SOA mechanism 4. 3 Establishment of a system to deliver geological information 4. 4 CGS-required work 5. NGIS Promotion and Customer Service 5. 1 Participation in related promotional activities 5. 2 Publication of R&D results 5. 3 Posters and advertising printed materials 5. 4 CGS-required work 6. Establishment of Physical Environment for Spatial Information 6. 1 Planning 6. 2 Establishment 6. 3 Planning for expanding the physical environment 6. 4 Expansion of the physical environment 6. 5 CGS-required work Work Schedule for each Year Planning of Project 8 2009 2010 2011 2012 ----- ---------- ---------- ----------------------- ----------------------- ------------------------------------- ----- ----------------------- ------------------- ---------- ---------- ------------------- ---------- ---------- ------------------------------------------------------------ ----- ---------- ----------
Work Done in 2008 6 categories of work 22 items 55 sub-items 5 standards of geological data(drafts) 94 modules of service parts 300 WMS-related releases Digitization of 2 digital geological maps 3 exhibitions or seminars 3 papers 4 types of training 1 back-up server 9
. Methodology and Procedures 6 NGIS promotion and customer service Specification (or modification) of standards of geological data formats 1 Standard 5 Establishment of geological data supply system Promotion Data System 2 Geological database management and updating Establishment of physical environment for spatial information Expansion of integrated 4 geological data warehouse system 10 3 Methodology and Procedu
Specification (or Modification) of Standards of Geological Data Formats Standards 1 of Geological Data (Draft, 2009 - 2010) Standards of Taiwan Stratigraphic names and usage (2009) Digital Codes for Stratigraphy and Standards of Geological Map Legends (Draft, 2009) Quality Control Standards for Geological Map Data (Draft, 2009 -2010) 11 Methodology and Procedu
Modification of standards of basic geological data (2008 v. , draft) Gaps between digital geological data and existing printed maps Elimination of the gaps through establishing consistent standards of data formats Standards and criteria for quality control of digital geological data 12 Methodology and Procedu
Problems in Geological Maps 1. Existing Printed Geological Maps 1) The same stratigraphic units are represented in different legends(texture pattern ) on different area sheets 2) Contempary stratigraphic units are shown in different colors on different area sheets 3) Texture pattern representing a stratigraphic unit does not conform with lithology 4) The same stratigraphic unit has different names or codes on different area sheets 5) There is different spelling of English names for the same stratigraphic units 13 Methodology and Procedu
Problems in Printed Geological Maps Area sheet Stratigraphy Linko Bi. Sa. Tung Dayuan Hsinchu Chungli Taoyuan Miliao Ton. She Nanto Dayuan Miliao Sand Dune Area sheet Stratigraphy Chungli Formation Area sheet Stratigraphy Jinshuei Shale 14 Methodology and Procedu
Problems in Geological Maps 2. Digital Geological Map 1) Inconsistent map formats and data between digital and existing printed geological maps 2) Classified coding of digital data is not based on a hierarchy of stratigraphic units 3) Textural patterns of stratigraphic units on digital maps do not conform with conventional ones 4) Formats of digital geological data need to be standardized 15 Methodology and Procedu
Current Standards of Digital Geological Data Balewan Formation (Conglomerate) Fig. ZA 2 Shuelian Conglomerate (Member) Fig. C 48 Shebachungci Formation Fig. Z 002 Legends of stratigraphic units do not conform with conventional ones for sedimentary rock type, e. g. the legend color of Shebachungci Formation is not conventional (yellowish is better than reddish), the code is not appropriate and there is not English abbreviation 16 Methodology and Procedu
Solutions 1. Based on fundamental principles of geology 2. Based on USGS standards system used by 17 Methodology and Procedu
Specification of Standards and Practice Fundamental principles and application of geology Rationale Design Practice Application Stratigraphic legends Stratigraphic coding Practice of designing legends Practice of designing codes Prsentation of Stratigraphic data 18 design of stratigraphic database Methodology and Procedu
Flow chart of Geological Data Standard Top refer Standard of basic geological data Transform and circulation Position of Standards Standard of geological map data Down Standard of stratigraphic name and usage QA/QC Standard of digital stratigraphic codes and legends Practice of Geological Map Amendment of geological data standard 19 Methodology and Procedu
Goals for Modification of Standards in 2009 n. Modification of standards of the basic geological data (draft) assistance in modification n. Standards of geological map data (draft) 1. The same map formats for printed and digital maps 2. Set up basic geological database 3. Complete standards of geological map data n. Standards of Taiwan stratigraphic names and usage(draft) 1. Collect Taiwan stratigraphic names and examine scales and difference in classification of formations 2. Standardize stratigraphic names, abbreviation, usage as well as legends 3. Standards of Taiwan stratigraphic names and usage(draft) 20 Methodology and Procedu
Goals for Modification of Standards in 2009 n Digital codes for stratigraphy and standards of legends(draft) 1. Design a coding system for stratigraphic names at different scales as well as standard legends 2. Compile codes of Taiwan digital stratigraphic units and standards of legends(draft) n Standards of quality control for geological map data(draft) 1. Digital geological maps:Data formats should conform to the standards of ISO 19113, ISO 19114 and ISO 19138 as well as those of ISO 19139 or TWSMP 1. 0 v 2. Geological data :Specify QA/QC criteria based on spatial characteristics of geological data (draft) ISO 19113: 2002 - Geographic information -- Quality principles ISO 19114: 2003 - Geographic information -- Quality evaluation procedures ISO 19138: 2006 - Geographic information -- Data quality measures ISO 19139: 2007 - Geographic information -- Metadata -- XML schema implementation 21 Methodology and Procedu
Establishment, Management and Updating of Geological Map Data 2 1. Collection, establishment and updating of geological map data (1)Establish 1/50000 regional geological profiles in KML interface and web pages (2)Set up a production system for vector KML (3)Fast production of image files (4)Quick processing of 1/25, 000 topographic maps about Taiwan (5)Integrate electronic map data provided by I. O. T. , MOTC with the platform (6)Complete digitization of geological map data in two months after CGS publishes regional geological map data (7)Integrate monitoring of map data service with the platform and set up a delivery system of WMS 2. Surveys for map data and establishment of metadata (1)In line with MOI announcement of WSMP, integrate MOI web version of metadata with warehouse system (2)Set up and publish metadata in compliance with ISO 19139 standards 3. QA/QC of map data (1)Set up a mechanism for disposing of platform problems (2)expand the QA mechanism for map data input Establishment, Management and Updating of Geological Map Data 22 Methodology and Procedu
Establishment of Production and Inquiry System of KML Geological Profiles Purpose 3 D Presentation of geological profiles Development Modules of Service Component Module for map data input to spatial databases Module for positioning geological profiles Module for inquiry about geological profiles Module for displaying information on geological profiles Establishment, Management and Updating of Geological Map Data 23 Methodology and Procedu
Establishment of Production System of Vector KML Purpose Production system of vector KML geological maps which enables users to adjust legends Development Modules of Service Component Module for map data input to spatial databases Module for KML conversion of spatial databases Module for setting KML legends Module for KMZ packaging Establishment, Management and Updating of Geological Map Data 24 Methodology and Procedu
Establishment of Fast Production System of Map Layers Purpose Instant display of maps from the platform Development of Service Component Modules Tiled Base Image Map Open spatial databases ORACLE Module for map data input to spatial databases Module for map data QA/QC Module for setting display of legends Module for examining overlap of the maps Module for mosaic of image files Module for fast production of map layers Module for quickly setting map layers Module for quickly saving map layers Module for instant display of map layers Platform Improvement in mapping Dynamic maps Block maps Pre-download 2 D Map. Viewer 3 D Map. Viewer XML vector map Establishment, Management and Updating of Geological Map Data 25 XML image map Methodology and Procedu
integrate the electronic map data of I. O. T. , MOTC with the platfor Integration of Electronic Map Data Provided by I. O. T. , MOTC Purpose Enable users to overlay road network layers and geological map layers Development of Service Component Modules Module for map data input to spatial databases Module for map data QA/QC Module for setting display of legends Module for classification of road systems Module for examining overlap of maps Establishment, Management and Updating of Geological Map Data 26 Methodology and Procedu
- Slides: 26