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,

Re: [postgis-users] point to multipoint

.. don't ask why im not just using min(st_distance) to solve that nearest thing problem :) you should know that all the unioned points are having the same coordinates. 2009/11/26 Mehmet Sirin m.siri...@googlemail.com hi, is someone out there who can explain how to make several points

[postgis-users] point to multipoint

? then i love you^^ leaving you kind regards mehmet sirin c. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

[postgis-users] Intersection between segments in multilinestring

Hi, I'm trying to dicern equally named ways in different areas. For that I have to know which segments in the multilinestring or collection are connected to each other and which not. Of course I could create a function that checks all parts that have the same name if there is a touch to each

Re: [postgis-users] ST_UNION - Exception in LWGEOM2GEOS

...@postgis.refractions.net [mailto: postgis-users-boun...@postgis.refractions.net] *On Behalf Of *Mehmet Sirin *Sent:* Monday, October 26, 2009 7:24 PM *To:* PostGIS Users Discussion *Subject:* [postgis-users] ST_UNION - Exception in LWGEOM2GEOS Hi, I just tried to create a mutlilinestring out of a set

[postgis-users] ST_UNION - Exception in LWGEOM2GEOS

ones of this kind in my database). Anybody can tell me why these sort of ways leads to a problem? thank you kind regards mehmet sirin ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo

Re: [postgis-users] find nearest point on line where distance to point not on line is minimum - or lets say drop a perpendicular on the nearest line through a given point

hi, i think you're searching this: http://pgrouting.postlbs.org/wiki/LoadingtheCode4 bye 2009/10/16 Marco Lechner - FOSSGIS e.V. marco.lech...@fossgis.de hi, I try to find a way to solve this problem in postgis. I have a table with lines an coorindates of a point that needn't to be on a

[postgis-users] Linestring to Multilinestring

linestrings. Too bad that St_union only accepts 2geometries: ST_UNION(ST_GeomFromText(geometry1, geometry2) ) And thats where my problem starts. Anybody knows how to merge more than 2 Linestring into a Multilinestring? I'm using Postgis 1.3 best regards Mehmet Sirin

[postgis-users] Transforming Linestring to Multipoint

that. i would appreciate your help!! Best regards Mehmet Sirin ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] Transforming Linestring to Multipoint

pointn( geometryn(the_geom, 1), generate_series(1, numpoints(geometryn(the_geom, 1))) ) Hi, that means if there is a Linestring, e.g. LINESTRING ( x1 y1, x2 y2, x3 y4 ) this function will Return 3 Points. But my itention was: If I have a LINESTRING ( x1 y1, x2 y2, x3 y4 ), I want to add a

Re: [postgis-users] Transforming Linestring to Multipoint

:D Okay, I think this is what I need! I never thought it would be that simple! thanks!! 2009/9/27 strk s...@keybit.net On Sun, Sep 27, 2009 at 10:47:40PM +0200, Mehmet Sirin wrote: so: transforming LINESTRING ( x1 y1, x2 y2, x3 y4 ) to LINESTRING ( x1 y1, x2 y2, x3 y4, x4 y4, x5 y5