[postgis-users] ST_Intersection

Hi, I have a polygon table (alk_flurstuecke) and create a view with a 40-meter buffer on an object: CREATE VIEW buffer_flur_40 AS SELECT gid, ST_SetSRID(st_buffer(the_geom,40), 31466 ) AS the_geom FROM alk_flurstuecke WHERE fkz = '072690033000230'; No problem, Ican see it in QGIS. Now I

[postgis-users] Create View From Spatial Table with libpq

Hi ! I try to create a view from a spatial table, but it can't be done successfully, please give me some hints. Here is how I create my spatial table: *CREATE TABLE table_name (ID SERIAL PRIMARY KEY); SELECT ADDGEOMETRYCOLUMN('', 'table_name', 'geocol', -1, 'MULTIPOLYGON', 2); * After I

[postgis-users] rakesh modi wants to chat

I've been using Google Talk and thought you might like to try it out. We can use it to call each other for free over the internet. Here's an invitation to download Google Talk. Give it a try! --- rakesh modi wants to stay in

Re: [postgis-users] ST_Intersection

Hi, I have a polygon table (alk_flurstuecke) and create a view with a 40-meter buffer on an object: CREATE VIEW buffer_flur_40 AS SELECT gid, ST_SetSRID(st_buffer(the_geom,40), 31466 ) AS the_geom FROM alk_flurstuecke WHERE fkz = '072690033000230'; No problem, Ican see it in QGIS.

Re: [postgis-users] ST_Intersection

Nicolas, Is the select used to create the view returning rows ? yes, I want to get the intersected parts of the polygonlayer and the area (I need the returned rows in a php application) Is this IsEmpty test necessary to validate there is an intersection ? yes, because I want only the

Re: [postgis-users] ST_Intersection

hi, why don't you merge both operations into one sql-command? In this case it's less difficult without using views. 2010/5/21 jj@gmx.de Hi, I have a polygon table (alk_flurstuecke) and create a view with a 40-meter buffer on an object: CREATE VIEW buffer_flur_40 AS SELECT gid,

[postgis-users] Retrieving and storing Geography column data through JDBC (Java/Hibernate)

Hi all, We used the GeometryType Hibernate UserType that gets delivered with Postgis 1.5 (java/ejb3) to store and retrieve Geometry column data. This works fine but unfortunately it does not seem to support the new Geography data type. We tried storing Point and LineString Geometry objects (SRID

Re: [postgis-users] How To build postGIS on debian with pbuilder?

Stephen Woodbridge wrote: Does anyone know how to build postGIS using pbuilder on Debian lenny. I have been about to build geos-3.2.0 and proj-4.6.1 Get the usual suspects like GEOS and PROJ.4 from the fine http://debian.gfoss.it/ and feel free to check if the packages at this location are

Re: [postgis-users] Retrieving and storing Geography column data through JDBC (Java/Hibernate)

You should file a ticket on it... I think if you create a function geography(bytea) that just call the ST_GeogFromWKB() function that should get around your casting problem. CREATE OR REPLACE FUNCTION geography(bytea) RETURNS geography AS 'SELECT ST_GeogFromWKB($1)'

[postgis-users] HELP WITH A POSTGIS FUNCTION

Which postgis function is used to return the amount of vertexes (in an array) I got in my geometry? Thanks. -- View this message in context: http://old.nabble.com/HELP-WITH-A-POSTGIS-FUNCTION-tp28635185p28635185.html Sent from the PostGIS - User mailing list archive at Nabble.com.

Re: [postgis-users] HELP WITH A POSTGIS FUNCTION

http://postgis.org/documentation/manual-1.5/ST_NumPoints.html On Fri, May 21, 2010 at 10:15 AM, Bolivar bdg...@gmail.com wrote: Which postgis function is used to return the amount of vertexes (in an array) I got in my geometry? Thanks. -- View this message in context:

[postgis-users] help

Hey guys i am having trouble connecting postgis to mapser, could anyone please give me directions on the same. what version of mapsever do i need? i am working with postgresql 8.4 thanks -- With regards, Linnet Kwamboka +254733229041 site: geekmates.ning.com blog: one-kenya.blogspot.com

[postgis-users] RE help

Do you mean that you want to read postgis data with mapserver? Perhaps this will help http://mapserver.org/input/vector/postgis.html steve Linnet Kwamboka scientific1qu...@gmail.com@postgis.refractions.net Envoyé par : postgis-users-boun...@postgis.refractions.net 03/05/2010 03:37 AM

[postgis-users] Check identical point

Hello I want to check if two points are identical, the points has x,y,z coordinates and they are not exactly the same, i need to check the intersection between them with tolerance value. any direction of how to do that. Thank kind regards

Re: [postgis-users] Check identical point

Try: ST_DWithin(point1, point2, 0.1) -F 2010/5/22 eehab hamzeh eeha...@hotmail.com Hello I want to check if two points are identical, the points has x,y,z coordinates and they are not exactly the same, i need to check the intersection between them with tolerance value. any