基于SQL数据库的行政区划地理信息的识别研究

Research on the Arithmetic of Geographic Regionalism based on SQL Server

为适应基于数据库的GIS应用开发,提出了在SQL数据库中重新组织并存储电子地图数据,并展开无需依赖GIS二次开发组件的空间数据处理算法的研究。根据行政区划信息在电子地图中的表现形式,本文首先面向图层讨论了区域对象的数据结构,为其设计了数据库结构模型,并创建了全国行政区划信息数据库。然后根据目标点的区域识别原理详细讨论了基于T-SQL语法的实现步骤,设计并实现了多级行政区划信息的识别算法。实验结果表明,本算法能够有效地识别目标点所属行政区域的多级区划信息,具有识别率高、处理时间短且资源占用少的特点。

For further using in the GIS application based on database,a new idea was proposed to build a relational database that stores spatial data as much as those in the MapInfo digital map and do some research work on spatial data with no dependence on commercial GIS components for secondary development. Focusing on the regional objects within the map layer which describes geographic regionalism, their data structures are studied and the database model is designed for re-storing those spatial data. And the database for national geographic regionalism is built in SQL Server. Then,the principle of regional recognition is proposed and steps to do the recognizing work with T-SQL are discussed. Finally the arithmetic of regionalism recognizing for multi-level is designed in details and implemented into the practice. Experimental results show that this arithmetic is capable of recognizing geographic regionalism where the target position locates, with high accuracy, short processing time and low consumption of system resources.