I'm trying to use point data to create a polyline to show my bus route.Initially began with coordinates and used this to create geom using the ST_MakePoint function (written to the BusRouteData table).
I'm now trying to use this geom to connect the dots as such to create a polyline. I have tried and failed using the ST_MakeLine function (trying to write this to BusRoute table).
ALTER TABLE "BusRT"."BusRoute" ADD COLUMN "geom" geometry(Point,4283);UPDATE "BusRT"."BusRoute" SET "geom"= ST_MakeLine("BusRouteData".geom)
أكثر...
I'm now trying to use this geom to connect the dots as such to create a polyline. I have tried and failed using the ST_MakeLine function (trying to write this to BusRoute table).
ALTER TABLE "BusRT"."BusRoute" ADD COLUMN "geom" geometry(Point,4283);UPDATE "BusRT"."BusRoute" SET "geom"= ST_MakeLine("BusRouteData".geom)
أكثر...