[postgis-users] shp2pgsql error?

[Lars Rößiger]

Hello,

we're using the Tele Atlas MultiNet geographic database to build a map
application.

I'm importing the shapefiles into PostGIS using shp2pgsql.

The fields 'FEATAREA' and 'FEATPERIM' are defined as numbers (N) without
decimals (0). This is what the documentation and 'dbview' says. However,
it looks like the numbers end in a decimal point, but have no decimals
themselves.

Example:
Id         : 542760711002103
Feattyp    : 3110
Featarea   : 327496.
Featperim  : 3856.
Name       : Mannhof
Namelc     : GER
Buacode    :

Of course, these numbers cause a PostgreSQL error when I try to import.
I can edit the import file manually and remove the decimal points, but
I've seen other applications which import the numbers and remove the
decimal point.

So I wonder if this is a problem I need to live with or if a workaround
for this should be included into PostGIS?

Any comments?

Thank you,
Lars