anthony - Network

Next Tuesday I'm presenting at ChiHackNight about www.betterdataportal.com and sharing some thoughts about how to make public data...

Next Tuesday I'm presenting at ChiHackNight about www.betterdataportal.com and sharing some thoughts about how to make public data genuinely accessible. Tune in!

https://chihacknight.org/events/2023/01/31/anthony-moser.html

I was on Outside The Loop this morning on WGN Radio talking about the MAT Asphalt, the complete lack of environmental enforcement, and why...

I was on Outside The Loop this morning on WGN Radio talking about the MAT Asphalt, the complete lack of environmental enforcement, and why JB Pritzker needs to stop the sale of the Damen Silos.

https://bit.ly/otlradio844

#DontSellTheSilos
#GoodMorningToEveryoneExceptMatAsphalt

Ok so search is literally just for hashtags and usernames? this is a real problem! I welcome suggestions

Ok so search is literally just for hashtags and usernames?

this is a real problem! I welcome suggestions

I try searching for like "link preview" to see what the deal is with Mastodon and link previews, and I get no results. Really?...

I try searching for like "link preview" to see what the deal is with Mastodon and link previews, and I get no results.

Really? Nobody on mastodon is asking or explaining about this? It's gotta be out there, but how do I -actually search- the wider fediverse

So I sincerely want to use this platform more, but is there a way to make the search function more effective? Is this a settings thing?

So I sincerely want to use this platform more, but is there a way to make the search function more effective? Is this a settings thing?

I made a streamlit app for visualizing TIF data. By default it shows CivicLab's 2020 TIF report, but you can paste in any public Google...

I made a streamlit app for visualizing TIF data.

By default it shows CivicLab's 2020 TIF report, but you can paste in any public Google Sheet that has a tif_number column

You can check it out at
http://chicagotifs.streamlit.app

I'd be engaging a lot more on here if I could QT

I'd be engaging a lot more on here if I could QT

Lastly if you want to link this to other CPS data, most of it uses school_id, which isn't in this file. The budgets use the finance_id...

Lastly if you want to link this to other CPS data, most of it uses school_id, which isn't in this file. The budgets use the finance_id (in the original data it's the number in the "unit" column without the u in front).

This is a crosswalk to join them

https://docs.google.com/spreadsheets/d/13Tjnx4BxaFcTnhnDEjiVX9ReRkLmzZeSbSnsj-w3Pbg/edit#gid=529381054

They were also inconsistent in how they labeled specific funds/grants/schools/etc, so I also extracted the labels into separate tables from...

They were also inconsistent in how they labeled specific funds/grants/schools/etc, so I also extracted the labels into separate tables from the ids.

You can check those tables to confirm what a specific fund/program/account ID was labeled in a particular year, but in the view I shared above, I just use the latest labels for consistency

Also CPS was inconsistent as to which fields they included each year (e.g. "ending budget" or "approved ending budget"),...

Also CPS was inconsistent as to which fields they included each year (e.g. "ending budget" or "approved ending budget"), etc, so not all fields have values for all years.

You can make your own calls about what is functionally equivalent.

Some notes: to get everything in one place, I renamed the explicit references to years with relative ones ("proposed_budget_FY23"...

Some notes:

to get everything in one place, I renamed the explicit references to years with relative ones ("proposed_budget_FY23" -> "proposed_budget_fiscal_year") and added a fiscal_year column

Can't remember if I shared this already, but I made a harmonized data set of all the CPS budget books from FY15-FY23 that you can query...

Can't remember if I shared this already, but I made a harmonized data set of all the CPS budget books from FY15-FY23 that you can query or download here (heads up it's ~4m rows)

https://data.thefoiabakery.org/budgets-a05428c/budget_view
#CPSmastodon

like what if you need to actually transport something in the back

like what if you need to actually transport something in the back

I have just been introduced to the concept of the "carolina squat", which sounds disgusting but I promise it's worse than it...

I have just been introduced to the concept of the "carolina squat", which sounds disgusting but I promise it's worse than it sounds because it's actually about trucks.

I am genuinely horrified

Thread@miriamcbyesterday, i came home to multiple messages from a friend who needed help with a CPS issuea CPS high school issued an out of...

Thread

@miriamcb

yesterday, i came home to multiple messages from a friend who needed help with a CPS issue

a CPS high school issued an out of school suspension followed by a forced transfer, aka expulsion

https://cityofchicago.live/@miriamcb/109433330995617544

10 day forecast: cold with excessive diagrams

10 day forecast: cold with excessive diagrams

Look out, I figured out how to do sankey diagrams with plotly

Look out, I figured out how to do sankey diagrams with plotly

I requested it as a table. They gave me a PDF of flattened images of a table. Also they have unresolved requests from April and I'm...

I requested it as a table. They gave me a PDF of flattened images of a table.

Also they have unresolved requests from April and I'm pretty sure they excluded a bunch of things arbitrarily.

Great work, all around

so I FOIA'd the CPS FOIA office for the log of all open FOIAs, just to see how much they were keeping on ice in the back. I submitted it...

so I FOIA'd the CPS FOIA office for the log of all open FOIAs, just to see how much they were keeping on ice in the back. I submitted it Nov 3rd and got it back... now

#CPSmastodon
#FOIAdon

so there is STILL MORE good stuff that we've put together this year, but going to pause there for now. Please:• ask questions about...

so there is STILL MORE good stuff that we've put together this year, but going to pause there for now.

Please:
• ask questions about any of this!
• ask other questions too!
• share anything you use or do or ask that helps you understand what's going on at CPS!

#CPSmastodon