[postgis-users] Shape File data loader

[Paul Ramsey]

Jeff,
Your string is a PostGIS 1.0 string, and your PostGIS is 0.9. So either 
upgrade your database or downgrade your shp2pgsql. (You probably have a 
0.9 shp2pgsql sitting around somewhere, I assume you installed a PostGIS 
1.0 over top of a 0.9 from the pginstaller.)
Also, please keep conversations on the list, so everyone can understand 
and learn.
Thanks,
Paul

Jeff Grice wrote:

> Hi Paul,
> 
> The error it is returning is :
> "ERROR:  couldnt parse objects in GEOMETRY"
> 
> I looked at the insert and it is trying to insert
> 
> 'SRID=27700;0106000000010000000103000000010000000C000000CE839759D1741F41
> 876C93540BAD07418848B41979711F41D7B1A8028CA40741493C5775FE641F41D28B370E
> E7A20741BDCF19F412601F41BEA7C867DDB40741ED0D7BA0F3541F414031AE7EA2BB0741
> 9AD8C27908591F415226B2A0B2CE0741FD904E8E354F1F4127B9EB8484D8074116E948F3
> 81551F411A4E74D510F90741D077EED58D631F41EC2A1C9E26FA07411D5E1B4625721F41
> 6FAFAC69B7C507410B41A98715791F41A37EDD6ED2CD0741CE839759D1741F41876C9354
> 0BAD0741'
> 
> Into the geometry column.
> 
> Should this string be wkt format?
> 
> My shape file is in British National Grid format; could that be a
> problem?
> 
> Any help would be much appreciated.
> 
> J
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
> Ramsey
> Sent: Monday, June 20, 2005 15:25
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Shape File data loader
> 
> You'll have to get the front of your error log to find the "interesting"
> 
> error message. Try running sql file in pgadin, you might find it easier 
> to see the first error.
> P
> 
> Jeff Grice wrote:
> 
> 
>>Hello all,
>>
>> 
>>
>>I am a new PostGIS user and had a question regarding loading data into
> 
> 
>>the database using the shp2pgsql.
>>
>> 
>>
>>I am running PostgreSQL 8.0.2 and PostGIS 0.9 on WindowsXP.
>>
>> 
>>
>>I issue the following command:
>>
>> 
>>
>>Shp2pgsql -s 27700 level5streets.shp lv5_street GIS_db > streets.sql
>>
>>Psql -d GIS_db -f lv5_street.sql
>>
>> 
>>
>>The shp2pgsql command executes and generates the *.sql file, but when
> 
> I 
> 
>>run the psql command it returns an error for each record :
>>
>> 
>>
>>ERROR: current transaction is aborted, commands ignored until end of 
>>transaction block
>>
>> 
>>
>> 
>>
>>Any ideas on where I am going wrong?
>>
>> 
>>
>>TIA,
>>
>> 
>>
>>Jeff Grice
>>
>>
>>
> 
> ------------------------------------------------------------------------
> 
>>_______________________________________________
>>postgis-users mailing list
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users