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, [email protected] 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 <[email protected]>: > >> 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 >> [email protected] >> http://lists.openstreetmap.org/listinfo/talk-ca >> > > > > _______________________________________________ > Talk-ca mailing list > [email protected] > http://lists.openstreetmap.org/listinfo/talk-ca _______________________________________________ Talk-ca mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk-ca
