<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16443"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=879392219-22052012><FONT color=#0000ff
size=2 face=Arial>Can you put in a ticket for this. I suspect its a
bug. The census blocks piece was the last piece to go in and when I was
testing I was loading mostly separately.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=879392219-22052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=879392219-22052012><FONT color=#0000ff
size=2 face=Arial><A
href="http://trac.osgeo.org/postgis/">http://trac.osgeo.org/postgis/</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=879392219-22052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=879392219-22052012><FONT color=#0000ff
size=2 face=Arial>Set to tiger_geocoder for component and it will be assigned to
me.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=879392219-22052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=879392219-22052012><FONT color=#0000ff
size=2 face=Arial>Also are you using tiger_2010 or tiger_2011. I haven't
fixed census blocks for 2011 yet.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=879392219-22052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=879392219-22052012><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=879392219-22052012><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=879392219-22052012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Jeff
Rossi<BR><B>Sent:</B> Tuesday, May 22, 2012 2:11 PM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> Re: [postgis-users]
tiger_geocoder import error<BR></FONT><BR></DIV>
<DIV></DIV>I can make a query to finish the import, but how would I fix the
import script so I don't have issues with the 49 other states.<BR><BR>
<DIV class=gmail_quote>On Tue, May 22, 2012 at 1:51 PM, Stephen Woodbridge [via
PostGIS] <SPAN dir=ltr><<A
href="/user/SendEmail.jtp?type=node&node=4997672&i=0" rel=nofollow
target=_top link="external">[hidden email]</A>></SPAN> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV class=im>Depends on if you just want to rename them or copy them!
<BR><BR>Rename like: <BR><BR>create schema tiger_data; <BR>begin; <BR>-- first
rename the table <BR>alter table tiger_staging.fl_tabblock10 rename
fl_tabblock; <BR>-- then move it to the new schema <BR>alter table
tiger_staging.fl_tabblock set schema tiger_data; <BR>commit; <BR><BR>If there
are name conflicts you can move it to the new schema then <BR>rename it. If
you want to copy the data then look at commands like: <BR><BR>create table
tiger_data.fl_tabblock as select * from <BR>tiger_staging.fl_tabblock10;
<BR><BR>or <BR><BR>insert into tiger_data.fl_tabblock (<column_list>)
select <column_list> <BR>from tiger_staging.fl_tabblock10;
<BR><BR>-Steve W <BR><BR>On 5/22/2012 11:46 AM, Jeff Rossi wrote: </DIV>
<DIV>
<DIV class=im><BR>> Any idea how I can get the 480K records from
tiger_staging.fl_tabblock10 <BR>> to tiger_data.fl_tabblock <BR>>
<BR></DIV>
<DIV>
<DIV class=h5>> On Tue, May 22, 2012 at 8:47 AM, Mario Sileone [via
PostGIS] <[hidden
<DIV class=shrinkable-quote><BR>> email]
</user/SendEmail.jtp?type=node&node=4997655&i=0>> wrote:
<BR>> <BR>> Dear Jeff: <BR>>
according to the error detailed <BR>>
ERROR: INSERT has more expressions than target columns <BR>>
You Have: <BR>>
the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp
<BR>> <BR>> <BR>> Which count 15 expressions and
<BR>> <BR>>
the_geom,intptlon10,intptlat10,awater10,aland10,funcstat10,uatyp10,uace10,ur10,mtfcc10,name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10
<BR>> <BR>> <BR>> are 16 values. <BR>> <BR>>
So, or You have a missin expression or one more value, check
this. <BR>> <BR>> Best Regards <BR>> <BR>> <BR>>
El 22/05/2012 8:45, Jeff Rossi escribió: <BR>> <BR>>
> Sorry if this is a double post, had an issue with my
mail server <BR>> and had to <BR>> <BR>>
> use my personal email. <BR>> > <BR>>
> This is my first project with postgresql/postgis and
it is <BR>> possible and <BR>> >
maybe even probable that I made an error. I used pgadmin to <BR>>
generate import <BR>> > scripts by
state and started with florida. The errors are below: <BR>>
> <BR>> > #### <BR>>
> <BR>> > COMMIT <BR>>
> NOTICE: INSERT INTO <BR>> >
<BR>>
tiger_data.fl_tabblock(the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp)
<BR>> <BR>> > SELECT <BR>>
> <BR>>
the_geom,intptlon10,intptlat10,awater10,aland10,funcstat10,uatyp10,uace10,ur10,mtfcc10,name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10
<BR>> <BR>> > FROM tiger_staging.fl_tabblock10;
<BR>> > CONTEXT: SQL function
"loader_load_staged_data" statement 1 <BR>> > ERROR:
INSERT has more expressions than target columns <BR>>
> LINE 1: <BR>>
...name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10 ... <BR>>
>
^ <BR>> > QUERY: INSERT INTO
<BR>> > <BR>>
tiger_data.fl_tabblock(the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,blockce,tractce,countyfp,statefp)
<BR>> <BR>> > SELECT <BR>>
> <BR>>
the_geom,intptlon10,intptlat10,awater10,aland10,funcstat10,uatyp10,uace10,ur10,mtfcc10,name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10
<BR>> <BR>> > FROM tiger_staging.fl_tabblock10;
<BR>> > CONTEXT: PL/pgSQL function
"loader_load_staged_data" line 24 at <BR>> EXECUTE <BR>>
> statement <BR>> > SQL
function "loader_load_staged_data" statement 1 <BR>>
> <BR>> > #### <BR>>
> <BR>> > It appears to me that the extra
column is uatyp10 <BR>> > <BR>>
> Many Thanks for your Assistance, <BR>> >
<BR>> > Jeff <BR>> >
<BR>> > -- <BR>> > View
this message in context: <BR>> <A
href="http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634.html"
rel=nofollow target=_blank
link="external">http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634.html</A></DIV>>
> Sent from the PostGIS - User mailing list archive at
Nabble.com. <BR>> >
_______________________________________________ <BR>>
> postgis-users mailing list <BR>> >
[hidden email] <BR></DIV></DIV>> <<A
href="http://user/SendEmail.jtp?type=node&node=4997640&i=0"
rel=nofollow target=_blank
link="external">http://user/SendEmail.jtp?type=node&node=4997640&i=0</A>>
<BR>
<DIV class=im>> > <A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
rel=nofollow target=_blank
link="external">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>>
> <BR>> <BR>> <BR>> -- <BR>>
Mario Sileone <BR>>
_______________________________________________ <BR>>
postgis-users mailing list <BR></DIV>> [hidden email] <<A
href="http://user/SendEmail.jtp?type=node&node=4997640&i=1"
rel=nofollow target=_blank
link="external">http://user/SendEmail.jtp?type=node&node=4997640&i=1</A>>
<BR>> <A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
rel=nofollow target=_blank
link="external">http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
<DIV class=im><BR>> <BR>> <BR>> If you reply to this
email, your message will be added to the <BR>> discussion
below: <BR>> <A
href="http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997640.html"
rel=nofollow target=_blank
link="external">http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997640.html</A><BR>>
<BR>> To unsubscribe from tiger_geocoder import error, click
here. <BR>> NAML <BR></DIV>> <<A
href="http://postgis.17.n6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml"
rel=nofollow target=_blank
link="external">http://postgis.17.n6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml</A>>
<BR>
<DIV class=im>>
<DIV class=shrinkable-quote><BR>> <BR>> <BR>> <BR>> <BR>> --
<BR>> Regards <BR>> <BR>> Jeff Rossi <BR>> <BR>> Intouch MVC
<BR>> 1506 Tuscaloosa Ave <BR>> Holly Hill, FL 32117 <BR>> <a
href="tel:%28386%29%20226-8979" value="+13862268979" target="_blank">(386)
226-8979</A> <BR>> </DIV></DIV>
<DIV class=im>> View this message in context: Re: tiger_geocoder import
error <BR>> <<A
href="http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997655.html"
rel=nofollow target=_blank
link="external">http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997655.html</A>>
<BR></DIV>
<DIV class=im>> Sent from the PostGIS - User mailing list archive
<BR></DIV>> <<A
href="http://postgis.17.n6.nabble.com/PostGIS-User-f3516033.html" rel=nofollow
target=_blank
link="external">http://postgis.17.n6.nabble.com/PostGIS-User-f3516033.html</A>>
at Nabble.com. <BR>
<DIV class=im>> <BR>> <BR>>
_______________________________________________ <BR>> postgis-users mailing
list <BR>> <A
href="http://user/SendEmail.jtp?type=node&node=4997671&i=0"
rel=nofollow target=_blank link="external">[hidden email]</A> <BR>> <A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
rel=nofollow target=_blank
link="external">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></DIV></DIV><BR>
<DIV class=im>_______________________________________________
<BR>postgis-users mailing list <BR><A
href="http://user/SendEmail.jtp?type=node&node=4997671&i=1"
rel=nofollow target=_blank link="external">[hidden email]</A> <BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
rel=nofollow target=_blank
link="external">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR><BR>
<HR color=#cccccc SIZE=1 noShade>
</DIV>
<DIV style="FONT: 12px tahoma,geneva,helvetica,arial,sans-serif; COLOR: #444">
<DIV class=im>
<DIV style="FONT-WEIGHT: bold">If you reply to this email, your message will
be added to the discussion below:</DIV></DIV><A
href="http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997671.html"
rel=nofollow target=_blank
link="external">http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997671.html</A>
</DIV>
<DIV class=HOEnZb>
<DIV class=h5>
<DIV
style="MARGIN-TOP: 0.4em; FONT: 11px/1.5em tahoma,geneva,helvetica,arial,sans-serif; COLOR: #666">To
unsubscribe from tiger_geocoder import error, <A href="" rel=nofollow
target=_blank link="external">click here</A>.<BR><A style="FONT: 9px serif"
href="http://postgis.17.n6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml"
rel=nofollow target=_blank link="external">NAML</A>
</DIV></DIV></DIV></BLOCKQUOTE></DIV><BR><BR clear=all>
<DIV><BR></DIV>-- <BR>Regards<BR><BR>Jeff Rossi<BR><BR>Intouch MVC<BR>1506
Tuscaloosa Ave<BR>Holly Hill, FL 32117<BR>(386) 226-8979<BR><BR>
<HR align=left width=300>
View this message in context: <A
href="http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997672.html">Re:
tiger_geocoder import error</A><BR>Sent from the <A
href="http://postgis.17.n6.nabble.com/PostGIS-User-f3516033.html">PostGIS - User
mailing list archive</A> at Nabble.com.<BR></BODY></HTML>