[postgis-users] shp2pgsql

[Laurent Michel]

Thanks very much indeed.

The sample shapefile I sent was produced by NavTech (Navigation
Technologies).

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of postgis-users-
> request at postgis.refractions.net
> Sent: mercredi 5 février 2003 21:00
> To: postgis-users at postgis.refractions.net
> Subject: postgis-users Digest, Vol 4, Issue 8
> 
> Send postgis-users mailing list submissions to
> 	postgis-users at postgis.refractions.net
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://postgis.refractions.net/mailman/listinfo/postgis-users
> or, via email, send a message with subject or body 'help' to
> 	postgis-users-request at postgis.refractions.net
> 
> You can reach the person managing the list at
> 	postgis-users-owner at postgis.refractions.net
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of postgis-users digest..."
> 
> 
> Today's Topics:
> 
>    1. Re: shp2psql problems (Jeff Lounsbury)
>    2. Re: shp2psql problems (Paul Ramsey)
>    3. Re: shp2psql problems (Paul Ramsey)
> 
> 
> ----------------------------------------------------------------------
> 
> Date: Tue, 04 Feb 2003 13:21:00 -0800
> From: Jeff Lounsbury <jeffloun at refractions.net>
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Subject: Re: [postgis-users] shp2psql problems
> Message-ID: <3E402EBB.F3CB0189 at refractions.net>
> References: <001101c2cc88$d15fcbd0$8100a8c0 at montrachet>
> Content-Type: text/plain; charset=us-ascii
> MIME-Version: 1.0
> Content-Transfer-Encoding: 7bit
> Precedence: list
> Reply-To: PostGIS Users Discussion
<postgis-users at postgis.refractions.net>
> Message: 1
> 
> This was an odd one, it appears that by changing the dbf structure(ie,
> deleting a column or two) , the file then loads into postgis fine.
Even
> by removing the shape and adding a simple square the same seg fault
> occurs so it is pretty much certain that there is some problem with
the
> DBF file itself. Although looking through the dbf file we can't see
any
> way that it is particulary different from other in any way?? So it
seems
> this is a problem to look at through the shapelib package and the dbf
> reader in that that shp2pgsql uses. Maybe Frank can take a look at
that
> DBF and give us some insight into it.
> 
> And if Michel wants to let us know where the shp/dbf files were
created
> from, that might help figure it out as well...
> -Jeff
> 
> Laurent Michel wrote:
> 
> > Dear all,
> >
> > I attached to this mail a shapefile (some French adminstrative
areas)
> > which shp2psql cannot handle (segmentation error).
> >
> > Thanks in advance for your kind help,
> >
> > Regards,
> >
> > L
> >
> >    ----------------------------------------------------------------
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> 
> 
> ------------------------------
> 
> Date: Tue, 04 Feb 2003 14:43:56 -0800
> From: Paul Ramsey <pramsey at refractions.net>
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Subject: Re: [postgis-users] shp2psql problems
> Message-ID: <3E40422C.8080107 at refractions.net>
> In-Reply-To: <3E402EBB.F3CB0189 at refractions.net>
> References: <001101c2cc88$d15fcbd0$8100a8c0 at montrachet>
> 	<3E402EBB.F3CB0189 at refractions.net>
> Content-Type: text/plain; charset=us-ascii; format=flowed
> MIME-Version: 1.0
> Content-Transfer-Encoding: 7bit
> Precedence: list
> Reply-To: PostGIS Users Discussion
<postgis-users at postgis.refractions.net>
> Message: 2
> 
> There is some nasty code which is corrupting the DBF file handle after
> it is opened. Dave thinks probably an array is getting written out of
> bounds. Anyhow, it turns out there is a workaround, and that is to
> rename the file to a shorter name (??!?!). I found three-letter names
> working OK. Jeff has to spend some time communing with a debugger in
> order to track this one down.
> 
> P.
> 
> Jeff Lounsbury wrote:
> > This was an odd one, it appears that by changing the dbf
structure(ie,
> > deleting a column or two) , the file then loads into postgis fine.
Even
> > by removing the shape and adding a simple square the same seg fault
> > occurs so it is pretty much certain that there is some problem with
the
> > DBF file itself. Although looking through the dbf file we can't see
any
> > way that it is particulary different from other in any way?? So it
seems
> > this is a problem to look at through the shapelib package and the
dbf
> > reader in that that shp2pgsql uses. Maybe Frank can take a look at
that
> > DBF and give us some insight into it.
> >
> > And if Michel wants to let us know where the shp/dbf files were
created
> > from, that might help figure it out as well...
> > -Jeff
> >
> > Laurent Michel wrote:
> >
> >
> >>Dear all,
> >>
> >>I attached to this mail a shapefile (some French adminstrative
areas)
> >>which shp2psql cannot handle (segmentation error).
> >>
> >>Thanks in advance for your kind help,
> >>
> 
> --
>        __
>       /
>       | Paul Ramsey
>       | Refractions Research
>       | Email: pramsey at refractions.net
>       | Phone: (250) 885-0632
>       \_
> 
> 
> ------------------------------
> 
> Date: Tue, 04 Feb 2003 15:07:48 -0800
> From: Paul Ramsey <pramsey at refractions.net>
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Subject: Re: [postgis-users] shp2psql problems
> Message-ID: <3E4047C4.5030405 at refractions.net>
> In-Reply-To: <3E40422C.8080107 at refractions.net>
> References: <001101c2cc88$d15fcbd0$8100a8c0 at montrachet>
> 	<3E402EBB.F3CB0189 at refractions.net>
> <3E40422C.8080107 at refractions.net>
> Content-Type: text/plain; charset=us-ascii; format=flowed
> MIME-Version: 1.0
> Content-Transfer-Encoding: 7bit
> Precedence: list
> Reply-To: PostGIS Users Discussion
<postgis-users at postgis.refractions.net>
> Message: 3
> 
> There was a memory management problem in the DBF header checking code
> (used to remove postgres-illegal things from the column names) which
was
> messing up the DBF handle in rare cases. It has been fixed and
committed
> to CVS.
> 
> Paul Ramsey wrote:
> > There is some nasty code which is corrupting the DBF file handle
after
> > it is opened. Dave thinks probably an array is getting written out
of
> > bounds. Anyhow, it turns out there is a workaround, and that is to
> > rename the file to a shorter name (??!?!). I found three-letter
names
> > working OK. Jeff has to spend some time communing with a debugger in
> > order to track this one down.
> >
> > P.
> >
> > Jeff Lounsbury wrote:
> >
> >> This was an odd one, it appears that by changing the dbf
structure(ie,
> >> deleting a column or two) , the file then loads into postgis fine.
Even
> >> by removing the shape and adding a simple square the same seg fault
> >> occurs so it is pretty much certain that there is some problem with
the
> >> DBF file itself. Although looking through the dbf file we can't see
any
> >> way that it is particulary different from other in any way?? So it
> seems
> >> this is a problem to look at through the shapelib package and the
dbf
> >> reader in that that shp2pgsql uses. Maybe Frank can take a look at
that
> >> DBF and give us some insight into it.
> >>
> >> And if Michel wants to let us know where the shp/dbf files were
created
> >> from, that might help figure it out as well...
> >> -Jeff
> >>
> >> Laurent Michel wrote:
> >>
> >>
> >>> Dear all,
> >>>
> >>> I attached to this mail a shapefile (some French adminstrative
areas)
> >>> which shp2psql cannot handle (segmentation error).
> >>>
> >>> Thanks in advance for your kind help,
> >>>
> >
> 
> 
> --
>        __
>       /
>       | Paul Ramsey
>       | Refractions Research
>       | Email: pramsey at refractions.net
>       | Phone: (250) 885-0632
>       \_
> 
> 
> ------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> End of postgis-users Digest, Vol 4, Issue 8
> *******************************************