Processes to automate

This page is meant to be a grab bag list of processes we would like to automate in the department. Eventually we will organize this list by priority order.

Please add your ideas here!

Do this soon

• Automate calendar reminders for dataset updates

• Elmer to portal scripts (for all major team datasets)

• assistance to modelers for summarization

• OFM April 1 published data for trends (population of cities and towns) a) annexations - Try complete prior to July trend update

Longer term to do

• Jurisdictional data profiles to do, Craig, long-term

• Census data reconciliation of different datasets and years (look at IPUMS) to do - new geographies for 2020; design around decennial Census; variable names https://ipums.org/

• Baseyear parcel & building data processing (from county assessor websites)

• Geocoding services creation (from address datasets) Christy has a repo - geocoding-services; Mike will coordinate

• Linear optimization to blockgroup from suppressed Alljobs estimates (supplanting adjLodes)

• Annual permit data processing (pending decision to use permits or replace w/ assessor db)

• Macro model Updates, integrated w/ other models, consideration with racial equity

---

Completed Projects