Geoportal as Decision Support System with Spatial Data Warehouse
Almir Karabegović & Mirza Ponjavić
The goal is therefore to build a platform using advanced GIS and web-based database technologies that would make key land-related information needed for investors available and easy to access.
The resulting interactive map is intended to become a comprehensive source of land related information relevant for businesses and investors that is easy to view on-line and that can serve a wide range of public and private sector end users too.
The primary purpose of the geoportal is distribution and visualization of spatial data over the Internet, but its interactive capabilities could bring its functionality far beyond. This paper proposed a usage of geoportals for decision making, especially with spatial data warehouses, whose main characteristics are: more organized data structure, better integration of disparate data, new spatially enabled analysis, reduced decision making cycle time and improved decisions making.
In the use case project, we utilized standard data warehousing infrastructure to integrate data from multiple source systems, enabling a central view across agencies. For agencies which could not accept the approach, we have created web services and catalogued all their data to central geoportal.
We got information system that supports business decision making activities and serve the management and planning levels of organizations.
As per definition, this geoportal provides an entry point to access all data (geospatial data, remote sensing, information and services), and could be used to Discovery, View, Download, and Transformation. We suggest building geoportal on three levels, web services platform, enterprise geoportal, and finally spatial data warehouse.
We got information system that supports business decision making activities and serve the management and planning levels of organizations, show structural and non-structural data changing. Basically, this data warehouse represent knowledge based system, and we have interactive system intended to help decision makers compile useful information from a combination of raw data, documents, and personal knowledge, with their business models to identify and make decisions.
Summarizing previous statements we can see that it sounds like real decision support system. This decision support geoportal gather and present information like inventories of information assets (including legacy and relational data sources, cubes, data warehouses, and data marts); comparative statistic and demography figures between time points; and historic and projected economic indicators and natural characterics based on statistic assumptions.
We suggest building geoportal on three levels:
web services platform,
enterprise geoportal, and
spatial data warehouse.
1st level: Web services platform contains Web GIS services, like Discovery service, means CSW (Catalogue Service Web), Viewing service, means WMS, WCS (Web Map Service, Web Coverage Service) and Download service, means WFS (Web Feature Service). Here also could be implemented geoprocessing services, open web services and tracking services.
2nd level: Enterprise geoportal contains catalog services, like Search, Channels, Link Browser Map, Download, and Collaboration.
3rd level: Finally, third level is data warehouse where data are stored.
A future direction
We confirm advances in usage of spatial data warehouse to present spatial with business data together to generate thematic maps, because it present all information consistently, provide a single common data model, restructure the data so that it makes sense to the business users, and delivers excellent query performance, even for complex analytic queries.
As future work, we plan to incorporate case management system, add full collaboration system, and implement full WebGIS editing capabilities for agencies.
 S. Shekhar, and S. Chawla, “Spatial Databases: A Tour”, Prentice Hall, 2003
 M.F. Worboys, “GIS: A computing perspective”, Taylor and Francis, 2004
 M. Batty, and P.A. Longley, “Advanced Spatial Analysis: The CASA Book of GIS”, ESRI Press, 2003
 M.F. Goodchild, P. Fu, and P.M. Rich, “Geographic information sharing: the case of the Geospatial One-Stop portal”, Annals of the Association of American Geographers, 2007
 D.J. Maguire, and P.A. Longley, “The emergence of geoportals and their role in spatial data infrastructures”, Computers, Environment and Urban Systems, 2005
 R. Haining, “Spatial Data Analysis: Theory and Practice”, Cambridge University Press, 2003
 J. Abonyi, and B. Feil, “Cluster Analysis for Data Mining and System Identification”, Springer, 2007
 R. Kimball, and M. Ross, “The data warehouse toolkit: the complete guide to dimensional modeling”, John Wiley & Sons, Inc., 2002
 L.T. Moss, and S. Atre, “Business intelligence roadmap: the complete project lifecycle for decision-support applications”, Addison-Wesley, 2003
This work is supported by Gauss Tuzla, Center for Geospatial Research Sarajevo