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. http://trac.osgeo.org/postgis/ Set to tiger_geocoder for component and it will be assigned to me. Also are you using tiger_2010 or tiger_2011. I haven't fixed census blocks for 2011 yet. Thanks, Regina
_____ From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Jeff Rossi Sent: Tuesday, May 22, 2012 2:11 PM To: postgis-users@postgis.refractions.net Subject: Re: [postgis-users] tiger_geocoder import error 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. On Tue, May 22, 2012 at 1:51 PM, Stephen Woodbridge [via PostGIS] <[hidden email]> wrote: Depends on if you just want to rename them or copy them! Rename like: create schema tiger_data; begin; -- first rename the table alter table tiger_staging.fl_tabblock10 rename fl_tabblock; -- then move it to the new schema alter table tiger_staging.fl_tabblock set schema tiger_data; commit; If there are name conflicts you can move it to the new schema then rename it. If you want to copy the data then look at commands like: create table tiger_data.fl_tabblock as select * from tiger_staging.fl_tabblock10; or insert into tiger_data.fl_tabblock (<column_list>) select <column_list> from tiger_staging.fl_tabblock10; -Steve W On 5/22/2012 11:46 AM, Jeff Rossi wrote: > Any idea how I can get the 480K records from tiger_staging.fl_tabblock10 > to tiger_data.fl_tabblock > > On Tue, May 22, 2012 at 8:47 AM, Mario Sileone [via PostGIS] <[hidden > email] </user/SendEmail.jtp?type=node&node=4997655&i=0>> wrote: > > Dear Jeff: > according to the error detailed > ERROR: INSERT has more expressions than target columns > You Have: > the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock _id,blockce,tractce,countyfp,statefp > > > Which count 15 expressions and > > the_geom,intptlon10,intptlat10,awater10,aland10,funcstat10,uatyp10,uace10,ur 10,mtfcc10,name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10 > > > are 16 values. > > So, or You have a missin expression or one more value, check this. > > Best Regards > > > El 22/05/2012 8:45, Jeff Rossi escribió: > > > Sorry if this is a double post, had an issue with my mail server > and had to > > > use my personal email. > > > > This is my first project with postgresql/postgis and it is > possible and > > maybe even probable that I made an error. I used pgadmin to > generate import > > scripts by state and started with florida. The errors are below: > > > > #### > > > > COMMIT > > NOTICE: INSERT INTO > > > tiger_data.fl_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.fl_tabblock10; > > CONTEXT: SQL function "loader_load_staged_data" statement 1 > > ERROR: INSERT has more expressions than target columns > > LINE 1: > ...name10,tabblock_id,blockce10,tractce10,countyfp10,statefp10 ... > > ^ > > QUERY: INSERT INTO > > > tiger_data.fl_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.fl_tabblock10; > > CONTEXT: PL/pgSQL function "loader_load_staged_data" line 24 at > EXECUTE > > statement > > SQL function "loader_load_staged_data" statement 1 > > > > #### > > > > It appears to me that the extra column is uatyp10 > > > > Many Thanks for your Assistance, > > > > Jeff > > > > -- > > View this message in context: > http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634.html > > Sent from the PostGIS - User mailing list archive at Nabble.com. > > _______________________________________________ > > postgis-users mailing list > > [hidden email] > <http://user/SendEmail.jtp?type=node <http://user/SendEmail.jtp?type=node&node=4997640&i=0> &node=4997640&i=0> > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > -- > Mario Sileone > _______________________________________________ > postgis-users mailing list > [hidden email] <http://user/SendEmail.jtp?type=node <http://user/SendEmail.jtp?type=node&node=4997640&i=1> &node=4997640&i=1> > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > If you reply to this email, your message will be added to the > discussion below: > http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p499764 0.html > > To unsubscribe from tiger_geocoder import error, click here. > NAML > <http://postgis.17.n6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer <http://postgis.17.n6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer &id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicName space-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.Node Namespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_email s%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> &id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicName space-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.Node Namespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_email s%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > > > > > > -- > Regards > > Jeff Rossi > > Intouch MVC > 1506 Tuscaloosa Ave > Holly Hill, FL 32117 > <a href="tel:%28386%29%20226-8979" value="+13862268979" target="_blank">(386) 226-8979 > > View this message in context: Re: tiger_geocoder import error > <http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p49976 55.html> > Sent from the PostGIS - User mailing list archive > <http://postgis.17.n6.nabble.com/PostGIS-User-f3516033.html> at Nabble.com. > > > _______________________________________________ > postgis-users mailing list > [hidden email] <http://user/SendEmail.jtp?type=node&node=4997671&i=0> > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [hidden email] <http://user/SendEmail.jtp?type=node&node=4997671&i=1> http://postgis.refractions.net/mailman/listinfo/postgis-users _____ If you reply to this email, your message will be added to the discussion below: http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p499767 1.html To unsubscribe from tiger_geocoder import error, click here. NAML <http://postgis.17.n6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer &id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicName space-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.Node Namespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_email s%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> -- Regards Jeff Rossi Intouch MVC 1506 Tuscaloosa Ave Holly Hill, FL 32117 (386) 226-8979 _____ View this message in context: Re: <http://postgis.17.n6.nabble.com/tiger-geocoder-import-error-tp4997634p49976 72.html> tiger_geocoder import error Sent from the PostGIS - User <http://postgis.17.n6.nabble.com/PostGIS-User-f3516033.html> mailing list archive at Nabble.com.
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users