[postgis-users] Encoding Issues shp2pgsql

[Travis Kirstine]

Hi All,
I have been trying to add a shpfile to postgis using the shp2pgsql
utility program, with little success.  The attribute info seems to be
fine however the coords of the_geom field are encoded incorrectly.
The source shpfile is in WGS84 geographic projection and I am running
the postgis on linux.  Any Ideas?

The .sql file:

BEGIN;
CREATE TABLE "lro_65_owner_parcel" (gid serial PRIMARY KEY,
"pin" varchar(9));
SELECT AddGeometryColumn('','lro_65_owner_parcel','the_geom','-1','MULTIPOLYGON',2);
INSERT INTO "lro_65_owner_parcel" ("pin",the_geom) VALUES
('029440218','010600000001000000010300000001000000060000006C09ABED6BD153C0B6
A94C7F66EB4540D27B711A65D153C03DB93F9D64EB454029C8F14C65D153C0BFBCFE
0462EB4540F257E2276CD153C06323D18263EB454055AB83F46BD153C0BE0F072566EB
45406C09ABED6BD153C0B6A94C7F66EB4540');


-- 
Travis K.

Toronto, Canada
------------------------------------------------------------
"She knows there's no success like failure
And that failure's no success at all."
-Bob Dylan-
------------------------------------------------------------