欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜:Formal mathematics/Isabelle/ML, Formal verification/Coq/Agda, C++/Erlang/Lisp
PostGIS
来自开放百科 - 灰狐
(版本间的差异)
小 (恢复到Allen的最后一次编辑) |
|||
第17行: | 第17行: | ||
psql -U postgres postgis | psql -U postgres postgis | ||
postgis=# SELECT postgis_version(); | postgis=# SELECT postgis_version(); | ||
− | + | ==initialization== | |
+ | *createlang plpgsql yourdatabase | ||
+ | *psql -f lwpostgis.sql -d yourdatabase | ||
+ | *psql -f spatial_ref_sys.sql -d yourdatabase | ||
==Links== | ==Links== | ||
*http://postgis.refractions.net | *http://postgis.refractions.net |
2008年2月25日 (一) 06:05的版本
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
分享您的观点