» Plaine Commune » Traffic » Express decision (demo only) #3

i6: Let's paint our town hall in blue

Rejected (rank 2)

4	Yes	57%	Yes
3	No	42%	No
0	Abstention	0%	Abstention

Let's paint our town hall in blue

draft history (1)

Suggestions for improvement (1)

written and rated by the supporters of this initiative to improve the proposal and its reasons

Light blue

by Ilia Christantoni

collective rating:

| implemented:

Light blue would be preferable.

Details

Express decision (demo only) #3

1. Admission (reached 1)

2. Discussion (finished)

3. Verification (reached 10.0% / 1)

4. Voting (finished)

Finished with winner

Competing initiatives

i5: Paint the Town Hall
by Axel Kistner
Reached ≥50/100: 4 Yes (57%), 3 No (42%), 0 Abstention (0%)
Competing initiatives in pairwise comparison to winner:
i7: Paint the town hall with white color
by Björn Swierczek
i8: i8: Leave Town Hall at it is
by Alejandro Blanco-M

What can I do here?

This issue is closed

Voters

Ilia Christantoni

Axel Kistner

Giacomo Gilmozzi

Gregory Tsardanidis

Andreas Nitsche

Björn Swierczek

Alejandro Blanco-M

TRACE

System trace (for computer programmers purposes)

this: u=1.7, d=0.0, t=1.7 | children: u=0.0, d=0.0, t=0.0 | total: u=1.7, d=0.0, t=1.7 ms
Configuration "devel"
REQUESTED VIEW: initiative/show
this: u=1.6, d=2.0, t=3.5 | children: u=22.4, d=17.8, t=37.5 | total: u=24.0, d=19.7, t=41.0 ms
/main/_filter/20_session.lua
- INSERT INTO "session" ("additional_secret", "ident") VALUES ('QEa6NOga6mUB8LBe4MUWQA0YvlT6gY3n3Xl2vCjgijuSE6jU', 'eGt4jV061goDcDUwnanKlzZg') RETURNING "ident"; 2.0 ms
- this: u=0.3, d=0.0, t=0.3 | children: u=22.1, d=17.8, t=37.3 | total: u=22.4, d=17.8, t=37.5 ms
  /main/_filter/21_auth.lua
  - No authentication needed.
  - this: u=0.5, d=0.0, t=0.5 | children: u=21.6, d=17.8, t=36.8 | total: u=22.1, d=17.8, t=37.3 ms
    /main/_filter_view/30_navigation.lua
    - this: u=0.0, d=0.0, t=0.0 | children: u=21.6, d=17.8, t=36.7 | total: u=21.6, d=17.8, t=36.8 ms
      /main/_filter_view/34_stylesheet.lua
      - this: u=0.1, d=0.0, t=0.1 | children: u=21.5, d=17.8, t=36.6 | total: u=21.6, d=17.8, t=36.7 ms
        /main/_filter_view/36_html_title.lua
        this: u=3.2, d=4.4, t=7.2 | children: u=18.2, d=13.3, t=29.5 | total: u=21.5, d=17.8, t=36.6 ms
        EXECUTE VIEW: initiative/show
        SELECT "initiative".* FROM "initiative" WHERE (id = 6) LIMIT 1; 1.8 ms
        SELECT "issue".*, justify_interval(min_admission_time)::text AS "min_admission_time_text", justify_interval(max_admission_time)::text AS "max_admission_time_text", justify_interval(discussion_time)::text AS "discussion_time_text", justify_interval(verification_time)::text AS "verification_time_text", justify_interval(voting_time)::text AS "voting_time_text", justify_interval(coalesce(issue.fully_frozen + issue.voting_time, issue.half_frozen + issue.verification_time, issue.accepted + issue.discussion_time, issue.created + issue.max_admission_time) - now()) AS "state_time_left", justify_interval(now() - issue.closed) AS "closed_ago" FROM "issue" WHERE ("issue"."id" IN (3)); 1.2 ms
        this: u=3.6, d=2.1, t=5.4 | children: u=0.0, d=0.0, t=0.0 | total: u=3.6, d=2.1, t=5.4 ms
        EXECUTE VIEW: issue/_head
        SELECT "policy".*, justify_interval(min_admission_time)::text AS "min_admission_time_text", justify_interval(max_admission_time)::text AS "max_admission_time_text", justify_interval(discussion_time)::text AS "discussion_time_text", justify_interval(verification_time)::text AS "verification_time_text", justify_interval(voting_time)::text AS "voting_time_text" FROM "policy" WHERE ("policy"."id" IN (2)); 0.8 ms
        SELECT "area".* FROM "area" WHERE ("area"."id" IN (1)); 0.7 ms
        SELECT "unit".* FROM "unit" WHERE ("unit"."id" IN (1)); 0.6 ms
        this: u=0.9, d=1.7, t=2.4 | children: u=1.0, d=0.0, t=1.0 | total: u=1.9, d=1.7, t=3.4 ms
        EXECUTE VIEW: initiative/_head
        SELECT "member".*, "initiator"."initiative_id" AS "mm_ref_", initiator.accepted AS "accepted" FROM "member" INNER JOIN "initiator" ON "initiator"."member_id" = "member"."id" WHERE ("initiator"."initiative_id" IN (6)) AND (initiator.accepted) ORDER BY member.name; 1.7 ms
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: initiative/_bargraph
        this: u=0.9, d=0.0, t=0.9 | children: u=0.0, d=0.0, t=0.0 | total: u=0.9, d=0.0, t=0.9 ms
        EXECUTE VIEW: initiative/_sidebar_state
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 6) ORDER BY "id" DESC LIMIT 1; 0.8 ms
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 6) ORDER BY "id" DESC LIMIT 1; 0.2 ms
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 6) ORDER BY "id" DESC LIMIT 1; 0.2 ms
        SELECT count(1) FROM (SELECT "draft".* FROM "draft" WHERE ("draft"."initiative_id" IN (6)) ORDER BY "id" DESC) AS "subquery" LIMIT 1; 0.3 ms
        this: u=2.8, d=1.8, t=4.1 | children: u=0.5, d=0.0, t=0.5 | total: u=3.3, d=1.8, t=4.7 ms
        EXECUTE VIEW: initiative/_suggestions
        SELECT "suggestion".* FROM "suggestion" WHERE ("suggestion"."initiative_id" IN (6)) ORDER BY "proportional_order" NULLS LAST, id; 0.7 ms
        SELECT "opinion".* FROM "opinion" WHERE (member_id = NULL) AND (suggestion_id = 9) LIMIT 1; 0.3 ms
        SELECT "member".* FROM "member" WHERE ("member"."id" IN (8)); 0.3 ms
        this: u=0.5, d=0.0, t=0.5 | children: u=0.0, d=0.0, t=0.0 | total: u=0.5, d=0.0, t=0.5 ms
        EXECUTE VIEW: suggestion/_collective_rating
        SELECT "rendered_suggestion".* FROM "rendered_suggestion" WHERE (suggestion_id = 9) AND (format = 'html') LIMIT 1; 0.4 ms
        this: u=0.3, d=0.0, t=0.3 | children: u=4.4, d=4.0, t=7.6 | total: u=4.7, d=4.0, t=7.9 ms
        EXECUTE VIEW: issue/_sidebar
        this: u=0.7, d=0.0, t=0.7 | children: u=0.0, d=0.0, t=0.0 | total: u=0.7, d=0.0, t=0.7 ms
        EXECUTE VIEW: issue/_sidebar_state
        this: u=0.5, d=0.6, t=1.0 | children: u=3.2, d=3.3, t=5.8 | total: u=3.8, d=4.0, t=6.9 ms
        EXECUTE VIEW: issue/_sidebar_issue
        SELECT "initiative".* FROM "initiative" WHERE ("initiative"."issue_id" IN (3)) ORDER BY initiative.admitted DESC NULLS LAST, initiative.rank NULLS LAST, initiative.harmonic_weight DESC NULLS LAST, id; 0.6 ms
        this: u=0.4, d=0.0, t=0.4 | children: u=2.8, d=3.3, t=5.4 | total: u=3.2, d=3.3, t=5.8 ms
        EXECUTE VIEW: initiative/_list
        this: u=1.0, d=1.0, t=1.7 | children: u=0.0, d=0.0, t=0.0 | total: u=1.0, d=1.0, t=1.7 ms
        EXECUTE VIEW: initiative/_list_element
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 5) ORDER BY "id" DESC LIMIT 1; 0.2 ms
        SELECT "member".*, "initiator"."initiative_id" AS "mm_ref_", initiator.accepted AS "accepted" FROM "member" INNER JOIN "initiator" ON "initiator"."member_id" = "member"."id" WHERE ("initiator"."initiative_id" IN (5)) AND (initiator.accepted) ORDER BY member.name; 0.7 ms
        this: u=0.6, d=0.7, t=1.1 | children: u=0.4, d=0.5, t=0.8 | total: u=1.0, d=1.3, t=2.0 ms
        EXECUTE VIEW: initiative/_list_element
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 7) ORDER BY "id" DESC LIMIT 1; 0.2 ms
        SELECT "member".*, "initiator"."initiative_id" AS "mm_ref_", initiator.accepted AS "accepted" FROM "member" INNER JOIN "initiator" ON "initiator"."member_id" = "member"."id" WHERE ("initiator"."initiative_id" IN (7)) AND (initiator.accepted) ORDER BY member.name; 0.5 ms
        this: u=0.4, d=0.5, t=0.8 | children: u=0.0, d=0.0, t=0.0 | total: u=0.4, d=0.5, t=0.8 ms
        EXECUTE VIEW: initiative/_bargraph
        SELECT "battle".* FROM "battle" WHERE (winning_initiative_id = 5) AND (losing_initiative_id = 7) LIMIT 1; 0.4 ms
        SELECT "battle".* FROM "battle" WHERE (winning_initiative_id = 7) AND (losing_initiative_id = 5) LIMIT 1; 0.1 ms
        this: u=0.6, d=0.8, t=1.2 | children: u=0.3, d=0.3, t=0.5 | total: u=0.9, d=1.1, t=1.8 ms
        EXECUTE VIEW: initiative/_list_element
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 8) ORDER BY "id" DESC LIMIT 1; 0.2 ms
        SELECT "member".*, "initiator"."initiative_id" AS "mm_ref_", initiator.accepted AS "accepted" FROM "member" INNER JOIN "initiator" ON "initiator"."member_id" = "member"."id" WHERE ("initiator"."initiative_id" IN (8)) AND (initiator.accepted) ORDER BY member.name; 0.6 ms
        this: u=0.3, d=0.3, t=0.5 | children: u=0.0, d=0.0, t=0.0 | total: u=0.3, d=0.3, t=0.5 ms
        EXECUTE VIEW: initiative/_bargraph
        SELECT "battle".* FROM "battle" WHERE (winning_initiative_id = 5) AND (losing_initiative_id = 8) LIMIT 1; 0.2 ms
        SELECT "battle".* FROM "battle" WHERE (winning_initiative_id = 8) AND (losing_initiative_id = 5) LIMIT 1; 0.1 ms
        this: u=1.2, d=0.5, t=1.6 | children: u=0.0, d=0.0, t=0.0 | total: u=1.2, d=0.5, t=1.6 ms
        EXECUTE VIEW: issue/_sidebar_whatcanido
        SELECT "member".*, "initiator"."initiative_id" AS "mm_ref_", initiator.accepted AS "accepted" FROM "member" INNER JOIN "initiator" ON "initiator"."member_id" = "member"."id" WHERE ("initiator"."initiative_id" IN (6)) AND (initiator.accepted) ORDER BY member.name; 0.5 ms
        this: u=0.2, d=0.0, t=0.2 | children: u=3.2, d=3.3, t=6.3 | total: u=3.5, d=3.3, t=6.5 ms
        EXECUTE VIEW: issue/_sidebar_members
        this: u=1.7, d=3.3, t=4.7 | children: u=1.6, d=0.0, t=1.6 | total: u=3.2, d=3.3, t=6.3 ms
        EXECUTE VIEW: member/_list
        SELECT count(1) FROM (SELECT "member".*, direct_voter.ownweight AS "ownweight", direct_voter.weight AS "voter_weight", vote.grade, direct_voter.comment AS "voter_comment", member.id = ANY(_member_list__delegating_voter.delegate_member_ids) AS "in_delegation_chain" FROM "member" INNER JOIN issue ON issue.id = 3 INNER JOIN direct_voter ON direct_voter.issue_id = 3 AND direct_voter.member_id = member.id INNER JOIN vote ON vote.member_id = member.id AND vote.initiative_id = 6 LEFT OUTER JOIN delegating_voter AS "_member_list__delegating_voter" ON _member_list__delegating_voter.issue_id = issue.id AND _member_list__delegating_voter.member_id = NULL WHERE (member.activated NOTNULL)) AS "subquery" LIMIT 1; 2.0 ms
        SELECT "member".*, direct_voter.ownweight AS "ownweight", direct_voter.weight AS "voter_weight", vote.grade, direct_voter.comment AS "voter_comment", member.id = ANY(_member_list__delegating_voter.delegate_member_ids) AS "in_delegation_chain" FROM "member" INNER JOIN issue ON issue.id = 3 INNER JOIN direct_voter ON direct_voter.issue_id = 3 AND direct_voter.member_id = member.id INNER JOIN vote ON vote.member_id = member.id AND vote.initiative_id = 6 LEFT OUTER JOIN delegating_voter AS "_member_list__delegating_voter" ON _member_list__delegating_voter.issue_id = issue.id AND _member_list__delegating_voter.member_id = NULL WHERE (member.activated NOTNULL) LIMIT 100 OFFSET 0; 1.4 ms
        this: u=0.4, d=0.0, t=0.4 | children: u=0.2, d=0.0, t=0.2 | total: u=0.6, d=0.0, t=0.6 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.2, d=0.0, t=0.2 | children: u=0.0, d=0.0, t=0.0 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.2, d=0.0, t=0.2 | children: u=0.0, d=0.0, t=0.0 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
  - End of authentication filter.