[postgis-users] postgis-users Digest, Vol 83, Issue 1

Wed Jul 8 12:52:05 PDT 2009

Thanks Regina,

The -W "latin1" parameter fixed the problem.

Regards,
Mary Whelan
Arizona State University

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
postgis-users-request at postgis.refractions.net
Sent: Wednesday, July 08, 2009 12:00 PM
To: postgis-users at postgis.refractions.net
Subject: postgis-users Digest, Vol 83, Issue 1

Send postgis-users mailing list submissions to
	postgis-users at postgis.refractions.net

To subscribe or unsubscribe via the World Wide Web, visit
	http://postgis.refractions.net/mailman/listinfo/postgis-users
or, via email, send a message with subject or body 'help' to
	postgis-users-request at postgis.refractions.net

You can reach the person managing the list at
	postgis-users-owner at postgis.refractions.net

When replying, please edit your Subject line so it is more specific
than "Re: Contents of postgis-users digest..."

Today's Topics:

   1. Problem with records being stripped out (Mary Whelan)
   2. Re: Problem with records being stripped out (Paul Ramsey)
   3. Re: Problem with records being stripped out (Paul Ramsey)
   4. Re: Problem with records being stripped out (Paragon Corporation)
   5. Re: Problem with records being stripped out (Paragon Corporation)
   6. sslv3 alert illegal parameter (Pedro Doria Meunier)
   7. Recomendaciones para Instalacion (Z.M.)
   8. Re: Recomendaciones para Instalacion (Barend Kobben)
   9. PostGIS 1.4.0rc2 (Paul Ramsey)

----------------------------------------------------------------------

Message: 1
Date: Tue, 7 Jul 2009 15:51:22 -0700
From: Mary Whelan <Mary.Whelan at asu.edu>
Subject: [postgis-users] Problem with records being stripped out
To: <postgis-users at postgis.refractions.net>
Message-ID:

<7B71869DF503464E9E8BE92F6FF33355055CBC0F at EX01.asurite.ad.asu.edu>
Content-Type: text/plain; charset="us-ascii"

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://postgis.refractions.net/pipermail/postgis-users/attachments/2009
0707/f09b322c/attachment.html>

------------------------------

Message: 2
Date: Tue, 7 Jul 2009 15:55:09 -0700
From: Paul Ramsey <pramsey at cleverelephant.ca>
Subject: Re: [postgis-users] Problem with records being stripped out
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID:
	<30fe546d0907071555k598f1d3fk27694a65b0f7ea93 at mail.gmail.com>
Content-Type: text/plain; charset=windows-1252

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
>
>

------------------------------

Message: 3
Date: Tue, 7 Jul 2009 15:55:30 -0700
From: Paul Ramsey <pramsey at cleverelephant.ca>
Subject: Re: [postgis-users] Problem with records being stripped out
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID:
	<30fe546d0907071555y763fc83ahcb9a143e1ea3bb58 at mail.gmail.com>
Content-Type: text/plain; charset=windows-1252

And a version number of the software you are using.

On Tue, Jul 7, 2009 at 3:55 PM, Paul Ramsey<pramsey at cleverelephant.ca>
wrote:
> 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
>>
>>
>

------------------------------

Message: 4
Date: Tue, 7 Jul 2009 22:35:21 -0400
From: "Paragon Corporation" <lr at pcorp.us>
Subject: Re: [postgis-users] Problem with records being stripped out
To: "'PostGIS Users Discussion'"
	<postgis-users at postgis.refractions.net>
Message-ID: <59B8A95ACB8E4A9DBE0EF9A4C6B3322E at H>
Content-Type: text/plain;	charset="iso-8859-1"

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

------------------------------

Message: 5
Date: Tue, 7 Jul 2009 22:38:27 -0400
From: "Paragon Corporation" <lr at pcorp.us>
Subject: Re: [postgis-users] Problem with records being stripped out
To: "'PostGIS Users Discussion'"
	<postgis-users at postgis.refractions.net>
Message-ID: <2D9BDA320FAA488C97AFBF45CBF5E018 at H>
Content-Type: text/plain;	charset="iso-8859-1"

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

------------------------------

Message: 6
Date: Wed, 08 Jul 2009 11:08:59 +0100
From: Pedro Doria Meunier <pdoria at netmadeira.com>
Subject: [postgis-users] sslv3 alert illegal parameter
To: Postgresql Mailing List <pgsql-general at postgresql.org>, 	PostGIS
	Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <4A54703B.60002 at netmadeira.com>
Content-Type: text/plain; charset=ISO-8859-1

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,

My server started spitting this out every second!

LOG:  could not accept SSL connection: sslv3 alert illegal parameter

"PostgreSQL 8.3.7 on x86_64-redhat-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2 20070925 (Red Hat 4.1.2-33)"

Server key in place..

What can I do about it?!

TIA,

- --
Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org

iD8DBQFKVHAz2FH5GXCfxAsRAixyAJ9m3TxToFE1sNdeDz9SsB9IoU/Q9wCePy3T
Yicl2v5RsJ+D424U9L7bKvw=
=1j89
-----END PGP SIGNATURE-----

------------------------------

Message: 7
Date: Wed, 08 Jul 2009 08:33:09 -0300
From: "Z.M." <nramire1 at rosario.gov.ar>
Subject: [postgis-users] Recomendaciones para Instalacion
To: "postgis-users at postgis.refractions.net"
	<postgis-users at postgis.refractions.net>
Message-ID: <op.uwqydjavo7jdb6 at car-800>
Content-Type: text/plain; charset=utf-8

Hola a todos. 
Ayer me puse a instalar postgis en mi pc con WinXP. ya que mi
experiencia con linux no ha sido muy productiva.
Descargue la version PostGIS 1.3.6 Release 
Quise intalarla en la PostgreSQL 8.4.0-1 
No me lo quiso instalar porque me decia que no reconocia algo de la 8.4

?Sobre que version de PostgreSQL debo instalar PostGIS 1.3.6 Release?

-- 
  Z.M.

------------------------------

Message: 8
Date: Wed, 8 Jul 2009 14:10:43 +0200
From: Barend Kobben <kobben at itc.nl>
Subject: Re: [postgis-users] Recomendaciones para Instalacion
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <C67A5963.BD0A%kobben at itc.nl>
Content-Type: text/plain; charset="ISO-8859-1"

This is an english-language list...

On 08-07-09 13:33, "Z.M." <nramire1 at rosario.gov.ar> wrote:

> Hola a todos.
Ayer me puse a instalar postgis en mi pc con WinXP. ya que mi
> experiencia con linux no ha sido muy productiva.
Descargue la version PostGIS
> 1.3.6 Release
Quise intalarla en la PostgreSQL 8.4.0-1
No me lo quiso
> instalar porque me decia que no reconocia algo de la 8.4

?Sobre que version
> de PostgreSQL debo instalar PostGIS 1.3.6 Release?

--

> Z.M.
_______________________________________________
postgis-users mailing
> list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mail
> man/listinfo/postgis-users

International Institute for Geo-Information Science and Earth
Observation (ITC)
Chamber of Commerce: 410 27 560

E-mail disclaimer
The information in this e-mail, including any attachments, is intended
for the addressee only. If you are not the intended recipient, you are
hereby notified that any disclosure, copying, distribution or action in
relation to the content of this information is strictly prohibited. If
you have received this e-mail by mistake, please delete the message and
any attachment and inform the sender by return e-mail. ITC accepts no
liability for any error or omission in the message content or for damage
of any kind that may arise as a result of e-mail transmission.

------------------------------

Message: 9
Date: Wed, 8 Jul 2009 08:26:44 -0700
From: Paul Ramsey <pramsey at opengeo.org>
Subject: [postgis-users] PostGIS 1.4.0rc2
To: PostGIS Development Discussion
	<postgis-devel at postgis.refractions.net>, 	PostGIS Users
Discussion
	<postgis-users at postgis.refractions.net>
Message-ID:
	<30fe546d0907080826q67082376y2831b717de78f304 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

The second (and hopefully last) release candidate for the 1.4 release
of PostGIS is now available for download:

 http://postgis.refractions.net/download/postgis-1.4.0rc2.tar.gz

For an idea of what's new, please read the NEWS file:

 http://svn.osgeo.org/postgis/branches/1.4/NEWS

For all the latest goodies, make sure you first install the latest GEOS:

 http://download.osgeo.org/geos/geos-3.1.1.tar.bz2

We are hoping to release a Windows test build shortly, and the final
1.4 release soon after.

If you find issues with the release, please file a ticket:

 http://trac.osgeo.org/postgis

Thanks for your help testing! Your time checking PostGIS makes it a
better product for everyone.

Yours,

The PostGIS Team

------------------------------

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

End of postgis-users Digest, Vol 83, Issue 1
********************************************