Refractions Research is pleased to announce the 0.6 release of
PostGIS : Geographic Objects for the PostgreSQL object-relational
database server. PostGIS/PostgreSQL is a spatial database much like
ESRI's SDE and Oracles OracleSpatial.
PostGIS/PostgreSQL includes the following functionality:
- Simple Features as defined by the OpenGIS Consortium (OGC)
- Support for Well-Known Text and Well-Known Binary representations
of GIS objects
- Fast spatial indexing using GiST
- Geospatial analysis functions
- PostgreSQL JDBC extension objects corresponding to the geometries
- Support for OGC access functions as defined by the Simple
The latest release increases OpenGIS standards support, upgrades
Mapserver support, and increases the number of accessor functions
For more information, see the PostGIS project web site at:
- PostgreSQL Version 7.1.x
(Version 7.2 and CVS versions of PostgreSQL will *not* work
due to changes in the GiST index interface. The next version
of PostGIS will move to PostgreSQL 7.2.)
- The PL/pgSQL server-side language must be installed before
- Version 0.6 includes numerous new functions bringing the system
closer to OpenGIS SQL standards. The SPATIAL_REF_SYS and
GEOMETRY_COLUMNS tables are now supported and maintainted.
SRIDs are included in all geometries, and functions check
for consistent SRIDs.
- The internal binary format has changed since version 0.5,
so a dump/restore of existing databases is *required*. See
the UPGRADING section of the README.
- The latest CVS version of Mapserver will be required if you
are using PostGIS as a Mapserver datasource. See
http://mapserver.gis.umn.edu/ for more information on
Mapserver and for CVS snapshots.
Return the PostGIS version number.
find_srid(<db/schema>::varchar, <table>::varchar, <column>::varchar)
Return the SRID number for a particular column of a database.
<column>::varchar, <srid>::integer, <type>::varchar,
Appends a geometry column to an existing table and updates the
metadata tables appropriately.
Removes a geometry column from an existing spatial table.
Returns the cartesian distance between two geometries.
Returns the OGC well-known text version of the geometry.
Returns the integer SRID of the geometry.
Creates a geometry object given the OGC well-known text and a valid
Sets the SRID of a geometry to a particular value.
Returns true of first and last points of geometry are coincident.
Returns the first point of a geometry.
Returns the last point of a geometry.
Returns the centroid of a geometry.
| Paul Ramsey
| Refractions Research
| Email: [hidden email] | Phone: (250) 885-0632
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Secure your servers with 128-bit SSL encryption! Grab your copy of VeriSign's FREE Guide, "Securing Your Web
site for Business" and learn all about serious security. Get it Now!