Форумы GIS-Lab.info

Код: Выделить всё

PROCEDURE `CreateTrkLine`(nid INT)
BEGIN
  DECLARE done INT DEFAULT 0;
  DECLARE coup, i INT DEFAULT 0;
  DECLARE p1, p2, CrP point;
  DECLARE CrLn LineString;
  DECLARE Cur1 Cursor FOR
   SELECT p FROM `gpx_db`.`trkpt` WHERE trk_id=nid AND nseg=1;
  DECLARE Continue Handler FOR NOT found SET done = 1;
 
  OPEN Cur1;
  Repeat
   Fetch Cur1 INTO CrP;
    IF NOT Done THEN
     CASE i
      WHEN 0 THEN
       SET p1 = geomfromtext(concat('Point(', X(CrP), ' ', Y(CrP), ')'));
      WHEN 1 THEN
       SET CrLn = geometryfromtext(concat('LineString(',x(p1),' ',y(p1),',',x(CrP),' ',y(CrP),')'));
      ELSE
       SET CrLn = `LS_AddPoint`(CrLn, CrP);
     END CASE;
     SET i=i+1;
    END IF;
  Until done END Repeat;
  Close Cur1;
 
  UPDATE trk SET `trk_line`=CrLn WHERE id=nid;
END $$

Код: Выделить всё

CREATE TABLE test2 as
SELECT ST_MakeLine ("geom" ORDER BY timestamp ASC) AS geom2
from first 

Код: Выделить всё

SELECT 
           ST_Makeline(p1, p2) as geom, id, num, class 
          FROM
            (SELECT
                id, row_number() over w as num, class, geom as p1, lead(geom) over w as p2
              FROM first
            window w as (partition by class order by timestamp)
           ) 
             as query where p2 is not NULL