[postgis-users] TIGER geocoder, Ticket #1838 (new defect)
jmarca at translab.its.uci.edu
Mon Aug 13 12:43:21 PDT 2012
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
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 .
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 189 bytes
Desc: not available
More information about the postgis-users