[postgis-users] shp2pgsql multipolygon weirdness

[Markus Schaber]

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().


Regards,
Markus

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

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