Guest User

Untitled

a guest
May 20th, 2018
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. --CREATE TABLE msk_roads_line(geom geometry) WITH OIDS;
  2. --INSERT INTO msk_roads_line(geom) SELECT (_.p_geom).geom FROM (SELECT ST_Dump(geom) AS p_geom FROM msk_roads) AS _;
  3. --CREATE INDEX msk_roads_line_gist ON msk_roads_line USING gist (geom);
  4. --ALTER TABLE msk_roads_line ADD COLUMN "source" integer;
  5. --ALTER TABLE msk_roads_line ADD COLUMN "target" integer;
  6. --SELECT assign_vertex_id('msk_roads_line', 0.00001, 'geom', 'oid');
Add Comment
Please, Sign In to add comment