Re: [postgis-users] Out of Memory problem for large table by ST_Contains(..)

2008-10-22 Thread Paul Ramsey
This should be fixed when 1.3.4 comes out. An rc2 will be out tomorrow you can try. P. On Tue, Oct 21, 2008 at 3:28 PM, John Zhang [EMAIL PROTECTED] wrote: Hello list, I am writing to seek your input on how to handle such an issue: I have a large table containing over 3 million polygons and

Thank you mailto me. Re: [postgis-users] Postgis problem : Can not compile the code successful

2008-10-22 Thread John
Hello Kevin: Thanks you send message to me, these days I solve one problem; In Postgis DOCUMENTATION,the source code is: ((org.postgresql.Connection)conn).addDataType(geometry,org.postgis.PGgeometry); the right code is:

RE: [postgis-users] making a circle with radius in meters, and la t/lon position

2008-10-22 Thread Lucas Antoine (External)
Hi, Indeed, making a buffer in my SRID (4326) will not makes a perfect circle. But how to make a circle then ? area = transform(Buffer(transform(GeomFromText('POINT(0.0 20)',4326), 2163) ,100), 4326) should be the correct function (point in lat / lon, transformed in

[postgis-users] postgis geometry to gml conversion ?

2008-10-22 Thread Smith Roman
Hi,   how can I transform the result of a pgrouting query to gml ? The result of my pgrouting query will be a collection of linestrings representing a route.. How can i do this in java ?   thanks,   Smith ___ postgis-users mailing list

[postgis-users] Help in query PostGIS

2008-10-22 Thread Manuela . Pastorelli
Qualcuno mi sa aiutare? Devo fare delle query di test, per confrontare i risultati ottenuti con Oracle piuttosto che con PostGIS. Non riesco però a trasformare da Oracle a PostGIS le query che lavorano con le SDO_UTIL, in particolare tutto quello che riguarda i vertici (GetNumVertices, ad

[postgis-users] RE: [postgis-devel] Help in query PostGIS

2008-10-22 Thread Obe, Regina
Manuela, GetNumVertices - ST_NPoints MakePolygonToLine - ST_Boundary ? http://postgis.refractions.net/documentation/manual-svn/ch07.html#id2840873 Per il futuro, meglio solo post postgis-users e anche in inglese se potete. (For the future, only post to postgis-users and also in

[postgis-users] Table w/existing geometry column (without AddGeometryColumn), SRID?

2008-10-22 Thread Stefan Keller
Dear all, When creating a new table with a geometry column, most of the instructions say: 1. create a non-spatial table 2. add a spatial column to the table using the AddGeometryColumn function. Now I've encountered at least three situations in which a table with all columns - including the

Re: [postgis-users] Table w/existing geometry column (without AddGeometryColumn), SRID?

2008-10-22 Thread Kristian Thy
On Thu, Oct 23, Stefan Keller wrote: * Is there a trick to add metadata to the geometry_columns table, given a table already exists with one geometry column? It is trivial to insert it manually, but I would like to add my vote for a RegisterGeometryColumn(...) function for easing the process.