[postgis-users] segmenting the roads using ST_MakeLine

[tasha dewasi]

Hello,

I have table with following columns

CREATE TABLE Receiver
(
  utc_time double precision,
  latitude double precision,
  longitude double precision,
  velocity double precision,
  rec_geom geometry(Point,4326)
)

using lat/lon points (which is actually a road network travelled by a
vehicle), i need to divide this road network into 10m segment,
either, road network should be a connected link of segments, with a fixed
segment size of 10m.

i tried to do it using ST_MakeLine, but it is not giving me any appropriate
result. It is giving me whole lot of points, while i just need starting and
ending co-ordinates of segment.

I am using C# and my postgre,postgis versions are

"PostgreSQL 8.4.14, compiled by Visual C++ build 1400, 32-bit"
"POSTGIS="2.0.1 r9979" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.8.0, 6 March
2012" GDAL="GDAL 1.9.1, released 2012/05/15" LIBXML="2.7.8"
LIBJSON="UNKNOWN" TOPOLOGY RASTER"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130122/c48dfc26/attachment.html>