PostGIS

来自开放百科 - 灰狐
2008年2月25日 (一) 06:05Allen (讨论 | 贡献)的版本

跳转到: 导航, 搜索

PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS follows the OpenGIS "Simple Features Specification for SQL" and has been certified as compliant with the "Types and Functions" profile.

Install

When you install PostgreSQL, do not install the PostGIS included in the PostgreSQL installer, it is often a few versions behind.Instead, use the separate PostGIS installer.

Linux & UNIX

tar xvfz postgis-1.3.1.tar.gz
cd postgis-1.3.1
./configure
make
make install
createlang plpgsql yourtestdatabase
psql -d yourtestdatabase -f lwpostgis.sql
psql -d yourtestdatabase -f spatial_ref_sys.sql

or Windows

http://postgis.refractions.net/download/windows/
psql -U postgres postgis
postgis=# SELECT postgis_version();

initialization

  • createlang plpgsql yourdatabase
  • psql -f lwpostgis.sql -d yourdatabase
  • psql -f spatial_ref_sys.sql -d yourdatabase

Links

分享您的观点
个人工具
名字空间

变换
操作
导航
工具箱