MULTIMEDIA GIS OF TOURISM SITES IN CROSS RIVER STATE

This project is based on multimedia GIS of tourism sites in Cross River State. Tourism in Cross River State is geared towards the diversification of the state based industry as well as providing an alternative means of improving the state internally generated revenue. The objective of the research is to map the tourism sites and develop a multimedia GIS Database for Cross River State. To achieve the objectives of this research, Hand held GPS was used to locate tourism sites and for update of digital maps of Cross River State. Cartographic digitization was employed to produce the tourism map of the state. A relational GIS database was created using Arc Map 10.1. Ulead Video DV X2 with a Fire wire 1394 adapter was used in downloading video clips recorded by the Digital Video Camera into Personal Computer (PC). Ulead Video Studio Pro X2 which has the capability of converting recorded sound to wave files which are later converted into AVI files and also of converting scanned images and photographs into Video Clips was also used. Microsoft Window Media Player played the Video Clips. Finally, spatial search and multimedia queries were carried out to test the database. This research has been able to demonstrate the dynamic capacities of Geographic information system application in mapping, analysis and modeling of Geographic phenomenon. This is to aid tourism planning authorities, tourists, and government agencies to visualize, plan,

monitor, manage and access various tourist sites in Cross River State. This database should be updated from time to time in other to capture new developing areas with the facilities that are present. 

COVER PAGE i

TITLE PAGE ii

CERTIFICATION iii

APPROVAL iv

DEDICATION v

ACKNOWLEDGEMENTS vi

ABSTRACT vii

TABLE OF CONTENTS viii- ix

LIST OF FIGURES xi

LIST OF TABLES xii

CHAPTER ONE - - - - - - 1

1.0 Introduction - - - - - - 1

1.1 Background to the study - - - - 1-3

1.2 Statement of the problem - - - - 3

1.3 Need for the study - - - - - 3

1.4 Aim and objectives - - - - - 4

1.4.1 Aim - - - - - - - 4

1.4.2 Objectives - - - - - - 4

1.5 Scope - - - - - - - 4

1.6 The study area - - - - - - 4-7

1.7 Multimedia map - - - - - 8

1.7.1 Concept of Multimedia Mapping - - 8-10

1.7.2 Concept of Hypermedia/Multimedia - 10-12

1.7.3 Concept of Multimedia GIS - - - 13

1.7.4 Conceptual frame work - - - 13

1.7.5 Theory of Geographical information System (GIS) - 15-17

1.7.6 Approach for Designing Map-base Multimedia Product - 17

1.7.7 Requirements for Designing Map-base Multimedia product - 18

1.7.8 Database Design - - - - - 18-19

1.8 Limitation - - - - - - 19-20

2.0 Literature Review - - - - - 21-28

3.0 Methodology - - - - - - 29

3.1 Research Design - - - - -- 29

3.1.1 Type of Research Design - - - 29

3.2 Material and Techniques - - - - 29

3.2.1 Equipment and software - - - 29

3.2.2 Equipment - - - - - - 29

3.2.3 Hardware requirement - - - - 30

3.2.4 Software requirement - - - - 30

3.2.5 Data - - - - - - - 30

3.2.6 Sources of data - - - - - 30-33

3.3 Geometric data acquisition - - - 33

3.3.1 Acquisition of primary dataset - - 33

3.3.2 Acquisition of secondary dataset - - 33

3.3.3 Acquisition of attribute data - - - 33

3.4 Data processing procedure and Database creation - 33

3.4.1 Mapping of tourism site in Cross River State - 33

3.4.2 Multimedia GIS Database design and Creation - 33

3.4.3 Multimedia Database Design - - - - 33-36

3.4.4 Database Implementation - - - - - 37-38

3.4.5 Multimedia database Creation - - - - 38-39

3.5 Analysis and Information Presentation - - - 40

3.5.1 Data analysis - - - - - - - - 40

3.5.2 Spatial search - - - - - - - 40

4.0 Data Analysis and Presentation - - - - 41

4.1 Analysis of result - - - - - - - 41

4.1.1 Single criteria queries - - - - - - 41-43

4.1.2 Multiple criteria queries - - - - - 43-44

4.1.3 Multimedia queries - - - - - - 44-48

4.2.0 Discussion - - - - - - - - 48

4.2.1 GIS and Hot-linking / Hyperlink - - - - 48-49

4.2.2 Application of Multimedia GIS products - - 49-50

5.0 Conclusion and Recommendation - - - - 51

5.1 Summary - - - - - - - - - 51

5.2 Conclusion - - - - - - - - 51

Table 3.1 Relational database structure - - - - 36

Table 3.2 Sample of Tourist Site table created in Arc-GIS 10.138

Figure 1.1 Map of the study area - - - - - - - - 7

Figure 3.1a: Map of Greater Calabar (Projects and Infrastructure) - 31

Figure 3.1c: Cross River Map of Flood and Erosion Site 2012 - - 31

Figure 3.1c: Orthophoto of part of Cross River State - - - - 32

Figure 3.3 Spatial data modeling - - - - - - - - 35

Figure 3.4: Multimedia GIS Database. Author - - - - - 39

Figure 4.1: show result of query by attribute - - - - - 42

Figure 4.2 Query by location using identity tool. - - - - - 43

Figure 4.3 Query for tour sites with syntax "ID"= "2 or<= 14" - - 43

Figure 4.