[Benchmarking] How to load spain shapefiles in postgis

[Andrea Aime]

On Wed, Jan 1, 2014 at 6:06 PM, Jeff McKenna
<jmckenna at gatewaygeomatics.com>wrote:

> On 2013-12-29 5:50 AM, Andrea Aime wrote:
> > Hi,
> > does anyone remember the command to load the last benchmarking effort
> > shapefiles
> > in postgis?
> >
> > I remember there were issues with the string encoding in the dbf, but I
> > can't seem to find
> > the right combination of db charset/shp2pgsql settings to have the
> > import work
> > successfully. Does anybody remember it?
> >
> > Cheers
> > Andrea
> >
>
> Happy new year to you and your family Andrea.
>
> If I remember, the trick I used was the -W <encoding> switch for
> shp2pgsql (you need to tell PG what encoding your dbf attributes are).
> Such as -W LATIN1    I think?
>

Ha! Yes, that's it! Tried a few charsets, but I guess I did not try this
one :-p
Thanks a lot!

Cheers
Andrea

-- 
*== GeoSolutions will be closed for seasonal holidays from 23/12/2013 to
06/01/2014 ==*

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/benchmarking/attachments/20140104/a9e4db2a/attachment.html>