[postgis-users] shp2pgsql multipolygon weirdness
schabi at logix-tt.com
Wed Jun 4 07:07:51 PDT 2008
"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