stud

study spacejunk
Log | Files | Refs | LICENSE

visvalingam.sql (290B) - Raw

      1 DROP TABLE IF EXISTS :tbl;
      2 
      3 CREATE TABLE :tbl (
      4     fid serial NOT NULL,
      5     geom geometry(MULTILINESTRING, 3346)
      6 );
      7 
      8 INSERT INTO :tbl (geom) (
      9     SELECT
     10         ST_Multi (ST_SimplifyVW (ST_LineMerge (ST_Union (geom)),
     11                 :param1 * :param1)) AS geoms
     12     FROM
     13         :src);
     14