» Torino » Parks and Recreation » Citizen proposal #2

i2: Choose next agenda meeting

Rejected (rank 1)

Yes	0%	Yes
No	0%	No
Abstention	0%	Abstention

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

draft history (1)

Suggestions for improvement (0)

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

Citizen proposal #2

1. Admission (reached 1)

2. Discussion (finished)

3. Verification (reached 1.0% / 1)

4. Voting (finished)

Disapproved

Competing initiatives

This is the only initiative in this issue, because nobody started a competing initiative.

What can I do here?

This issue is closed

Voters

TRACE

System trace (for computer programmers purposes)

this: u=2.4, d=0.0, t=2.4 | children: u=0.0, d=0.0, t=0.0 | total: u=2.4, d=0.0, t=2.4 ms
Configuration "pt"
REQUESTED VIEW: initiative/show
this: u=4.6, d=4.0, t=8.2 | children: u=21.4, d=19.9, t=44.5 | total: u=26.0, d=23.8, t=52.7 ms
/main/_filter/20_session.lua
- INSERT INTO "session" ("ident", "additional_secret") VALUES ('7Gd2dHogcvvUPWMhaEXZWe97', 'w72KvpDr103aIHO1TAkqLBgwRAuOPnIUBQY7bkiRvHfbWTn7') RETURNING "ident"; 4.0 ms
- this: u=0.7, d=0.0, t=6.2 | children: u=20.7, d=19.9, t=38.3 | total: u=21.4, d=19.9, t=44.5 ms
  /main/_filter/21_auth.lua
  - No authentication needed.
  - this: u=0.8, d=0.0, t=0.8 | children: u=19.9, d=19.9, t=37.5 | total: u=20.7, d=19.9, t=38.3 ms
    /main/_filter_view/30_navigation.lua
    - this: u=0.1, d=0.0, t=0.1 | children: u=19.7, d=19.9, t=37.4 | total: u=19.9, d=19.9, t=37.5 ms
      /main/_filter_view/34_stylesheet.lua
      - this: u=0.3, d=0.0, t=0.3 | children: u=19.5, d=19.9, t=37.1 | total: u=19.7, d=19.9, t=37.4 ms
        /main/_filter_view/36_html_title.lua
        this: u=4.8, d=7.3, t=11.4 | children: u=14.6, d=12.6, t=25.7 | total: u=19.5, d=19.9, t=37.1 ms
        EXECUTE VIEW: initiative/show
        SELECT "initiative".* FROM "initiative" WHERE (id = 2) LIMIT 1; 3.3 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 (2)); 1.8 ms
        this: u=5.2, d=3.6, t=8.2 | children: u=0.0, d=0.0, t=0.0 | total: u=5.2, d=3.6, t=8.2 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 (1)); 1.2 ms
        SELECT "area".* FROM "area" WHERE ("area"."id" IN (1)); 1.3 ms
        SELECT "unit".* FROM "unit" WHERE ("unit"."id" IN (1)); 1.1 ms
        this: u=1.2, d=2.2, t=3.2 | children: u=1.5, d=0.0, t=1.5 | total: u=2.7, d=2.2, t=4.6 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 (2)) AND (initiator.accepted) ORDER BY member.name; 2.2 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: initiative/_bargraph
        this: u=1.0, d=0.0, t=1.0 | children: u=0.0, d=0.0, t=0.0 | total: u=1.0, d=0.0, t=1.0 ms
        EXECUTE VIEW: initiative/_sidebar_state
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 2) ORDER BY "id" DESC LIMIT 1; 1.3 ms
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 2) ORDER BY "id" DESC LIMIT 1; 0.3 ms
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 2) ORDER BY "id" DESC LIMIT 1; 0.2 ms
        SELECT count(1) FROM (SELECT "draft".* FROM "draft" WHERE ("draft"."initiative_id" IN (2)) ORDER BY "id" DESC) AS "subquery" LIMIT 1; 0.4 ms
        this: u=1.2, d=1.1, t=2.2 | children: u=0.0, d=0.0, t=0.0 | total: u=1.2, d=1.1, t=2.2 ms
        EXECUTE VIEW: initiative/_suggestions
        SELECT "suggestion".* FROM "suggestion" WHERE ("suggestion"."initiative_id" IN (2)) ORDER BY "proportional_order" NULLS LAST, id; 1.1 ms
        this: u=0.4, d=0.0, t=0.4 | children: u=1.6, d=1.0, t=2.2 | total: u=2.0, d=1.0, t=2.6 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.9, d=1.0, t=1.5 | children: u=0.0, d=0.0, t=0.0 | total: u=0.9, d=1.0, t=1.5 ms
        EXECUTE VIEW: issue/_sidebar_issue
        SELECT "initiative".* FROM "initiative" WHERE ("initiative"."issue_id" IN (2)) ORDER BY initiative.admitted DESC NULLS LAST, initiative.rank NULLS LAST, initiative.harmonic_weight DESC NULLS LAST, id; 1.0 ms
        this: u=2.0, d=0.8, t=2.6 | children: u=0.0, d=0.0, t=0.0 | total: u=2.0, d=0.8, t=2.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 (2)) AND (initiator.accepted) ORDER BY member.name; 0.8 ms
        this: u=0.4, d=0.0, t=0.4 | children: u=1.2, d=4.1, t=5.0 | total: u=1.6, d=4.1, t=5.5 ms
        EXECUTE VIEW: issue/_sidebar_members
        this: u=1.2, d=4.1, t=5.0 | children: u=0.0, d=0.0, t=0.0 | total: u=1.2, d=4.1, t=5.0 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 = 2 INNER JOIN direct_voter ON direct_voter.issue_id = 2 AND direct_voter.member_id = member.id INNER JOIN vote ON vote.member_id = member.id AND vote.initiative_id = 2 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.3 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 = 2 INNER JOIN direct_voter ON direct_voter.issue_id = 2 AND direct_voter.member_id = member.id INNER JOIN vote ON vote.member_id = member.id AND vote.initiative_id = 2 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.7 ms
  - End of authentication filter.