Estimates Program v1.2.0

Estimates Program 1.2.0

Preliminary Estimates 2025 release for QA/QC team review as [run_id]=213

Major Updates

• Restricted "Special MGRA" age/sex/ethnicity category violation resolved
• Addition of the Employment module
• An updated local debug mode
• The use of [demographic_warehouse] for year-specific MGRA cross references

What's Changed

• [PULL REQUEST] Cleanup preparing for new features by @GregorSchroeder in #160
• [PULL REQUEST] Mermaid Database Diagram by @GregorSchroeder in #167
• [PULL REQUEST] Add PUMAs to mgra table by @GregorSchroeder in #170
• [PULL REQUEST] Configuration for template sync by @Eric-Liu-SANDAG in #172
• [PULL REQUEST] Wiki to documentation folder by @Eric-Liu-SANDAG in #169
• [PULL REQUEST] Upstream merge template repository by @github-actions[bot] in #173
• [PULL REQUEST] New IPF implementation by @Eric-Liu-SANDAG in #176
• [PULL REQUEST] Change from conda to uv by @Eric-Liu-SANDAG in #181
• [PULL REQUEST] Upstream merge template repository by @github-actions[bot] in #182
• [PULL REQUEST] Optimize data insertion for ASE data by @Eric-Liu-SANDAG in #184
• [PULL REQUEST] POC transition from yml to toml by @KPHSANDAG in #191
• [PULL REQUEST] Add Employment Estimates by @bryce-sandag in #192
• [PULL REQUEST] few small changes missed for adding employment module and full test run in production database by @bryce-sandag in #199
• [PULL REQUEST] Updated Regional GQ ASE logic for 2010 by @GregorSchroeder in #202
• [PULL REQUEST] Update GQ Age/Sex/Ethnicity distributions by @GregorSchroeder in #205
• [PULL REQUEST] Upgrades to debug mode by @Eric-Liu-SANDAG in #207
• [PULL REQUEST] add logic for employment point-based xref by @bryce-sandag in #204
• [PULL REQUEST] New actual/implied hhp balancing methodology by @Eric-Liu-SANDAG in #208
• [PULL REQUEST] Updated actions/checkout version by @Eric-Liu-SANDAG in #213
• [PULL REQUEST] Startup Module - Blockgroups, Validation, Debug by @GregorSchroeder in #211
• [PULL REQUEST] Update Cities to use pretty names by @GregorSchroeder in #216
• Bump black from 25.12.0 to 26.3.1 by @dependabot[bot] in #218
• [PULL REQUEST] Create dependabot.yml by @GregorSchroeder in #220
• Bump sqlalchemy from 2.0.45 to 2.0.49 by @dependabot[bot] in #225
• Bump numpy from 2.4.0 to 2.4.4 by @dependabot[bot] in #224
• Bump actions/checkout from 3 to 6 by @dependabot[bot] in #222
• [PULL REQUEST] Fix for Explicit returns mixed with implicit (fall through) returns by @GregorSchroeder in #221
• Potential fixes for 2 code quality findings by @GregorSchroeder in #226
• [PULL REQUEST] add in self employment to employment module by @bryce-sandag in #217
• Potential fixes for 2 code quality findings by @GregorSchroeder in #229
• [PULL REQUEST] Refactor MGRA table by @GregorSchroeder in #233
• [PULL REQUEST] Update DOF Sources by @GregorSchroeder in #235
• [PULL REQUEST] Intercensal Age/Sex/Ethnicity Regional Control Totals by @GregorSchroeder in #237
• [PULL REQUEST] Age/Sex/Ethnicity Seed Misalignment by @GregorSchroeder in #240
• [PULL REQUEST] Add Wiki Page for Employment Module by @GregorSchroeder in #248
• [PULL REQUEST] add in military employment by @bryce-sandag in #245
• Bump black from 26.3.1 to 26.5.1 by @dependabot[bot] in #249
• [PULL REQUEST] Preparations for 2025 run by @GregorSchroeder in #254
• [PULL REQUEST] Upstream merge template repository by @github-actions[bot] in #255
• [PULL REQUEST] Wiki update for military and self employment regional controls by @GregorSchroeder in #258

New Contributors

• @github-actions[bot] made their first contribution in #173
• @bryce-sandag made their first contribution in #192
• @dependabot[bot] made their first contribution in #218

Full Changelog: v1.1.0...v1.2.0

Estimates Program 1.1.0

Preliminary release for QA/QC team review.
Approved for use by QA/QC team published as Estimates v24.

What's Changed

• [PULL REQUEST] Special MGRAs Constraints by @GregorSchroeder in #135
• [PULL REQUEST] Create Database Diagram by @KPHSANDAG in #137
• [PULL REQUEST] QA Fixes by @Eric-Liu-SANDAG in #139
• [PULL REQUEST] weighted_random methodololgy for 1D integerizer by @Eric-Liu-SANDAG in #147
• [PULL REQUEST] Fixes for lack of determinism and data not matching regional controls by @Eric-Liu-SANDAG in #151
• [WARNING] QA Closeout and Special MGRA Adjustments by @GregorSchroeder #154

New Contributors

• @KPHSANDAG made their first contribution in #137

Full Changelog: v1.0.0...v1.1.0

Estimates Program 1.0.0

Preliminary release for QA/QC team review of Estimates 2024.
Contains all functionality to run years 2020-2024.

What's Changed

• [PULL REQUEST] Repository Setup by @Eric-Liu-SANDAG in #1
• [PULL REQUEST] Update issue templates by @GregorSchroeder in #24
• [PULL REQUEST] Create SQL Engines by @GregorSchroeder in #27
• [PULL REQUEST] Run Initialization by @GregorSchroeder in #31
• [PULL REQUEST] Create the MGRA base geography by @GregorSchroeder in #33
• [PULL REQUEST] Generate Housing Stock by @GregorSchroeder in #35
• [PULL REQUEST] Special MGRAs by @GregorSchroeder in #46
• [PULL REQUEST] SQL Tables for Controls by @GregorSchroeder in #52
• [PULL REQUEST] Update lu mapping for housing units by @GregorSchroeder in #57
• [PULL REQUEST] Group Quarters Estimates by @GregorSchroeder in #56
• [PULL REQUEST] Basic skeleton for main.py control flow by @Eric-Liu-SANDAG in #37
• [PULL REQUEST] Fix for environment.yml showing as a binary file by @Eric-Liu-SANDAG in #65
• [PULL REQUEST] Household Estimates by @GregorSchroeder in #58
• [PULL REQUEST] Integration of existing modules into main.py by @Eric-Liu-SANDAG in #70
• [PULL REQUEST] Add Census Tract 2010 cross reference by @GregorSchroeder in #76
• [PULL REQUEST] MGRA level household population by @Eric-Liu-SANDAG in #79
• [PULL REQUEST] Basic generic testing for module I/O by @Eric-Liu-SANDAG in #82
• [PULL REQUEST] Create A/S/E Regional Controls by Population Type by @GregorSchroeder in #84
• [PULL REQUEST] Census Tract Seed Data for Age/Sex/Ethnicity by @GregorSchroeder in #88
• [PULL REQUEST] Shift HS from SQL --> Python by @Eric-Liu-SANDAG in #90
• [PULL REQUEST] Population by Age/Sex/Ethnicity by Type by @GregorSchroeder in #93
• [PULL REQUEST] Replace iteround by @GregorSchroeder in #103
• [PULL REQUEST] MGRA Household Income by @Eric-Liu-SANDAG in #102
• [PULL REQUEST] Update with DOF Releases by @GregorSchroeder in #108
• [PULL REQUEST] Allow ACS queries to use previous year by @GregorSchroeder in #109
• [PULL REQUEST] MGRA Households by Household Size by @Eric-Liu-SANDAG in #107
• [PULL REQUEST] Householders Bug Fix by @GregorSchroeder in #114
• [PULL REQUEST] Basic Logging Implementation by @GregorSchroeder in #116
• [PULL REQUEST] Staging module by @Eric-Liu-SANDAG in #118
• [PULL REQUEST] LUDU Overrides by @GregorSchroeder in #125
• [PULL REQUEST] Special MGRA a/s/e by @GregorSchroeder in #123
• [PULL REQUEST] Fixes for [run_id] = 245 by @Eric-Liu-SANDAG in #129
• [PULL REQUEST] Manual QA/QC scripts by @Eric-Liu-SANDAG in #120

New Contributors

• @Eric-Liu-SANDAG made their first contribution in #1
• @GregorSchroeder made their first contribution in #24

Full Changelog: https://github.com/SANDAG/Estimates-Program/commits/v1.0.0