[PostGIS] #5710: GA and LA TIGER TABBLOCK20 files fail to load for years 2020 through 2023

[PostGIS]

#5710: GA and LA TIGER TABBLOCK20 files fail to load for years 2020 through 2023
------------------------------+---------------------
 Reporter:  weyhing           |      Owner:  pramsey
     Type:  defect            |     Status:  new
 Priority:  medium            |  Milestone:
Component:  postgis           |    Version:  3.3.x
 Keywords:  TIGER,TABBLOCK20  |
------------------------------+---------------------
 Both Georgia and Louisiana have malformed TABBLOCK20 shapefiles (for 2020
 through 2023 download years).  These two states will not load into
 tiger_data tables inherited from tiger.tabblock20.

 The problem is that each shapefile is missing a **UATYPE20** column, and
 also has an unexpected **GEOIDFQ20** column.  These are the only two
 TABBLOCK20 shapefiles with this problem.

 Considering the UATYPE20 column is as-of-yet unused I've worked around the
 problem by adding a couple lines of code to the ga_load.cmd and
 la_load.cmd scripts:


 {{{
 %PSQL% -c "ALTER TABLE tiger_staging.la_tabblock20 ADD COLUMN IF NOT
 EXISTS uatype varchar(1) null;"
 %PSQL% -c "ALTER TABLE tiger_staging.la_tabblock20 DROP COLUMN IF EXISTS
 geoidfq20;"
 }}}

 Specific TIGER files tested:


 {{{
 www2.census.gov\geo\tiger\TIGER2020\TABBLOCK20\tl_2020_13_tabblock20.zip
 www2.census.gov\geo\tiger\TIGER2020\TABBLOCK20\tl_2020_22_tabblock20.zip

 www2.census.gov\geo\tiger\TIGER2022\TABBLOCK20\tl_2022_13_tabblock20.zip
 www2.census.gov\geo\tiger\TIGER2022\TABBLOCK20\tl_2022_22_tabblock20.zip

 www2.census.gov\geo\tiger\TIGER2023\TABBLOCK20\tl_2023_13_tabblock20.zip
 www2.census.gov\geo\tiger\TIGER2023\TABBLOCK20\tl_2023_22_tabblock20.zip
 }}}

 See attached output for specific dtypes using geopandas.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5710>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.