RSSAmplifier

Blog

Gary Sieling

Software Engineer

garysieling.comRSS feed ↗10 posts

Latest posts

The accelerant effects of AI

I’ve had now hundreds of conversations about AI. Surprisingly, rather than being a simple productivity tool, these conversations meander into debates and speculation about social change, and reveal our greatest fears and deepest desires. Simultaneous to my vocational conversations, I facilitated running a survey on social justice issues in my state senate district. To my Continue reading "The…

Allow a CircleCI self-hosted machine runner to run jobs for more than 5 hrs

Edit /usr/lib/systemd/system/circleci-runner.service Change TimeoutStopSec to be a larger number Edit /etc/circleci-runner/circleci-runner-config.yaml To the runner: block, add a line like so: Then, restart the service: sudo systemctl daemon-reload sudo systemctl restart circleci-runner The post Allow a CircleCI self-hosted machine runner to run jobs for more than 5 hrs first appeared on Gary…

Import a folder of CSVs into a single Google Sheet (1 per tab)

Got this from ChatGPT and tested. Go to apps script: Paste the script below, add your folder ID, and save. The folder ID can be obtained from the URL to the folder: Then, click Run you will have to go through several security prompts to agree to trust the script. The post Import a folder of CSVs into a single Google Sheet (1 per tab) first appeared on Gary Sieling .

R Code to summarize Dept of Ed, Civil Rights Data by school district / LEA

Notes: The post R Code to summarize Dept of Ed, Civil Rights Data by school district / LEA first appeared on Gary Sieling .

Export Census ACS5 data by GEOID/block group to CSV in R

See prior posts for a list of variables Or as a function of the variable name, The post Export Census ACS5 data by GEOID/block group to CSV in R first appeared on Gary Sieling .

Get US Census population by block group (GEOID) in R

This shows population by block group for the entire state: To get a list of variables available for this, see the previous post. The post Get US Census population by block group (GEOID) in R first appeared on Gary Sieling .

Get a list of census fields available at the GEOID (block group) level in R

A couple of points here: The post Get a list of census fields available at the GEOID (block group) level in R first appeared on Gary Sieling .

PA Senate Committees 2023 CSV Download

Code for how this is obtained The post PA Senate Committees 2023 CSV Download first appeared on Gary Sieling .

PA House Committees CSV 2023

Download here Code for how this was obtained The post PA House Committees CSV 2023 first appeared on Gary Sieling .

Shapefile of 599 police districts in PA

Shape file showing 599 police districts in PA Combines all of Pittsburgh, Harrisburg, Montgomery County, Bucks County, Chester County, Delaware County includes population #s and standardized naming for all attributes compiled from disparate data sources and combined using a Node.js script. Download here: https://www.garysieling.com/blog/wp-content/uploads/2023/12/Police.geojson and contact…