opencleveland/refundcleveland

website for residents to adjust the city of Cleveland proposed budget to reflect their priorities.

refundcleveland's Issues

Improve the confirmation page (add directions to contact your councilperson, share on social media)

After the user submits their budget, they're directed to store-data page:

Include:

• Contact your councilperson!
  (content at: https://docs.google.com/document/d/1ydc5Bw0Ctp8LJFEWECu9f9wMeUfM-FKlhTROik0QJiY/edit# (council person section))

• Should this be a new page or displayed here?

• include links to share on social media (possibly use django_social_share)

Write sql query to generate average submission per ward or city wide

Create a sql query (or two) we can start running to get an average budget of the submissions per ward and city wide, filtering out test emails: us devs and [email protected], etc

we could then build a page that displays these averages or use to send to councilpersons/media/etc

2022 Updates: Update Change the Budget Page

Update Change the Budget Page - Update Numbers, names, etc. to reflect 2022 Mayoral estimate.

https://github.com/opencleveland/refundcleveland/blob/main/peoples_budget/templates/change-the-budget.html

Meta image error on Facebook

Facebook share debugger (https://developers.facebook.com/tools/debug/?q=refundcleveland.com) is giving the following error:

Provided og:image URL, https://refundcleveland.com/static/meta-img.jpg could not be processed as an image because it has an invalid content type.

Here is the URL for the image being used (for now): https://www.refundcleveland.com/static/images/meta-img.jpg

ward field is not populated when find ward button is run

On the website,
I noticed that when an address is input into the field
and find ward button is pressed, the ward number wasn't not being populated/filled into the id_ward input field.

when the find ward button is pressed, lookup_address does make a fetch query -

and this is the response:
HTTP/1.1 200 OK Connection: keep-alive Server: gunicorn/20.0.4 Date: Thu, 11 Feb 2021 15:48:17 GMT Content-Type: text/html; charset=utf-8 X-Frame-Options: DENY Content-Length: 19 X-Content-Type-Options: nosniff Referrer-Policy: same-origin Via: 1.1 vegur

Disabled submit button event listener

I think we could add an event listener to the submit button on the /change-the-budget page that displays a message when a user clicks the disabled button (something like, "Please make sure all funds are allocated before submitting your budget").

2022 Updates: Understanding the Budget Page (NEW)

Create Understanding the Budget page - home for all Cleveland Documenters contributions.
2022 Budget Primer
Glossary Budget Term Cards click through slides?

django-heroku is now deprecated; no longer supported

License

finalize the license of the code.

require email address?

We are currently requiring users to enter an email address; this is turning all users who ; also have to keep in mind if whether this would lead abuse/spamming of the submissions

Further Details on the "Show Details" section for each category.

It might be nice to have a short little blurb about the line items in the little Details pop-ups. Like, what does "public works" mean, as compared to "capital projects"? Not a priority.

Street address validation

We currently don't have any validation for the street address input in the submit form -- the USPS API might be a good option: https://www.usps.com/business/web-tools-apis/address-information-api.htm

Documentation Improvements

Mention the necessity of mailgun in the API

Clarify the file names

include in the readme what each of the files do; although they are somewhat self-evident; to someone who is not completely familiar with it would struggle a little bit.

privacy policy

About what we collect: (email address, address)

Share to Facebook results in Not Found link

When sharing to Facebook from the /view/ page, the link populates a "Not Found" preview. If the link is clicked after sharing, the user is directed to a Not Found page.

Example: https://www.refundcleveland.com/7a573a22-f172-421b-9b1e-daaa98caef1e/view/%7B%7B%20id%20%7D%7D/view/?fbclid=IwAR0xG78-PKynX12Q4q07N3vCk8neAcjIKB_Wnd8Z1_3rBwn33t8VpM07ffU

update requirements.txt (tracking)

• django-heroku is now deprecated; #132

1% and -1% buttons for the Change the Budget page

The slide and drop sliders are great, but they can get finicky for fine details + very specific numbers. It'd be helpful to have +1% and -1% buttons.

Upgrade django

We're currently using django 3.1.5 which is deprecated and not receiving anymore security updates (ref:
https://www.djangoproject.com/download/

Determine whether it's worth upgrading to 4.0, 5.Z or just update to 3.2 which will be supported through 2024.

Adding dollar values to budget displays

I was thinking we can enhance these budget display interfaces to include dollar amounts so people have a better idea of the scale of the budget when they are making their own version. Intuitively people think in thousands, millions, and billions instead of percentage points, and it could make the interaction more accessible and provoking to show those numbers as they adjust them. There is a visceral feeling to seeing 9 figure amounts for policing that dwarfs over things like community services and bike infrastructure, etc.

Attached photo of idea below.

I am going to try this in my own branch, but it may take me a while! So I am sharing my idea here to the real programmers, in case we want to implement this sooner (if there is consensus to add this).

form submissions with Email addresses that do not contain periods return error

When submitting the form and the email value not contain a period in it (e.g. "sfdfsd@ss2com");

error is returned

ValueError at /store-data/

The view peoples_budget.views.store_data didn't return an HttpResponse object. It returned None instead.

full error messages at https://gist.github.com/skorasaurus/6c8a7014164f43d440b4afb224a03cc8

Perhaps will need to write a validator? (https://docs.djangoproject.com/en/3.1/ref/validators/#django.core.validators.EmailValidator)

2022 Updates: 2022 Simplified Budget tool

Update chart tool with data from 2022 Mayor’s estimate (will come out Feb 1 and I will post a link to it here once it is in.)

Home page file: https://github.com/opencleveland/refundcleveland/blob/main/peoples_budget/templates/home.html

ensure the https is loading in the browser

making a note for myself; I implemented the domain ; triple check in a day or two that

refundcleveland.com automatically loads to https in the browser.

Bars aren't to scale

The bars aren't to scale. This makes it hard to build an intuition about how much bigger one budget is over another.

This image implies that 50% is approximately 15%.

Potential further reading: https://infovis-wiki.net/wiki/Lie_Factor

Enter your Own Number on Change the Budget

For specific accessibility reasons as well as general ease of use, it'd be helpful to have the ability to enter in a specific number that someone wants for a given budget category. IE they could tap a part of the Health section and enter in "23" percent.

send email to user upon submission

• Send an email to the user after submission with a link to their budget, so they can go back to it later and share it easily.
• create nice/accessible html/text content of email

Clarify what happens when you hit the "find my ward" button

The find my ward button is a miracle, in that it just pops my ward number in instantaneously when I put in my addresses. But two things:

1. It doesn't indicate that it's filled in the ward number. A user could be looking at the "find my ward" button and would click it over and over, without realizing that the button had successfully filled in the ward number above.
2. There's no "you actually don't have a ward because your address is not in Cleveland" response. (This is related to the other conversation about a proposed null ward.)

Update Home Page Copy

Change "leaders" to "elected officials" in the first paragraph on the home page.

update the councilpersons for 2023

brian mooney is no longer councilperson; this file needs to be updated

refundcleveland/peoples_budget/templates/store-data.html

Line 43 in c465638

<li>Ward 11: <a href="mailto:[email protected]">Brian Mooney - [email protected]</a></li>

Update the Open Graph Image

Update the open graph image; which is a hard image, and contains data from 2021. https://github.com/opencleveland/refundcleveland/blob/f755f73f30f09ebc2280d5695825c9927f217ad4/static/images/meta-img.jpg

Change URL for /store-data/ page

Can we update this URL to be more meaningful? Perhaps something like /share-budget/ or similar?

View an existing budget

Add url: refundcleveland.com/<budget_id>/view

retrieve data from database, show to user, add links on the bottom to:

• share via social, email, etc

bonus:

• edit (only original user)
• duplicate to edit - make a copy, take to /change-the-budget/

Submission Retrospective?

I forgot that we actually do save submission results (because that's how we're able to send links to people to view their budget).

What about a retrospective where we compare submissions to the final budget. Ex: The average desired Police budget submitted was 25%, and the final Police budget ended up being 37%.

Could be a cool way to see if the city reflects what people want in the budget.

Share Your Budget Submission not working on /store-data/

After submitting email and ward #, the links to share the budget on Facebook is not working and no link is present for Twitter. These links should match the behavior on the share links from the /view/ page

Stats / summary page

creating a page that has the stats of the averages (and perhaps the median as well); of what proposed budgets submitted were

(This page can also be shared with councilperson as well. )

will need #97

(This page could be shared independent of any other page)

Admin on the "Change" Screen

People keep getting confused why there are seven bars on the main screen but only six on the Change the Budget screen. We have a good reason why, but fair enough.

It'd be helpful to have the seventh bar, the Admin bar, at least appear in the Change the Budget screen so people don't get confused. I agree that it shouldn't be edit-able. Maybe we can have a red X drawn across it, or put a free SVG of a lock over it. But I've gotten this feedback about the seventh bar multiple times.

2022: update councilpeople

Need to update the list of councilpeople at https://www.clevelandcitycouncil.org/council/council-members

located at https://github.com/opencleveland/refundcleveland/blob/main/peoples_budget/templates/store-data.html

Update readme; now use python 3.9

@haileyhoyat reminded me in last night's meeting; we updated the project to use python 3.9 (haven't tested with any newer versions than yet) last year and haven't noted that in the readme.

increase color contrast on category detail links

The contrast for the "see details" links should be increased to meet accessibility (WCAG 2.1) requirements.

a.category_detail

Add Documenters link about the budget

Rachel Dissell with the Documenters wrote a good overview on the budget; perhaps we can link to that on the index page?