#5388 closed defect (fixed)

TIGER 2022 faces changed

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 3.3.3
Component: tiger geocoder Version: 3.3.x
Keywords: Cc:

Description

Looks like Census decided to update TIGER 2022 data again, adding an additional column to faces.

Change History (4)

comment:1 by robe, 18 months ago

updating exclude columns for faces seems to fix the issue.

UPDATE loader_lookuptables SET columns_exclude = 
'{gid,geoid,cpi,suffix1ce,statefp00,statefp10,countyfp00,countyfp10,tractce00,tractce10,blkgrpce00,blkgrpce10,blockce00,blockce10,cousubfp00,submcdfp00,conctyfp00,placefp00,aiannhfp00,aiannhce00,comptyp00,trsubfp00,trsubce00,anrcfp00,elsdlea00,scsdlea00,unsdlea00,uace00,cd108fp,sldust00,sldlst00,vtdst00,zcta5ce00,tazce00,ugace00,puma5ce00,vtdst10,tazce10,uace10,puma5ce10,tazce,uace,vtdst,zcta5ce10,puma5ce,ugace10,pumace10,estatefp,ugace,blockce,pumace20,sdadmlea,uace20}'::text[]
WHERE lookup_name = 'faces';

comment:2 by Regina Obe <lr@…>, 18 months ago

In 7aef48a5/git:

Fix tiger 2022 faces load

  • Add uace20 to exclusions column list

References #5388 for PostGIS 3.4.0

comment:3 by Regina Obe <lr@…>, 18 months ago

In 5a935c7/git:

Fix tiger 2022 faces load

  • Add uace20 to exclusions column list

References #5388 for PostGIS 3.3.3

comment:4 by robe, 18 months ago

Milestone: PostGIS 3.1.9PostGIS 3.3.3
Resolution: fixed
Status: newclosed

I guess I don't have tiger_2022 for prior versions, so stops at 3.3

Note: See TracTickets for help on using tickets.