Online Business Systems, Spatial Warehouses and Spatial Intelligence

1. Online Business Systems, Spatial Warehouses and Spatial Intelligence Online Real Time Spatial Processing Prospects and Challenges

2. Overview

3. Overview Our experience in deploying spatially-enabled applications and related infrastructure in several provinces Observations on Nature of the systems Technical challenges Synergies between government mandates and spatial technologies No two jurisdictions are alike

4. Overview • Specifically, we look at • Building online, real time, spatially-enabled, transaction business systems • Deploying spatial infrastructures – Spatial Data Warehouses • How they are used to build and evolve spatial intelligence applications and platforms

5. Building Online Real Time Spatially Enabled Business Systems

6. Managing Land and Resources Governments moving to online, map-based systems to deliver effective stewardship of land and natural resources Government mandates can be complex: preserve a diverse, changing set of values for future generations enabling improved global access to development opportunities to sustain continued economic growth, employment and vibrant local communities.

7. Acquisition of Mineral Rights In BC the Mineral Titles Online Project was an early example of Government’s resource sector partnerships

8. Objectives and Guiding Principles Improve access to land information Secure tenure for existing and new titles reduce conflict confidence in ground held Orderly and efficient system for allocating rights

9. Objectives and Guiding Principles Reduce the cost of doing business Promote on-the- ground exploration Support a competitive investment climate for exploration Manage competing demands

10. Highlights Prospectors and Mining Industry Authorized Access to online map Online selection of an area of interest for mineral rights Determine land availability in real time Online payment ONE STEP automated approval and issuance of the rights Automated report for First Nations and affected agencies notification

11. Sample Business Flow

12. Development Challenges • How to build an Internet component for defining the area of interest? • How to create a spatial representation of the title in real-time? • How to process significant amount of spatial data to help determine availability of rights in real time? • How to store the parcel based on the Internet selection, to be able to retrieve in subsequent requests?

13. Development Challenges 24/7 – requires robust spatial infrastructure ONE STEP AUTOMATED APPROVAL/ISSUANCE Complete functional integration Real time automated updates Authoritative, up-to-date spatial and attribute information

14. Extranet Intranet Integration with Corporate Components Security Corporate Spatial Warehouse E-Payment Web Mapping Gateway Registry Business Transactions Operational (Spatial) Database Operational (Spatial) Database Real time geoprocessing MTA Gateway Spatial Editing Environment Client/ MEM Staff GIS Desktop

15. Components

16. Model for Other Resource Systems The MTO system has wide-ranging uses Other resource extraction industries, e.g. oil and gas, forestry Land use planning regimes Parks and recreation Environmental management

17. Deploying Corporate Spatial Warehouses

18. CorporateSpatial Warehouse A key component to effectively enabling these online transaction business applications is the spatial infrastructure Corporate spatial warehouse (CSW) and web mapping

19. CorporateSpatial Warehouse The spatial warehouse Single logical repository of enterprise-wide authoritative, standardized spatial data and associated attributes Contributed and often managed by separate or distributed business units Made accessible to a wide range of both internal and external clients according to their requirements

20. Corporate Spatial Warehouse

21. CSW Information Architecture Implements the access requirements of both data suppliers and data consumers through application of Custodianship Principles Applies a rigorous data population and access configuration process to ensure that the enterprise nature of the warehouse has been maintained Creates an optimized data access environment by Data transform at population stage targeting client needs Specialized business view creation in the database Application of fine-grained authorization to secure custodial data where needed Informative business and object level metadata to assist in data discovery

22. Key Requirements to Support Transactional Business Applications 24/7 Robust infrastructure Up-to-date data from custodians Well defined process for updating the warehouse layers Scheduled layer loads/updates from operational systems

23. Deployment Challenges for Business Applications Jurisdictions and enterprises often do not have such infrastructures Individual business sponsors do not have the mandate or budget to establish complete systems While there are technical and budgetary challenges, there are also organizational hurdles

24. Hurdles In other jurisdictions No central repository of spatial data Spatial data resources are of variable quality Reluctance of custodians to give another department or ministry the authority to establish the CSW Strong desire for central repository

25. Solution Develop operational spatial repository Define spatial data for transaction business application Assess data quality and create agreements with custodians Create a design that reflects operational requirements Acts as a prototype for a CSW Creates buy-in for OSR and momentum for CSW

26. Conclusions Spatial warehouses are critical infrastructure It is possible to start small with special purpose systems and grow them into corporate wide systems Spatial Warehouses are continuously evolving resources Critical to the development of spatial business intelligence systems

27. Building Spatial Business Intelligence Applications

28. Growing Public Participation Rapid growth and evolution of online spatial data sources and interactive technologies Reinforces the trend towards public participation – by both novice and GIS expert alike – in using location information Visualization and analysis of a wide range of phenomena from archaeological sites to criminal activity, tracking flu epidemics and hurricanes, and environmental impacts

29. Public Engagement – Same Data, Same Tools Increasingly, governments are enabling the public to engage in dialogue about public policy Key to consensus building use of common, authoritative data sources powerful user friendly application tools publicly available.

30. Technical Challenges • Significant amount of spatial data from different sources • How to report in real time based on spatial predicates (in, near, touch, intersect,…) • Can the infrastructure, including hardware, support the user base and query demands • Integrate new sources (web services)

31. Answer: Spatial Business Intelligence • Existing BI platforms only provide Location Intelligence

32. Existing Location Intelligence Systems ERP CRM GIS System SCM Other Business Intelligence Spatially Enabled Queries and Reports

33. Spatial Business Intelligence Systems Corporate Spatial Warehouse Other Operational Spatial Database Spatial Business Intelligence Spatial Operators Spatial Filtering Geographic Visualization Bi-Directional Interaction

34. Components of Spatial Business Intelligence • Source Data • Operational Spatial Databases • Corporate Spatial Warehouses • Presentation • Dashboards (including Map Viewer) • Enterprise Reporting • Advanced and Predictive Analysis • Alerts and Proactive Notification

35. What is Spatial ETL • Extract • Spatial Data extraction and staging • Minimize impact on production data sources • Transform • Convert to format required by spatial data warehouse • Cleanse data to ensure accuracy • Validate primary keys • Convert to different numbering schema • Load • Load data to spatial data warehouse • Follow guidelines as outlined by data warehouse

36. Spatial BI Dashboard – More than Visualisation • Geographic Visualisation • Map allows users to see spatial patterns, trends that are often impossible to see using only tabular reports, charts and graphs. • Bi-Directional Interaction • Allows higher level analysis by providing the ability to pass data from a report to a map and from the map to back to the report. • Spatial Filtering • Geographic filtering enables users to incorporate a spatial dimension to analyzing and modifying a report to show spatial relationships based on an area of interest. • Spatial Operators • Report based on spatial operators (in/out)

37. Alerts and Proactive Notification First Nation notification Reports on encumbrances

38. Conclusions More work required to develop a Spatial Business Intelligence Platform

39. Thanks Questions, Comments?