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 <l...@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
pgp3g4tZhABxE.pgp
Description: PGP signature
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users