Maniphest T397493

Missing geocode data - backfill
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Eileenmcnaughton
	Jun 20 2025, 1:07 AM

Project Tags

Referenced Files

None

Subscribers

Eileenmcnaughton

Description

We have a bunch of addresses that have postal codes in the US but do not have a state due to the recently-fixed bug - we should do a backfill update

Details

Related Changes in Gerrit:

	Subject	Author	Repo	Branch	Lines +/-
	Backfill state for US addresses with postal code	Lars SG	wikimedia/fundraising/crm	master	+33 -0

Customize query in gerrit

Related Objects

Mentioned In: T430722: Sprint K Priorities

Event Timeline

Eileenmcnaughton created this task.Jun 20 2025, 1:07 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 20 2025, 1:07 AM

AKanji-WMF moved this task from Triage to Next on the Fundraising-Backlog board.Jun 23 2025, 8:15 PM

AKanji-WMF added a project: Fundraising-Tech-Roadmap.Jul 9 2025, 7:14 PM

AKanji-WMF moved this task from Backlog to CiviCRM on the Fundraising-Tech-Roadmap board.Oct 24 2025, 5:44 PM

AKanji-WMF added a project: 25 Dec Q3 Planning.Dec 4 2025, 6:46 PM

AKanji-WMF removed a project: 25 Dec Q3 Planning.Thu, Jun 11, 1:32 AM

Change #1303463 had a related patch set uploaded (by Lars SG; author: Lars SG):

[wikimedia/fundraising/crm@master] Backfill state for US addresses with postal code

https://gerrit.wikimedia.org/r/1303463

gerritbot added a project: Patch-For-Review.Wed, Jun 17, 3:14 PM

Change #1303463 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Backfill state for US addresses with postal code

https://gerrit.wikimedia.org/r/1303463

This runs about 40 minutes.

Maintenance_bot removed a project: Patch-For-Review.Wed, Jun 17, 4:31 PM

SBurnett-WMF added a project: Civi RoadMap FY 26-27.Wed, Jun 17, 5:39 PM

Added states to ~120k contacts.

Lars moved this task from Pending Deployment to Done on the Fundraising Tech - Chaos Crew board.Thu, Jun 18, 5:19 PM

Damilare closed this task as Resolved.Mon, Jun 29, 7:51 PM

Damilare set Final Story Points to 2.

Damilare mentioned this in T430722: Sprint K Priorities.Tue, Jun 30, 6:04 PM