Hey all,
Does anyone if there is a way to extract a line from a MultiLineString?
I am trying to make the call
SELECT
line_interpolate_point(the_geom,line_locate_point(the_geom,PointFromText
('POINT(-74.5 40)'))) FROM roads ORDER BY
Distance(the_geom,PointFromText('POINT(-74.5 40)')) LIMIT 1
But I get the error
ERROR: line_locate_point: 1st arg isn't a line
My 'the_geom' field is filed with MultiLineString data (though only
LineString in each one).
Ex:
select AsText(the_geom) from roads limit 1;
astext
------------------------------------------------------------------------
------------------
MULTILINESTRING((-74.4595680236816 40.0301723480225,-74.4591522216797
40.0302429199219))
(1 row)
- Brian Peck
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
