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" target="_top" rel="nofollow" link="external">[hidden email]</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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" link="external" target="_blank">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" link="external" target="_blank">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" link="external" target="_blank">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" link="external" target="_blank">http://user/SendEmail.jtp?type=node&node=4997640&i=1</a>>
<br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" rel="nofollow" link="external" target="_blank">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" link="external" target="_blank">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" link="external" target="_blank">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" link="external" target="_blank">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" link="external" target="_blank">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" link="external" target="_blank">[hidden email]</a>
<br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" rel="nofollow" link="external" target="_blank">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" link="external" target="_blank">[hidden email]</a>
<br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" rel="nofollow" link="external" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br>
<br>
<hr noshade size="1" color="#cccccc">
</div><div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif"><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" target="_blank" rel="nofollow" link="external">http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p4997671.html</a>
</div><div class="HOEnZb"><div class="h5">
<div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em;line-height:1.5em">
To unsubscribe from tiger_geocoder import error, <a href="" target="_blank" rel="nofollow" link="external">click here</a>.<br>
<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" style="font:9px serif" 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/>