[postgis-users] shp2pgsql multipolygon weirdness

Markus Schaber schabi at logix-tt.com
Wed Jun 4 07:07:51 PDT 2008

Hi, Robert,

"Burgholzer,Robert" <rwburgholzer at deq.virginia.gov> wrote:

> You're seeing binary. Some where along the way the storage of shapes in
> PostGIS was changed to that.

To be exact, the _storage_ was always in binary.

But the text representation used for dumps etc. was changed to
hex-encoded binary because of problems with rounding errors - there are
some broken floating point libs on some platforms that tend to round
differently when reading and writing, so dumping and reloading a table
would shift some coordinates a little.

Btw, to see the text representation, use asText() or asEWKT().


Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org

More information about the postgis-users mailing list