The Data Department

• Handbook
• Mission, Vision, and Values
• Resources
• Glossary
• Accounts
• Not Public

People and Onboarding

• See People repository
• See internal README - Must be logged into GitHub

How-To

• Setup the Cook County VPN
• Setup the AWS Command Line Interface and Multi-factor Authentication
• Connect to AWS Resources
• Administer Users on CCAO Services
• Use the renv global cache
• Use the Data team server
• Issue a certificate for the Data team server
• Create a New Residential Feature
• Add Columns to Open Data Assets

Standard Operating Procedures (SOPs)

• Sales Ratio Studies
• Desk Review
• Open Data

Residential

• Single and Multi-Family Residential Model
• Condominium Model
• Residential Exemptions
• Home Improvement Exemptions (288s)
• Cook County Property Tax Ordinance

Data Documentation

• See main data catalog/dbt documentation

Office Terminology

• Property Class Definitions - Available via the CCAO R package
• Township Codes and Maps - Available via the CCAO R package
• CDU Codes - Available via the CCAO R package

Data Guides

• Data Catalog - Deprecated, see dbt documentation
• iasWorld Tables
• iasWorld Keys - As of June 14, 2021
• iasWorld Entity Relationship Diagram (ERD)