[postgis-users] TIGER geocoder, Ticket #1838 (new defect)

[James Marca]

Hi, 

I am trying to install the Tiger geocoder, 2011 version, and I seem to
have run into the same problem listed in Ticket #1838 (new defect).

For California import, using 2011 scripts, the import fails on 

"SELECT loader_load_staged_data(lower('CA_tabblock'),
lower('CA_tabblock')); "

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,...
                                                             ^
QUERY:  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:  PL/pgSQL function "loader_load_staged_data" line 24 at
EXECUTE statement

The ticket and the original email thread implied that the original
reporter was able to get the 2011 import to work.  Any tips on how to
do that?

I'm using: 

  Gentoo ebuild for PostgreSQL 9.1.4, 
  PostGIS 2.0.1 (Gentoo ebuild postgis-2.0.1), 
  the tiger importer from a git clone: 
     commit  f95ed8ece94b437cdb71a1490c21aacb6a7d0742
     Author: Regina Obe <lr at pcorp.us>, 
     Date:   Thu Aug 9 15:54:52 2012 +0000)


I also had to comment out all of the unzip lines that looked like 
    for z in */tl_*_06*...
As there was no such data for any of the downloads

Regards, 

James Marca
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120810/2f8a6442/attachment.pgp>