stud

study spacejunk
Log | Files | Refs | LICENSE

chaikin.sql (364B) - Raw

      1 DROP TABLE IF EXISTS :tbl;
      2 
      3 CREATE TABLE :tbl (
      4     fid serial NOT NULL,
      5     z DOUBLE PRECISION,
      6     geom geometry(MULTILINESTRING, 3346)
      7 );
      8 
      9 INSERT INTO :tbl (
     10     SELECT
     11         fid,
     12         z,
     13         ST_Multi(
     14             ST_ChaikinSmoothing (
     15                 ST_SimplifyVW(geom, 50),
     16                 5
     17             )
     18         ) AS geoms
     19     FROM
     20         :src);