The Consistency of Relational Database and Object-Relational Database in GIS Applications

This final year project involves a research and a simple Geographical Information System (GIS) application that will show GIS, spatial data, spatial database management, which focused on relational and object-relational database management system. The main objectives of this project is to study and gain deeper understanding on the implementation of the two types of databases in GIS applications, to compare the level of performance between the databases in a GIS application and to determine the most suggested database to be implemented in a GIS application. The scope of the study will focus on integrating a GIS application that implements Malacca spatial database with two different database management system, namely relational database and objectrelational database system. The performance of each database system will be identified and compared. Rapid Development environment methodology will be utilized in the research on the performance of relational and object-relational databases in GIS applications and also in the development of an application that will implement the database with GIS applications. This methodology basically involved overlapping Planning, Analysis, Design and Implementation phases. Database development design process involved conceptual, logical and physical design stages. This report also includes discussions on the consistency of relational database as well as of the objectrelational database in GIS applications. This report suggests GIS application developer to choose object-relational database in order to manage both spatial and attributes data for the applications efficiently. Furthermore, the result from the object-relational database will be more consistent and reliable compared to a relational database and the performance is better. Recommendations for continuing this project are to compare and determine the level of consistency between relational database and object-relational database in World Wide Web environment or with multi-user accessing the database concurrently in order to study on the effects to the level of consistency and also to develop a map query interface

The Consistency of Relational Database and Object-Relational Database in GIS Applications

This final year project involves a research and a simple Geographical Information System (GIS) application that will show GIS, spatial data, spatial database management, which focused on relational and object-relational database management system. The main objectives of this project is to study and gain deeper understanding on the implementation of the two types of databases in GIS applications, to compare the level of performance between the databases in a GIS application and to determine the most suggested database to be implemented in a GIS application. The scope of the study will focus on integrating a GIS application that implements Malacca spatial database with two different database management system, namely relational database and objectrelational database system. The performance of each database system will be identified and compared. Rapid Development environment methodology will be utilized in the research on the performance of relational and object-relational databases in GIS applications and also in the development of an application that will implement the database with GIS applications. This methodology basically involved overlapping Planning, Analysis, Design and Implementation phases. Database development design process involved conceptual, logical and physical design stages. This report also includes discussions on the consistency of relational database as well as of the objectrelational database in GIS applications. This report suggests GIS application developer to choose object-relational database in order to manage both spatial and attributes data for the applications efficiently. Furthermore, the result from the object-relational database will be more consistent and reliable compared to a relational database and the performance is better. Recommendations for continuing this project are to compare and determine the level of consistency between relational database and object-relational database in World Wide Web environment or with multi-user accessing the database concurrently in order to study on the effects to the level of consistency and also to develop a map query interface

The Use of a Geographical Information System (GIS) as a Spatial Decision Support System: Processing Planning Applications in Hilly Areas

Decision-making pertaining to development control has been increasingly complex as urbanization extends into environmentally sensitive hilly areas. Coupled to that, the traditional data analysis method of sieving maps is very cumbersome and inefficient for processing planning applications. Here a Geographical Information System [GIS] is seen as the ideal tool of the information age to improve the current inadequacies of the present planning system. Henceforth, the study aimed to adapt GIS as a decision support tool for processing planning applications specifically, in hilly areas. The study methodology basically involved the identification of a problem statement, formulation of goal and objectives, literature review on the application of GIS in local planning, the development of a planning data model and the design of a planning expert system. The planning data model consolidated relevant data for processing potential development in hilly areas. Hence, it was structured into common groups namely town planning, administration, utilities, environment and transportation. The principle object behind data analysis was to query site suitability and to determine whether the detailed proposals conformed to planning requirements. To aid decision-making, the decision support system employed a planning expert system. The knowledge base rules of the planning expert system incorporated planning guidelines development in hilly areas. An inference engine consisted of various scripts based on Boolean argument was designed to enable comparative assessment between detail proposals and planning parameters and provided technical advice to support or reject an application. A customised pull-down menu was designed to simplify data query and data retrieval. The study found that although GIS was effective at data analysis, for the moment, it would be of limited success in processing planning applications because there are many types of planning issues to consider. This would require further development of GIS analytical techniques before it could comprehensively process planning applications. The expert system while effective, depended on a standard format to process layout plans. Overlaying regularly used for data analysis but proved more effective when combined with other techniques e.g. buffering or spatial analysis. Although planning criteria were available, they had to be reviewed to weed out ambiguous terminologies. Attributes tables were vital to ensure the expert system worked because the inference engine is critical where data are kept. Since GIS was in various stages of implementation, it was concluded GIS could serve as a decision support system for processing planning applications in hilly areas. Further research was still required to develop new planning expert systems in various sectoral studies e.g. transportation planning. This included the development of digital supporting database, expansion in the scope and depth of data analysis, development of planning design models, fine-tuning planning criteria and the establishment a uniform digital format for the preparation of layout plans

Historical Places In Malacca (Enhancement Of Maps Manipulation Capability Through The Website) Using MySQL

The motivation to be involved with the field of study regarding GIS, has been emerging in a fast pace in these few years.Much research had been done and performed, giving tremendous and beneficial results towards this field. But most ofthe GIS applications were developed usingthe vendors ownproprietary database, in which, this could promote many problems. Geographic Information Systems alsoknown as GIS, are all about gathering data andthen building layers upon layers of this dataand then displaying them on a computer screen. The aim and the objective of the study done through this paper wouldbe in usingMySQLfor developing a GIS application, thus showingMySQL's ability for supporting GIS-based data, or in the otherword, the spatial data. While the main objective in doing the study and developing the particular system is mainly using MySQL in managing the spatial data, the otherintegral objectives which comes along with this project are, providing better features and quality spatial data features from the system for the users and also enhancing the capability of manipulating the maps, which are provided through the system. TheMethodology beingused in developing this project is according to the RAD Methodology, which involved the stages such as Requirement Planning, User Design, Construction, and Implementation. These stages would be further discussed through Chapter 3 of Methodology and Projectwork. And as for the Conclusion, which could be derived from the entire project, from the research being done, it could be seenthat, MySQL is able to support in the development of any GIS - based application through thenew released of its database which also included the spatial data management ability

The RAP Net: A Geodetic Positioning Network for Andalusia (South Spain)

The Council of Public Works and Housing of the Government of Andalusia by means of the Andalusian Cartographic Institute has set a positioning geodetic network named Andalusian Positioning Network (RAP). The Laboratory of Astronomy, Geodesy and Cartography (LAGC) of the University of Cadiz is responsible for the design, development, quality checking, geodetic control and technical support of this network. The RAP network main goal is providing GPS data in RINEX format for post-processing operations, and broadcasting differential corrections (RTK or DGPS) from the stations for real-time operations. The RAP network is formed by 22 permanent stations distributed homogeneously as to solve the position problem along Andalusia, including the coast line. The network is referred to ETRF89 reference frame and it has become the geodetic reference frame to scientific and technologic applications, such as the geodynamic control of Andalusia; precise geoid determination; obtaining tropospheric and ionospheric models to regional climatological studies; setting photogrammetric points or marks for georeferencing of satellite images; establishing control points for reference networks in big civil works, for GIS applications, and for terrestrial, maritime and aerial navigation etc. In this paper we present the proceedings to design and set up of the network, to the organization and quality checking of data and the stations. Finally we explain the methodology established to calculate and adjust the RAP network.IECA (instituto de Estadística y Cartografía de Andalucía) Junta de Andalucía- Autor/es: Berrocoso M., Paez R., Jigena B. and Caturla C. - Título: The RAP Net: A Geodetic Positioning Network for Andalusia (South Spain) - Nombre de la revista: EUREF Publication No. 16 - Volumen: Publication No. 16 - Página inicial y final d

GIS Application to Support Land Administration Services in Ghana: Institutional Factors and Software Developments

In June 1999, the Ghanaian Government launched a new land policy document that sought to address some fundamental problems associated with land administration and management in the country. The document identified the weak land administration system as a particular problem and recommended the introduction of computer-aided information systems in the ‘lands sector’. In 2001, the Government made further proposals to prepare and implement a Land Administration Programme (LAP) to provide a better platform for evolving an efficient land administration that would translate the ‘National Land Policy’ into action. Thus, an up-to-date land information system (LIS), supporting efficient management of land records, is to be constructed, which provides a context for the research reported in this paper. We document two aspects of our research on the adoption of GIS by the Lands Commission Secretariat (LCS) which form part of a pilot project in GIS diffusion. Part one of the paper mainly outlines the empirical results arising from fieldwork undertaken during 2001 to determine the information and GIS requirements of the LCS in relation to their routine administrative processes and to identify the critical factors that are required to ensure that any new GIS applications are successfully embraced. Part two explains the prototype software system developed using ArcView 3.2 and Access that provides the LCS with a means to automate some of the routine administrative tasks that they are required to fulfil. The software has been modified and upgraded following an initial evaluation by LCS employees also conducted as part of the fieldwork in Accra

The potential of public participation geographic information systems in UK environmental planning: Appraisals by active publics

The paper draws on an empirical study of two workshops in which the issues that arise from the use of geographic information systems (GIS) as a planning tool in public participation settings were explored by local residents who take an active interest in local planning matters in their London borough. The paper demonstrates how issues concerned with the democratization of GIS and public participation GIS (PPGIS) informed the structure and conduct of the workshops and the qualitative analysis of the workshop discussions. Key themes raised by participants included: the potential of PPGIS as a means of extending knowledge networks; issues of data ownership and the responsiveness of data providers to public concerns; and the role that institutional norms and practices play in democratizing information availability and the transparency of the decision-making process. The paper concludes that the potential of PPGIS as a planning tool cannot be separated from public concerns about the legitimacy of the planning process or local government