Skip to content

Instantly share code, notes, and snippets.

@yiqingj

yiqingj/populate_current_tables.sql

Last active May 30, 2017 16:57
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save yiqingj/de0c8985185fa7559414f13815861875 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save yiqingj/de0c8985185fa7559414f13815861875 to your computer and use it in GitHub Desktop.
Download ZIP
repopulate current tables for osm apidb
Raw
populate_current_tables.sql
TRUNCATE current_relation_members CASCADE;
TRUNCATE current_relation_tags CASCADE;
TRUNCATE current_relations CASCADE;
TRUNCATE current_way_nodes CASCADE;
TRUNCATE current_way_tags CASCADE;
TRUNCATE current_ways CASCADE;
TRUNCATE current_node_tags CASCADE;
TRUNCATE current_nodes CASCADE;
INSERT INTO current_nodes SELECT node_id, latitude, longitude, changeset_id, visible, timestamp, tile, version FROM nodes t1 WHERE t1.version = (SELECT max(version) FROM nodes t2 WHERE t2.node_id = t1.node_id);
INSERT INTO current_node_tags SELECT node_id, k, v FROM node_tags t1 WHERE t1.version = (SELECT max(version) FROM node_tags t2 WHERE t2.node_id = t1.node_id);
INSERT INTO current_ways SELECT way_id, changeset_id, timestamp, visible, version FROM ways t1 WHERE t1.version = (SELECT max(version) FROM ways t2 WHERE t2.way_id = t1.way_id);
INSERT INTO current_way_tags SELECT way_id, k, v FROM way_tags t1 WHERE t1.version = (SELECT max(version) FROM way_tags t2 WHERE t2.way_id = t1.way_id);
INSERT INTO current_way_nodes SELECT way_id, node_id, sequence_id FROM way_nodes t1 WHERE t1.version = (SELECT max(version) FROM way_nodes t2 WHERE t2.way_id = t1.way_id);
INSERT INTO current_relations SELECT relation_id, changeset_id, timestamp, visible, version FROM relations t1 WHERE t1.version = (SELECT max(version) FROM relations t2 WHERE t2.relation_id = t1.relation_id);
INSERT INTO current_relation_tags SELECT relation_id, k, v FROM relation_tags t1 WHERE t1.version = (SELECT max(version) FROM relation_tags t2 WHERE t2.relation_id = t1.relation_id);
INSERT INTO current_relation_members (relation_id, member_id, member_role, member_type, sequence_id) SELECT relation_id, member_id, member_role, member_type, sequence_id FROM relation_members t1 WHERE t1.version = (SELECT max(version) FROM relation_members t2 WHERE t2.relation_id = t1.relation_id);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment