<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16450"></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT color=#0000ff size=2
face=Arial></FONT> </DIV>
<DIV><SPAN class=089163404-03112012></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>Mike,</FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT
size=2></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2>T<SPAN
class=089163404-03112012>hat'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.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012> 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.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012>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.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012>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:
<A
href="http://trac.osgeo.org/postgis/ticket/2076">http://trac.osgeo.org/postgis/ticket/2076</A></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012>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.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012>Regina</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012><A
href="http://www.postgis.us">http://www.postgis.us</A></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=089163404-03112012></SPAN></FONT></FONT></FONT> </DIV>
<DIV><BR></DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Michael
Papet<BR><B>Sent:</B> Saturday, November 03, 2012 12:26 AM<BR><B>To:</B>
postgis-users@lists.osgeo.org<BR><B>Subject:</B> [postgis-users] Newbie Tiger
2010 Query Errors<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV
style="BACKGROUND-COLOR: #fff; FONT-FAMILY: times new roman, new york, times, serif; COLOR: #000; FONT-SIZE: 12pt">
<DIV>I think I figured the stuff out I was doing wrong, but now I'm at a loss
for the query errors that follow.</DIV>
<DIV><BR></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px">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;</DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><BR></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px">I
get the following errors in my Postgresql log and I don't know if they mean
anything.<BR></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px"><BR></DIV>
<DIV
style="BACKGROUND-COLOR: transparent; FONT-STYLE: normal; FONT-FAMILY: times new roman,new york,times,serif; COLOR: rgb(0,0,0); FONT-SIZE: 16px">2012-11-02
18:00:31 PDT ERROR: INSERT has more expressions than target columns at
character 294<BR>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;<BR>2012-11-02 18:00:31 PDT CONTEXT:
PL/pgSQL function "loader_load_staged_data" line 24 at EXECUTE
statement<BR><BR>2012-11-02 19:56:18 PDT ERROR: syntax error at or near
"FROM" at character 637<BR>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;<BR><BR>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'));<BR><BR>2012-11-02 20:43:19 PDT ERROR: column
"tabblock_id" does not exist at character 246<BR>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)<BR>
SELECT
the_geom,intptlon10,intptlat10,awater10,aland10,funcstat10,uace10,ur10,mtfcc10,name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10
FROM tiger_staging.wi_tabblock10;<BR><BR></DIV></DIV></BODY></HTML>