Database Content Structure In GIS Environment


Initially, the national basic standards set on basic geographic information  14 was issued . The list of construction standards in the content of standardizing the national basic geographic information system is presented in Table 2.1.

Table 2.1. List of construction standards


TT

Standard name

Basis of application

1

Standard terminology

Terminology standard (ISO 19104)

2

Spatial reference system standards

Spatial Referencing by coordinates, by geographical identifiers (ISO 19111, 19112)


3


Data structure model standard

Conceptual schema language, Data model (ISO 19103, 19107, 19108, 19109)

4

Object Classification Standards

Feature Cataloguing & Feature and

Attribute Coding Catalog – FACC

5

Presentation and display standards

Portrayal and Symbolization (ISO 19117)

6

Data quality standards

space

Quality principles (ISO 19113)

7

Metadata Standards

Metadata (ISO 19115 and ANZLIC

version 1, FGDC)

8

Standards for encryption and data exchange

whether

Encoding, Data Exchange (ISO 19118,

DIGEST)

Maybe you are interested!

Database Content Structure In GIS Environment


Terminology Standard aims to standardize the concepts and phrases used in standardized documents; these terms are used as basic concepts to allow linking standardized contents together. Terminology standardization helps the parties involved in the construction and use of TDD to have a common language.

Standards on spatial reference systems: in Vietnam today, the standards on national reference systems and coordinate systems VN-2000 have been issued, creating a foundation


unified reference basis for measurement data in general and geographic information data in particular. This standard includes provisions on:

- Scope of application for all coordinate systems of all levels, topographic maps, base maps, cadastral maps, national administrative maps and other specialized maps.

- Parameters of the reference system: Global WGS-84 Ellipsoid has dimensions: rotational angular velocity, gravitational constant, positioning and national coordinate origin.

- Map projection grid: Use a horizontal cylindrical projection grid at right angles to the projection zone 30 with a length deformation ratio adjustment coefficient k0 = 0.9999; the central meridian depends on each specific locality and region.

Geographic data structure model standard: the standard on the data structure model will specify how the structure of geographic information data is organized and built. For basic geographic information applied according to the national geographic data structure model standard, technical documents and regulations for creating topographic maps of all scales include regulations on the representation of structural models, primitive data types, basic data structures, general geographic object models, etc.

Standards for classifying geographical objects: standards specify methods for classifying objects, standards for classifying objects will define types of geographical objects along with their attributes and relationships; standards clearly state the classification, identification, and meaningful content of each type of object, and also specifically describe the relationships between objects and the required attribute data of each object.

Geographic data representation standard: a standard that defines a mechanism that allows datasets to be presented in different ways without changing


Data content; construction methods based on published standards for digital map presentation and design and editing of standard symbol sets for the database.

Spatial data quality standards: this standard specifies the quality assessment process, data quality is divided into: quantitative quality and non-quantitative quality. Quantitative data quality factors include the completeness of objects, attributes and their relationships, logical consistency of concepts, domain values, format, topology, attribute relationships, accuracy of values, location, time..., non-quantitative data quality factors include the purpose, origin, application that the dataset has been used for.

Metadata: Metadata is a type of data that describes information related to the status of data in the database; this information indicates what data is being stored in the database, the method of data collection, processing and integration, the time of data construction, data update, data quality, data legality, data storage method, data access and distribution procedures.

Data encoding and exchange standards: spatial data needs to be encoded based on a certain rule in a computer understandable format, data encoding is considered in two aspects: for storage and for exchange. The standards on content model and data structure as described above create the basis for building a standard data set. The provincial HTTDL database basically complies with the National technical standards on geographic information issued by the Ministry of Natural Resources and Environment.

* Spatial data of water resources database uses VN-2000 National reference system and coordinate system:


- WSG-84 reference ellipsoid with dimensions:

+ Major semi-axis: 6,378,137 m;

+ Flatness: 298, 257223563;

- Map projection grid: Use a horizontal cylindrical projection grid at right angles to the projection zone 30 with a length deformation ratio adjustment coefficient k0 = 0.9999; the central meridian depends on each specific locality and region.

In the ArcGIS software system, the VN-2000 reference system parameters are specified as follows:

Table 2.2. VN-2000 reference system parameters


Projection: Transverse_Mercator

False_Easting: 500000.000000

False_Northing: 0.000000

Central_Meridian:

Scale_Factor: 0.999900

Latitude_Of_Origin: 0.000000

Linear Unit: Meter (1.000000)

Geographic Coordinate System: GCS_WGS_1984

Angular Unit: Degree (0.017453292519943299)

Prime Meridian: Greenwich (0.000000000000000000)

Date: D_WGS_1984

Spheroid: WGS_1984

Semimajor Axis: 6378137.000000000000000000

Semiminor Axis: 6356752.314245179300000000


In which the central meridian parameter (Central_Meridian) is changed according to the central meridian parameter of each province and region according to regulations.

- Resolution (XY Resolution) = 0.001 m.

2.3.1.4. Choosing construction software

Depending on the purpose and source of documents used, the water resources database must be selected on a suitable platform. The selected software must ensure:

- The software is popular but must be highly professional in creating databases.

- The software must handle digital maps well and is widely used today in research and production agencies.

- Data and display software can be linked together, exchanging data with each other.

- Tend to want to connect with digital map processing software such as ArcMap; MapInfo.

- The analysis and conversion of data according to administrative unit boundaries can be converted into a database according to hydrological units and performed through the functions of digital map processing software.

* Build database functions

Depending on the different types of data, the specific functions of each type of data are also different. However, the main problem is still storage, access and conversion. The construction of these functions is carried out from the perspective of "maximum friendliness" for convenience in using the database later with the criterion of least reference use (the basic interfaces can be seen in the main results section below). The functions of the database are built in groups


Create menus by writing code in Visual Basic Application, Macro, SQL of ACCESS...

* Database testing: testing of database functions is integrated into the database construction process.

2.3.1.5. Database content structure in GIS environment

The water resources database is built in a GIS environment, a geographic information software system developed by Esri (USA), expected to use ArcGIS version 10.2.2, managed in the national coordinate system VN-2000 using open ArcGIS software, allowing easy updating, editing, supplementing, decentralizing management, accessing and exploiting information.

Water resources database includes two main information blocks: spatial data and attribute data. To form the database content structure in GIS environment, it is necessary to:

* Collect and define software requirements

- Purpose: to determine functional and non-functional requirements of the software.

- Implementation steps

+ Collect software requirements: Collect functional requirements. Collect non-functional requirements.

+ Determine functional requirements:

Identify and describe the software actors. Identify and describe the use cases.

Identify factors that influence the complexity of each use case including: number of transactions, GIS technology application, inheritance.

+ Identify non-functional requirements:

Identify software development needs.


Determine the complexity of the software installation. Determine the security requirements.

Identify multi-user requirements. Identify other non-functional requirements.

+ Convert use cases.

* Detailed business modeling

- Purpose: to model in detail the processes and operations of an organization using UML language.

- Steps to follow:

+ Detailed modeling of processes and operations: Identify a list of business processes. Describe each business process in detail.

+ Build a business use - case diagram: Identify business use cases.

Identify business actors.

Identify the relationship between business actors and business use cases.

Identify relationships between business use cases.

* Design

- Purpose: to design detailed software based on the results collected and analyzed in the above steps. The product of this step is used for the programming and testing phase.

- Steps to follow:

+ Software architecture design.

+ Design use case diagrams.

+ Design activity diagram.


+ Design sequence diagram.

+ Design class diagram.

+ Database model design (database model design; enter sample data to test database model).

+ Software interface design.

- Product:

+ Database model in XML format.

+ Report explaining the database model.

+ Software interface design report.

* Programming

- Purpose: write source code based on detailed software designs.

- Steps to follow:

+ Write source code.

+Source code integration.

* Testing

- Purpose: to detect errors in the software and make repairs to ensure the software meets the requirements.

- Steps to follow:

+ Check source code according to coding convention.

+ Check ingredient levels.

+ Check system level.

2.3.2. Data entry and processing methods

The water resources database is built from the following 04 documents:

- Cadastral database (from the land database, select water resource data such as hydrological data: lakes, dams, dikes; point-type hydroelectric projects; river system comparison);

Comment


Agree Privacy Policy *