基于PostGIS获取人员地理活动信息的设计与实现  

Design and implementation of getting geographic activity information of people based on PostGIS

作　　者：李志翔 LI Zhixiang(Meiya Yi'an Information Technology Co.,Ltd.,Xiamen,Fujian 361000,China)

机构地区：[1]美亚亿安信息科技有限公司,福建厦门361000

出　　处：《计算机应用文摘》2023年第15期31-33,共3页Chinese Journal of Computer Application

摘　　要：PostGIS是开源关系数据库系统PostgreSQL基于地理信息系统的扩展插件。文章分析对比了Oracle,MySQL与PostgreSQL3种空间数据库对地理信息系统的支持,并深入研究了PostgreSQL搭载PostGIS模型的架构与原理,最后基于研究结果,提出了一种基于PostGIS获取人员相关地理活动信息的方案,并对其进行了实现。PostGIS is an extension of the open source relational database system PostgreSQL based on geographic information system.The article analyzes and compares the support of Oracle,MySQL and PostgreSQL three spatial databases for geographic information systems,and deeply studies the architecture and principle of PostgreSQL-based PostGIS model.Finally,based on the research results,a scheme for obtaining personnel-related geographic activity information based on PostGIS is proposed and implemented.

关 键 词：POSTGIS POSTGRESQL 地理信息系统 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]