The Arc-view application in the field of hydrology and water resources
2017-12-16WANGXiaomingXUEFei
WANG Xiao-ming, XUE Fei
School of Water Resources & Environment, Hebei GEO University, Shijiazhuang 050031, China.
Abstract: Through system design and analysis from the aspects of entity categories,hierarchical design, attribute design, and the final function design and realization of the system,this paper develops a software application based on Arc-view platform with a view to solving the deficiencies of conventional groundwater dynamic management in managing the spatial graphics data. Using this application into the supporting automatic monitoring system of groundwater level helps to achieve the automatic analysis of attribute data, and offer a new,visual and efficient automated management tool. Moreover, the computer geospatial modeling can realize the quick query and spatial analysis of geographic information, and thus facilitating dynamic simulation and prediction of the research object. However, a multi-functional,multi-level groundwater level information management system is a complex system engineering,which requires continuous improvement of the structure, development of functions, and supplement of user models.
Keywords: Water level dynamics; Spatial database; Groundwater resources; Geographic Information Systems
Introduction
Geographic Information System (GIS) is a computer-based integrated processing and spatial data analysis system, an emerging, edge research area combining computer science, management science, information science, space science,geography, environmental science. Since the 1970s,the Tennessee Valley Authority of the U.S. has used GIS to process and analyze various watershed data,so as to provide services for decision-making on watershed management and planning. GIS has begun to be used in hydrology and water management (LIU Jing, 2015). Since the 1980s,with the rapid development of computer technology,GIS has developed rapidly in the field of hydrology and water resources management. At the annual meeting of the American Congress on Surveying and Mapping (ACSM) and the American Society for Photogrammetry and Remote Sensing (ASPRS)in 1986, there has already been some pragmatic systems and theoretical research results on the application of GIS on hydrology and water resources management. Since the 1990s, GIS application has been a hot topic in water resource discipline. In 1993, the “Geographic Information Systems and Water Symposium” was held in Mobile City, Alabama. In terms of groundwater modeling, water quality and water use, the International Association of Hydrological Sciences(IAHS) held in 1993, the “GIS application in hydrology and water resources management” in Vienna; the University of Colorado held in 1995 an academic conference on water resources system simulation and management; in 1996, International Conference on the Application of GIS in Hydrology and Water Resources was held again in Vienna. In addition, some GIS software developers hold regularly user exchange meetings, such as the annual global and regional GIS user exchange meeting held by ESRI, in which water resource alone is set as a theme (LIU Jing, 2015).
In recent years, due to lack of understanding and effective management in terms of groundwater resources development and utilization, people in many places have overexploited the groundwater,making the dynamic, accurate and real-time monitoring groundwater level more imperative(WANG Zhan, 2015). At present, the domestic measurement is by manual stringing on-site and some simple field instruments, lagging far behind in terms of both equipment and the technical methods.The use of groundwater level automatic monitoring network to transfer data is convenient, with no restrictions and small error, which helps to improve work efficiency by saving manpower and material resources (ZHAO Feng, 2015).
When processing groundwater monitoring information, spatial information data is inevitably involved. To better manage those information, it is necessary to introduce the geographic information system. On this basis, developing an information processing application that is of a practical value and compatible with the geographic information system will have an important significance on improving efficiency and designing timely management measures (LIU Er-min et al. 2014).
The emerging technology of spatial database has developed along with the GIS development and application. It is an important part of geographic information system and the foundation of other parts of applications. Whether a geographic information system can obtain easily and accurately the required information from spatial database depends on the spatial databases organization and management. Therefore, a comprehensive and efficient geographic information system is practical only when the spatial database is reasonably designed (WANG Zongwen and YOU Su-nan, 2013).
Groundwater dynamic management requires not only a large amount of non-spatial data, but also abundant geospatial information. The conventional system can effectively manage non-spatial data, but fails on spatial location graphics data. To make up for this deficiency, the Arcview-based groundwater dynamic management software applies GIS and database technologies.The computer modeling of the geospatial space can help to realize the quick query and spatial analysis of geographic information, and achieve dynamic simulation and prediction of the research object more effectively. Therefore, compared to the conventional management system, it is more effective to conduct rich spatial data analysis and makes groundwater environment dynamics visual,which is beneficial to planning, management and decision-making about the groundwater resources.
1 System design analysis
ArcGIS’s Geodatabase is a Feature Datasets built in accordance with a certain models and by certain rules with a view to better managing and using geographic feature data. Geodatabase organizes data by hierarchical level of the data objects, which include Objects, Feature Classes,and Feature Datasets. Geodatabase can effectively manage the relationship between the geographic feature classes and the feature classes, the geometric network of geographic feature classes and others, and allows the establishment, deletion and modification of the feature datasets, the relationship and the geometric network. Due to the above-mentioned merits of Geodatabase, this paper designs a digital topographic map spatial database based on it (MENG Ge-ping et al. 2012).
1.1 Division of entities
GeoDatabase is an object-oriented spatial data model that allows users to add behaviors, attributes,and relationships to their data. The so-called object-oriented data model is that people can conduct all levels of decomposition of the geographical spaces according to their understanding of the real spatial world, and select the most basic operating units (point, line, polygon)according to the different spatial entities, thus realizing the structural and behavioral simulation of the real world that is closest to human thinking habits. In order to reflect the rationality of the design in the coding and achieve unified management on the physical storage of entities,this paper specially makes logical division of space entities when designing the database (Table 1). For the convenience of description, entity categorical identifiers are introduced: SP-IPOINT; DL,SL-IPOLYLINE; PG-IPOLYGON; TX-TEXT.

Table 1 Entity division table
1.1.1 Simple point
Simple point entities only record the insertion points’ location and associated attributes, and must be collected in the form of an insertion symbol.Simple point entity corresponds to the IPOINT object in the ARCOBJECT system. When using the simple point symbol, the collector must ensure that the symbol is consistent with the symbol description provided by this scheme, and that the insertion point of the symbol is also consistent(CHEN Zhi-yun, 2012).
1.1.2 Simple directional line
Simple directional lines require creating line symbols for each entity, in which the line symbols must be a symbol library provided by the collection system, rather than drawn by program. Simple directional line corresponds to the IPOLYLINE object in the ARCOBJECT system. Entities that apply fitting processing must avoid deform when output. Any two disjoint lines should not be too close, the minimum distance being 0.2 mm. There is direction restriction when collecting simple directional lines, the symbolized direction being the left side of the collection. Collection needs to accord with the international standards.Disconnection should be made if necessary so as to guarantee the perfect effect of the map.
1.1.3 Composite-line entity
A composite-line entity is a non-surface entity composed of multiple lines (some also include points). In the collection of composite entities,international standards must be followed to ensure the effect of drawing. Composite entity corresponds to the IPOLYLINE and IPOINT object in the ARCOBJECT system. If all of the composite entities are composed of solid lines, all the lines adopt a uniform encoding. If there are both solid lines and dotted lines, differentiated encoding of the two lines is needed. If the composite entity is composed of points and lines, in addition to the differentiated line encoding, the encoding is refined according to the entity type (LI Shen, 2012).
1.1.4 Polygon entity
The polygon entity corresponds to the IPOLYGON object in the ARCOBJECT system.The imageries required for this include:polygon-shape residential areas, stadium facilities,border surface, polygon-shape topography, and vegetation surface. The edge lines must be connected; if there is common edge with other ground objects, the common side line must fully overlap; if there is intersection with other ground objects, no intersection point is generated.Residential areas (RESRGN) only collect primary edges to ensure that lines are completely closed.Indoor facilities (INDRGN) only collect primary edges to ensure that lines are completely closed.Waterbodies (HYDRGN) must heed to the difference between the lines of user polygons and that of the waterbodies. Lines of Polygon waterbodies must be closed, while that of the waterbodies may not be closed, according to the results of field measurements. But it is important to note that the overlap of polygon lines and waterbody line must be entirely consistent. Border polygon (BOURGN) must ensure completely closed lines. The focus is to distinguish the border polygon lines from the border boundaries, and to make sure of the second collection of overlap areas and the completely same public side line.Vegetation (VEGRGN) polygon must ensure completely closed lines. It is important to distinguish edge lines of the polygon vegetation from land boundaries and lines of other ground objects, and to make sure of the second collection of overlap areas and the completely same public side line. At the same time, filled symbols for the vegetation must be expressed in the form of points.
1.1.5 Text
Text is managed in the form of points. Insertion point of text is the lower left point. Simple point entity corresponds to the IPOINT object in the ARCOBJECT system. The horizontal text can be an alphabetic string, while the vertical text must use a single character (GUO Yu-chuan, 2011).
1.2 Hierarchical design
This design will divide topographic features into ten categories based on the national standards on graphic decoration specifications. Each category then uses the entity categories (point, line, surface)provided by the GeoDatabase data model to determine the Hierarchical design for feature classes. At the same time, each category sets up a text layer for storing the various annotations. There are a total of 41 graphic layers (see part of them in Table 2-5): Measurement control points, control point marks, control point auxiliary lines, polygon residential area, linear ancillary facilities for houses,point-like ancillary facilities for houses, unit name mark points, residential area notes, linear industrial and mining construction and ancillary facilities(ZHANG Zai-ming, 2011).
All of the entity types in this design include only point (IPOINT), line (IPOLYLINE), and polygon(IPOLYGON). In each table: P represents point(IPOINT), L represents line (IPOLYLINE), R represents polygon (IPOLYGON). There is no“road centerline” in the traditional topographic map,but considering the analysis and query of the road attribute information, this paper puts it in a separate graphics. Given that the three-dimensional solid model is commonly generated by elevation points,contour lines and elevation points are specially placed in different graphics. Since in conventional digital topographic maps many lines are not closed,polygon graphics is difficult to convert directly into the database and requires use of other means(manual closure or additional programming).

Table 2 Measurement control points

Table 3 Residential area category

Table 4 Industrial and mining building category

Table 5 Transportation category
1.3 Attribute design
This design only defines the extended attributes for each layer of data, excluding the system default attributes (line width, line color, surface color,entity coordinates, entity size). The attribute table of each data layer table contains item of feature code (Code), which is categorical code of map features.
This design only includes the attributes of the objects available from the base topographic map.Attribute items do not have symbol name or line name; instead, symbols are named by code after symbols or lines are encoded one by one. The main reason behind that is to reduce memory occupation when calling database. The following conventions are used for the data type: C - character type (text), I- integer type (long integer), F - binary integer type(double precision type). The format used to represent the length of the floating point data is:“Digits before decimal point” + “.” + “digits after decimal point”.
Partial layer attributes are shown in Table 6-8 below:

Table 6 Measurement control points

Table 7 Linear auxiliary facilities for houses

Table 8 Residential areas notes
1.4 Groundwater level display of vertical and horizontal hydrological sections
The overall goal of the system is to use the water level data transmitted by the automatic monitoring system in the Shenmu County well-irrigation area to analyze the dynamic changes of groundwater level in the vertical and horizontal sections and grasp the changes in groundwater environment and mining conditions so as to guide and adjust the groundwater exploitation plans, and provide the necessary technical information for the protection of regional water environment. The specific functional design is as follows:
Dynamic display of groundwater level change in vertical and horizontal hydrological sections.First, the water level monitoring wells lay out four horizontal sections along the east-west direction to reflect groundwater level changes of different locations along the east-west direction in the same geomorphic unit. Then, three longitudinal section are set in the north-south direction to reflect groundwater level changes of different geomorphic units along the north-south direction. The detailed form is: Horizontal X axis represents different monitoring well numbers, and vertical Y axis represents groundwater level elevation value(YAN Jin-fenget al. 2010).
2 Overall thinking on system design
Based on Arc-view, the groundwater level information management system is based on the application of GIS and database technologies in the groundwater dynamic management of Shenmu County project area. It uses Arc-view GIS3.3 desktop software as the development platform,specially sets up an operational data theme (theme)of 14 groundwater monitoring points in the management project area, and connects them to the data transmitted from database-controlled monitoring points. From the aspect of realized functions, there are three function modules: Single well water level dynamic display, single well water flow calculation, section water level dynamic display. The Function module 1 is shown in Fig. 1.
Among them, information transmitted from the groundwater monitoring points are structured as Table 9, which will transfer, after processing, into groundwater monitoring points water level data.The data is stored in dbf form, then it can directly connect to the established theme of monitoring points, see the results in Table 10. During processing, if the water level information of ten days or twenty days fails to transfer into data results,data will be set as zero. Therefore, the monthly water level data cannot be calculated by simply adding up numbers and finding the average; rather,it requires rational judgment before getting the correct monthly average water level results (JIA Zheng-qiang, 2010).

Fig. 1 Flow chart of system design

Table 9 Groundwater level monitoring results

Table 10 Results of groundwater level data conversion
3 System functional design and realization
The system design language is the AVENUE programming language in Arc-view GIS.3.3.Functions of each module are as follows:
1) Single-well water level dynamic display
A. Write water level information processing program in AVENUE language with information data in Table 10, convert it into a data structure with time on the horizontal axis and well number on the vertical axis, and link it to the attribute table of water level monitoring theme via the Join command in the Arc-view. Data link is achieved as the common field values of the two tables splice them together. As data is linked to the theme attribute table, it becomes part of the table (John M Lorinc,1982).
B. Design the Arc-view interface and set on it four buttons for choosing monitoring wells,drawing curve, deleting curve, and exit.
C. Write single well water level graphic display program, and connect the program to the drawing curve button in the operation interface. The program should first determine the number of the selected monitoring wells and generate the corresponding characteristic curve of water level changes.
D. Write the corresponding programs for other operations.
2) Single-well water flow variation calculation
The 14 monitoring wells arranged in the project area form a groundwater level monitoring network that covers the entire area requiring monitoring.According to the hydrological and geological zoning and the principle of monitoring layout, the project is divided into 14 cells with monitoring wells as the center. Based on the data of groundwater level variations of a single well and the specific yield in each cell gained via groundwater resource analysis, the variation of groundwater flow in the cell is calculated. See Equation in Fig. 1. That is to say, variation of groundwater flow is determined by monitoring the water level changes in the single cell. Finally, the groundwater level monitoring network in the project area is used to monitor the approximate changes of groundwater flow in the whole area(Reichhardt, 1996).

in which, ∆W: Changes in groundwater reserves (10 000 m3);
µ: Specific yield;
F: Calculated area (km2);
∆h : Change of groundwater level amplitude in calculated area (m).
3) Section water level dynamic display
A. Write water level information processing program in AVENUE language with information data in Table 2, convert it into a data structure with time on the horizontal axis and well number on the vertical axis (Fig. 3. left), and link it to the attribute table of water level monitoring theme via the Join command in the Arc-view.
B. Design the Arc-view interface and set on it four buttons for choosing horizontal and vertical section number, drawing curve, deleting curve, and exit (James R Cannistra, 1991).
C. Write section water level graphic display program, and connect the program to the drawing curve button in the operation interface. The program should first determine the number of the selected sections and generate the corresponding characteristic curve of water level changes (Fig. 3 right).
D. Write the corresponding programs for other operations.

Fig. 2 Single-well water level dynamic display

Fig. 3 Characteristic curve of water level change in horizontal and vertical sections
4 Conclusion
The software in this paper realizes the change curve of cross-section water level in a certain period of time. If the water level data of the year and of the same period in history are drawn on the same map,the yearly cross-section water level changes and historical changes in the same period can be presented. Those graphics can provide basis for groundwater management decision-making, and also basic information for groundwater decisionmaking support systems. With the wider application of ArcView-based Geographic Information System(GIS) in resource management, environmental monitoring, disaster assessment, urban and regional planning, and other areas, it plays an increasingly important role in national economy and sustainable social development. This system is designed to develop a software application based on ArcView platform so as to support the groundwater level automatic monitoring and management, realize automatic analysis of attribute data, and provide a new, visual, and efficient automated management tool.
Acknowledgements
This work is supported by Hebei Province Universities Research Project (ZD2014023); Hebei Province Science and Technology Department Research Project (15273630); Hebei Province Graduate Student Innovation Fund Project(CXZZSS2017129).
杂志排行
地下水科学与工程(英文版)的其它文章
- A study on the supply relations of different groundwater in Qingdao subway line R3
- Hydrochemical and isotope characteristics of spring water discharging from Qiushe Loess Section in Lingtai,northwestern China and their implication to groundwater recharge
- The comprehensive evaluation on resource environmental bearing capacity of central cities in the Yellow River Delta-A case study on Dongying City
- Arsenic distribution and source in groundwater of Yangtze River Delta economic region, China
- Analysis on variation characteristics of geothermal response in Liaoning Province
- Research on the fault controlling mechanism of geothermal water in Zhangzhou Basin
