[postgis-users] Geometry precision setting

2007-10-22 Thread Ramachandran
Hi, I would like to change Geometry precision setup, is it possible to change in postGIS? Actually, i need have precision of 5 digits after the dot placement in lat/lat with srid 4326 for example... 42.65832, 12.58464 Can anyone advise me, how to get this level of precision in postgis?

Re: [postgis-users] Geometry precision setting

2007-10-22 Thread Mark Leslie
Ramachandran wrote: Hi, I would like to change Geometry precision setup, is it possible to change in postGIS? Actually, i need have precision of 5 digits after the dot placement in lat/lat with srid 4326 for example... 42.65832, 12.58464 Can anyone advise me, how to get this

Re: [postgis-users] Re: PROJ Projection Issues

2007-10-22 Thread Mark Cave-Ayland
On Sun, 2007-10-21 at 17:57 -0600, Brian Timoney wrote: Paul: In the Windows install, there is the libproj.dll in the BIN directory but no other files with which have names that imply 'grid' or 'nad'. Unfortunately, we don't have an older Windows install in the office to compare to...

Re: [postgis-users] Re: Upgrade 1.2.1 to 1.3.1 - Problems

2007-10-22 Thread Mark Cave-Ayland
On Fri, 2007-10-19 at 00:48 -0700, Brian Hamlin wrote: Per-Olof My worst problem it seems is that I had expected the clear warnings as described in the README and doc. I just tried a freshly created DB, initialized with postgis 1.3.1 and got none of those terrible errors. So things are

[postgis-users] psql and jdbc give different result

2007-10-22 Thread temiz
hello String rs1ql4=select astext(wkb_geometry) from shey61_points where yuk_nokta=(select max(yuk_nokta) from shey61_points where heycat=?); by preparedStatement in jdbc Geometry g3 = wkbReader.read(WKBReader.hexToBytes(rs4.getString(1))); /// JTS

RE: [postgis-users] Repost: Intersection not working properly

2007-10-22 Thread Obe, Regina
Craig, Yes as Webb said - that would help a lot to see some of your problematic geometries. Looking at your query it looks perfectly fine. The only reason I can think why you would be missing polygons is your condition of a.buf_dist = 1 (I am assuming you are not expecting to see any

[postgis-users] Dynamic Bounding boxes

2007-10-22 Thread Obe, Regina
I'm just wandering about this since I have found work-arounds for this so its not much of a bother aside from when loading a new db. Is there a technical reason why we don't allow casting a BOX from a dynamic string (text) although you can from a static string (cstring). e.g. I can do this:

RE: [postgis-users] ESRI Shapes from database

2007-10-22 Thread Lee Keel
I want to thank everyone for their help. I finally talked the client into giving me superuser access, so I can continue with the way I have it now. As for the permissions, I have Select, insert, delete, update on the table in question, but it still throws an error for needing to be a superuser.

Re: [postgis-users] Re: PROJ Projection Issues

2007-10-22 Thread Frank Warmerdam
Mark Cave-Ayland wrote: The tricky part with distributing a set of the PROJ.4 datum files is how to tell PROJ.4 where to find them. Is there a PROJ.4 call that allows you to set PROJ_LIB dynamically? Mark, The pj_set_searchpath() function may be called to install a set of directories to

RE: [postgis-users] Problem with geodata storage

2007-10-22 Thread Lee Keel
-Original Message- From: [EMAIL PROTECTED] [mailto:postgis-users- [EMAIL PROTECTED] On Behalf Of Emilio Ponce Sent: Monday, October 22, 2007 11:10 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] Problem with geodata storage Hi everyone, here Emilio from

Re: [postgis-users] Problem with geodata storage

2007-10-22 Thread Matthew Perry
Emilio, The geometry is encoded in a binary format. In order to get the textual representation of the geometry use select AsText(the_geom) from - matt On 10/22/07, Emilio Ponce [EMAIL PROTECTED] wrote: Hi everyone, here Emilio from Barcelona, I've found a problem with my

RE: [postgis-users] Problem with geodata storage

2007-10-22 Thread Burgholzer,Robert
Emilio, That is the default storage now, binary. If you want the text representation, select AsTExt(calles_geom); Robert W. Burgholzer Surface Water Modeler Office of Water Supply and Planning Virginia Department of Environmental Quality [EMAIL PROTECTED] 804-698-4405 Open Source Modeling Tools:

[postgis-users] Geos broken

2007-10-22 Thread Gilles Bassière
Hi, I got no answer for the issue below. I also tried to post a message on the geos-devel mailing list but it seems like nobody listen to it :/ I'm still having the issue and I don't know how to track down the problem. Does anybody can help ? Thanks in advance Gilles Hi list, I try to

Re: [postgis-users] Problem with geodata storage

2007-10-22 Thread Emilio Ponce
Ok, that works :) Thank you 2007/10/22, Matthew Perry [EMAIL PROTECTED]: Emilio, The geometry is encoded in a binary format. In order to get the textual representation of the geometry use select AsText(the_geom) from - matt On 10/22/07, Emilio Ponce [EMAIL PROTECTED] wrote: Hi

[postgis-users] ST_Difference Syntax

2007-10-22 Thread Richard Heimann [C]
PostGIS users, I have failed at constructing the ST_Differnece operation. Can someone expose the proper syntax? Thanks Richard ___ postgis-users mailing list postgis-users@postgis.refractions.net