[postgis-devel] GEOS CAPI crash ?

[strk at refractions.net]

Sergio, weird enough I'm getting two completely different
results on two hosts (both GNU/Linux, both i386 32bit).

I've reduced the test to this:

	select geosnoop('GEOMETRYCOLLECTION(POINT(0 2),POINT(0 0))');

Can you confirm this still crashes the backend in your host?

I'm getting *both* a *success* and a *failure* with these setup:

 - PostgreSQL 8.0.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.3
 - POSTGIS="1.1.1CVS" GEOS="2.2.1-CAPI-1.0.1" PROJ="Rel. 4.4.8, 3 May 2004" USE_STATS

... still trying to find out any difference between the hosts ...

--strk;


On Thu, Jan 12, 2006 at 12:12:52PM +0100, strk at refractions.net wrote:
> In order to "explode" multi geometries you need to use the
> dump(geometry) function. This would return a set of basic components
> (POINT,LINE,POLYS). One you have these you can use distance()
> to find the nearest line to your point. Then you proceed
> with locate and interpolate.
> 
> --strk;
> 
> On Thu, Jan 12, 2006 at 09:04:47AM -0200, sergio at labtrans.ufsc.br wrote:
> > Hello again,
> > 
> >    My problem is the following one:  I need to interpolate a point with a
> > line, being that for this I possess two tables, I was trying to use the
> > following command:
> >   - SELECT line_interpolate_point(f.geom, line_locate_point(f.geom,
> > c.geom)) from railroad f, city c;
> >   Where geom of the railroad is a field MULTILINESTRING and geom of the city
> > is a field POINT, this command does not function, therefore the first
> > argument of line_locate_point must be LINE and not MULTILINESTRING, would
> > like to know if somebody possue some suggestion of as I can tranformar
> > this MULTILINESTRING in LINE or if exists some function that finds the
> > line next to a point and that it returns as resulted the point where the
> > original point is interpolated with the line.
> > 
> > grateful,
> > Sérgio Zarth Jr.
> > 
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> -- 
> 
>  /"\    ASCII Ribbon Campaign
>  \ /    Respect for low technology.
>   X     Keep e-mail messages readable by any computer system.
>  / \    Keep it ASCII. 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

 /"\    ASCII Ribbon Campaign
 \ /    Respect for low technology.
  X     Keep e-mail messages readable by any computer system.
 / \    Keep it ASCII.