Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --CREATE TABLE msk_roads_line(geom geometry) WITH OIDS;
- --INSERT INTO msk_roads_line(geom) SELECT (_.p_geom).geom FROM (SELECT ST_Dump(geom) AS p_geom FROM msk_roads) AS _;
- --CREATE INDEX msk_roads_line_gist ON msk_roads_line USING gist (geom);
- --ALTER TABLE msk_roads_line ADD COLUMN "source" integer;
- --ALTER TABLE msk_roads_line ADD COLUMN "target" integer;
- --SELECT assign_vertex_id('msk_roads_line', 0.00001, 'geom', 'oid');
Add Comment
Please, Sign In to add comment