Hey, the order by has to be on the same statement of your ST_makeline, or the order could be wrong.
Morevover, the order by should order the Point3D CTE because you want (points3d.geom) to be ordered, not line or others. Cheers, rémi-C 2014-05-11 13:30 GMT+02:00 Hugues François <[email protected]>: > I don't have any available data and not enough time for now but you may > try the same query but without all "with" statements for the final one ( > SELECT ST_MakeLine(geom) FROM points3d). You can also add a serial column > in the points3d with to keep the ordering information. > > Hug > > Le 11 mai 2014 13:05, georgew <[email protected]> a écrit : > > > > Thank you Hugues (and my apologies for using the wrong name), if I > understood > > you correctly this is what the code should look like: > > > > WITH line AS > > (SELECT geom from foot_cl where (sheet='AT24' AND sid=463)), > > cells AS > > (SELECT ST_Centroid((ST_Intersection(at24.rast, line.geom)).geom) AS > geom, > > (ST_Intersection(at24.rast, line.geom)).val AS val > > FROM at24, line > > WHERE ST_Intersects(at24.rast, line.geom)), > > points3d AS > > (SELECT ST_SetSRID(ST_MakePoint(ST_X(cells.geom), ST_Y(cells.geom), val), > > 2193) AS geom > > FROM cells, line ORDER BY ST_Distance(ST_StartPoint(line.geom), > cells.geom)) > > SELECT ST_MakeLine(points3d.geom) FROM points3d,line,cells > > > > The result is exactly the same as before as you can see here: > > makeline.png <http://postgis.17.x6.nabble.com/file/n5006270/makeline.png > > > > > > But it should look as follows (after replacing makeline with the points): > > > > points.png <http://postgis.17.x6.nabble.com/file/n5006270/points.png> > > > > Thank you for your help > > > > > > > > -- > > View this message in context: > http://postgis.17.x6.nabble.com/ST-MakeLine-woes-tp5006266p5006270.html > > Sent from the PostGIS - User mailing list archive at Nabble.com. > > _______________________________________________ > > postgis-users mailing list > > [email protected] > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
