Re: [postgis-users] Check identical point

Try: ST_DWithin(point1, point2, 0.1) -F 2010/5/22 eehab hamzeh > 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

[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 _

[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 @postgis.refractions.net Envoyé par : postgis-users-boun...@postgis.refractions.net 03/05/2010 03:37 AM Veuillez répondre à PostGIS Users

[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 facebook

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 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: > http://old.nabble.com/HE

[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] 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)' LANGUAG

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 a

[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] 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 > 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(s

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 inters

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

[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 bett

[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 inse

[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 t