[postgis-users] TIGER geocoder, Ticket #1838 (new defect)

[James Marca]

On Sat, Aug 11, 2012 at 03:53:56PM -0400, Paragon Corporation wrote:
> Correct.  It's just with loading tabblock data which isn't used in Geocoder.
> I don't have it used in any function at the moment actually though its a
> table a couple of people asked for for stats 
> which is why we included it.
>  
> anyrate just fixed the issue for tiger_2011 (distributed with PostGIS 2.1)
> and will have fixed for tiger_2010 (distributed with PostGIS 2.0) soon as
> well

Awesome.  But...now I hit a new problem

NOTICE:  INSERT INTO tiger_data.ca_tabblock(the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,countyfp,statefp) SELECT the_geom,intptlon,intptlat,awate;
ERROR:  value too long for type character varying(15)
CONTEXT:  SQL statement "INSERT INTO tiger_data.ca_tabblock(the_geom,intptlon,intptlat,awater,aland,funcstat,uace,ur,mtfcc,name,tabblock_id,countyfp,statefp) SELECT the_geom,intptlo"
PL/pgSQL function "loader_load_staged_data" line 24 at EXECUTE statement


I am processing California.

I will add the -e flag to the psql command to see what is too long .

Regards, 
James Marca
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120813/7598cb82/attachment.pgp>