[postgis-users] shp2pgsql problem

[Willy-Bas Loos]

thanks.
how can you tell?

On Dec 13, 2007 6:17 PM, Tom Glancy <Tom.Glancy at dnr.state.mn.us> wrote:

>  Your dbf file contains spaces (0x20) in the "microrelie" boolean and
> "macrorelie" boolean fields. The representation of NULL in boolean fields is
> a question mark (0x3f). Allowable characters in a boolean field are
> Y,y,N,n,T,t,F,f,?
>
> It looks like your dbf is broken.
>
> Regards,
> Tom
>
>
> >>> "Willy-Bas Loos" <willybas at gmail.com> 12/13/2007 6:15 AM >>>
>
> here's the rest of the shapefile (still one record, attached).
>
> On Dec 13, 2007 11:04 AM, Willy-Bas Loos <willybas at gmail.com> wrote:
>
> > Hi,
> >
> > I have a small problem wit shp2pgsql, it doesn't convert my colleague's
> > shapefile correctly.
> > I've attached the 1rec shapefile and the shp2pgsql result in this mail,
> > hope that works.
> >
> > I'm using this version: RCSID: $Id: shp2pgsql.c,v 1.88.2.7 2005/08/29
> > 22:36:14 strk Exp $
> > on windows XP.
> >
> > The problem is in two of the boolean fields: "microrelie" boolean and
> > "macrorelie" boolean.
> > They are both created, but their values don't make it into the INSERT
> > statement. They turn up as empty strings, which is illegal SQL.
> > There are lots (37) of fields in the shapefile.
> > 12 other boolean fields are handled correctly.
> > The "bad" fields are the 24th and the 25th field.
> >
> > is this some bug?
> >
> > WBL
> >
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071213/398a0840/attachment.html>