[Talk-ca] Errors importing NRN shapefiles

[Robert Shand]

Thanks Frank,

That worked a treat - now need to work out how to use RoadMatcher - any good documentation out there?  The stuff in the wiki is sparse at best.

B

On 2010-02-28, at 6:10 AM, steggink at steggink.org wrote:

> Hi Bob,
> 
> Can you try to add the option -W "latin1" ? (the -W needs to be uppercase)
> This will take care of the encoding. Probably the default encoding is  
> different from the one in the shapefile (which is always latin1).
> 
> HTH,
> 
> Frank
> 
> Citeren Robert Shand <bob at shand.org.uk>:
> 
>> Hi Everyone,
>> 
>> I'm once again playing with NRN import now that I have more free time.
>> 
>> I noticed I'm getting some errors importing the shapefile into my   
>> gis database
>> 
>> shp2pgsql -s 4326 NRN_PE_8_0_ROADSEG nrn_roadseg | psql -d gis -f -
>> 
>> <snip>
>> 
>> psql:<stdin>:16493: ERROR:  invalid byte sequence for encoding   
>> "UTF8": 0xe96527
>> HINT:  This error can also happen if the byte sequence does not   
>> match the encoding expected by the server, which is controlled by   
>> "client_encoding".
>> psql:<stdin>:16494: ERROR:  current transaction is aborted, commands  
>> ignored until end of transaction block
>> etc. etc.
>> 
>> Does anyone know how I can fix this error - or will I have to live   
>> with that data not making it into my database.
>> 
>> Thanks
>> 
>> Bob
>> 
>> 
>> _______________________________________________
>> Talk-ca mailing list
>> Talk-ca at openstreetmap.org
>> http://lists.openstreetmap.org/listinfo/talk-ca
>> 
> 
> 
> 
> _______________________________________________
> Talk-ca mailing list
> Talk-ca at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk-ca