ai_ml_operations/monica_site
2
0 Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Show EDDM size, income, businesses and USPS map link on route picker #17

New Issue
Closed
opened 2026-09-22 12:35:44 -07:00 by westfarn · 2 comments
westfarn commented 2026-09-22 12:35:44 -07:00
Owner
Copy link
Copy source

Goal

Enrich the carrier-route (EDDM-style) compose table so Monica can compare routes before picking 1–2 to mail.

Scope

  • Add Size (avg household), Income (median), and Businesses columns to the route result table.
  • Link out to the official USPS EDDM map: https://eddm.usps.com/eddm/select-routes.htm (search ZIP there, Show Table for Census filters).
  • Join public USPS EDDM GIS stats onto PCM ZipCRRT rows. Households/cost stay PCM (order count). GIS fail must not block Find routes.
  • Size/income may be blank (—) when USPS GIS omits AVG_HH_SIZ / MED_INCOME; businesses typically fill.
  • Not official EDDM postage — still PCM purchased occupant lists.

Mirror

westfarn/web_django_template (ticket to follow).

Out of scope

  • Embedding the USPS map iframe.
  • Changing PCM order placement.
## Goal Enrich the carrier-route (EDDM-style) compose table so Monica can compare routes before picking 1–2 to mail. ## Scope - Add **Size** (avg household), **Income** (median), and **Businesses** columns to the route result table. - Link out to the official USPS EDDM map: https://eddm.usps.com/eddm/select-routes.htm (search ZIP there, Show Table for Census filters). - Join public USPS EDDM GIS stats onto PCM ZipCRRT rows. Households/cost stay PCM (order count). GIS fail must not block Find routes. - Size/income may be blank (`—`) when USPS GIS omits `AVG_HH_SIZ` / `MED_INCOME`; businesses typically fill. - Not official EDDM postage — still PCM purchased occupant lists. ## Mirror westfarn/web_django_template (ticket to follow). ## Out of scope - Embedding the USPS map iframe. - Changing PCM order placement.
westfarn commented 2026-09-22 12:35:50 -07:00
Author
Owner
Copy link
Copy source

Template mirror: westfarn/web_django_template#13

Template mirror: https://git.aimloperations.com/westfarn/web_django_template/issues/13
westfarn commented 2026-09-22 12:38:11 -07:00
Author
Owner
Copy link
Copy source

PR: #18

Template counterpart: westfarn/web_django_template#14

PR: https://git.aimloperations.com/ai_ml_operations/monica_site/pulls/18 Template counterpart: https://git.aimloperations.com/westfarn/web_django_template/pulls/14
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
twestfall westfarn (Ryan Westfall)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: ai_ml_operations/monica_site#17