Skip to content

v0.2.50..v0.2.51 changeset changeset 4.osc.sql

Jump to bottom
Garret Voltz edited this page Jan 15, 2020 · 1 revision 
diff --git a/test-files/cmd/slow/serial/ServiceChangesetDeriveCmdSqlTest/changeset-4.osc.sql b/test-files/cmd/slow/serial/ServiceChangesetDeriveCmdSqlTest/changeset-4.osc.sql
new file mode 100644
index 0000000..aa8f8a7
--- /dev/null
+++ b/test-files/cmd/slow/serial/ServiceChangesetDeriveCmdSqlTest/changeset-4.osc.sql
@@ -0,0 +1,200 @@
+INSERT INTO changesets (id, user_id, created_at, closed_at) VALUES (4, 1, (now() at time zone 'utc'), (now() at time zone 'utc'));
+INSERT INTO changeset_tags (changeset_id, k, v) VALUES (4, 'written_by', 'Hootenanny');
+/* create node 1669723*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669723, 388541670, 1048997070, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669723, 388541670, 1048997070, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+/* create node 1669725*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669725, 388540851, 1049014477, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669725, 388540851, 1049014477, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+/* create node 1669727*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669727, 388542471, 1049010789, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669727, 388542471, 1049010789, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+/* create node 1669729*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669729, 388542600, 1049005795, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669729, 388542600, 1049005795, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+/* create node 1669731*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669731, 388549614, 1048997124, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669731, 388549614, 1048997124, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+/* create node 1669733*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669733, 388545785, 1048997171, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669733, 388545785, 1048997171, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+/* create node 1669735*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669735, 388542618, 1048997171, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669735, 388542618, 1048997171, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+/* create node 1669737*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669737, 388539526, 1048996840, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669737, 388539526, 1048996840, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+/* create node 1669739*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669739, 388536248, 1048996935, 4, true, (now() at time zone 'utc'), 3852309121, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669739, 388536248, 1048996935, 4, true, (now() at time zone 'utc'), 3852309121, 1);
+/* create node 1669741*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669741, 388532583, 1048997543, 4, true, (now() at time zone 'utc'), 3852309121, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669741, 388532583, 1048997543, 4, true, (now() at time zone 'utc'), 3852309121, 1);
+/* create node 1669743*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669743, 388532424, 1048996868, 4, true, (now() at time zone 'utc'), 3852309121, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669743, 388532424, 1048996868, 4, true, (now() at time zone 'utc'), 3852309121, 1);
+/* create node 1669745*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669745, 388533001, 1048994529, 4, true, (now() at time zone 'utc'), 3852309121, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669745, 388533001, 1048994529, 4, true, (now() at time zone 'utc'), 3852309121, 1);
+/* create node 1669747*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669747, 388533470, 1048993672, 4, true, (now() at time zone 'utc'), 3852309121, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669747, 388533470, 1048993672, 4, true, (now() at time zone 'utc'), 3852309121, 1);
+/* create node 1669749*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669749, 388535166, 1048992699, 4, true, (now() at time zone 'utc'), 3852309121, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669749, 388535166, 1048992699, 4, true, (now() at time zone 'utc'), 3852309121, 1);
+/* create node 1669751*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669751, 388535689, 1048990568, 4, true, (now() at time zone 'utc'), 3852309035, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669751, 388535689, 1048990568, 4, true, (now() at time zone 'utc'), 3852309035, 1);
+/* create node 1669753*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669753, 388535509, 1048988321, 4, true, (now() at time zone 'utc'), 3852309035, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669753, 388535509, 1048988321, 4, true, (now() at time zone 'utc'), 3852309035, 1);
+/* create node 1669755*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669755, 388536194, 1048987070, 4, true, (now() at time zone 'utc'), 3852309035, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669755, 388536194, 1048987070, 4, true, (now() at time zone 'utc'), 3852309035, 1);
+/* create node 1669757*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669757, 388537204, 1048987233, 4, true, (now() at time zone 'utc'), 3852309035, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669757, 388537204, 1048987233, 4, true, (now() at time zone 'utc'), 3852309035, 1);
+/* create node 1669759*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669759, 388539585, 1048989155, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669759, 388539585, 1048989155, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+/* create node 1669761*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669761, 388541335, 1048988900, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669761, 388541335, 1048988900, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+/* create node 1669763*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669763, 388541768, 1048987070, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669763, 388541768, 1048987070, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+/* create node 1669765*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669765, 388542327, 1048983110, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669765, 388542327, 1048983110, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+/* create node 1669767*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669767, 388544293, 1048980654, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669767, 388544293, 1048980654, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+/* create node 1669769*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669769, 388546043, 1048977759, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669769, 388546043, 1048977759, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+/* create node 1669771*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669771, 388547197, 1048973219, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669771, 388547197, 1048973219, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+/* create node 1669773*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669773, 388548604, 1048968587, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669773, 388548604, 1048968587, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+/* create node 1669775*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669775, 388549019, 1048964394, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669775, 388549019, 1048964394, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+/* create node 1669777*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669777, 388549073, 1048961823, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669777, 388549073, 1048961823, 4, true, (now() at time zone 'utc'), 3852309038, 1);
+/* create node 1669779*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669779, 388548514, 1049005693, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669779, 388548514, 1049005693, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+/* create node 1669781*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669781, 388549290, 1049005253, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669781, 388549290, 1049005253, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+/* create node 1669783*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669783, 388548207, 1049008079, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669783, 388548207, 1049008079, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+/* create node 1669785*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669785, 388543319, 1049017877, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669785, 388543319, 1049017877, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+/* create node 1669787*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669787, 388541299, 1049023065, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669787, 388541299, 1049023065, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+/* create node 1669789*/
+INSERT INTO nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669789, 388540541, 1049024316, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+INSERT INTO current_nodes (id, latitude, longitude, changeset_id, visible, "timestamp", tile, version) VALUES (1669789, 388540541, 1049024316, 4, true, (now() at time zone 'utc'), 3852309124, 1);
+/* create way 1669795*/
+INSERT INTO ways (way_id, changeset_id, visible, "timestamp", version) VALUES (1669795, 4, true, (now() at time zone 'utc'), 1);
+INSERT INTO current_ways (id, changeset_id, visible, "timestamp", version) VALUES (1669795, 4, true, (now() at time zone 'utc'), 1);
+INSERT INTO current_way_tags (way_id, k, v) VALUES (1669795, 'highway', 'road');
+INSERT INTO way_tags (way_id, k, v, version) VALUES (1669795, 'highway', 'road', 1);
+INSERT INTO current_way_tags (way_id, k, v) VALUES (1669795, 'note', '2');
+INSERT INTO way_tags (way_id, k, v, version) VALUES (1669795, 'note', '2', 1);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669795, 1669725, 1, 1);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669795, 1669725, 1);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669795, 1669727, 1, 2);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669795, 1669727, 2);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669795, 1669729, 1, 3);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669795, 1669729, 3);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669795, 1669735, 1, 4);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669795, 1669735, 4);
+/* create way 1669797*/
+INSERT INTO ways (way_id, changeset_id, visible, "timestamp", version) VALUES (1669797, 4, true, (now() at time zone 'utc'), 1);
+INSERT INTO current_ways (id, changeset_id, visible, "timestamp", version) VALUES (1669797, 4, true, (now() at time zone 'utc'), 1);
+INSERT INTO current_way_tags (way_id, k, v) VALUES (1669797, 'highway', 'road');
+INSERT INTO way_tags (way_id, k, v, version) VALUES (1669797, 'highway', 'road', 1);
+INSERT INTO current_way_tags (way_id, k, v) VALUES (1669797, 'note', '0');
+INSERT INTO way_tags (way_id, k, v, version) VALUES (1669797, 'note', '0', 1);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669789, 1, 1);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669789, 1);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669787, 1, 2);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669787, 2);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669785, 1, 3);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669785, 3);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669783, 1, 4);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669783, 4);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669781, 1, 5);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669781, 5);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669731, 1, 6);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669731, 6);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669733, 1, 7);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669733, 7);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669735, 1, 8);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669735, 8);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669723, 1, 9);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669723, 9);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669737, 1, 10);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669737, 10);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669739, 1, 11);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669739, 11);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669741, 1, 12);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669741, 12);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669743, 1, 13);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669743, 13);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669745, 1, 14);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669745, 14);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669747, 1, 15);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669747, 15);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669749, 1, 16);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669749, 16);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669751, 1, 17);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669751, 17);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669753, 1, 18);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669753, 18);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669755, 1, 19);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669755, 19);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669757, 1, 20);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669757, 20);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669759, 1, 21);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669759, 21);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669761, 1, 22);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669761, 22);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669763, 1, 23);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669763, 23);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669765, 1, 24);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669765, 24);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669767, 1, 25);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669767, 25);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669769, 1, 26);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669769, 26);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669771, 1, 27);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669771, 27);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669773, 1, 28);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669773, 28);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669775, 1, 29);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669775, 29);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669797, 1669777, 1, 30);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669797, 1669777, 30);
+/* create way 1669799*/
+INSERT INTO ways (way_id, changeset_id, visible, "timestamp", version) VALUES (1669799, 4, true, (now() at time zone 'utc'), 1);
+INSERT INTO current_ways (id, changeset_id, visible, "timestamp", version) VALUES (1669799, 4, true, (now() at time zone 'utc'), 1);
+INSERT INTO current_way_tags (way_id, k, v) VALUES (1669799, 'highway', 'road');
+INSERT INTO way_tags (way_id, k, v, version) VALUES (1669799, 'highway', 'road', 1);
+INSERT INTO current_way_tags (way_id, k, v) VALUES (1669799, 'note', '3');
+INSERT INTO way_tags (way_id, k, v, version) VALUES (1669799, 'note', '3', 1);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669799, 1669729, 1, 1);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669799, 1669729, 1);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669799, 1669779, 1, 2);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669799, 1669779, 2);
+INSERT INTO way_nodes (way_id, node_id, version, sequence_id) VALUES (1669799, 1669781, 1, 3);
+INSERT INTO current_way_nodes (way_id, node_id, sequence_id) VALUES (1669799, 1669781, 3);
+UPDATE changesets SET min_lat=388532424, max_lat=388549614, min_lon=1048961823, max_lon=1049024316, num_changes=37 WHERE id=4;
Clone this wiki locally