» Plaine Commune » Ideas for the Olympic Village » Citizen proposal #4

i9: Implement Urban agriculture

Approved

6	Yes	66%	Yes
2	No	22%	No
1	Abstention	11%	Abstention

How to build a City Farm on the Olympic village site after 2024 ?
On this specific topic we have several project proposals. We would like to discuss and deliberate using our Knowledge evaluation model :
1) Document / describe the different proposals2) Detail the corresponding knowledge existing or to be developped (ex: Knowing how to build a greenhouse)3) For each knowledge detail the value indicators :
- Energy autonomy- Low consumption of water- Strenth- Ability to open the greenhouse- ...4) Participant may modify/improve the indicators5) Participants may order the indicators (ex: what is the most important indicator)6) Participants may qualify the indicators (ex: Energy autonomy is important, Low water consumption is not an important indicator)7) Vote may be usefull in order to approve or to reject the final set of indicator8) Vote may be usefull to decide which project needs to be selected (labellized for Contributive Income) according to the best compliacy with deliberated indicators.

draft history (2)

Suggestions for improvement (0)

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

Citizen proposal #4

1. Admission (reached 1)

2. Discussion (finished)

3. Verification (reached 10.0% / 1)

4. Voting (finished)

Finished with winner

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

Axel Kistner

Andreas Nitsche +1

Dominique

Jules Durant

Westbrook

Amity

Anne Roberts

Claretta

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=4.5, d=4.3, t=8.4 | children: u=24.8, d=19.1, t=41.6 | total: u=29.2, d=23.4, t=50.0 ms
/main/_filter/20_session.lua
- INSERT INTO "session" ("additional_secret", "ident") VALUES ('R32Dq33fnNpScwqgm3uV7cCrzf4HV7giQsn4UTQiAYy1XcFk', 'bXE2Md48EPABq9IasXWWcDg0') RETURNING "ident"; 4.3 ms
- this: u=0.8, d=0.0, t=0.8 | children: u=24.0, d=19.1, t=40.8 | total: u=24.8, d=19.1, t=41.6 ms
  /main/_filter/21_auth.lua
  - No authentication needed.
  - this: u=1.0, d=0.0, t=1.0 | children: u=22.9, d=19.1, t=39.8 | total: u=24.0, d=19.1, t=40.8 ms
    /main/_filter_view/30_navigation.lua
    - this: u=0.1, d=0.0, t=0.1 | children: u=22.8, d=19.1, t=39.7 | total: u=22.9, d=19.1, t=39.8 ms
      /main/_filter_view/34_stylesheet.lua
      - this: u=0.3, d=0.0, t=0.3 | children: u=22.5, d=19.1, t=39.4 | total: u=22.8, d=19.1, t=39.7 ms
        /main/_filter_view/36_html_title.lua
        this: u=5.0, d=6.6, t=10.9 | children: u=17.6, d=12.6, t=28.5 | total: u=22.5, d=19.1, t=39.4 ms
        EXECUTE VIEW: initiative/show
        SELECT "initiative".* FROM "initiative" WHERE (id = 9) LIMIT 1; 2.2 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 (4)); 2.6 ms
        this: u=5.1, d=3.0, t=8.0 | children: u=0.0, d=0.0, t=0.0 | total: u=5.1, d=3.0, t=8.0 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.4 ms
        SELECT "area".* FROM "area" WHERE ("area"."id" IN (3)); 0.8 ms
        SELECT "unit".* FROM "unit" WHERE ("unit"."id" IN (1)); 0.9 ms
        this: u=1.4, d=2.5, t=3.7 | children: u=1.9, d=0.0, t=1.9 | total: u=3.4, d=2.5, t=5.7 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 (9)) AND (initiator.accepted) ORDER BY member.name; 2.5 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.4, d=0.0, t=1.4 | children: u=0.0, d=0.0, t=0.0 | total: u=1.4, d=0.0, t=1.4 ms
        EXECUTE VIEW: initiative/_sidebar_state
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 9) ORDER BY "id" DESC LIMIT 1; 1.2 ms
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 9) ORDER BY "id" DESC LIMIT 1; 0.3 ms
        SELECT count(1) FROM (SELECT "draft".* FROM "draft" WHERE ("draft"."initiative_id" IN (9)) ORDER BY "id" DESC) AS "subquery" LIMIT 1; 0.3 ms
        this: u=1.2, d=0.9, t=1.8 | children: u=0.0, d=0.0, t=0.0 | total: u=1.2, d=0.9, t=1.8 ms
        EXECUTE VIEW: initiative/_suggestions
        SELECT "suggestion".* FROM "suggestion" WHERE ("suggestion"."initiative_id" IN (9)) ORDER BY "proportional_order" NULLS LAST, id; 0.9 ms
        this: u=0.4, d=0.0, t=0.4 | children: u=1.8, d=1.0, t=2.5 | total: u=2.2, d=1.0, t=2.9 ms
        EXECUTE VIEW: issue/_sidebar
        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: issue/_sidebar_state
        this: u=0.9, d=1.0, t=1.6 | children: u=0.0, d=0.0, t=0.0 | total: u=0.9, d=1.0, t=1.6 ms
        EXECUTE VIEW: issue/_sidebar_issue
        SELECT "initiative".* FROM "initiative" WHERE ("initiative"."issue_id" IN (4)) ORDER BY initiative.admitted DESC NULLS LAST, initiative.rank NULLS LAST, initiative.harmonic_weight DESC NULLS LAST, id; 1.0 ms
        this: u=1.2, d=0.7, t=1.8 | children: u=0.0, d=0.0, t=0.0 | total: u=1.2, d=0.7, t=1.8 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 (9)) AND (initiator.accepted) ORDER BY member.name; 0.7 ms
        this: u=0.2, d=0.0, t=0.2 | children: u=4.2, d=4.3, t=8.1 | total: u=4.4, d=4.3, t=8.3 ms
        EXECUTE VIEW: issue/_sidebar_members
        this: u=2.1, d=4.3, t=6.1 | children: u=2.0, d=0.0, t=2.0 | total: u=4.2, d=4.3, t=8.1 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 = 4 INNER JOIN direct_voter ON direct_voter.issue_id = 4 AND direct_voter.member_id = member.id INNER JOIN vote ON vote.member_id = member.id AND vote.initiative_id = 9 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.4 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 = 4 INNER JOIN direct_voter ON direct_voter.issue_id = 4 AND direct_voter.member_id = member.id INNER JOIN vote ON vote.member_id = member.id AND vote.initiative_id = 9 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.9 ms
        this: u=0.5, d=0.0, t=0.5 | children: u=0.2, d=0.0, t=0.2 | total: u=0.7, d=0.0, t=0.7 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.2, d=0.0, t=0.2 | children: u=0.1, d=0.0, t=0.1 | total: u=0.3, d=0.0, t=0.3 ms
        EXECUTE VIEW: member/_show_thumb
        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: 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
        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: 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.1, d=0.0, t=0.1 | total: u=0.3, d=0.0, t=0.3 ms
        EXECUTE VIEW: member/_show_thumb
        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: member_image/_show
  - End of authentication filter.