is an application of ArcGIS 10.2.2 software to design a database, serving the management of water resources on the main stream of the Da River, aiming to be the best tool for managing, adjusting and forecasting issues related to water security.
3. Subject and scope of the research topic
- Research object: water resources.
- Research scope: on the main stream of the Da River.
Maybe you are interested!
-
Water Resources Database Development Process -
Assessment of surface water resources in Dong Nai river basin to serve sustainable development goals in the context of climate change - 2 -
Building a Water Resources Database at a Scale of 1:100,000 -
Identify Rating Levels and Rating Scales
zt2i3t4l5ee
zt2a3gstourism,quan lan,quang ninh,ecology,ecotourism,minh chau,van don,geography,geographical basis,tourism development,science
zt2a3ge
zc2o3n4t5e6n7ts
of the islanders. Therefore, this indicator will be divided into two sub-indicators:
a1. Natural tourism attractiveness a2. Cultural tourism attractiveness
b. Tourist capacity
The two island communes in Quan Lan have different capacities to receive tourists. Minh Chau Commune is home to many standard hotels and resorts, attracting high-income domestic and international tourists. Meanwhile, Quan Lan Commune has many motels mainly built and operated by local people, so the scale and quality are not high, and will be suitable for ordinary tourists such as students.
c. Time of exploitation of Quan Lan Island Commune:
Quan Lan tourism is seasonal due to weather and climate conditions and festivals only take place on certain days of the year, specifically in spring. In Quan Lan commune, the period from April to June and from September to November is considered the best time to visit Quan Lan because the cultural tourism activities are mainly associated with festivals taking place during this time.
Minh Chau island commune:
Tourism exploitation time is all year round, because this is a place with a number of tourist attractions with diverse ecosystems such as Bai Tu Long National Park Research Center, Tram forest, Turtle Laying Beach, so besides coming to the beach for tourism and vacation in the summer, Minh Chau will attract research groups to come for tourism combined with research at other times of the year.
d. Sustainability
The sustainability of ecotourism sites in Quan Lan and Minh Chau communes depends on the sensitivity of the ecosystems to climate changes.
landscape. In general, these tourist destinations have a fairly high level of sustainability, because they are natural ecosystems, planned and protected. However, if a large number of tourists gather at certain times, it can exceed the carrying capacity and affect the sustainability of the environment (polluted beaches, damaged trees, animals moving away from their habitats, etc.), then the sustainability of the above ecosystems (natural ecosystems, human ecosystems) will also be affected and become less sustainable.
e. Location and accessibility
Both island communes have ports to take tourists to visit from Van Don wharf:
- Quan Lan – Van Don traffic route:
Phuc Thinh – Viet Anh high-speed boat and Quang Minh high-speed boat, depart at 8am and 2pm from Van Don to Quan Lan, and at 7am and 1pm from Quan Lan to Van Don. There are also wooden boats departing at 7am and 1pm.
- Van Don - Minh Chau traffic route:
Chung Huong high-speed train, Minh Chau train, morning 7:30 and afternoon 13:30 from Van Don to Minh Chau, morning 6:30 and afternoon 13:00 from Minh Chau to Van Don.
f. Infrastructure
Despite receiving investment attention, the issue of infrastructure and technical facilities for tourism on Quan Lan Island is still an issue that needs to be resolved because it has a direct impact on the implementation of ecotourism activities. The minimum conditions for serving tourists such as accommodation, electricity, water, communication, especially medical services, and security work need to be given top priority. Ecotourism spots in Minh Chau commune are assessed to have better infrastructure and technical facilities for tourism because there are quite complete and synchronous conditions for serving tourists, meeting many needs of domestic and foreign tourists.
3.2.1.4. Determine assessment levels and assessment scales
Corresponding to the levels of each criterion, the index is the score of those levels in the order of 4, 3, 2, 1 decreasing according to the standard of each level: very attractive (4), attractive (3), average (2), less attractive (1).
3.2.1.5. Determining the coefficients of the criteria
For the assessment of DLST in the two communes of Quan Lan and Minh Chau islands, the students added evaluation coefficients to show the importance of the criteria and indicators as follows:
Coefficient 3 with criteria: Attractiveness, Exploitation time. These are the 2 most important criteria for attracting tourists to tourism in general and eco-tourism in particular, so they have the highest coefficient.
Coefficient 2 with criteria: Capacity, Infrastructure, Location and accessibility . Because the assessment area is an island commune of Van Don district, the above criteria are selected by the author with appropriate coefficients at the average level.
Coefficient 1 with criteria: Sustainability. Quan Lan has natural and human-made ecotourism sites, with high biodiversity and little impact from local human factors. Most of the ecotourism sites are still wild, so they are highly sustainable.
3.2.1.6. Results of DLST assessment on Quan Lan island
a. Assessment of the potential for natural tourism development
For Minh Chau commune:
+ Natural tourism attractiveness is determined to be very attractive (4 points) and the most important coefficient (coefficient 3), so the score of the Attractiveness criterion is 4 x 3 = 12.
+ Capacity is determined as average (2 points) and the coefficient is quite important (coefficient 2), then the score of Capacity criterion is 2 x 2 = 4.
+ Exploitation time is long (4 points), the most important coefficient (coefficient 3) so the score of the Exploitation time criterion is 4 x 3 = 12.
+ Sustainability is determined as sustainable (4 points), the important coefficient is the average coefficient (coefficient 1), so the score of the Sustainability criterion is 4 x 1 = 4 points
+ Location and accessibility are determined to be quite favorable (2 points), the coefficient is quite important (coefficient 2), the criterion score is 2 x 2 = 4 points.
+ Infrastructure is assessed as good (3 points), the coefficient is quite important (coefficient 2), then the score of the Infrastructure criterion is 3 x 2 = 6 points.
The total score for evaluating DLST in Minh Chau commune according to 6 evaluation criteria is determined as: 12 + 4 + 12 + 4 + 4 + 6 = 42 points
Similar assessment for Quan Lan commune, we have the following table:
Table 3.3: Assessment of the potential for natural ecotourism development in Quan Lan and Minh Chau communes
Attractiveness of self-tourismof course
Capacity
Mining time
Sustainability
Location and accessibility
Infrastructure
Result
Point
DarkMulti
Point
DarkMulti
Point
DarkMulti
Point
DarkMulti
Point
DarkMulti
Point
DarkMulti
CommuneMinh Chau
12
12
4
8
12
12
4
4
4
8
6
8
42/52
Quan CommuneLan
6
12
6
8
9
12
4
4
4
8
4
8
33/52
b. Assessment of the potential for humanistic tourism development
For Quan Lan commune:
+ The attractiveness of human tourism is determined to be very attractive (4 points) and the most important coefficient (coefficient 3), so the score of the Attractiveness criterion is 4 x 3 = 12.
+ Capacity is determined to be large (3 points) and the coefficient is quite important (coefficient 2), then the score of the Capacity criterion is 3 x 2 = 6.
+ Mining time is average (3 points), the most important coefficient (coefficient 3) so the score of the Mining time criterion is 3 x 3 = 9.
+ Sustainability is determined as sustainable (4 points), the important coefficient is the average coefficient (coefficient 1), so the score of the Sustainability criterion is 4 x 1 = 4 points.
+ Location and accessibility are determined to be quite favorable (2 points), the coefficient is quite important (coefficient 2), the criterion score is 2 x 2 = 4 points.
+ Infrastructure is rated as average (2 points), the coefficient is quite important (coefficient 2), then the score of the Infrastructure criterion is 2 x 2 = 4 points.
The total score for evaluating DLST in Quan Lan commune according to 6 evaluation criteria is determined as: 12 + 6 + 6 + 4 + 4 + 4 = 36 points.
Similar assessment with Minh Chau commune we have the following table:
Table 3.4: Assessment of the potential for developing humanistic eco-tourism in Quan Lan and Minh Chau communes
Attractiveness of human tourismliterature
Capacity
Mining time
Sustainability
Location and accessibility
Infrastructure
Result
Point
DarkMulti
Point
DarkMulti
Point
DarkMulti
Point
DarkMulti
Point
DarkMulti
Point
DarkMulti
Quan CommuneLan
12
12
6
8
9
12
4
4
4
8
4
8
39/52
Minh CommuneChau
6
12
4
8
12
12
4
4
4
8
6
8
36/52
Basically, both Minh Chau and Quan Lan localities have quite favorable conditions for developing ecotourism. However, Quan Lan commune has more advantages to develop ecotourism in a humanistic direction, because this is an area with many famous historical relics such as Quan Lan Communal House, Quan Lan Pagoda, Temple worshiping the hero Tran Khanh Du, ... along with local festivals held annually such as the wind praying ceremony (March 15), Quan Lan festival (June 10-19); due to its location near the port and long exploitation time, the beaches in Quan Lan commune (especially Quan Lan beach) are no longer hygienic and clean to ensure the needs of tourists coming to relax and swim; this is also an area with many beautiful landscapes such as Got Beo wind pass, Ong Phong head, Voi Voi cave, but the ability to access these places is still very limited (dirt hill road, lots of gravel and rocks), especially during rainy and windy times; In addition, other natural resources such as mangrove forests and sea worms have not been really exploited for tourism purposes and ecotourism development. On the contrary, Minh Chau commune has more advantages in developing ecotourism in the direction of natural tourism, this is an area with diverse ecosystems such as at Rua De Beach, Bai Tu Long National Park Conservation Center...; Minh Chau beach is highly appreciated for its natural beauty and cleanliness, ranked in the top ten most beautiful beaches in Vietnam; Minh Chau commune is also home to Tram forest with a large area and a purity of up to 90%, suitable for building bridges through the forest (a very effective type of natural ecotourism currently applied by many countries) for tourists to sightsee, as well as for the purpose of studying and researching.
Figure 3.1: Thenmala Forest Bridge (India) Source: https://www.thenmalaecotourism.com/(August 21, 2019)
3.2.2. Using SWOT matrix to evaluate Quan Lan island tourism
General assessment of current tourism activities of Quan Lan island is shown through the following SWOT matrix:
Table 3.5: SWOT matrix evaluating tourism activities on Quan Lan island
Internal agent
Strengths- There is a lot of potential for tourism development, especially natural ecotourism and humanistic ecotourism.- The unskilled labor force is relatively abundant.- resource environmentunpolluted, still
Weaknesses- Poorly developed infrastructure, especially traffic routes to tourist destinations on the island.- The team of professional staff is still weak.- Tourism products in general
quite wild, originalintact
general and DLST in particularalone is monotonous.
External agents
Opportunity- Tourism is a key industry in the socio-economic development strategy of the province and Van Don economic zone.- Quan Lan was selected as a pilot area for eco-tourism development within the framework of the green growth project between Quang Ninh province and the Japanese organization JICA.- The flow of tourists and especially ecotourism in the world tends toincreasing
Challenge- Weather and climate change abnormally.- Competition in tourism products is increasingly fierce, especially with other localities in the province such as Ha Long, Mong Cai...- Awareness of tourists, especially domestic tourists, about ecotourism and nature conservation is not high.
Through summary analysis using SWOT matrix we see that:
To exploit strengths and take advantage of opportunities, it is necessary to:
- Diversify products and service types (build more tourism routes aimed at specific needs of tourists: experiential tourism immersed in nature, spiritual cultural tourism...)
- Effective exploitation of resources and differentiated products (natural resources and human resources)
div.maincontent .p { color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 14pt; margin:0pt; } div.maincontent p { color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 14pt; margin:0pt; } div.maincontent .s1 { color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 13pt; } div.maincontent .s2 { color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 13pt; } div.maincontent .s3 { color: #0D0D0D; font-family:"Times New Roman", serif; font-style: normal; font-weight: bold; text-decoration: none; font-size: 14pt; } div.maincontent .s4 { color: black; font-family:"Times New Roman", serif; font-style: italic; font-weight: normal; text-decoration: none; font-size: 14pt; } div.maincontent .s5 { color: black; font-family:"Times New Roman", serif; font-style: italic; font-weight: bold; text-decoration: none; font-size: 14pt; } div.maincontent .s6 { color: black; font-family:"Times New Roman", serif; font-style: italic; font-weight: normal; text-decoration: none; font-size: 14pt; vertical-align: -3pt; } div.maincontent .s7 { color: black; font-family:"Times New Roman", serif; font-style: italic; font-weight: normal; text-decoration: none; font-size: 14pt; vertical-align: -2pt; } div.maincontent .s8 { color: black; font-family:"Times New Roman", serif; font-style: italic; font-weight: normal; text-decoration: none; font-size: 14pt; vertical-align: -1pt; } div.maincontent .s9 { color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 14pt; } div.maincontent .s10 { color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: bold; text-decoration: none; font-size: 14pt; } div.maincontent .s11 { color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 14pt; } div.maincontent .s12 { color: black; font-family:Symbol, serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 14pt; } div.maincontent .s13 { color: black; font-family:Wingdings; font-style: normal; font-weight: normal; text-decoration: none; font-size: 14pt; } div.maincontent .s14 { color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 9pt; vertical-align: 5pt; } div.maincontent .s15 { color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 9pt; vertical-align: 5pt; } div.maincontent .s16 { color: black; font-family:Cambria, serif; font-style: italic; font-weight: normal; text-decoration: none; font-size: 14pt; } div.maincontent .s17 { color: #080808; font-family:"Times New Roman", serif; font-style: normal; font-weight: bold; text-decoration: none; font-size: 14pt; } div.maincontent .s18 { color: #080808; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 14pt; } div.maincontent .s19 { color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 11pt; } div.maincontent .s20 { color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 10pt; } div.maincontent .s21 { color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: bold; text-decoration: none; font-size: 11pt; } div.maincontent .s22 { color: black; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; text-decoration: none; font-size: 11pt; } div.maincontent .s23 { color: black; font-family:"Times New Roman", serif; font-style: italic; font-weight: normal; text-decoration: none; font-size: 14pt; } div.maincontent .s24 { color: #212121; font-family:"Times New Roman", serif; font-style: normal; font-weight: normal; tex -
Assessment of surface water resources in Dong Nai river basin to serve sustainable development goals in the context of climate change - 21
4. Research content of the topic
The topic includes the following research contents:
- Collect information on water resources on the Da River mainstream, thereby assessing the current status of water resources databases, digital maps, determining data requirements, classifying and standardizing data types.
- Design model and build water resources data structure (DB) with ArcGIS10.2.2 software.
- Convert, edit, update data according to standards.
- Experimental construction of a water resources database at a scale of 1:100,000 on the Da River mainstream to ensure water security on the Da River mainstream.
5. Research methods
To achieve the objectives and content of the thesis, the research methods used in this thesis include the following methods:
- Methods of collecting and synthesizing documents include:
+ Collect existing documents, professional documents, relevant scientific topics that have been published, update new information online, inherit achievements related to the content of the thesis.
+ Analyze the collected data sources and then choose the method.
appropriate research
- Methods of technology assessment and exploitation include:
+ Evaluate and compare research methods with other conventional methods.
+ Improve database accuracy.
- Database construction method:
Build and manage information on the current status of water resources. From there, analyze current information and propose solutions for rational and scientific use of this resource.
- GIS application methods include:
+ Information layers extracted from 1:100,000 scale maps are digitized and standardized and entered into the database.
+ Use GIS tools to overlay information layers and check the accuracy between the information.
+ Use GIS tools to display designed information in the database.
6. Scientific and practical significance of the topic
* Scientific meaning :
The topic is a scientific and technological product that clearly demonstrates the application of information technology combined with professional knowledge in management work, serving the protection of water resources on the main stream of the Da River.
The database of water resources on the main stream of the Da River is used as a basis for developing plans and solutions in management work, as well as better coordination with departments and agencies to protect, rationally use and promote the values of water resources.
GIS database on water resources on the main stream of the Da River is
To serve the monitoring and assessment of water resources in accordance with the required level of detail of information, map data layers are designed at a scale of 1:100,000.
* Practical significance :
The study has demonstrated that combining GIS with ArcGIS10.2.2 software in building water resources database is a highly effective method, suitable for practical application.
7. Structure of the thesis
The thesis consists of 3 chapters, introduction, conclusion and recommendations and appendix presented in 128 pages.
During the process of writing my thesis, with the dedicated and thoughtful guidance of Dr. Dinh Xuan Vinh and Associate Professor Dr. Tran Duy Kieu, along with other teachers and colleagues, I have learned a lot of useful knowledge for my research and work.
Besides, I would like to sincerely thank the teachers in the Department of Geodesy and Cartography, Hanoi University of Natural Resources and Environment, and my colleagues who have given valuable comments to this thesis. I would like to thank the students of the Geodesy and Cartography Engineering class who have helped me during my studies.
CHAPTER 1: OVERVIEW OF THE PROBLEM OF BUILDING WATER RESOURCES DATABASE
1.1. OVERVIEW OF DATABASE
1.1.1. History of database development
Following the development trend of science and technology, the concept of database is also perceived as more and more modern, so its role is increasingly broader. Database is a collection of structured data information arranged, organized for access, exploitation, management and regular update by electronic means and is the foundation for information systems.

Figure 1.1. Database system
It is difficult to define a database precisely, but it can be seen that a database is an information system about objects referenced in a unified space and time that can previously produce new information based on the information available in the system. It is a model of the real world in the form of a combination of a finite number of data classes, each of which
in a defined reference system with the accuracy of the model calculated according to the purpose of the system and the technical capabilities of acquiring, storing, managing and displaying the information extracted from the model.
1.1.2. Geographical database
The term GIS is widely used in fields such as geography, information technology, environmental resource management, spatial data processing science... Therefore, there are many definitions of GIS as follows:
According to Burrough (1986), GIS is a powerful toolbox used to store and retrieve arbitrary, transform and display spatial data from the real world for specific purposes.
According to Smith (1987), GIS is a database system in which data is linked to spatial location and its operating procedures to meet the requirements of spatial objects in the database.
According to Nguyen Kim Loi and collaborators (2009), GIS is an information system that uses input data, analysis operations, and output databases related to spatial geography to assist in the collection, storage, management, processing, analysis, and display of spatial information from the real world, to solve problems of information synthesis for human purposes, such as supporting planning; natural resource management...
In general, the geographic database is the most important component in the information system. The data used in the geographic database is designed according to pre-determined principles and structures, called DB. Geographic data includes spatial data to describe spatial characteristics and attribute data reflecting the nature of geographic objects; spatial data is represented by computer graphics tools, attribute data is represented by letters, numbers, etc. Such geographic information must be
includes data about geographic location, shape, size, attributes, spatial and temporal relationships of information.

Figure 1.2.Geographic database
Data can also be classified according to the nature of geographic object classes: data used as the basis for representing specific thematic data are called geographic base data classes, specific thematic classes (education, health, land use, etc.); for different purposes of the information system, there can be a division between these two groups of data.
The data is collected from various sources:
+ Documents and data collected in the field.
+ Documents and data are collected from statistical methods.
+ Documents and data collected from remote sensing methods.
+ Documents and data collected from other geographic information systems.
1.1.3. Water resources database
a. Overview of water resources database
- According to the Law on Water Resources, Water Resources include rainwater, surface water, underground water, and seawater within a country's territory. Surface water resources include water existing on the mainland or islands, in riverbeds (river flows), ponds, lakes, and swamps. Groundwater is water existing in underground aquifers.
- A database is a logically organized collection of interrelated information arranged according to pre-determined principles and structures, controlled together and stored as a unified unit in large storage devices such as hard disks and magnetic tapes; these data have the ability to be exchanged and transformed to serve multiple industries, many users and for other purposes such as management and research.
- Water resources database is a collection of related information about water resources, arranged and stored as a unified unit in the database. This data has the ability to be exchanged and transformed to serve many sectors, especially water resources management in particular.
b. Overview of water resources database
Water resources database is built according to GIS structure, formed and developed from two main foundations: geography and cartography, along with strong promotion of advances in engineering, computer science and mathematics.
The first GIS system was born in the early 60s and has been increasingly developed on the basis of advances in computer technology, graphics, spatial data analysis and data management. The first system was applied in resource management in Canada under the name of Canada Geographic Information System, including information on agriculture; forestry; land use and wildlife.
Since the 80s, GIS technology has made a qualitative leap, becoming a useful tool in management and decision support. GIS software is aiming to turn GIS technology into an automatic system for mapping and processing Hypermedia data. GIS hardware has developed strongly according to desktop solutions, especially in recent years, with the emergence of extremely powerful microprocessors; data storage devices; advanced information display and printing, GIS technology has changed qualitatively 1 . Today, GIS technology is developing strongly in the direction of combination and network connection, GIS technology is always self-improving to match the latest advances in science and technology.
c. General requirements when building a water resources database
- To build and effectively use the water resources database, it is necessary to comply with a unified legal framework on product technology, which is the geographic information standard. Including 8 standards:
+ Terminology Standard.
+ Spatial reference system standards.
+ Standard geographic data structure model.
+ Standards for classifying geographic objects.
+ Standard for presenting geographic data.
+ Standards for spatial data quality.
+ Metadata standards.
+ Data encryption and exchange standards.
- Spatial data of water resources database uses VN-2000 National reference system and coordinate system. Comply with basic regulations on WSG-84 reference ellipsoid.
- The main components that make up a database include:





