[postgis-users] Problem with records being stripped out

[Paragon Corporation]

Typo I meant

shp2pgsql  -s 4269 -g the_geom -W "latin1" -a sometable public.sometable |
psql -d somedb -U someuser


Hope that helps,
Regina
-----Original Message-----
From: Paragon Corporation [mailto:lr at pcorp.us] 
Sent: Tuesday, July 07, 2009 10:35 PM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] Problem with records being stripped out

Mary,

Are you using the -W latin switch when loading?

I have on occasion forgotten to do this and lost some relevant parts of
Arizona, Florida, Texas and California in the process.  I forget what other
states.  Well enough to make people make comments like "Hmm I know there is
a big road right here where is it?".  This was loading census data so yes
I'm pretty sure there are latin type characters in there you lose if you
don't have that switch on and the error notice just sort of flys by.

Hope that helps,
Regina

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Tuesday, July 07, 2009 6:55 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Problem with records being stripped out

Not without some example data....

On Tue, Jul 7, 2009 at 3:51 PM, Mary Whelan<Mary.Whelan at asu.edu> wrote:
> We use a stack of GeoServer, PostGIS, and Open Layers.  When I try to 
> load certain shapefiles using the shp2pgsql command, PostGIS seems to 
> strip out some records but not all.  This happens with any US Federal 
> government shapefiles, I suspect ones derived from Census data (it
happened with Dept.
> of Agriculture and GNIS shapefiles today).  The error seems to 
> indicate an encoding problem, but when I look at the original 
> shapefile, there aren’t any accent marks or non-English characters.
> Can you help me understand what is happening and how to work around it?
>
>
>
> Thanks!
>
> Mary Whelan
>
> Arizona State University
>
>
>
> _______________________________________________
> 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