[postgis-users] Newbie Tiger 2010 Query Errors

Michael Papet mpapet at yahoo.com
Fri Nov 2 21:26:29 PDT 2012


I think I figured the stuff out I was doing wrong, but now I'm at a loss for the query errors that follow.

I'm using Debian's postgresql 9.1 and PostGIS 2.0SVN. I got the Tigetr2010 loader script that generated the error using the following example: SELECT loader_generate_script(ARRAY['WI', 'WY', 'DC'], 'sh') AS result;

I get the following errors in my Postgresql log and I don't know if they mean anything.


2012-11-02 18:00:31 PDT ERROR:  INSERT has more expressions than target columns at character 294
2012-11-02 18:00:31 PDT QUERY:  INSERT INTO tiger_data.dc_tabblock(the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp) SELECT the_geom,intptlon10,intptlat10,awater10,aland10,funcstat10,uatyp10,uace10,ur10,mtfcc10,name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10 FROM tiger_staging.dc_tabblock10;
2012-11-02 18:00:31 PDT CONTEXT:  PL/pgSQL function "loader_load_staged_data" line 24 at EXECUTE statement

2012-11-02 19:56:18 PDT ERROR:  syntax error at or near "FROM" at character 637
2012-11-02 19:56:18 PDT QUERY:  INSERT INTO tiger_data.wi_faces(the_geom,intptlon,intptlat,atotal,"offset",lwflag,nctadvfp,nectafp,cnectafp,metdivfp,cbsafp,csafp,puma5ce,ugace,tazce,zcta5ce,vtdst,sldlst,sldust,cd111fp,uace,unsdlea,scsdlea,elsdlea,tblkgpce,ttractce,anrcfp,trsubce,trsubfp,comptyp,aiannhce,aiannhfp,placefp,conctyfp,submcdfp,cousubfp,blockce,blkgrpce,tractce,countyfp,statefp,puma5ce00,ugace00,tazce00,zcta5ce00,vtdst00,sldlst00,sldust00,cd108fp,uace00,unsdlea00,scsdlea00,elsdlea00,anrcfp00,trsubce00,trsubfp00,comptyp00,aiannhce00,aiannhfp00,placefp00,conctyfp00,submcdfp00,cousubfp00,blockce00,blkgrpce00,tractce00,countyfp00,statefp00,tfid) SELECT  FROM tiger_staging.wi_faces;

2012-11-02 19:55:50 PDT STATEMENT:  ALTER TABLE tiger_staging.WI_tabblock10 RENAME geoid10 TO tabblock_id;  SELECT loader_load_staged_data(lower('WI_tabblock10'), lower('WI_tabblock'));

2012-11-02 20:43:19 PDT ERROR:  column "tabblock_id" does not exist at character 246
2012-11-02 20:43:19 PDT STATEMENT:   INSERT INTO tiger_data.wi_tabblock(the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp)
         SELECT the_geom,intptlon10,intptlat10,awater10,aland10,funcstat10,uace10,ur10,mtfcc10,name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10 FROM tiger_staging.wi_tabblock10;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121102/b3475bcd/attachment.html>


More information about the postgis-users mailing list