[postgis-devel] [PostGIS] #1930: Missing fields from tabblock table in tiger2011 census loader

[PostGIS]

#1930: Missing fields from tabblock table in tiger2011 census loader
----------------------------+-----------------------------------------------
 Reporter:  bpanulla        |       Owner:  robe         
     Type:  defect          |      Status:  new          
 Priority:  low             |   Milestone:  PostGIS 2.0.2
Component:  tiger geocoder  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 Similar to #1885, the TIGER 2011 Geocoder has some issues with the
 tabblock table. The loader throws the following error in the logs:

 {{{
 NOTICE:  INSERT INTO
 tiger_data.ca_tabblock(the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp)
 SELECT
 the_geom,intptlon,intptlat,awater,aland,funcstat,uace10,ur10,mtfcc,name,tabblock_id,suffix1ce,blockce10,tractce10,countyfp10,statefp10,countyfp,statefp
 FROM tiger_staging.ca_tabblock;
 CONTEXT:  SQL function "loader_load_staged_data" statement 1
 ERROR:  INSERT has more expressions than target columns
 LINE 1: ...block_id,suffix1ce,blockce10,tractce10,countyfp10,statefp10,...
 }}}

 The extra fields in the staging table generated by the shapefile loader
 are:
 {{{
         statefp CHARACTER VARYING(2),
         countyfp CHARACTER VARYING(3),
 ...
         suffix1ce CHARACTER VARYING(1),
 }}}

 The statefp and countyfp fields are accompanied by statefp10 and
 countyfp10, so I'm not sure which pair is actually extra.

 I haven't noticed any problems with the functionality of the Geocoder.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1930>
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.