Polls need to be processed and translated to a simple language #141

New issue

Open

opened 2026-09-12 19:59:00 +00:00 by aniram · 2 comments

aniram commented

2026-09-12 19:59:00 +00:00

Owner

Each possible group of poll results comes with its own questions. Instead of trying to find a solution for all cases, figure out all of the groups with the queries below, find one relevant group, that actually led to a proposition being rejected or accepted that day and represents a big portion of all results, and craft a solution just for that one.

I think Substituto oferecido pelo relator is a good candidate. The solution should be tailored for each group. Upon clicking on a link of this poll, the user should see a header explaining the overall journey of a proposition, not of this proposition but of a a proposition of this type and how it came to be that this proposition got replaced by a proposal of a committee's rapporteur(relator). It would also be interesting to see what part of it was replaced in a highlighted PDF split-view style. Something similar to the screenshot would be nice to see.

So, find poll results groups, pick a representative and relevant group and find a tailored solution to display this result in a simple language.

--GROUPS
--SELECT proposition_name FROM poll_session WHERE proposition_name LIKE "%SUBSTITUTIVO OFERECIDO PELO RELATOR%";
--SELECT proposition_name FROM poll_session WHERE proposition_name LIKE "%URGÊNCIA PARA APRECIAÇÃO%";
--SELECT proposition_name FROM poll_session WHERE proposition_name LIKE "%REQUERIMENTO DE ADIAMENTO DA DISCUSSÃO%";
--SELECT proposition_name FROM poll_session WHERE proposition_name LIKE "%REQUERIMENTO DE RETIRADA DE PAUTA%";
--SELECT proposition_name FROM poll_session WHERE proposition_name LIKE "%PROJETO DE LEI%";

We have everything that has been voted but the reader still does not know what all of it means. What does it mean "Substituto oferecido pelo relator" was approved? What is a substitute? What did it contain? Who was the "relator"? What did the thing it replaced contain and who proposed it? Each possible group of poll results comes with its own questions. Instead of trying to find a solution for all cases, figure out all of the groups with the queries below, find one relevant group, that actually led to a proposition being rejected or accepted that day and represents a big portion of all results, and craft a solution just for that one. I think **Substituto oferecido pelo relator** is a good candidate. The solution should be tailored for each group. Upon clicking on a link of this poll, the user should see a header explaining the overall journey of a proposition, not of this proposition but of a a proposition of this type and how it came to be that this proposition got replaced by a proposal of a committee's rapporteur(relator). It would also be interesting to see what part of it was replaced in a highlighted PDF split-view style. Something similar to the screenshot would be nice to see. So, find poll results groups, pick a representative and relevant group and find a tailored solution to display this result in a simple language. ```sql --GROUPS --SELECT proposition_name FROM poll_session WHERE proposition_name LIKE "%SUBSTITUTIVO OFERECIDO PELO RELATOR%"; --SELECT proposition_name FROM poll_session WHERE proposition_name LIKE "%URGÊNCIA PARA APRECIAÇÃO%"; --SELECT proposition_name FROM poll_session WHERE proposition_name LIKE "%REQUERIMENTO DE ADIAMENTO DA DISCUSSÃO%"; --SELECT proposition_name FROM poll_session WHERE proposition_name LIKE "%REQUERIMENTO DE RETIRADA DE PAUTA%"; --SELECT proposition_name FROM poll_session WHERE proposition_name LIKE "%PROJETO DE LEI%"; ```

Screenshot 2026-08-29 at 23.14.56.png

1,001 KiB

aniram commented

2026-09-12 20:10:02 +00:00

Author

Owner

Create detail page for polls
Sync projects, referenced by polls, we don't have yet

- [ ] Create detail page for polls - [ ] Sync projects, referenced by polls, we don't have yet

aniram commented

2026-10-05 18:30:50 +00:00

Author

Owner

There is another problem, the thing that gets voted is rarely the document written by the bill's author but more often a substitute or an amendment. Some bills like PEC must be approved in two sessions(turnos) in order to be considered truly approved. Even if we would show just the polls of the project's main texts in both sessions it still would not tell the whole story since there are many other documents like Urgency Requirements that are equally important to tell the context around a bill. So the solution is to show it all otherwise we would be rewriting the story.

Here is a mockup:

Screenshot 2026-10-05 at 15.30.31.png

268 KiB

aniram added this to the 2027.1 milestone

2026-10-06 11:51:32 +00:00

aniram added this to the Release 2027.1 project

2026-10-06 11:51:36 +00:00

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

overdrives/chambersbr#141

No description provided.

Rows
Columns