[postgis-tickets] [SCM] PostGIS branch stable-3.3 updated. 3.3.2-62-g5a935c7e0

[git at osgeo.org]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, stable-3.3 has been updated
       via  5a935c7e0f82b8d6d7b7ac7a7cff67cbb5d4d3f5 (commit)
      from  b4511a7280ae13f2583093c5cade162cd15bb052 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 5a935c7e0f82b8d6d7b7ac7a7cff67cbb5d4d3f5
Author: Regina Obe <lr at pcorp.us>
Date:   Wed May 24 22:16:55 2023 -0400

    Fix tiger 2022 faces load
     - Add uace20 to exclusions column list
    
    References #5388 for PostGIS 3.3.3

diff --git a/NEWS b/NEWS
index 7c944a145..74193bff4 100644
--- a/NEWS
+++ b/NEWS
@@ -31,6 +31,8 @@ YYYY/MM/DD
           (Paul Ramsey, Regina Obe, Sandro , Laurenz Albe)
   - #5371, ST_Union segfaults (PG 11-12) (Regina Obe)
   - #5378, ST_Buffer(geography) drops SRID (Paul Ramsey)
+  - #5388, [postgis_tiger_geocoder] Fix faces table tiger_gload,
+           caused census rerelease of faces data (Regina Obe)
 
 
 PostGIS 3.3.2
diff --git a/extras/tiger_geocoder/tiger_loader_2022.sql b/extras/tiger_geocoder/tiger_loader_2022.sql
index 12e761d8b..af4b9ee25 100644
--- a/extras/tiger_geocoder/tiger_loader_2022.sql
+++ b/extras/tiger_geocoder/tiger_loader_2022.sql
@@ -361,7 +361,7 @@ VALUES(6, 'faces', 'faces', true, true, false,false, 'c',
       , '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']);
+       'tazce00', 'ugace00', 'puma5ce00','vtdst10','tazce10','uace10','puma5ce10','tazce', 'uace', 'vtdst',  'zcta5ce10', 'puma5ce', 'ugace10','pumace10', 'estatefp', 'ugace', 'blockce', 'pumace20', 'sdadmlea', 'uace20']);
 
 INSERT INTO loader_lookuptables(process_order, lookup_name, table_name, load, level_county, level_state, single_geom_mode, insert_mode, pre_load_process, post_load_process, columns_exclude )
 VALUES(7, 'featnames', 'featnames', true, true, false,false, 'a',

-----------------------------------------------------------------------

Summary of changes:
 NEWS                                        | 2 ++
 extras/tiger_geocoder/tiger_loader_2022.sql | 2 +-
 2 files changed, 3 insertions(+), 1 deletion(-)


hooks/post-receive
-- 
PostGIS