Skip to content

Processes to automate

Jump to bottom
Suzanne Childress edited this page Feb 25, 2021 · 25 revisions

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)

  • API etc automated Macroeconomic baseyear compilation process

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

Completed Projects

Clone this wiki locally