[postgis-users] Newbie Tiger 2010 Query Errors

[Paragon Corporation]

Mike,
 
That's a strange error.  What does your tiger_stagin.wi_faces table look
like.  Strange there is not a field list.  Might suggest something amiss
with the load.
 
 
 I'll have to double check to make sure not an issue in our script  on that
since I just use the tiger_2011 loader scripts for work these days.
 
BTW: you might be better off using the tiger_2011 packaged in 2.1.0SVN.
That one will work fine with PostGIS 2.0 and has some loading improvements
as well.
 
It will handle the newer 2011 dataset and 2011 has a bunch of corrections
from 2010.  Also have on todo to handle new 2012 data:
http://trac.osgeo.org/postgis/ticket/2076
 
That we hope to have in the next 2-3 weeks.  Hopefully this time it will
just require a change to the url instead of script changes.
 
Regina
http://www.postgis.us
 
 
 

  _____  

From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Michael Papet
Sent: Saturday, November 03, 2012 12:26 AM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] Newbie Tiger 2010 Query Errors


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,ur
10,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,nctadv
fp,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,zcta5ce
00,vtdst00,sldlst00,sldust00,cd108fp,uace00,unsdlea00,scsdlea00,elsdlea00,an
rcfp00,trsubce00,trsubfp00,comptyp00,aiannhce00,aiannhfp00,placefp00,conctyf
p00,submcdfp00,cousubfp00,blockce00,blkgrpce00,tractce00,countyfp00,statefp0
0,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,mtfcc
10,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/20121103/e8acef53/attachment.html>