User:Mmd/OsmChange upload logs

From OpenStreetMap Wiki
Jump to: navigation, search

Creating a single node

<osmChange version="0.6" generator="JOSM">
<create>
  <node id='-39255' changeset='33' lat='40.7217622917' lon='-74.02680160761'>
    <tag k='highway' v='bus_stop' />
  </node>
</create>
</osmChange>


Started POST "/api/0.6/changeset/33/upload" for 127.0.0.1 at 2017-12-27 10:45:15 +0100
Processing by ChangesetController#upload as HTML
  Parameters: {"id"=>"33"}
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE (email = 'mmd2' OR display_name = 'mmd2') LIMIT $1  [["LIMIT", 1]]
  UserBlock Load (0.2ms)  SELECT  "user_blocks".* FROM "user_blocks" WHERE "user_blocks"."user_id" = $1 AND (needs_view or ends_at > '2017-12-27 09:45:15.495598') LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
   (0.1ms)  BEGIN
  User Load (0.2ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Exists (6.0ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" IS NULL LIMIT $1  [["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (3.9ms)  INSERT INTO "current_nodes" ("latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id"  [["latitude", 407217623], ["longitude", -740268016], ["changeset_id", 33], ["visible", "t"], ["timestamp", "2017-12-27 09:45:15.538054"], ["tile", 1707833060], ["version", 1]]
  SQL (3.4ms)  DELETE FROM "current_node_tags" WHERE "current_node_tags"."node_id" = $1  [["node_id", 1980701]]
  Node Load (0.9ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980701], ["LIMIT", 1]]
  Node Exists (0.4ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" = $1 AND ("current_nodes"."id" != $2) LIMIT $3  [["id", 1980701], ["id", 1980701], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  NodeTag Exists (0.4ms)  SELECT  1 AS one FROM "current_node_tags" WHERE "current_node_tags"."k" = $1 AND "current_node_tags"."node_id" = $2 LIMIT $3  [["k", "highway"], ["node_id", 1980701], ["LIMIT", 1]]
  SQL (2.4ms)  INSERT INTO "current_node_tags" ("node_id", "k", "v") VALUES ($1, $2, $3) RETURNING "node_id","k"  [["node_id", 1980701], ["k", "highway"], ["v", "bus_stop"]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (7.9ms)  INSERT INTO "nodes" ("node_id", "latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "node_id","version"  [["node_id", 1980701], ["latitude", 407217623], ["longitude", -740268016], ["changeset_id", 33], ["visible", "t"], ["timestamp", "2017-12-27 09:45:15.538054"], ["tile", 1707833060], ["version", 1]]
  OldNode Load (1.4ms)  SELECT  "nodes".* FROM "nodes" WHERE "nodes"."node_id" = $1 AND "nodes"."version" = $2 LIMIT $3  [["node_id", 1980701], ["version", 1], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  OldNodeTag Exists (2.6ms)  SELECT  1 AS one FROM "node_tags" WHERE "node_tags"."k" = $1 AND "node_tags"."node_id" = $2 AND "node_tags"."version" = $3 LIMIT $4  [["k", "highway"], ["node_id", 1980701], ["version", 1], ["LIMIT", 1]]
  SQL (3.5ms)  INSERT INTO "node_tags" ("node_id", "version", "k", "v") VALUES ($1, $2, $3, $4) RETURNING "node_id","version","k"  [["node_id", 1980701], ["version", 1], ["k", "highway"], ["v", "bus_stop"]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.8ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2, "min_lon" = $3, "min_lat" = $4, "max_lon" = $5, "max_lat" = $6 WHERE "changesets"."id" = $7  [["closed_at", "2017-12-27 10:45:15.616785"], ["num_changes", 1], ["min_lon", -740268016], ["min_lat", 407217623], ["max_lon", -740268016], ["max_lat", 407217623], ["id", 33]]
   (3.6ms)  COMMIT
Completed 200 OK in 139ms (Views: 0.1ms | ActiveRecord: 43.7ms)


Move single node

<osmChange version="0.6" generator="JOSM">
<modify>
  <node id='1980701' version='1' changeset='33' lat='40.72190560467' lon='-74.02708458066'>
    <tag k='highway' v='bus_stop' />
  </node>
</modify>
</osmChange>


Started POST "/api/0.6/changeset/33/upload" for 127.0.0.1 at 2017-12-27 10:47:45 +0100
Processing by ChangesetController#upload as HTML
  Parameters: {"id"=>"33"}
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE (email = 'mmd2' OR display_name = 'mmd2') LIMIT $1  [["LIMIT", 1]]
  UserBlock Load (0.3ms)  SELECT  "user_blocks".* FROM "user_blocks" WHERE "user_blocks"."user_id" = $1 AND (needs_view or ends_at > '2017-12-27 09:47:45.077211') LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
   (0.1ms)  BEGIN
  Node Load (0.1ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980701], ["LIMIT", 1]]
  User Load (0.2ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
  Node Load (0.2ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 1980701], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Exists (0.2ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" = $1 AND ("current_nodes"."id" != $2) LIMIT $3  [["id", 1980701], ["id", 1980701], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "current_nodes" SET "version" = $1, "longitude" = $2, "latitude" = $3, "timestamp" = $4, "tile" = $5 WHERE "current_nodes"."id" = $6  [["version", 2], ["longitude", -740270846], ["latitude", 407219056], ["timestamp", "2017-12-27 09:47:45.083636"], ["tile", 1707833038], ["id", 1980701]]
  SQL (0.2ms)  DELETE FROM "current_node_tags" WHERE "current_node_tags"."node_id" = $1  [["node_id", 1980701]]
  Node Load (0.2ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980701], ["LIMIT", 1]]
  Node Exists (0.1ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" = $1 AND ("current_nodes"."id" != $2) LIMIT $3  [["id", 1980701], ["id", 1980701], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  NodeTag Exists (0.2ms)  SELECT  1 AS one FROM "current_node_tags" WHERE "current_node_tags"."k" = $1 AND "current_node_tags"."node_id" = $2 LIMIT $3  [["k", "highway"], ["node_id", 1980701], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "current_node_tags" ("node_id", "k", "v") VALUES ($1, $2, $3) RETURNING "node_id","k"  [["node_id", 1980701], ["k", "highway"], ["v", "bus_stop"]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "nodes" ("node_id", "latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "node_id","version"  [["node_id", 1980701], ["latitude", 407219056], ["longitude", -740270846], ["changeset_id", 33], ["visible", "t"], ["timestamp", "2017-12-27 09:47:45.083636"], ["tile", 1707833038], ["version", 2]]
  OldNode Load (0.2ms)  SELECT  "nodes".* FROM "nodes" WHERE "nodes"."node_id" = $1 AND "nodes"."version" = $2 LIMIT $3  [["node_id", 1980701], ["version", 2], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  OldNodeTag Exists (0.2ms)  SELECT  1 AS one FROM "node_tags" WHERE "node_tags"."k" = $1 AND "node_tags"."node_id" = $2 AND "node_tags"."version" = $3 LIMIT $4  [["k", "highway"], ["node_id", 1980701], ["version", 2], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "node_tags" ("node_id", "version", "k", "v") VALUES ($1, $2, $3, $4) RETURNING "node_id","version","k"  [["node_id", 1980701], ["version", 2], ["k", "highway"], ["v", "bus_stop"]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2, "min_lon" = $3, "max_lat" = $4 WHERE "changesets"."id" = $5  [["closed_at", "2017-12-27 10:47:45.101729"], ["num_changes", 2], ["min_lon", -740270846], ["max_lat", 407219056], ["id", 33]]
   (2.5ms)  COMMIT
Completed 200 OK in 40ms (Views: 0.1ms | ActiveRecord: 7.5ms)


Single node remove tags

<osmChange version="0.6" generator="JOSM">
<modify>
  <node id='1980701' version='2' changeset='33' lat='40.72190560467' lon='-74.02708458066' />
</modify>
</osmChange>


Started POST "/api/0.6/changeset/33/upload" for 127.0.0.1 at 2017-12-27 10:49:51 +0100
Processing by ChangesetController#upload as HTML
  Parameters: {"id"=>"33"}
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE (email = 'mmd2' OR display_name = 'mmd2') LIMIT $1  [["LIMIT", 1]]
  UserBlock Load (0.3ms)  SELECT  "user_blocks".* FROM "user_blocks" WHERE "user_blocks"."user_id" = $1 AND (needs_view or ends_at > '2017-12-27 09:49:51.817710') LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
   (0.1ms)  BEGIN
  Node Load (0.2ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980701], ["LIMIT", 1]]
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
  Node Load (0.2ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 1980701], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Exists (0.2ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" = $1 AND ("current_nodes"."id" != $2) LIMIT $3  [["id", 1980701], ["id", 1980701], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "current_nodes" SET "version" = $1, "timestamp" = $2 WHERE "current_nodes"."id" = $3  [["version", 3], ["timestamp", "2017-12-27 09:49:51.824626"], ["id", 1980701]]
  SQL (0.2ms)  DELETE FROM "current_node_tags" WHERE "current_node_tags"."node_id" = $1  [["node_id", 1980701]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.3ms)  INSERT INTO "nodes" ("node_id", "latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "node_id","version"  [["node_id", 1980701], ["latitude", 407219056], ["longitude", -740270846], ["changeset_id", 33], ["visible", "t"], ["timestamp", "2017-12-27 09:49:51.824626"], ["tile", 1707833038], ["version", 3]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 10:49:51.833074"], ["num_changes", 3], ["id", 33]]
   (1.9ms)  COMMIT
Completed 200 OK in 31ms (Views: 0.1ms | ActiveRecord: 5.4ms)


Delete single node

<osmChange version="0.6" generator="JOSM">
<delete>
  <node id='1980701' version='3' changeset='33'/>
</delete>
</osmChange>
Started POST "/api/0.6/changeset/33/upload" for 127.0.0.1 at 2017-12-27 10:51:00 +0100
Processing by ChangesetController#upload as HTML
  Parameters: {"id"=>"33"}
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE (email = 'mmd2' OR display_name = 'mmd2') LIMIT $1  [["LIMIT", 1]]
  UserBlock Load (0.2ms)  SELECT  "user_blocks".* FROM "user_blocks" WHERE "user_blocks"."user_id" = $1 AND (needs_view or ends_at > '2017-12-27 09:51:00.126662') LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
   (0.1ms)  BEGIN
  Node Load (0.2ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980701], ["LIMIT", 1]]
  CACHE Node Load (0.0ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980701], ["LIMIT", 1]]
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
  Node Load (0.2ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 1980701], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Way Exists (7.4ms)  SELECT  1 AS one FROM "current_ways" INNER JOIN "current_way_nodes" ON "current_way_nodes"."way_id" = "current_ways"."id" WHERE "current_ways"."visible" = $1 AND "current_way_nodes"."node_id" = $2 LIMIT $3  [["visible", "t"], ["node_id", 1980701], ["LIMIT", 1]]
  Relation Exists (4.1ms)  SELECT  1 AS one FROM "current_relations" INNER JOIN "current_relation_members" ON "current_relation_members"."relation_id" = "current_relations"."id" WHERE "current_relations"."visible" = $1 AND "current_relation_members"."member_type" = $2 AND "current_relation_members"."member_id" = $3 LIMIT $4  [["visible", "t"], ["member_type", "Node"], ["member_id", 1980701], ["LIMIT", 1]]
  CACHE Changeset Load (0.0ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Exists (0.2ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" = $1 AND ("current_nodes"."id" != $2) LIMIT $3  [["id", 1980701], ["id", 1980701], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "current_nodes" SET "version" = $1, "visible" = $2, "timestamp" = $3 WHERE "current_nodes"."id" = $4  [["version", 4], ["visible", "f"], ["timestamp", "2017-12-27 09:51:00.166480"], ["id", 1980701]]
  SQL (0.1ms)  DELETE FROM "current_node_tags" WHERE "current_node_tags"."node_id" = $1  [["node_id", 1980701]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.3ms)  INSERT INTO "nodes" ("node_id", "latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "node_id","version"  [["node_id", 1980701], ["latitude", 407219056], ["longitude", -740270846], ["changeset_id", 33], ["visible", "f"], ["timestamp", "2017-12-27 09:51:00.166480"], ["tile", 1707833038], ["version", 4]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.6ms)  UPDATE "changesets" SET "num_changes" = $1, "closed_at" = $2 WHERE "changesets"."id" = $3  [["num_changes", 4], ["closed_at", "2017-12-27 10:51:00.174526"], ["id", 33]]
   (3.2ms)  COMMIT
Completed 200 OK in 72ms (Views: 0.2ms | ActiveRecord: 22.5ms)


Create two nodes and one highway=primary way

<osmChange version="0.6" generator="JOSM">
<create>
  <node id='-39265' changeset='33' lat='40.72183545758' lon='-74.02714222804' />
  <node id='-39264' changeset='33' lat='40.72195437675' lon='-74.02724146977' />
  <way id='-39266' changeset='33'>
    <nd ref='-39264' />
    <nd ref='-39265' />
    <tag k='highway' v='primary' />
  </way>
</create>
</osmChange>



Started POST "/api/0.6/changeset/33/upload" for 127.0.0.1 at 2017-12-27 10:52:43 +0100
Processing by ChangesetController#upload as HTML
  Parameters: {"id"=>"33"}
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE (email = 'mmd2' OR display_name = 'mmd2') LIMIT $1  [["LIMIT", 1]]
  UserBlock Load (0.2ms)  SELECT  "user_blocks".* FROM "user_blocks" WHERE "user_blocks"."user_id" = $1 AND (needs_view or ends_at > '2017-12-27 09:52:43.773432') LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
   (0.1ms)  BEGIN
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Exists (0.1ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" IS NULL LIMIT $1  [["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "current_nodes" ("latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id"  [["latitude", 407218355], ["longitude", -740271422], ["changeset_id", 33], ["visible", "t"], ["timestamp", "2017-12-27 09:52:43.777987"], ["tile", 1707833038], ["version", 1]]
  SQL (0.1ms)  DELETE FROM "current_node_tags" WHERE "current_node_tags"."node_id" = $1  [["node_id", 1980702]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "nodes" ("node_id", "latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "node_id","version"  [["node_id", 1980702], ["latitude", 407218355], ["longitude", -740271422], ["changeset_id", 33], ["visible", "t"], ["timestamp", "2017-12-27 09:52:43.777987"], ["tile", 1707833038], ["version", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2, "min_lon" = $3 WHERE "changesets"."id" = $4  [["closed_at", "2017-12-27 10:52:43.785794"], ["num_changes", 5], ["min_lon", -740271705], ["id", 33]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Exists (0.1ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" IS NULL LIMIT $1  [["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "current_nodes" ("latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id"  [["latitude", 407219544], ["longitude", -740272415], ["changeset_id", 33], ["visible", "t"], ["timestamp", "2017-12-27 09:52:43.787639"], ["tile", 1707833038], ["version", 1]]
  SQL (0.1ms)  DELETE FROM "current_node_tags" WHERE "current_node_tags"."node_id" = $1  [["node_id", 1980703]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "nodes" ("node_id", "latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "node_id","version"  [["node_id", 1980703], ["latitude", 407219544], ["longitude", -740272415], ["changeset_id", 33], ["visible", "t"], ["timestamp", "2017-12-27 09:52:43.787639"], ["tile", 1707833038], ["version", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.3ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2, "min_lon" = $3, "max_lat" = $4 WHERE "changesets"."id" = $5  [["closed_at", "2017-12-27 10:52:43.794814"], ["num_changes", 6], ["min_lon", -740272783], ["max_lat", 407219687], ["id", 33]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Load (0.4ms)  SELECT "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" IN (1980702, 1980703) AND "current_nodes"."visible" = $1 for share  [["visible", "t"]]
  Way Exists (0.2ms)  SELECT  1 AS one FROM "current_ways" WHERE "current_ways"."id" IS NULL LIMIT $1  [["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.7ms)  INSERT INTO "current_ways" ("changeset_id", "timestamp", "visible", "version") VALUES ($1, $2, $3, $4) RETURNING "id"  [["changeset_id", 33], ["timestamp", "2017-12-27 09:52:43.803245"], ["visible", "t"], ["version", 1]]
  SQL (1.0ms)  DELETE FROM "current_way_tags" WHERE "current_way_tags"."way_id" = $1  [["way_id", 1618]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1618], ["LIMIT", 1]]
  Way Exists (0.2ms)  SELECT  1 AS one FROM "current_ways" WHERE "current_ways"."id" = $1 AND ("current_ways"."id" != $2) LIMIT $3  [["id", 1618], ["id", 1618], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  WayTag Exists (0.3ms)  SELECT  1 AS one FROM "current_way_tags" WHERE "current_way_tags"."k" = $1 AND "current_way_tags"."way_id" = $2 LIMIT $3  [["k", "highway"], ["way_id", 1618], ["LIMIT", 1]]
  SQL (0.7ms)  INSERT INTO "current_way_tags" ("way_id", "k", "v") VALUES ($1, $2, $3) RETURNING "way_id","k"  [["way_id", 1618], ["k", "highway"], ["v", "primary"]]
  SQL (0.2ms)  DELETE FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1  [["way_id", 1618]]
  SQL (0.5ms)  INSERT INTO "current_way_nodes" ("way_id", "node_id", "sequence_id") VALUES ($1, $2, $3) RETURNING "way_id","sequence_id"  [["way_id", 1618], ["node_id", 1980703], ["sequence_id", 1]]
  SQL (0.2ms)  INSERT INTO "current_way_nodes" ("way_id", "node_id", "sequence_id") VALUES ($1, $2, $3) RETURNING "way_id","sequence_id"  [["way_id", 1618], ["node_id", 1980702], ["sequence_id", 2]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (4.2ms)  INSERT INTO "ways" ("way_id", "changeset_id", "timestamp", "version") VALUES ($1, $2, $3, $4) RETURNING "way_id","version"  [["way_id", 1618], ["changeset_id", 33], ["timestamp", "2017-12-27 09:52:43.803245"], ["version", 1]]
  OldWay Load (0.2ms)  SELECT  "ways".* FROM "ways" WHERE "ways"."way_id" = $1 AND "ways"."version" = $2 LIMIT $3  [["way_id", 1618], ["version", 1], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  OldWayTag Exists (2.0ms)  SELECT  1 AS one FROM "way_tags" WHERE "way_tags"."k" = $1 AND "way_tags"."way_id" = $2 AND "way_tags"."version" = $3 LIMIT $4  [["k", "highway"], ["way_id", 1618], ["version", 1], ["LIMIT", 1]]
  SQL (0.6ms)  INSERT INTO "way_tags" ("way_id", "k", "v", "version") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","k"  [["way_id", 1618], ["k", "highway"], ["v", "primary"], ["version", 1]]
  SQL (3.7ms)  INSERT INTO "way_nodes" ("way_id", "node_id", "version", "sequence_id") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","sequence_id"  [["way_id", 1618], ["node_id", 1980703], ["version", 1], ["sequence_id", 1]]
  SQL (0.3ms)  INSERT INTO "way_nodes" ("way_id", "node_id", "version", "sequence_id") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","sequence_id"  [["way_id", 1618], ["node_id", 1980702], ["version", 1], ["sequence_id", 2]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1618], ["LIMIT", 1]]
  Node Exists (3.0ms)  SELECT  1 AS one FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 LIMIT $2  [["way_id", 1618], ["LIMIT", 1]]
  Node Load (0.7ms)  SELECT "current_nodes".* FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1618]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.3ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 10:52:43.892214"], ["num_changes", 7], ["id", 33]]
   (3.5ms)  COMMIT
Completed 200 OK in 136ms (Views: 0.1ms | ActiveRecord: 33.0ms)


Extending way by one node

<osmChange version="0.6" generator="JOSM">
<create>
  <node id='-39274' changeset='33' lat='40.72191168784' lon='-74.0269812955' />
</create>
<modify>
  <way id='1618' version='1' changeset='33'>
    <nd ref='1980703' />
    <nd ref='1980702' />
    <nd ref='-39274' />
    <tag k='highway' v='primary' />
  </way>
</modify>
</osmChange>


Started POST "/api/0.6/changeset/33/upload" for 127.0.0.1 at 2017-12-27 10:55:57 +0100
Processing by ChangesetController#upload as HTML
  Parameters: {"id"=>"33"}
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE (email = 'mmd2' OR display_name = 'mmd2') LIMIT $1  [["LIMIT", 1]]
  UserBlock Load (0.2ms)  SELECT  "user_blocks".* FROM "user_blocks" WHERE "user_blocks"."user_id" = $1 AND (needs_view or ends_at > '2017-12-27 09:55:57.806504') LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
   (0.1ms)  BEGIN
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Exists (0.1ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" IS NULL LIMIT $1  [["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.3ms)  INSERT INTO "current_nodes" ("latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id"  [["latitude", 407219117], ["longitude", -740269813], ["changeset_id", 33], ["visible", "t"], ["timestamp", "2017-12-27 09:55:57.811207"], ["tile", 1707833060], ["version", 1]]
  SQL (0.2ms)  DELETE FROM "current_node_tags" WHERE "current_node_tags"."node_id" = $1  [["node_id", 1980704]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "nodes" ("node_id", "latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "node_id","version"  [["node_id", 1980704], ["latitude", 407219117], ["longitude", -740269813], ["changeset_id", 33], ["visible", "t"], ["timestamp", "2017-12-27 09:55:57.811207"], ["tile", 1707833060], ["version", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 10:55:57.819382"], ["num_changes", 8], ["id", 33]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1618], ["LIMIT", 1]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 1618], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  WayNode Load (0.2ms)  SELECT "current_way_nodes".* FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1618]]
  Node Load (0.3ms)  SELECT "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = 1980704 AND "current_nodes"."visible" = $1 for share  [["visible", "t"]]
  Node Exists (0.2ms)  SELECT  1 AS one FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 LIMIT $2  [["way_id", 1618], ["LIMIT", 1]]
  Node Load (0.3ms)  SELECT "current_nodes".* FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1618]]
  Way Exists (0.2ms)  SELECT  1 AS one FROM "current_ways" WHERE "current_ways"."id" = $1 AND ("current_ways"."id" != $2) LIMIT $3  [["id", 1618], ["id", 1618], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "current_ways" SET "version" = $1, "timestamp" = $2 WHERE "current_ways"."id" = $3  [["version", 2], ["timestamp", "2017-12-27 09:55:57.825513"], ["id", 1618]]
  SQL (0.2ms)  DELETE FROM "current_way_tags" WHERE "current_way_tags"."way_id" = $1  [["way_id", 1618]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1618], ["LIMIT", 1]]
  Way Exists (0.2ms)  SELECT  1 AS one FROM "current_ways" WHERE "current_ways"."id" = $1 AND ("current_ways"."id" != $2) LIMIT $3  [["id", 1618], ["id", 1618], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  WayTag Exists (0.2ms)  SELECT  1 AS one FROM "current_way_tags" WHERE "current_way_tags"."k" = $1 AND "current_way_tags"."way_id" = $2 LIMIT $3  [["k", "highway"], ["way_id", 1618], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "current_way_tags" ("way_id", "k", "v") VALUES ($1, $2, $3) RETURNING "way_id","k"  [["way_id", 1618], ["k", "highway"], ["v", "primary"]]
  SQL (0.1ms)  DELETE FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1  [["way_id", 1618]]
  SQL (0.2ms)  INSERT INTO "current_way_nodes" ("way_id", "node_id", "sequence_id") VALUES ($1, $2, $3) RETURNING "way_id","sequence_id"  [["way_id", 1618], ["node_id", 1980703], ["sequence_id", 1]]
  SQL (0.2ms)  INSERT INTO "current_way_nodes" ("way_id", "node_id", "sequence_id") VALUES ($1, $2, $3) RETURNING "way_id","sequence_id"  [["way_id", 1618], ["node_id", 1980702], ["sequence_id", 2]]
  SQL (0.2ms)  INSERT INTO "current_way_nodes" ("way_id", "node_id", "sequence_id") VALUES ($1, $2, $3) RETURNING "way_id","sequence_id"  [["way_id", 1618], ["node_id", 1980704], ["sequence_id", 3]]
  Changeset Load (0.3ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "ways" ("way_id", "changeset_id", "timestamp", "version") VALUES ($1, $2, $3, $4) RETURNING "way_id","version"  [["way_id", 1618], ["changeset_id", 33], ["timestamp", "2017-12-27 09:55:57.825513"], ["version", 2]]
  OldWay Load (0.1ms)  SELECT  "ways".* FROM "ways" WHERE "ways"."way_id" = $1 AND "ways"."version" = $2 LIMIT $3  [["way_id", 1618], ["version", 2], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  OldWayTag Exists (0.1ms)  SELECT  1 AS one FROM "way_tags" WHERE "way_tags"."k" = $1 AND "way_tags"."way_id" = $2 AND "way_tags"."version" = $3 LIMIT $4  [["k", "highway"], ["way_id", 1618], ["version", 2], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "way_tags" ("way_id", "k", "v", "version") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","k"  [["way_id", 1618], ["k", "highway"], ["v", "primary"], ["version", 2]]
  SQL (0.2ms)  INSERT INTO "way_nodes" ("way_id", "node_id", "version", "sequence_id") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","sequence_id"  [["way_id", 1618], ["node_id", 1980703], ["version", 2], ["sequence_id", 1]]
  SQL (0.4ms)  INSERT INTO "way_nodes" ("way_id", "node_id", "version", "sequence_id") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","sequence_id"  [["way_id", 1618], ["node_id", 1980702], ["version", 2], ["sequence_id", 2]]
  SQL (0.2ms)  INSERT INTO "way_nodes" ("way_id", "node_id", "version", "sequence_id") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","sequence_id"  [["way_id", 1618], ["node_id", 1980704], ["version", 2], ["sequence_id", 3]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1618], ["LIMIT", 1]]
  Node Exists (0.3ms)  SELECT  1 AS one FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 LIMIT $2  [["way_id", 1618], ["LIMIT", 1]]
  Node Load (0.3ms)  SELECT "current_nodes".* FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1618]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.3ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 10:55:57.854285"], ["num_changes", 9], ["id", 33]]
   (1.9ms)  COMMIT
Completed 200 OK in 63ms (Views: 0.1ms | ActiveRecord: 11.8ms)


Split way in two ways

<osmChange version="0.6" generator="JOSM">
<create>
  <way id='-39277' changeset='33'>
    <nd ref='1980702' />
    <nd ref='1980704' />
    <tag k='highway' v='primary' />
  </way>
</create>
<modify>
  <way id='1618' version='2' changeset='33'>
    <nd ref='1980703' />
    <nd ref='1980702' />
    <tag k='highway' v='primary' />
  </way>
</modify>
</osmChange>


Started POST "/api/0.6/changeset/33/upload" for 127.0.0.1 at 2017-12-27 10:57:49 +0100
Processing by ChangesetController#upload as HTML
  Parameters: {"id"=>"33"}
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE (email = 'mmd2' OR display_name = 'mmd2') LIMIT $1  [["LIMIT", 1]]
  UserBlock Load (0.2ms)  SELECT  "user_blocks".* FROM "user_blocks" WHERE "user_blocks"."user_id" = $1 AND (needs_view or ends_at > '2017-12-27 09:57:49.792371') LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
   (0.1ms)  BEGIN
  User Load (0.2ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Load (0.2ms)  SELECT "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" IN (1980702, 1980704) AND "current_nodes"."visible" = $1 for share  [["visible", "t"]]
  Way Exists (0.1ms)  SELECT  1 AS one FROM "current_ways" WHERE "current_ways"."id" IS NULL LIMIT $1  [["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "current_ways" ("changeset_id", "timestamp", "visible", "version") VALUES ($1, $2, $3, $4) RETURNING "id"  [["changeset_id", 33], ["timestamp", "2017-12-27 09:57:49.796473"], ["visible", "t"], ["version", 1]]
  SQL (0.1ms)  DELETE FROM "current_way_tags" WHERE "current_way_tags"."way_id" = $1  [["way_id", 1619]]
  Way Load (0.1ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1619], ["LIMIT", 1]]
  Way Exists (0.1ms)  SELECT  1 AS one FROM "current_ways" WHERE "current_ways"."id" = $1 AND ("current_ways"."id" != $2) LIMIT $3  [["id", 1619], ["id", 1619], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  WayTag Exists (0.1ms)  SELECT  1 AS one FROM "current_way_tags" WHERE "current_way_tags"."k" = $1 AND "current_way_tags"."way_id" = $2 LIMIT $3  [["k", "highway"], ["way_id", 1619], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "current_way_tags" ("way_id", "k", "v") VALUES ($1, $2, $3) RETURNING "way_id","k"  [["way_id", 1619], ["k", "highway"], ["v", "primary"]]
  SQL (0.1ms)  DELETE FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1  [["way_id", 1619]]
  SQL (0.2ms)  INSERT INTO "current_way_nodes" ("way_id", "node_id", "sequence_id") VALUES ($1, $2, $3) RETURNING "way_id","sequence_id"  [["way_id", 1619], ["node_id", 1980702], ["sequence_id", 1]]
  SQL (0.2ms)  INSERT INTO "current_way_nodes" ("way_id", "node_id", "sequence_id") VALUES ($1, $2, $3) RETURNING "way_id","sequence_id"  [["way_id", 1619], ["node_id", 1980704], ["sequence_id", 2]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "ways" ("way_id", "changeset_id", "timestamp", "version") VALUES ($1, $2, $3, $4) RETURNING "way_id","version"  [["way_id", 1619], ["changeset_id", 33], ["timestamp", "2017-12-27 09:57:49.796473"], ["version", 1]]
  OldWay Load (0.1ms)  SELECT  "ways".* FROM "ways" WHERE "ways"."way_id" = $1 AND "ways"."version" = $2 LIMIT $3  [["way_id", 1619], ["version", 1], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  OldWayTag Exists (0.3ms)  SELECT  1 AS one FROM "way_tags" WHERE "way_tags"."k" = $1 AND "way_tags"."way_id" = $2 AND "way_tags"."version" = $3 LIMIT $4  [["k", "highway"], ["way_id", 1619], ["version", 1], ["LIMIT", 1]]
  SQL (0.3ms)  INSERT INTO "way_tags" ("way_id", "k", "v", "version") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","k"  [["way_id", 1619], ["k", "highway"], ["v", "primary"], ["version", 1]]
  SQL (0.2ms)  INSERT INTO "way_nodes" ("way_id", "node_id", "version", "sequence_id") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","sequence_id"  [["way_id", 1619], ["node_id", 1980702], ["version", 1], ["sequence_id", 1]]
  SQL (0.2ms)  INSERT INTO "way_nodes" ("way_id", "node_id", "version", "sequence_id") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","sequence_id"  [["way_id", 1619], ["node_id", 1980704], ["version", 1], ["sequence_id", 2]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1619], ["LIMIT", 1]]
  Node Exists (0.3ms)  SELECT  1 AS one FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 LIMIT $2  [["way_id", 1619], ["LIMIT", 1]]
  Node Load (0.4ms)  SELECT "current_nodes".* FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1619]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 10:57:49.817493"], ["num_changes", 10], ["id", 33]]
  Way Load (0.1ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1618], ["LIMIT", 1]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 1618], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  WayNode Load (0.2ms)  SELECT "current_way_nodes".* FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1618]]
  Node Exists (0.3ms)  SELECT  1 AS one FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 LIMIT $2  [["way_id", 1618], ["LIMIT", 1]]
  Node Load (0.3ms)  SELECT "current_nodes".* FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1618]]
  Way Exists (0.2ms)  SELECT  1 AS one FROM "current_ways" WHERE "current_ways"."id" = $1 AND ("current_ways"."id" != $2) LIMIT $3  [["id", 1618], ["id", 1618], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "current_ways" SET "version" = $1, "timestamp" = $2 WHERE "current_ways"."id" = $3  [["version", 3], ["timestamp", "2017-12-27 09:57:49.821531"], ["id", 1618]]
  SQL (0.1ms)  DELETE FROM "current_way_tags" WHERE "current_way_tags"."way_id" = $1  [["way_id", 1618]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1618], ["LIMIT", 1]]
  Way Exists (0.1ms)  SELECT  1 AS one FROM "current_ways" WHERE "current_ways"."id" = $1 AND ("current_ways"."id" != $2) LIMIT $3  [["id", 1618], ["id", 1618], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  WayTag Exists (0.2ms)  SELECT  1 AS one FROM "current_way_tags" WHERE "current_way_tags"."k" = $1 AND "current_way_tags"."way_id" = $2 LIMIT $3  [["k", "highway"], ["way_id", 1618], ["LIMIT", 1]]
  SQL (0.3ms)  INSERT INTO "current_way_tags" ("way_id", "k", "v") VALUES ($1, $2, $3) RETURNING "way_id","k"  [["way_id", 1618], ["k", "highway"], ["v", "primary"]]
  SQL (0.2ms)  DELETE FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1  [["way_id", 1618]]
  SQL (0.2ms)  INSERT INTO "current_way_nodes" ("way_id", "node_id", "sequence_id") VALUES ($1, $2, $3) RETURNING "way_id","sequence_id"  [["way_id", 1618], ["node_id", 1980703], ["sequence_id", 1]]
  SQL (0.2ms)  INSERT INTO "current_way_nodes" ("way_id", "node_id", "sequence_id") VALUES ($1, $2, $3) RETURNING "way_id","sequence_id"  [["way_id", 1618], ["node_id", 1980702], ["sequence_id", 2]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "ways" ("way_id", "changeset_id", "timestamp", "version") VALUES ($1, $2, $3, $4) RETURNING "way_id","version"  [["way_id", 1618], ["changeset_id", 33], ["timestamp", "2017-12-27 09:57:49.821531"], ["version", 3]]
  OldWay Load (0.2ms)  SELECT  "ways".* FROM "ways" WHERE "ways"."way_id" = $1 AND "ways"."version" = $2 LIMIT $3  [["way_id", 1618], ["version", 3], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  OldWayTag Exists (0.1ms)  SELECT  1 AS one FROM "way_tags" WHERE "way_tags"."k" = $1 AND "way_tags"."way_id" = $2 AND "way_tags"."version" = $3 LIMIT $4  [["k", "highway"], ["way_id", 1618], ["version", 3], ["LIMIT", 1]]
  SQL (0.1ms)  INSERT INTO "way_tags" ("way_id", "k", "v", "version") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","k"  [["way_id", 1618], ["k", "highway"], ["v", "primary"], ["version", 3]]
  SQL (0.1ms)  INSERT INTO "way_nodes" ("way_id", "node_id", "version", "sequence_id") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","sequence_id"  [["way_id", 1618], ["node_id", 1980703], ["version", 3], ["sequence_id", 1]]
  SQL (0.1ms)  INSERT INTO "way_nodes" ("way_id", "node_id", "version", "sequence_id") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","sequence_id"  [["way_id", 1618], ["node_id", 1980702], ["version", 3], ["sequence_id", 2]]
  Way Load (0.1ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1618], ["LIMIT", 1]]
  Node Exists (0.3ms)  SELECT  1 AS one FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 LIMIT $2  [["way_id", 1618], ["LIMIT", 1]]
  Node Load (0.3ms)  SELECT "current_nodes".* FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1618]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.3ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 10:57:49.843979"], ["num_changes", 11], ["id", 33]]
   (2.2ms)  COMMIT
Completed 200 OK in 67ms (Views: 0.1ms | ActiveRecord: 14.8ms)


Delete one node and two ways

<osmChange version="0.6" generator="JOSM">
<delete>
  <way id='1618' version='3' changeset='33'/>
  <way id='1619' version='1' changeset='33'/>
  <node id='1980702' version='1' changeset='33'/>
</delete>
</osmChange>
Started POST "/api/0.6/changeset/33/upload" for 127.0.0.1 at 2017-12-27 10:59:49 +0100
Processing by ChangesetController#upload as HTML
  Parameters: {"id"=>"33"}
  User Load (0.4ms)  SELECT  "users".* FROM "users" WHERE (email = 'mmd2' OR display_name = 'mmd2') LIMIT $1  [["LIMIT", 1]]
  UserBlock Load (0.3ms)  SELECT  "user_blocks".* FROM "user_blocks" WHERE "user_blocks"."user_id" = $1 AND (needs_view or ends_at > '2017-12-27 09:59:49.201487') LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
   (0.0ms)  BEGIN
  Way Load (0.1ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1618], ["LIMIT", 1]]
  CACHE Way Load (0.0ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1618], ["LIMIT", 1]]
  WayNode Load (0.1ms)  SELECT "current_way_nodes".* FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1618]]
  User Load (0.1ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
  Way Load (0.1ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 1618], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Relation Exists (0.2ms)  SELECT  1 AS one FROM "current_relations" INNER JOIN "current_relation_members" ON "current_relation_members"."relation_id" = "current_relations"."id" WHERE "current_relations"."visible" = $1 AND "current_relation_members"."member_type" = $2 AND "current_relation_members"."member_id" = $3 LIMIT $4  [["visible", "t"], ["member_type", "Way"], ["member_id", 1618], ["LIMIT", 1]]
  Node Exists (0.3ms)  SELECT  1 AS one FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 LIMIT $2  [["way_id", 1618], ["LIMIT", 1]]
  Node Load (0.3ms)  SELECT "current_nodes".* FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1618]]
  Way Exists (0.2ms)  SELECT  1 AS one FROM "current_ways" WHERE "current_ways"."id" = $1 AND ("current_ways"."id" != $2) LIMIT $3  [["id", 1618], ["id", 1618], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "current_ways" SET "version" = $1, "visible" = $2, "timestamp" = $3 WHERE "current_ways"."id" = $4  [["version", 4], ["visible", "f"], ["timestamp", "2017-12-27 09:59:49.208112"], ["id", 1618]]
  SQL (0.2ms)  DELETE FROM "current_way_tags" WHERE "current_way_tags"."way_id" = $1  [["way_id", 1618]]
  SQL (0.1ms)  DELETE FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1  [["way_id", 1618]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "ways" ("way_id", "changeset_id", "timestamp", "version", "visible") VALUES ($1, $2, $3, $4, $5) RETURNING "way_id","version"  [["way_id", 1618], ["changeset_id", 33], ["timestamp", "2017-12-27 09:59:49.208112"], ["version", 4], ["visible", "f"]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1618], ["LIMIT", 1]]
  Node Exists (0.3ms)  SELECT  1 AS one FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 LIMIT $2  [["way_id", 1618], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 10:59:49.219469"], ["num_changes", 12], ["id", 33]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1619], ["LIMIT", 1]]
  CACHE Way Load (0.0ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1619], ["LIMIT", 1]]
  WayNode Load (0.2ms)  SELECT "current_way_nodes".* FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1619]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 1619], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Relation Exists (0.3ms)  SELECT  1 AS one FROM "current_relations" INNER JOIN "current_relation_members" ON "current_relation_members"."relation_id" = "current_relations"."id" WHERE "current_relations"."visible" = $1 AND "current_relation_members"."member_type" = $2 AND "current_relation_members"."member_id" = $3 LIMIT $4  [["visible", "t"], ["member_type", "Way"], ["member_id", 1619], ["LIMIT", 1]]
  Node Exists (0.3ms)  SELECT  1 AS one FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 LIMIT $2  [["way_id", 1619], ["LIMIT", 1]]
  Node Load (0.4ms)  SELECT "current_nodes".* FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1619]]
  Way Exists (0.2ms)  SELECT  1 AS one FROM "current_ways" WHERE "current_ways"."id" = $1 AND ("current_ways"."id" != $2) LIMIT $3  [["id", 1619], ["id", 1619], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "current_ways" SET "version" = $1, "visible" = $2, "timestamp" = $3 WHERE "current_ways"."id" = $4  [["version", 2], ["visible", "f"], ["timestamp", "2017-12-27 09:59:49.224856"], ["id", 1619]]
  SQL (0.2ms)  DELETE FROM "current_way_tags" WHERE "current_way_tags"."way_id" = $1  [["way_id", 1619]]
  SQL (0.1ms)  DELETE FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1  [["way_id", 1619]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "ways" ("way_id", "changeset_id", "timestamp", "version", "visible") VALUES ($1, $2, $3, $4, $5) RETURNING "way_id","version"  [["way_id", 1619], ["changeset_id", 33], ["timestamp", "2017-12-27 09:59:49.224856"], ["version", 2], ["visible", "f"]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1619], ["LIMIT", 1]]
  Node Exists (0.3ms)  SELECT  1 AS one FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 LIMIT $2  [["way_id", 1619], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 10:59:49.236417"], ["num_changes", 13], ["id", 33]]
  Node Load (0.1ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980702], ["LIMIT", 1]]
  CACHE Node Load (0.0ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980702], ["LIMIT", 1]]
  Node Load (0.2ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 1980702], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Way Exists (0.2ms)  SELECT  1 AS one FROM "current_ways" INNER JOIN "current_way_nodes" ON "current_way_nodes"."way_id" = "current_ways"."id" WHERE "current_ways"."visible" = $1 AND "current_way_nodes"."node_id" = $2 LIMIT $3  [["visible", "t"], ["node_id", 1980702], ["LIMIT", 1]]
  Relation Exists (0.3ms)  SELECT  1 AS one FROM "current_relations" INNER JOIN "current_relation_members" ON "current_relation_members"."relation_id" = "current_relations"."id" WHERE "current_relations"."visible" = $1 AND "current_relation_members"."member_type" = $2 AND "current_relation_members"."member_id" = $3 LIMIT $4  [["visible", "t"], ["member_type", "Node"], ["member_id", 1980702], ["LIMIT", 1]]
  CACHE Changeset Load (0.0ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Exists (0.2ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" = $1 AND ("current_nodes"."id" != $2) LIMIT $3  [["id", 1980702], ["id", 1980702], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "current_nodes" SET "version" = $1, "visible" = $2, "timestamp" = $3 WHERE "current_nodes"."id" = $4  [["version", 2], ["visible", "f"], ["timestamp", "2017-12-27 09:59:49.242128"], ["id", 1980702]]
  SQL (0.1ms)  DELETE FROM "current_node_tags" WHERE "current_node_tags"."node_id" = $1  [["node_id", 1980702]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "nodes" ("node_id", "latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "node_id","version"  [["node_id", 1980702], ["latitude", 407218355], ["longitude", -740271422], ["changeset_id", 33], ["visible", "f"], ["timestamp", "2017-12-27 09:59:49.242128"], ["tile", 1707833038], ["version", 2]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "num_changes" = $1, "closed_at" = $2 WHERE "changesets"."id" = $3  [["num_changes", 14], ["closed_at", "2017-12-27 10:59:49.248528"], ["id", 33]]
   (2.3ms)  COMMIT
Completed 200 OK in 63ms (Views: 0.1ms | ActiveRecord: 13.4ms)


Create highway=unclassified way using existing nodes

<osmChange version="0.6" generator="JOSM">
<create>
  <way id='-39282' changeset='33'>
    <nd ref='1980703' />
    <nd ref='1980704' />
    <tag k='highway' v='unclassified' />
  </way>
</create>
</osmChange>


Started POST "/api/0.6/changeset/33/upload" for 127.0.0.1 at 2017-12-27 11:02:14 +0100
Processing by ChangesetController#upload as HTML
  Parameters: {"id"=>"33"}
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE (email = 'mmd2' OR display_name = 'mmd2') LIMIT $1  [["LIMIT", 1]]
  UserBlock Load (0.2ms)  SELECT  "user_blocks".* FROM "user_blocks" WHERE "user_blocks"."user_id" = $1 AND (needs_view or ends_at > '2017-12-27 10:02:14.452765') LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
   (0.1ms)  BEGIN
  User Load (0.2ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Load (0.3ms)  SELECT "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" IN (1980703, 1980704) AND "current_nodes"."visible" = $1 for share  [["visible", "t"]]
  Way Exists (0.2ms)  SELECT  1 AS one FROM "current_ways" WHERE "current_ways"."id" IS NULL LIMIT $1  [["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "current_ways" ("changeset_id", "timestamp", "visible", "version") VALUES ($1, $2, $3, $4) RETURNING "id"  [["changeset_id", 33], ["timestamp", "2017-12-27 10:02:14.456929"], ["visible", "t"], ["version", 1]]
  SQL (0.2ms)  DELETE FROM "current_way_tags" WHERE "current_way_tags"."way_id" = $1  [["way_id", 1620]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1620], ["LIMIT", 1]]
  Way Exists (0.2ms)  SELECT  1 AS one FROM "current_ways" WHERE "current_ways"."id" = $1 AND ("current_ways"."id" != $2) LIMIT $3  [["id", 1620], ["id", 1620], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  WayTag Exists (0.1ms)  SELECT  1 AS one FROM "current_way_tags" WHERE "current_way_tags"."k" = $1 AND "current_way_tags"."way_id" = $2 LIMIT $3  [["k", "highway"], ["way_id", 1620], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "current_way_tags" ("way_id", "k", "v") VALUES ($1, $2, $3) RETURNING "way_id","k"  [["way_id", 1620], ["k", "highway"], ["v", "unclassified"]]
  SQL (0.2ms)  DELETE FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1  [["way_id", 1620]]
  SQL (0.2ms)  INSERT INTO "current_way_nodes" ("way_id", "node_id", "sequence_id") VALUES ($1, $2, $3) RETURNING "way_id","sequence_id"  [["way_id", 1620], ["node_id", 1980703], ["sequence_id", 1]]
  SQL (0.2ms)  INSERT INTO "current_way_nodes" ("way_id", "node_id", "sequence_id") VALUES ($1, $2, $3) RETURNING "way_id","sequence_id"  [["way_id", 1620], ["node_id", 1980704], ["sequence_id", 2]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "ways" ("way_id", "changeset_id", "timestamp", "version") VALUES ($1, $2, $3, $4) RETURNING "way_id","version"  [["way_id", 1620], ["changeset_id", 33], ["timestamp", "2017-12-27 10:02:14.456929"], ["version", 1]]
  OldWay Load (0.1ms)  SELECT  "ways".* FROM "ways" WHERE "ways"."way_id" = $1 AND "ways"."version" = $2 LIMIT $3  [["way_id", 1620], ["version", 1], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  OldWayTag Exists (0.2ms)  SELECT  1 AS one FROM "way_tags" WHERE "way_tags"."k" = $1 AND "way_tags"."way_id" = $2 AND "way_tags"."version" = $3 LIMIT $4  [["k", "highway"], ["way_id", 1620], ["version", 1], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "way_tags" ("way_id", "k", "v", "version") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","k"  [["way_id", 1620], ["k", "highway"], ["v", "unclassified"], ["version", 1]]
  SQL (0.2ms)  INSERT INTO "way_nodes" ("way_id", "node_id", "version", "sequence_id") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","sequence_id"  [["way_id", 1620], ["node_id", 1980703], ["version", 1], ["sequence_id", 1]]
  SQL (0.2ms)  INSERT INTO "way_nodes" ("way_id", "node_id", "version", "sequence_id") VALUES ($1, $2, $3, $4) RETURNING "way_id","version","sequence_id"  [["way_id", 1620], ["node_id", 1980704], ["version", 1], ["sequence_id", 2]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1620], ["LIMIT", 1]]
  Node Exists (0.3ms)  SELECT  1 AS one FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 LIMIT $2  [["way_id", 1620], ["LIMIT", 1]]
  Node Load (0.3ms)  SELECT "current_nodes".* FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1620]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.3ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 11:02:14.478718"], ["num_changes", 15], ["id", 33]]
   (5.5ms)  COMMIT
Completed 200 OK in 44ms (Views: 0.1ms | ActiveRecord: 12.1ms)


Create two relations, two nodes, mixed case

<osmChange version="0.6" generator="JOSM">
<create>
  <node id='-39294' changeset='33' lat='40.72181716231' lon='-74.02706578508' />
  <node id='-39284' changeset='33' lat='40.72182326073' lon='-74.0272200121' />
  <relation id='-39306' changeset='33'>
    <member type='node' ref='-39294' role='' />
    <tag k='tag2' v='value2' />
  </relation>
  <relation id='-39290' changeset='33'>
    <member type='way' ref='1620' role='' />
    <member type='node' ref='-39284' role='' />
    <tag k='tag1' v='value2' />
  </relation>
</create>
</osmChange>
Started POST "/api/0.6/changeset/33/upload" for 127.0.0.1 at 2017-12-27 11:07:45 +0100
Processing by ChangesetController#upload as HTML
  Parameters: {"id"=>"33"}
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE (email = 'mmd2' OR display_name = 'mmd2') LIMIT $1  [["LIMIT", 1]]
  UserBlock Load (0.2ms)  SELECT  "user_blocks".* FROM "user_blocks" WHERE "user_blocks"."user_id" = $1 AND (needs_view or ends_at > '2017-12-27 10:07:45.672027') LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
   (0.1ms)  BEGIN
  User Load (0.2ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Exists (0.1ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" IS NULL LIMIT $1  [["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "current_nodes" ("latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id"  [["latitude", 407218172], ["longitude", -740270658], ["changeset_id", 33], ["visible", "t"], ["timestamp", "2017-12-27 10:07:45.675207"], ["tile", 1707833038], ["version", 1]]
  SQL (0.1ms)  DELETE FROM "current_node_tags" WHERE "current_node_tags"."node_id" = $1  [["node_id", 1980705]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "nodes" ("node_id", "latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "node_id","version"  [["node_id", 1980705], ["latitude", 407218172], ["longitude", -740270658], ["changeset_id", 33], ["visible", "t"], ["timestamp", "2017-12-27 10:07:45.675207"], ["tile", 1707833038], ["version", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 11:07:45.680823"], ["num_changes", 16], ["id", 33]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Exists (0.1ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" IS NULL LIMIT $1  [["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "current_nodes" ("latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id"  [["latitude", 407218233], ["longitude", -740272200], ["changeset_id", 33], ["visible", "t"], ["timestamp", "2017-12-27 10:07:45.682467"], ["tile", 1707833038], ["version", 1]]
  SQL (0.2ms)  DELETE FROM "current_node_tags" WHERE "current_node_tags"."node_id" = $1  [["node_id", 1980706]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "nodes" ("node_id", "latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "node_id","version"  [["node_id", 1980706], ["latitude", 407218233], ["longitude", -740272200], ["changeset_id", 33], ["visible", "t"], ["timestamp", "2017-12-27 10:07:45.682467"], ["tile", 1707833038], ["version", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 11:07:45.688705"], ["num_changes", 17], ["id", 33]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Load (0.3ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2 for share  [["id", 1980705], ["LIMIT", 1]]
  Relation Exists (0.2ms)  SELECT  1 AS one FROM "current_relations" WHERE "current_relations"."id" IS NULL LIMIT $1  [["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.6ms)  INSERT INTO "current_relations" ("changeset_id", "timestamp", "visible", "version") VALUES ($1, $2, $3, $4) RETURNING "id"  [["changeset_id", 33], ["timestamp", "2017-12-27 10:07:45.695161"], ["visible", "t"], ["version", 1]]
  SQL (0.5ms)  DELETE FROM "current_relation_tags" WHERE "current_relation_tags"."relation_id" = $1  [["relation_id", 6]]
  Relation Load (0.2ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2  [["id", 6], ["LIMIT", 1]]
  Relation Exists (0.2ms)  SELECT  1 AS one FROM "current_relations" WHERE "current_relations"."id" = $1 AND ("current_relations"."id" != $2) LIMIT $3  [["id", 6], ["id", 6], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  RelationTag Exists (0.2ms)  SELECT  1 AS one FROM "current_relation_tags" WHERE "current_relation_tags"."k" = $1 AND "current_relation_tags"."relation_id" = $2 LIMIT $3  [["k", "tag2"], ["relation_id", 6], ["LIMIT", 1]]
  SQL (0.3ms)  INSERT INTO "current_relation_tags" ("relation_id", "k", "v") VALUES ($1, $2, $3) RETURNING "relation_id","k"  [["relation_id", 6], ["k", "tag2"], ["v", "value2"]]
  SQL (0.1ms)  DELETE FROM "current_relation_members" WHERE "current_relation_members"."relation_id" = $1  [["relation_id", 6]]
  SQL (0.4ms)  INSERT INTO "current_relation_members" ("relation_id", "member_type", "member_id", "member_role") VALUES ($1, $2, $3, $4) RETURNING "relation_id","sequence_id"  [["relation_id", 6], ["member_type", "Node"], ["member_id", 1980705], ["member_role", ""]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (1.2ms)  INSERT INTO "relations" ("relation_id", "changeset_id", "timestamp", "version") VALUES ($1, $2, $3, $4) RETURNING "relation_id","version"  [["relation_id", 6], ["changeset_id", 33], ["timestamp", "2017-12-27 10:07:45.695161"], ["version", 1]]
  OldRelation Load (0.2ms)  SELECT  "relations".* FROM "relations" WHERE "relations"."relation_id" = $1 AND "relations"."version" = $2 LIMIT $3  [["relation_id", 6], ["version", 1], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  OldRelationTag Exists (0.5ms)  SELECT  1 AS one FROM "relation_tags" WHERE "relation_tags"."k" = $1 AND "relation_tags"."relation_id" = $2 AND "relation_tags"."version" = $3 LIMIT $4  [["k", "tag2"], ["relation_id", 6], ["version", 1], ["LIMIT", 1]]
  SQL (0.3ms)  INSERT INTO "relation_tags" ("relation_id", "k", "v", "version") VALUES ($1, $2, $3, $4) RETURNING "relation_id","version","k"  [["relation_id", 6], ["k", "tag2"], ["v", "value2"], ["version", 1]]
  SQL (0.9ms)  INSERT INTO "relation_members" ("relation_id", "member_type", "member_id", "member_role", "version") VALUES ($1, $2, $3, $4, $5) RETURNING "relation_id","version","sequence_id"  [["relation_id", 6], ["member_type", "Node"], ["member_id", 1980705], ["member_role", ""], ["version", 1]]
  Node Load (0.2ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980705], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.3ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 11:07:45.748913"], ["num_changes", 18], ["id", 33]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Way Load (0.2ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2 for share  [["id", 1620], ["LIMIT", 1]]
  WayNode Load (0.2ms)  SELECT "current_way_nodes".* FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1620]]
  Node Load (0.2ms)  SELECT "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" IN (1980703, 1980704) AND "current_nodes"."visible" = $1 for share  [["visible", "t"]]
  Node Load (0.2ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2 for share  [["id", 1980706], ["LIMIT", 1]]
  Relation Exists (0.1ms)  SELECT  1 AS one FROM "current_relations" WHERE "current_relations"."id" IS NULL LIMIT $1  [["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "current_relations" ("changeset_id", "timestamp", "visible", "version") VALUES ($1, $2, $3, $4) RETURNING "id"  [["changeset_id", 33], ["timestamp", "2017-12-27 10:07:45.753836"], ["visible", "t"], ["version", 1]]
  SQL (0.2ms)  DELETE FROM "current_relation_tags" WHERE "current_relation_tags"."relation_id" = $1  [["relation_id", 7]]
  Relation Load (0.1ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2  [["id", 7], ["LIMIT", 1]]
  Relation Exists (0.2ms)  SELECT  1 AS one FROM "current_relations" WHERE "current_relations"."id" = $1 AND ("current_relations"."id" != $2) LIMIT $3  [["id", 7], ["id", 7], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  RelationTag Exists (0.1ms)  SELECT  1 AS one FROM "current_relation_tags" WHERE "current_relation_tags"."k" = $1 AND "current_relation_tags"."relation_id" = $2 LIMIT $3  [["k", "tag1"], ["relation_id", 7], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "current_relation_tags" ("relation_id", "k", "v") VALUES ($1, $2, $3) RETURNING "relation_id","k"  [["relation_id", 7], ["k", "tag1"], ["v", "value2"]]
  SQL (0.1ms)  DELETE FROM "current_relation_members" WHERE "current_relation_members"."relation_id" = $1  [["relation_id", 7]]
  SQL (0.2ms)  INSERT INTO "current_relation_members" ("relation_id", "member_type", "member_id", "member_role") VALUES ($1, $2, $3, $4) RETURNING "relation_id","sequence_id"  [["relation_id", 7], ["member_type", "Way"], ["member_id", 1620], ["member_role", ""]]
  SQL (0.1ms)  INSERT INTO "current_relation_members" ("relation_id", "member_type", "member_id", "member_role", "sequence_id") VALUES ($1, $2, $3, $4, $5) RETURNING "relation_id","sequence_id"  [["relation_id", 7], ["member_type", "Node"], ["member_id", 1980706], ["member_role", ""], ["sequence_id", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "relations" ("relation_id", "changeset_id", "timestamp", "version") VALUES ($1, $2, $3, $4) RETURNING "relation_id","version"  [["relation_id", 7], ["changeset_id", 33], ["timestamp", "2017-12-27 10:07:45.753836"], ["version", 1]]
  OldRelation Load (0.1ms)  SELECT  "relations".* FROM "relations" WHERE "relations"."relation_id" = $1 AND "relations"."version" = $2 LIMIT $3  [["relation_id", 7], ["version", 1], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  OldRelationTag Exists (0.1ms)  SELECT  1 AS one FROM "relation_tags" WHERE "relation_tags"."k" = $1 AND "relation_tags"."relation_id" = $2 AND "relation_tags"."version" = $3 LIMIT $4  [["k", "tag1"], ["relation_id", 7], ["version", 1], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "relation_tags" ("relation_id", "k", "v", "version") VALUES ($1, $2, $3, $4) RETURNING "relation_id","version","k"  [["relation_id", 7], ["k", "tag1"], ["v", "value2"], ["version", 1]]
  SQL (0.2ms)  INSERT INTO "relation_members" ("relation_id", "member_type", "member_id", "member_role", "version") VALUES ($1, $2, $3, $4, $5) RETURNING "relation_id","version","sequence_id"  [["relation_id", 7], ["member_type", "Way"], ["member_id", 1620], ["member_role", ""], ["version", 1]]
  SQL (0.2ms)  INSERT INTO "relation_members" ("relation_id", "member_type", "member_id", "member_role", "version", "sequence_id") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "relation_id","version","sequence_id"  [["relation_id", 7], ["member_type", "Node"], ["member_id", 1980706], ["member_role", ""], ["version", 1], ["sequence_id", 1]]
  Way Load (0.1ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1620], ["LIMIT", 1]]
  Node Load (0.3ms)  SELECT "current_nodes".* FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1620]]
  Node Load (0.2ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980706], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.3ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 11:07:45.772055"], ["num_changes", 19], ["id", 33]]
   (5.8ms)  COMMIT
Completed 200 OK in 119ms (Views: 0.1ms | ActiveRecord: 26.8ms)

Relation including relation

<osmChange version="0.6" generator="JOSM">
<modify>
  <relation id='6' version='1' changeset='33'>
    <member type='relation' ref='7' role='' />
    <member type='node' ref='1980705' role='' />
    <tag k='tag2' v='value2' />
  </relation>
</modify>
</osmChange>


Started POST "/api/0.6/changeset/33/upload" for 127.0.0.1 at 2017-12-27 11:09:26 +0100
Processing by ChangesetController#upload as HTML
  Parameters: {"id"=>"33"}
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE (email = 'mmd2' OR display_name = 'mmd2') LIMIT $1  [["LIMIT", 1]]
  UserBlock Load (0.2ms)  SELECT  "user_blocks".* FROM "user_blocks" WHERE "user_blocks"."user_id" = $1 AND (needs_view or ends_at > '2017-12-27 10:09:26.950567') LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
   (0.1ms)  BEGIN
  Relation Load (0.1ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2  [["id", 6], ["LIMIT", 1]]
  User Load (0.1ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
  Relation Load (0.1ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 6], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  RelationMember Load (0.2ms)  SELECT "current_relation_members".* FROM "current_relation_members" WHERE "current_relation_members"."relation_id" = $1 ORDER BY "current_relation_members"."sequence_id" ASC  [["relation_id", 6]]
  Relation Load (0.1ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2 for share  [["id", 7], ["LIMIT", 1]]
  RelationMember Load (0.1ms)  SELECT "current_relation_members".* FROM "current_relation_members" WHERE "current_relation_members"."relation_id" = $1 ORDER BY "current_relation_members"."sequence_id" ASC  [["relation_id", 7]]
  Way Load (0.1ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2 for share  [["id", 1620], ["LIMIT", 1]]
  WayNode Load (0.1ms)  SELECT "current_way_nodes".* FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1620]]
  Node Load (0.2ms)  SELECT "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" IN (1980703, 1980704) AND "current_nodes"."visible" = $1 for share  [["visible", "t"]]
  Node Load (0.1ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2 for share  [["id", 1980706], ["LIMIT", 1]]
  Relation Exists (0.1ms)  SELECT  1 AS one FROM "current_relations" WHERE "current_relations"."id" = $1 AND ("current_relations"."id" != $2) LIMIT $3  [["id", 6], ["id", 6], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.1ms)  UPDATE "current_relations" SET "version" = $1, "timestamp" = $2 WHERE "current_relations"."id" = $3  [["version", 2], ["timestamp", "2017-12-27 10:09:26.960062"], ["id", 6]]
  RelationTag Load (0.1ms)  SELECT "current_relation_tags".* FROM "current_relation_tags" WHERE "current_relation_tags"."relation_id" = $1  [["relation_id", 6]]
  SQL (0.1ms)  DELETE FROM "current_relation_tags" WHERE "current_relation_tags"."relation_id" = $1  [["relation_id", 6]]
  Relation Load (0.1ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2  [["id", 6], ["LIMIT", 1]]
  Relation Exists (0.1ms)  SELECT  1 AS one FROM "current_relations" WHERE "current_relations"."id" = $1 AND ("current_relations"."id" != $2) LIMIT $3  [["id", 6], ["id", 6], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  RelationTag Exists (0.1ms)  SELECT  1 AS one FROM "current_relation_tags" WHERE "current_relation_tags"."k" = $1 AND "current_relation_tags"."relation_id" = $2 LIMIT $3  [["k", "tag2"], ["relation_id", 6], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "current_relation_tags" ("relation_id", "k", "v") VALUES ($1, $2, $3) RETURNING "relation_id","k"  [["relation_id", 6], ["k", "tag2"], ["v", "value2"]]
  SQL (0.1ms)  DELETE FROM "current_relation_members" WHERE "current_relation_members"."relation_id" = $1  [["relation_id", 6]]
  SQL (0.2ms)  INSERT INTO "current_relation_members" ("relation_id", "member_type", "member_id", "member_role") VALUES ($1, $2, $3, $4) RETURNING "relation_id","sequence_id"  [["relation_id", 6], ["member_type", "Relation"], ["member_id", 7], ["member_role", ""]]
  SQL (0.1ms)  INSERT INTO "current_relation_members" ("relation_id", "member_type", "member_id", "member_role", "sequence_id") VALUES ($1, $2, $3, $4, $5) RETURNING "relation_id","sequence_id"  [["relation_id", 6], ["member_type", "Node"], ["member_id", 1980705], ["member_role", ""], ["sequence_id", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "relations" ("relation_id", "changeset_id", "timestamp", "version") VALUES ($1, $2, $3, $4) RETURNING "relation_id","version"  [["relation_id", 6], ["changeset_id", 33], ["timestamp", "2017-12-27 10:09:26.960062"], ["version", 2]]
  OldRelation Load (0.1ms)  SELECT  "relations".* FROM "relations" WHERE "relations"."relation_id" = $1 AND "relations"."version" = $2 LIMIT $3  [["relation_id", 6], ["version", 2], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  OldRelationTag Exists (0.1ms)  SELECT  1 AS one FROM "relation_tags" WHERE "relation_tags"."k" = $1 AND "relation_tags"."relation_id" = $2 AND "relation_tags"."version" = $3 LIMIT $4  [["k", "tag2"], ["relation_id", 6], ["version", 2], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "relation_tags" ("relation_id", "k", "v", "version") VALUES ($1, $2, $3, $4) RETURNING "relation_id","version","k"  [["relation_id", 6], ["k", "tag2"], ["v", "value2"], ["version", 2]]
  SQL (0.2ms)  INSERT INTO "relation_members" ("relation_id", "member_type", "member_id", "member_role", "version") VALUES ($1, $2, $3, $4, $5) RETURNING "relation_id","version","sequence_id"  [["relation_id", 6], ["member_type", "Relation"], ["member_id", 7], ["member_role", ""], ["version", 2]]
  SQL (0.2ms)  INSERT INTO "relation_members" ("relation_id", "member_type", "member_id", "member_role", "version", "sequence_id") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "relation_id","version","sequence_id"  [["relation_id", 6], ["member_type", "Node"], ["member_id", 1980705], ["member_role", ""], ["version", 2], ["sequence_id", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 11:09:26.977525"], ["num_changes", 20], ["id", 33]]
   (1.9ms)  COMMIT
Completed 200 OK in 42ms (Views: 0.1ms | ActiveRecord: 7.6ms)


Delete child relation

<osmChange version="0.6" generator="JOSM">
<modify>
  <relation id='6' version='2' changeset='33'>
    <member type='node' ref='1980705' role='' />
    <tag k='tag2' v='value2' />
  </relation>
</modify>
<delete>
  <relation id='7' version='1' changeset='33'/>
</delete>
</osmChange>


Started POST "/api/0.6/changeset/33/upload" for 127.0.0.1 at 2017-12-27 11:10:42 +0100
Processing by ChangesetController#upload as HTML
  Parameters: {"id"=>"33"}
  User Load (0.5ms)  SELECT  "users".* FROM "users" WHERE (email = 'mmd2' OR display_name = 'mmd2') LIMIT $1  [["LIMIT", 1]]
  UserBlock Load (0.2ms)  SELECT  "user_blocks".* FROM "user_blocks" WHERE "user_blocks"."user_id" = $1 AND (needs_view or ends_at > '2017-12-27 10:10:42.913555') LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
  Changeset Load (0.3ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
   (0.0ms)  BEGIN
  Relation Load (0.1ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2  [["id", 6], ["LIMIT", 1]]
  User Load (0.2ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
  Relation Load (0.1ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 6], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  RelationMember Load (0.2ms)  SELECT "current_relation_members".* FROM "current_relation_members" WHERE "current_relation_members"."relation_id" = $1 ORDER BY "current_relation_members"."sequence_id" ASC  [["relation_id", 6]]
  Relation Exists (0.1ms)  SELECT  1 AS one FROM "current_relations" WHERE "current_relations"."id" = $1 AND ("current_relations"."id" != $2) LIMIT $3  [["id", 6], ["id", 6], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "current_relations" SET "version" = $1, "timestamp" = $2 WHERE "current_relations"."id" = $3  [["version", 3], ["timestamp", "2017-12-27 10:10:42.919358"], ["id", 6]]
  RelationTag Load (0.1ms)  SELECT "current_relation_tags".* FROM "current_relation_tags" WHERE "current_relation_tags"."relation_id" = $1  [["relation_id", 6]]
  SQL (0.1ms)  DELETE FROM "current_relation_tags" WHERE "current_relation_tags"."relation_id" = $1  [["relation_id", 6]]
  Relation Load (0.1ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2  [["id", 6], ["LIMIT", 1]]
  Relation Exists (0.1ms)  SELECT  1 AS one FROM "current_relations" WHERE "current_relations"."id" = $1 AND ("current_relations"."id" != $2) LIMIT $3  [["id", 6], ["id", 6], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  RelationTag Exists (0.1ms)  SELECT  1 AS one FROM "current_relation_tags" WHERE "current_relation_tags"."k" = $1 AND "current_relation_tags"."relation_id" = $2 LIMIT $3  [["k", "tag2"], ["relation_id", 6], ["LIMIT", 1]]
  SQL (0.1ms)  INSERT INTO "current_relation_tags" ("relation_id", "k", "v") VALUES ($1, $2, $3) RETURNING "relation_id","k"  [["relation_id", 6], ["k", "tag2"], ["v", "value2"]]
  SQL (0.1ms)  DELETE FROM "current_relation_members" WHERE "current_relation_members"."relation_id" = $1  [["relation_id", 6]]
  SQL (0.1ms)  INSERT INTO "current_relation_members" ("relation_id", "member_type", "member_id", "member_role") VALUES ($1, $2, $3, $4) RETURNING "relation_id","sequence_id"  [["relation_id", 6], ["member_type", "Node"], ["member_id", 1980705], ["member_role", ""]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "relations" ("relation_id", "changeset_id", "timestamp", "version") VALUES ($1, $2, $3, $4) RETURNING "relation_id","version"  [["relation_id", 6], ["changeset_id", 33], ["timestamp", "2017-12-27 10:10:42.919358"], ["version", 3]]
  OldRelation Load (0.1ms)  SELECT  "relations".* FROM "relations" WHERE "relations"."relation_id" = $1 AND "relations"."version" = $2 LIMIT $3  [["relation_id", 6], ["version", 3], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  OldRelationTag Exists (0.1ms)  SELECT  1 AS one FROM "relation_tags" WHERE "relation_tags"."k" = $1 AND "relation_tags"."relation_id" = $2 AND "relation_tags"."version" = $3 LIMIT $4  [["k", "tag2"], ["relation_id", 6], ["version", 3], ["LIMIT", 1]]
  SQL (0.1ms)  INSERT INTO "relation_tags" ("relation_id", "k", "v", "version") VALUES ($1, $2, $3, $4) RETURNING "relation_id","version","k"  [["relation_id", 6], ["k", "tag2"], ["v", "value2"], ["version", 3]]
  SQL (0.1ms)  INSERT INTO "relation_members" ("relation_id", "member_type", "member_id", "member_role", "version") VALUES ($1, $2, $3, $4, $5) RETURNING "relation_id","version","sequence_id"  [["relation_id", 6], ["member_type", "Node"], ["member_id", 1980705], ["member_role", ""], ["version", 3]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 11:10:42.934513"], ["num_changes", 21], ["id", 33]]
  Relation Load (0.1ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2  [["id", 7], ["LIMIT", 1]]
  CACHE Relation Load (0.0ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2  [["id", 7], ["LIMIT", 1]]
  RelationMember Load (0.1ms)  SELECT "current_relation_members".* FROM "current_relation_members" WHERE "current_relation_members"."relation_id" = $1 ORDER BY "current_relation_members"."sequence_id" ASC  [["relation_id", 7]]
  Relation Load (0.1ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 7], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  RelationMember Load (0.2ms)  SELECT  "current_relation_members".* FROM "current_relation_members" INNER JOIN "current_relations" ON "current_relations"."id" = "current_relation_members"."relation_id" WHERE (visible = 't' AND member_type = 'Relation' and member_id = 7 ) LIMIT $1  [["LIMIT", 1]]
  Relation Exists (0.1ms)  SELECT  1 AS one FROM "current_relations" WHERE "current_relations"."id" = $1 AND ("current_relations"."id" != $2) LIMIT $3  [["id", 7], ["id", 7], ["LIMIT", 1]]
  CACHE Changeset Load (0.0ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.1ms)  UPDATE "current_relations" SET "version" = $1, "visible" = $2, "timestamp" = $3 WHERE "current_relations"."id" = $4  [["version", 2], ["visible", "f"], ["timestamp", "2017-12-27 10:10:42.939159"], ["id", 7]]
  RelationTag Load (0.2ms)  SELECT "current_relation_tags".* FROM "current_relation_tags" WHERE "current_relation_tags"."relation_id" = $1  [["relation_id", 7]]
  SQL (0.1ms)  DELETE FROM "current_relation_tags" WHERE "current_relation_tags"."relation_id" = $1  [["relation_id", 7]]
  RelationMember Load (0.2ms)  SELECT "current_relation_members".* FROM "current_relation_members" WHERE "current_relation_members"."relation_id" = $1 ORDER BY "current_relation_members"."sequence_id" ASC  [["relation_id", 7]]
  SQL (0.2ms)  DELETE FROM "current_relation_members" WHERE "current_relation_members"."relation_id" = $1  [["relation_id", 7]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.3ms)  INSERT INTO "relations" ("relation_id", "changeset_id", "timestamp", "version", "visible") VALUES ($1, $2, $3, $4, $5) RETURNING "relation_id","version"  [["relation_id", 7], ["changeset_id", 33], ["timestamp", "2017-12-27 10:10:42.939159"], ["version", 2], ["visible", "f"]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.3ms)  UPDATE "changesets" SET "num_changes" = $1, "closed_at" = $2 WHERE "changesets"."id" = $3  [["num_changes", 22], ["closed_at", "2017-12-27 11:10:42.949188"], ["id", 33]]
   (2.0ms)  COMMIT
Completed 200 OK in 51ms (Views: 0.1ms | ActiveRecord: 9.4ms)

Delete relation, way, node

<osmChange version="0.6" generator="JOSM">
<delete>
  <relation id='6' version='3' changeset='33'/>
  <way id='1620' version='1' changeset='33'/>
  <node id='1980703' version='1' changeset='33'/>
  <node id='1980704' version='1' changeset='33'/>
  <node id='1980705' version='1' changeset='33'/>
  <node id='1980706' version='1' changeset='33'/>
</delete>
</osmChange>
Started POST "/api/0.6/changeset/33/upload" for 127.0.0.1 at 2017-12-27 11:12:17 +0100
Processing by ChangesetController#upload as HTML
  Parameters: {"id"=>"33"}
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE (email = 'mmd2' OR display_name = 'mmd2') LIMIT $1  [["LIMIT", 1]]
  UserBlock Load (0.3ms)  SELECT  "user_blocks".* FROM "user_blocks" WHERE "user_blocks"."user_id" = $1 AND (needs_view or ends_at > '2017-12-27 10:12:17.294285') LIMIT $2  [["user_id", 1], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
   (0.1ms)  BEGIN
  Relation Load (0.1ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2  [["id", 6], ["LIMIT", 1]]
  CACHE Relation Load (0.0ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2  [["id", 6], ["LIMIT", 1]]
  RelationMember Load (0.2ms)  SELECT "current_relation_members".* FROM "current_relation_members" WHERE "current_relation_members"."relation_id" = $1 ORDER BY "current_relation_members"."sequence_id" ASC  [["relation_id", 6]]
  User Load (0.1ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
  Relation Load (0.2ms)  SELECT  "current_relations".* FROM "current_relations" WHERE "current_relations"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 6], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  RelationMember Load (0.2ms)  SELECT  "current_relation_members".* FROM "current_relation_members" INNER JOIN "current_relations" ON "current_relations"."id" = "current_relation_members"."relation_id" WHERE (visible = 't' AND member_type = 'Relation' and member_id = 6 ) LIMIT $1  [["LIMIT", 1]]
  Relation Exists (0.1ms)  SELECT  1 AS one FROM "current_relations" WHERE "current_relations"."id" = $1 AND ("current_relations"."id" != $2) LIMIT $3  [["id", 6], ["id", 6], ["LIMIT", 1]]
  CACHE Changeset Load (0.0ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "current_relations" SET "version" = $1, "visible" = $2, "timestamp" = $3 WHERE "current_relations"."id" = $4  [["version", 4], ["visible", "f"], ["timestamp", "2017-12-27 10:12:17.300222"], ["id", 6]]
  RelationTag Load (0.1ms)  SELECT "current_relation_tags".* FROM "current_relation_tags" WHERE "current_relation_tags"."relation_id" = $1  [["relation_id", 6]]
  SQL (0.1ms)  DELETE FROM "current_relation_tags" WHERE "current_relation_tags"."relation_id" = $1  [["relation_id", 6]]
  RelationMember Load (0.1ms)  SELECT "current_relation_members".* FROM "current_relation_members" WHERE "current_relation_members"."relation_id" = $1 ORDER BY "current_relation_members"."sequence_id" ASC  [["relation_id", 6]]
  SQL (0.1ms)  DELETE FROM "current_relation_members" WHERE "current_relation_members"."relation_id" = $1  [["relation_id", 6]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "relations" ("relation_id", "changeset_id", "timestamp", "version", "visible") VALUES ($1, $2, $3, $4, $5) RETURNING "relation_id","version"  [["relation_id", 6], ["changeset_id", 33], ["timestamp", "2017-12-27 10:12:17.300222"], ["version", 4], ["visible", "f"]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "num_changes" = $1, "closed_at" = $2 WHERE "changesets"."id" = $3  [["num_changes", 23], ["closed_at", "2017-12-27 11:12:17.308846"], ["id", 33]]
  Way Load (0.1ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1620], ["LIMIT", 1]]
  CACHE Way Load (0.0ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1620], ["LIMIT", 1]]
  WayNode Load (0.1ms)  SELECT "current_way_nodes".* FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1620]]
  Way Load (0.1ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 1620], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Relation Exists (0.2ms)  SELECT  1 AS one FROM "current_relations" INNER JOIN "current_relation_members" ON "current_relation_members"."relation_id" = "current_relations"."id" WHERE "current_relations"."visible" = $1 AND "current_relation_members"."member_type" = $2 AND "current_relation_members"."member_id" = $3 LIMIT $4  [["visible", "t"], ["member_type", "Way"], ["member_id", 1620], ["LIMIT", 1]]
  Node Exists (0.2ms)  SELECT  1 AS one FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 LIMIT $2  [["way_id", 1620], ["LIMIT", 1]]
  Node Load (0.2ms)  SELECT "current_nodes".* FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 ORDER BY "current_way_nodes"."sequence_id" ASC  [["way_id", 1620]]
  Way Exists (0.1ms)  SELECT  1 AS one FROM "current_ways" WHERE "current_ways"."id" = $1 AND ("current_ways"."id" != $2) LIMIT $3  [["id", 1620], ["id", 1620], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.1ms)  UPDATE "current_ways" SET "version" = $1, "visible" = $2, "timestamp" = $3 WHERE "current_ways"."id" = $4  [["version", 2], ["visible", "f"], ["timestamp", "2017-12-27 10:12:17.313427"], ["id", 1620]]
  SQL (0.1ms)  DELETE FROM "current_way_tags" WHERE "current_way_tags"."way_id" = $1  [["way_id", 1620]]
  SQL (0.1ms)  DELETE FROM "current_way_nodes" WHERE "current_way_nodes"."way_id" = $1  [["way_id", 1620]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "ways" ("way_id", "changeset_id", "timestamp", "version", "visible") VALUES ($1, $2, $3, $4, $5) RETURNING "way_id","version"  [["way_id", 1620], ["changeset_id", 33], ["timestamp", "2017-12-27 10:12:17.313427"], ["version", 2], ["visible", "f"]]
  Way Load (0.1ms)  SELECT  "current_ways".* FROM "current_ways" WHERE "current_ways"."id" = $1 LIMIT $2  [["id", 1620], ["LIMIT", 1]]
  Node Exists (0.2ms)  SELECT  1 AS one FROM "current_nodes" INNER JOIN "current_way_nodes" ON "current_nodes"."id" = "current_way_nodes"."node_id" WHERE "current_way_nodes"."way_id" = $1 LIMIT $2  [["way_id", 1620], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "closed_at" = $1, "num_changes" = $2 WHERE "changesets"."id" = $3  [["closed_at", "2017-12-27 11:12:17.323411"], ["num_changes", 24], ["id", 33]]
  Node Load (0.1ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980703], ["LIMIT", 1]]
  CACHE Node Load (0.0ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980703], ["LIMIT", 1]]
  Node Load (0.1ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 1980703], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Way Exists (0.2ms)  SELECT  1 AS one FROM "current_ways" INNER JOIN "current_way_nodes" ON "current_way_nodes"."way_id" = "current_ways"."id" WHERE "current_ways"."visible" = $1 AND "current_way_nodes"."node_id" = $2 LIMIT $3  [["visible", "t"], ["node_id", 1980703], ["LIMIT", 1]]
  Relation Exists (0.2ms)  SELECT  1 AS one FROM "current_relations" INNER JOIN "current_relation_members" ON "current_relation_members"."relation_id" = "current_relations"."id" WHERE "current_relations"."visible" = $1 AND "current_relation_members"."member_type" = $2 AND "current_relation_members"."member_id" = $3 LIMIT $4  [["visible", "t"], ["member_type", "Node"], ["member_id", 1980703], ["LIMIT", 1]]
  CACHE Changeset Load (0.0ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Exists (0.3ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" = $1 AND ("current_nodes"."id" != $2) LIMIT $3  [["id", 1980703], ["id", 1980703], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "current_nodes" SET "version" = $1, "visible" = $2, "timestamp" = $3 WHERE "current_nodes"."id" = $4  [["version", 2], ["visible", "f"], ["timestamp", "2017-12-27 10:12:17.335305"], ["id", 1980703]]
  SQL (0.1ms)  DELETE FROM "current_node_tags" WHERE "current_node_tags"."node_id" = $1  [["node_id", 1980703]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "nodes" ("node_id", "latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "node_id","version"  [["node_id", 1980703], ["latitude", 407219544], ["longitude", -740272415], ["changeset_id", 33], ["visible", "f"], ["timestamp", "2017-12-27 10:12:17.335305"], ["tile", 1707833038], ["version", 2]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "num_changes" = $1, "closed_at" = $2 WHERE "changesets"."id" = $3  [["num_changes", 25], ["closed_at", "2017-12-27 11:12:17.341800"], ["id", 33]]
  Node Load (0.1ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980704], ["LIMIT", 1]]
  CACHE Node Load (0.0ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980704], ["LIMIT", 1]]
  Node Load (0.1ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 1980704], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Way Exists (0.2ms)  SELECT  1 AS one FROM "current_ways" INNER JOIN "current_way_nodes" ON "current_way_nodes"."way_id" = "current_ways"."id" WHERE "current_ways"."visible" = $1 AND "current_way_nodes"."node_id" = $2 LIMIT $3  [["visible", "t"], ["node_id", 1980704], ["LIMIT", 1]]
  Relation Exists (0.2ms)  SELECT  1 AS one FROM "current_relations" INNER JOIN "current_relation_members" ON "current_relation_members"."relation_id" = "current_relations"."id" WHERE "current_relations"."visible" = $1 AND "current_relation_members"."member_type" = $2 AND "current_relation_members"."member_id" = $3 LIMIT $4  [["visible", "t"], ["member_type", "Node"], ["member_id", 1980704], ["LIMIT", 1]]
  CACHE Changeset Load (0.0ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Exists (0.1ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" = $1 AND ("current_nodes"."id" != $2) LIMIT $3  [["id", 1980704], ["id", 1980704], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "current_nodes" SET "version" = $1, "visible" = $2, "timestamp" = $3 WHERE "current_nodes"."id" = $4  [["version", 2], ["visible", "f"], ["timestamp", "2017-12-27 10:12:17.346510"], ["id", 1980704]]
  SQL (0.1ms)  DELETE FROM "current_node_tags" WHERE "current_node_tags"."node_id" = $1  [["node_id", 1980704]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "nodes" ("node_id", "latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "node_id","version"  [["node_id", 1980704], ["latitude", 407219117], ["longitude", -740269813], ["changeset_id", 33], ["visible", "f"], ["timestamp", "2017-12-27 10:12:17.346510"], ["tile", 1707833060], ["version", 2]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "num_changes" = $1, "closed_at" = $2 WHERE "changesets"."id" = $3  [["num_changes", 26], ["closed_at", "2017-12-27 11:12:17.352711"], ["id", 33]]
  Node Load (0.3ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980705], ["LIMIT", 1]]
  CACHE Node Load (0.0ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980705], ["LIMIT", 1]]
  Node Load (0.4ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 1980705], ["LIMIT", 1]]
  Changeset Load (0.2ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Way Exists (0.3ms)  SELECT  1 AS one FROM "current_ways" INNER JOIN "current_way_nodes" ON "current_way_nodes"."way_id" = "current_ways"."id" WHERE "current_ways"."visible" = $1 AND "current_way_nodes"."node_id" = $2 LIMIT $3  [["visible", "t"], ["node_id", 1980705], ["LIMIT", 1]]
  Relation Exists (0.2ms)  SELECT  1 AS one FROM "current_relations" INNER JOIN "current_relation_members" ON "current_relation_members"."relation_id" = "current_relations"."id" WHERE "current_relations"."visible" = $1 AND "current_relation_members"."member_type" = $2 AND "current_relation_members"."member_id" = $3 LIMIT $4  [["visible", "t"], ["member_type", "Node"], ["member_id", 1980705], ["LIMIT", 1]]
  CACHE Changeset Load (0.0ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Exists (0.2ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" = $1 AND ("current_nodes"."id" != $2) LIMIT $3  [["id", 1980705], ["id", 1980705], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "current_nodes" SET "version" = $1, "visible" = $2, "timestamp" = $3 WHERE "current_nodes"."id" = $4  [["version", 2], ["visible", "f"], ["timestamp", "2017-12-27 10:12:17.358077"], ["id", 1980705]]
  SQL (0.1ms)  DELETE FROM "current_node_tags" WHERE "current_node_tags"."node_id" = $1  [["node_id", 1980705]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.3ms)  INSERT INTO "nodes" ("node_id", "latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "node_id","version"  [["node_id", 1980705], ["latitude", 407218172], ["longitude", -740270658], ["changeset_id", 33], ["visible", "f"], ["timestamp", "2017-12-27 10:12:17.358077"], ["tile", 1707833038], ["version", 2]]
  Changeset Exists (0.2ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "num_changes" = $1, "closed_at" = $2 WHERE "changesets"."id" = $3  [["num_changes", 27], ["closed_at", "2017-12-27 11:12:17.363732"], ["id", 33]]
  Node Load (0.1ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980706], ["LIMIT", 1]]
  CACHE Node Load (0.0ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2  [["id", 1980706], ["LIMIT", 1]]
  Node Load (0.2ms)  SELECT  "current_nodes".* FROM "current_nodes" WHERE "current_nodes"."id" = $1 LIMIT $2 FOR UPDATE  [["id", 1980706], ["LIMIT", 1]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Way Exists (0.3ms)  SELECT  1 AS one FROM "current_ways" INNER JOIN "current_way_nodes" ON "current_way_nodes"."way_id" = "current_ways"."id" WHERE "current_ways"."visible" = $1 AND "current_way_nodes"."node_id" = $2 LIMIT $3  [["visible", "t"], ["node_id", 1980706], ["LIMIT", 1]]
  Relation Exists (0.2ms)  SELECT  1 AS one FROM "current_relations" INNER JOIN "current_relation_members" ON "current_relation_members"."relation_id" = "current_relations"."id" WHERE "current_relations"."visible" = $1 AND "current_relation_members"."member_type" = $2 AND "current_relation_members"."member_id" = $3 LIMIT $4  [["visible", "t"], ["member_type", "Node"], ["member_id", 1980706], ["LIMIT", 1]]
  CACHE Changeset Load (0.0ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Node Exists (0.2ms)  SELECT  1 AS one FROM "current_nodes" WHERE "current_nodes"."id" = $1 AND ("current_nodes"."id" != $2) LIMIT $3  [["id", 1980706], ["id", 1980706], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.3ms)  UPDATE "current_nodes" SET "version" = $1, "visible" = $2, "timestamp" = $3 WHERE "current_nodes"."id" = $4  [["version", 2], ["visible", "f"], ["timestamp", "2017-12-27 10:12:17.368267"], ["id", 1980706]]
  SQL (0.1ms)  DELETE FROM "current_node_tags" WHERE "current_node_tags"."node_id" = $1  [["node_id", 1980706]]
  Changeset Load (0.1ms)  SELECT  "changesets".* FROM "changesets" WHERE "changesets"."id" = $1 LIMIT $2  [["id", 33], ["LIMIT", 1]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  INSERT INTO "nodes" ("node_id", "latitude", "longitude", "changeset_id", "visible", "timestamp", "tile", "version") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) RETURNING "node_id","version"  [["node_id", 1980706], ["latitude", 407218233], ["longitude", -740272200], ["changeset_id", 33], ["visible", "f"], ["timestamp", "2017-12-27 10:12:17.368267"], ["tile", 1707833038], ["version", 2]]
  Changeset Exists (0.1ms)  SELECT  1 AS one FROM "changesets" WHERE "changesets"."id" = $1 AND ("changesets"."id" != $2) LIMIT $3  [["id", 33], ["id", 33], ["LIMIT", 1]]
  SQL (0.2ms)  UPDATE "changesets" SET "num_changes" = $1, "closed_at" = $2 WHERE "changesets"."id" = $3  [["num_changes", 28], ["closed_at", "2017-12-27 11:12:17.374107"], ["id", 33]]
   (2.6ms)  COMMIT
Completed 200 OK in 96ms (Views: 0.1ms | ActiveRecord: 19.0ms)