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

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

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.