[postgis-users] trouble with moving data

[Mark Cave-Ayland]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Sears, Jeremy
> Sent: 16 November 2005 17:02
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] trouble with moving data
> 
> 
> Mark,
> 
> Ive managed to get data into the database. All seemed to go 
> well, I can connect to the new db via QuantumGIS and view the 
> data without problem. However, my geometry column is messed 
> up. In the old db the column contained regular looking 
> entries, in the new db I have what appears to be binary or 
> hex entries, this is an example of what the geom_col contains :
> 
> 010600002040A50000010000000103000000020000005B020000000000602F
> 1224C1000000A0
> F4F9294100000060691224C1000000E0FDF92941000000A0721224C1000000
> E0C3F929410000
> 00A0AC1224C100000020CDF92941000000A0E61224C100000060D6F9294100
> 000060DD1224C1
> 0000006010FA294100000060171324C1000000A019FA29 ... and on ..
> 
> This seems highly abnormal. Any Ideas?
> 
> Many Thanks
> Jeremy


Hi Jeremy,

Don't worry this is normal with PostGIS 1.0. The reason this was changed to
an encoded format was because we had complaints from users loading and
restoring dumps that the points would move after the restore because of the
lossiness of conversion from floating point -> text -> back to floating
point.

If you want to see the EWKT(PostGIS enhanced) or WKT(OGC compliant)
representations simply do:

	SELECT AsEWKT(geom) FROM geom_table
Or	SELECT AsText(geom) FROM geom_table


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk   
http://www.infomapper.com 
http://www.swtc.co.uk  

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.