User:Mmd/OsmChange upload logs
< User:Mmd
Jump to navigation
Jump to 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)