[postgis-users] St_intersection

Paul Ramsey pramsey at opengeo.org
Mon Mar 19 11:08:06 PDT 2012


Co-linearity.

On Mon, Mar 19, 2012 at 10:44 AM, Bob Pawley <rjpawley at shaw.ca> wrote:
> Hi
>
> I am querying a geometry looking for intersection point between a line and
> an other geometry.
>
> The return is 2 points and 2 linestrings. (when I use st_union a geometry
> collection results)
>
> Can anyone tell me under what conditions that a st_intersection would return
> a linestring??
>
> insert into num_search (the_geom3)
> select st_intersection(Num_Search.the_geom1, entities.wkb_geometry)
> from entities, Num_Search
> where Num_Search.seq = 'R'
> and st_intersects(entities.wkb_geometry, Num_Search.the_geom1) = True
>
> Bob
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



More information about the postgis-users mailing list