Estimates Program v1.2.1

Estimates Program v1.2.1

Official Estimates 2025 released as [run_id]=224 after QA review and approval. Data also loaded into [demographic_warehouse] as [datasource_id]=55
Adjusted post-QA review of v1.2.0 [run_id]=213.
2025-049.Estimates.2024.Closeout.Memo.pdf
2025-049.Estimates.2024.Test.Plan.pdf

Note, while this release includes the Employment Module, the process and data is still preliminary and will not be included in any released products nor loaded to SANDAG's Demographic Warehouse database.

Major Updates

• The Special MGRAs table has been updated for year 2025.

What's Changed

• [PULL REQUEST] Updating/Resolving ODBC driver issue by @KPHSANDAG in #259
• [PULL REQUEST] Add employment/jobs module to database diagram by @GregorSchroeder in #261
• [PULL REQUEST] Intercensal Preparation and Special MGRAs by @GregorSchroeder in #265
• Potential fix for 1 code quality finding by @GregorSchroeder in #267
• [PULL REQUEST] Combined AI Findings by @GregorSchroeder in #269

Full Changelog: v1.2.0...v1.2.1

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