Thanks Regina, The -W "latin1" parameter fixed the problem.
Regards, Mary Whelan Arizona State University -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, July 08, 2009 12:00 PM To: [email protected] Subject: postgis-users Digest, Vol 83, Issue 1 Send postgis-users mailing list submissions to [email protected] 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 [email protected] You can reach the person managing the list at [email protected] 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 <[email protected]> Subject: [postgis-users] Problem with records being stripped out To: <[email protected]> Message-ID: <[email protected]> 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 <[email protected]> Subject: Re: [postgis-users] Problem with records being stripped out To: PostGIS Users Discussion <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset=windows-1252 Not without some example data.... On Tue, Jul 7, 2009 at 3:51 PM, Mary Whelan<[email protected]> 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > ------------------------------ Message: 3 Date: Tue, 7 Jul 2009 15:55:30 -0700 From: Paul Ramsey <[email protected]> Subject: Re: [postgis-users] Problem with records being stripped out To: PostGIS Users Discussion <[email protected]> Message-ID: <[email protected]> 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<[email protected]> wrote: > Not without some example data.... > > On Tue, Jul 7, 2009 at 3:51 PM, Mary Whelan<[email protected]> 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 >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> > ------------------------------ Message: 4 Date: Tue, 7 Jul 2009 22:35:21 -0400 From: "Paragon Corporation" <[email protected]> Subject: Re: [postgis-users] Problem with records being stripped out To: "'PostGIS Users Discussion'" <[email protected]> Message-ID: <59b8a95acb8e4a9dbe0ef9a4c6b33...@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: [email protected] [mailto:[email protected]] 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<[email protected]> 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users ------------------------------ Message: 5 Date: Tue, 7 Jul 2009 22:38:27 -0400 From: "Paragon Corporation" <[email protected]> Subject: Re: [postgis-users] Problem with records being stripped out To: "'PostGIS Users Discussion'" <[email protected]> Message-ID: <2d9bda320faa488c97afbf45cbf5e...@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:[email protected]] 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: [email protected] [mailto:[email protected]] 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<[email protected]> 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users ------------------------------ Message: 6 Date: Wed, 08 Jul 2009 11:08:59 +0100 From: Pedro Doria Meunier <[email protected]> Subject: [postgis-users] sslv3 alert illegal parameter To: Postgresql Mailing List <[email protected]>, PostGIS Users Discussion <[email protected]> Message-ID: <[email protected]> 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." <[email protected]> Subject: [postgis-users] Recomendaciones para Instalacion To: "[email protected]" <[email protected]> Message-ID: <op.uwqydjavo7j...@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 <[email protected]> Subject: Re: [postgis-users] Recomendaciones para Instalacion To: PostGIS Users Discussion <[email protected]> Message-ID: <c67a5963.bd0a%[email protected]> Content-Type: text/plain; charset="ISO-8859-1" This is an english-language list... On 08-07-09 13:33, "Z.M." <[email protected]> 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 [email protected] 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 <[email protected]> Subject: [postgis-users] PostGIS 1.4.0rc2 To: PostGIS Development Discussion <[email protected]>, PostGIS Users Discussion <[email protected]> Message-ID: <[email protected]> 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users End of postgis-users Digest, Vol 83, Issue 1 ******************************************** _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
