[postgis-users] ST_Intersects(geom, geom) Memory issue

2012-02-03 Thread Andreas Forø Tollefsen
Hi again, I have a issue with the server crashing when running a simple query i have been using together with previous versions of postgis on the same system. The query intersects two tables with geometry. While i never have had problems with this query before, it is now terminates my postgresql

Re: [postgis-users] ST_Intersects(geom, geom) Memory issue

2012-02-03 Thread Andreas Forø Tollefsen
Hi again... Downgraded to revision 8001 and the query works. Query returned successfully: 162082 rows affected, 114992 ms execution time. Andreas 2012/2/3 Andreas Forø Tollefsen andrea...@gmail.com Hi again, I have a issue with the server crashing when running a simple query i have been

[postgis-users] Kosmo SIG and PostGIS 2.0

2012-02-03 Thread Jose Carlos Martinez
Hola, Si alguien está interesado he modificado el driver de Kosmo SIG2.0.1 para que soporte PostGIS 2.0 Para la instalación simplemente hay que sobreescribir el fichero saig.jar que está dentro del directorio bin de la instalación de Kosmo. El fichero [1] solo estará 7 dias disponible en

Re: [postgis-users] ST_Intersects(geom, geom) Memory issue

2012-02-03 Thread Paul Ramsey
Something in this chain of changes is probably the cause... P. On Fri, Feb 3, 2012 at 2:44 AM, Andreas Forø Tollefsen andrea...@gmail.com wrote: Hi again... Downgraded to revision 8001 and the query works. Query returned successfully: 162082 rows affected, 114992 ms execution time. Andreas

[postgis-users] Postgis for Postgres 64 bits

2012-02-03 Thread CARLOS MUÑOZ
hello, When is Postgis for Postgres in 64 bits? Thank you   Carlos J. Muñoz M. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] Postgis for Postgres 64 bits

2012-02-03 Thread pcreso
For Linux, it has been available for some years. If you need 64bit support, you might consider upgrading :-) Cheers Brent Wood --- On Sat, 2/4/12, CARLOS MUÑOZ cjmun...@yahoo.com wrote: From: CARLOS MUÑOZ cjmun...@yahoo.com Subject: [postgis-users] Postgis for Postgres 64 bits To:

[postgis-users] Rv: Postgis for Postgres 64 bits

2012-02-03 Thread CARLOS MUÑOZ
Great, For windows in 64 bits Its possible Postgis for Postgres? Thank you ;)   Carlos J. Muñoz M. Student Master GIS - Mensaje reenviado - De: pcr...@pcreso.com pcr...@pcreso.com Para: CARLOS MUÑOZ cjmun...@yahoo.com; PostGIS Users Discussion postgis-users@postgis.refractions.net

[postgis-users] Overlapping linestrings

2012-02-03 Thread Adam McManus
I'm looking for the fastest way to detect whether a given linestring overlaps another linestring. Here's my current approach. Given two tables: r1 and s1, both containing a geo_data column of linestring, first narrow the data (taking advantage of gist index) with r1.geo_data s1.geo_data, then

Re: [postgis-users] PostGIS support of Geography data type in java jdbc, driver?

2012-02-03 Thread SITRACK
Try hibernate spatial= Disclaimer: This email and any attachments thereof may contain confidential, privileged, proprietary, or otherwise private information. This email is intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient of the email

[postgis-users] enforce_dims_geom change between 1.3.3 and 1.4.0?

2012-02-03 Thread Brian Peschel
I have this geometric is a 1.3.3 PostGIS enabled database: st_npoints | st_astext +--- 3 | POLYGON((-97.288445 39.566748,-97.288188 39.566749,-97.288445 39.566748)) I

Re: [postgis-users] enforce_dims_geom change between 1.3.3 and 1.4.0?

2012-02-03 Thread Paul Ramsey
Crazily, we ended up with a situation for a while where the input checks were looser than the output checks, or could be depending on the output format you used. I hope we fixed it in later minor releases, try a later 1.4 release. P. On Fri, Feb 3, 2012 at 1:39 PM, Brian Peschel

Re: [postgis-users] shp2pgsql-gui and option -S (Generate simple instead of MULTI geometries) / Ticket #660?

2012-02-03 Thread Mark Cave-Ayland
On 30/01/12 08:32, Sandro Santilli wrote: On Mon, Jan 30, 2012 at 07:40:01AM +0100, Stefan Keller wrote: 2012/1/27 Sandro Santillis...@keybit.net: On Thu, Jan 26, 2012 at 09:50:25PM +0100, Stefan Keller wrote: ... Am I missing something? A ticket on the trac system, most likely :) So

Re: [postgis-users] Rv: Postgis for Postgres 64 bits

2012-02-03 Thread Bborie Park
Carlos, There is no official 64-bit Windows build of PostGIS (any version including 2.0) available due to build issues with mingw. You could try building it yourself with Visual Studio but you might be on your own. -bborie On 02/03/2012 11:45 AM, CARLOS MUÑOZ wrote: Great, For windows in

Re: [postgis-users] Rv: Postgis for Postgres 64 bits

2012-02-03 Thread Paragon Corporation
What people are interested in seeing a 64-bit windows build of PostGIS and willing to pay for it? We've heard a lot of people mention it, but unfortunately as Bborie said, we've run into some build issues with getting GEOS and GDAL to compile so its not trivial. A lot of the pieces we do have