Installation Management Agency Korea Region Office KOROGIS CADD GIS

Installation Management Agency Korea Region Office KOROGIS CADD/GIS Interoperability Presented By: Anna Austin, GISP Spatial Engineering, Inc. 17 -Oct-07 Spatial Engineering, Inc. 1

Overview • Background – History – Issues – Objectives • Approach – Initial – Without Oracle Spatial – Revised – With Oracle Spatial • Current Configuration – Overall Data Flow – Interoperability Data Flow • Conclusions 17 -Oct-07 Spatial Engineering, Inc. 2

History • 1997 Camp Humphreys and Camp Carroll ~ $700 k – MGE/Oracle – Data Maintenance Other Duties • 1999 Camp Casey Enclave (6 sites) ~$550 k – Geo. Graphics/Access – Data maintenance personnel, no equipment • 1999 Yongsan Garrison ~$3 M – Geo. Graphics/Oracle FME Arc. IMS – Data maintenance by Contract Over $4 M spent……. . 17 -Oct-07 Spatial Engineering, Inc. 3

Issues • HQ KORO Observed: – Limited access/use • High $$$, few (1 -2) people able to use • Inconsistent products from installations to HQ – Irregular Data Maintenance • • Other duties as assigned Planimetrics & utilities maintained in Micro. Station DGN. (EN/PN) Environmental & Training maintained in Arc. View SHP. (ITAM/EV) Multiple versions (“Who has the latest? ”) – System/data compatibility questioned • Why is data from locations different? • Why is data from Directorates (DPW, ITAM) different? • Installation specific development and functionality 17 -Oct-07 Spatial Engineering, Inc. 4

Objectives • A “Common Installation Picture (CIP)” for all sites. • Easy access to all authorized KORO users (US and KN) • Support all geospatial platforms used – Micro. Station CADD – Arc. GIS • Standard data structure (SDSFIE) all sites. • Up-to-date consistent data all sites. • Standard tools for all users/sites. 17 -Oct-07 Spatial Engineering, Inc. 5

Overview • Background – History – Issues – Objectives • Approach – Initial – No Oracle Spatial – Revised – Oracle Spatial • Current Configuration – Overall Data Flow – Interoperability Data Flow • Conclusion 17 -Oct-07 Spatial Engineering, Inc. 6

Initial Approach 2002 KOROGIS Enterprise Implementation Plan • Provide On-site Support Personnel (Michael Baker, Jr. , Inc. ) – GIS Manager/DBA (GDBA) – Area Support Managers (ASM) for Area I, III, and IV • Knowledgeable of CADD and GIS • Software – – Micro. Station Geo. Graphics/Access (Geospatial CADD) Arc. GIS 8. 3 (GIS) Arc. SDE/Oracle 9 i (Arc. SDE_Binary RDBMS) Arc. IMS (Web Publisher) • Goal – – Support Geospatial Data (CADD (Micro. Station) and GIS (Arc. GIS)) Secure multi-level web access to over 80 camps, 1000+ routine users Maintain single corporate spatial database. Eliminate multiple copies. Use Standard data schema. (SDSFIE) 17 -Oct-07 Spatial Engineering, Inc. 7

Locations Area II ASM GIS DBA (Yongsan) Area I ASM (Camp Casey) (Yongsan) GIS Server 1 (Yongsan) Area IV ASM (Camp Henry) Area III ASM (Camp Humphreys) ASM – (Area Support Manager) responsible data maintenance within assigned area GIS Server 2 (Camp Henry) GIS DBA – Manages overall system. GIS Server – Redundant servers replicate to ensure reliability 17 -Oct-07 Spatial Engineering, Inc. 8

Initial Data Workflow • Pros – Data maintained at DPW by ASM. – CADD access at DPW. – Central spatial database supports GIS and WEB access. – Controlled data input. (by ASM) – One common map. 17 -Oct-07 Spatial Engineering, Inc. 9

Initial Data Workflow • Cons – – – Convert data (DGN SHP SDE_Binary) Conversion problems Multiple data type Enterprise spatial database does not support CADD Difficult finding knowledgeable support in CADD AND GIS. Users know dialog boxes! 17 -Oct-07 Spatial Engineering, Inc. 10

Revised Approach • 2003 Migration Plan - Enterprise Oracle Spatial – SDSFIE Adjustments • Match CADD Feature to GIS Feature Class • Match CADD Category to GIS Feature Data Set – Data Maintenance adjustments • • 17 -Oct-07 Extend Micro. Station Geo. Graphics (DBQue) Define update procedures per application (Do’s and Don’ts) Capture updates to the central server nightly Train support staff on one data format (SDO_Geometry) Spatial Engineering, Inc. 11

Our Goal 17 -Oct-07 Spatial Engineering, Inc. 12

Oracle Spatial Workflow • Pros – – Data maintained in CADD (Geo. Graphics) at DPW Central spatial database supports CADD and GIS. Single common data type (SDO). No Conversion. Oracle procedures automate/support QC/QA process. 17 -Oct-07 Spatial Engineering, Inc. 13

Oracle Spatial Workflow • Cons – Oracle Spatial Cost ($2, 500/CPU on ITL BPA). – Train support personnel on new workflow. (This is minor since a total spatial solution requires training. ) – Adjustments required to accommodate vendor requirement/deficiencies. (“IOP”) 17 -Oct-07 Spatial Engineering, Inc. 14

Overview • Background – History – Issues – Objectives • Approach – Initial – No Oracle Spatial – Revised – Oracle Spatial • Current Configuration – Overall Data Flow – Interoperability Data Flow • Conclusion 17 -Oct-07 Spatial Engineering, Inc. 15

Overall Data Flow 17 -Oct-07 Spatial Engineering, Inc. 16

Implementing Oracle Spatial • PROS – – – – – • CADD GIS WEB GIS CADD Stores element geometry in the SDO_GEOMETRY (SDO) data type. Data can be accessed using standard SQL procedures and commands. Bentley and ESRI support the Oracle Spatial SDO format. No Conversion of geometry. Accuracy and content are maintained. Enterprise spatial database supports CADD, GIS and WEB applications. Oracle Spatial provides additional data validation tools. Data stored in Oracle through its life-cycle. Simple geometry makes edits simple. CONS – – Must understand vendor requirements and limitations. Geometry must be simple polygon, line, and point elements for interoperability. Must have data maintenance procedures to account for vendor limitations. Additional cost for Oracle Spatial. 17 -Oct-07 Spatial Engineering, Inc. 17

Conclusion • • • Collect and edit data once, use by many (users & applications) Manage a single data format (SDO) to support CADD and GIS. NO conversion, minimize pre/post-process time. Data maintenance procedures critical. Use CADD/GIS technology that best satisfies the specific need. – Engineers use CADD (Micro. Station) – Planners use GIS (Arc. GIS) – Leverage current investment in technology, personnel and data development. • Paradigm change – CADD and GIS are tools or the engine! – Data is the fuel! – You would not buy a KIA Sorento that ONLY used KIA fuel!!! 17 -Oct-07 Spatial Engineering, Inc. 18

Conclusion KORO owns the data. The cost to convert to CADD or GIS: $ZERO 17 -Oct-07 Spatial Engineering, Inc. 19

Questions KOROGIS CADD/GIS Interoperability By: Anna Austin, GISP aaustin@spateng. com 17 -Oct-07 Spatial Engineering, Inc. 20