
Designing a database model of district-level land use planning with community consultation in Vung Tau city, Ba Ria - Vung Tau province
Author(s) -
Linh D. T. Truong
Publication year - 2021
Publication title -
the journal of agriculture and development/the journal of agriculture and develoment/nông nghiệp và phát triển
Language(s) - English
Resource type - Journals
eISSN - 2615-949X
pISSN - 2615-9503
DOI - 10.52997/jad.7.04.2021
Subject(s) - database , land use planning , computer science , spatial database , land use , data access layer , sql , data model (gis) , data modeling , geography , spatial analysis , remote sensing , civil engineering , engineering , artificial intelligence
Nowadays, building a land database and land use planning database is an indispensable requirement, especially for a seaport city as Vung Tau city (Ba Ria - Vung Tau province) where there are complex land fluctuations. Accordingly, a complete land use planning database with the participation of community will contribute to connecting planners, managers and people, and increase the publicity, transparency and feasibility of land use planning options. The study designed a database model of land use planning with the community consultation for Vung Tau city in accordance with the land data standards of Circular No. 75/2015/TT-BTNMT. Based on the designed model, a set of land use planning database with high accuracy was created and it was in line with the data standards of the Ministry of Natural Resources and Environment and the designed database model. This database structure contained 22 spatial data tables on ArcGIS and 8 attribute data tables (with the community consultation) on Microsoft SQL Server. Finally, we successfully used the VBDLIS software to build the land use planning database (period 2010 - 2020) for Vung Tau city with 6 data layers, including land use planning data layer (15.060 records), project layer (163 records), adjustment layer for land use planning (12.002 records), adjustment layer for project (570 records), and 2 attribute data layers of community consultation. The results of this study indicated that the correct model and complete database structure were the basis for successfully building and effectively exploiting the database of land use planning. The designed model could contribute to the planning of land management and improve the efficiency of land use.