[postgis-users] Dealing with bogus records

[Andy Turk]

On Sunday 26 May 2002 01:47 pm, you wrote:
> Hello,
> I'm using PostGIS for a project with large shapefiles (for now, at least
> 600.000 records) and I have a problem with bogus records. In my shapefiles,
> some records are bogus, things like "A11" in a integer column, 81120-9
> instead of 81129, this kind of things. I think that there is less than 10
> problematic records per shapefile.

I noticed similar problems in converting TIGER data. My fix was to change the 
schema so that varchar is used instead of integer for the offending columns.