[postgis-users] tiger_geocoder import error

Tue May 22 12:27:58 PDT 2012

Forgot to add in the o\loader_table if you disable those tables it shouldn't
generate a script for them.  You only need them for census block lookups
functions not for the core geocoder.

  _____  

From: Paragon Corporation [mailto:lr at pcorp.us] 
Sent: Tuesday, May 22, 2012 3:25 PM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] tiger_geocoder import error

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-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Jeff
Rossi
Sent: Tuesday, May 22, 2012 2:11 PM
To: postgis-users at 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120522/9cb80cb8/attachment.html>