[postgis-users] pgsql2shp cuts varchar fields

[Sufficool, Stanley]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of David Fawcett
> Sent: Thursday, December 18, 2008 9:33 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] pgsql2shp cuts varchar fields
> 
> 
> Other things that you may notice when exporting to shape is 
> that field names may be truncated, and you are limited to 
> ~256 columns in your table as well.  This goes back to the 
> .dbf spec.  Some (column limit) of the these limitations also 
> show up when you export to the ESRI Personal Geodatabase as well.
> 
> David.
> 
> On Thu, Dec 18, 2008 at 10:37 AM, Gustavo Ces <g.ces at pettra.es> wrote:
> > Hi Regina,
> >
> >     thanks for answering. You must be right. I´ve tried to 
> export with 
> > Gvsig to shapefile and cuts the varchar fields... I´ve 
> tried to join 
> > with arcgis and fields don´t be cutted but when i export 
> joined data 
> > to a shapefile ( i need this to use Arcgis Mapbook and use those 
> > fields as tags), then i´ve got cutted fields... So it seems a 
> > shape/dbf problem... And i´ve got no option now! :(
> >      Maybe making two fields from all original fields it´s 
> the answer 
> > ( i´ve got no text larger than 254*2). Any other suggestion will be 
> > welcomed...
> >

Foxpro and Clipper allow for text field sizes up to 64K using the field size + (decimal count * 256).

Would it be a problem to include this support in the shape file importer? Does ogr2ogr support this?


> >
> > Gus
> >
> > ----- Original Message -----
> > From: Obe, Regina
> > To: PostGIS Users Discussion
> > Sent: Thursday, December 18, 2008 5:08 PM
> > Subject: RE: [postgis-users] pgsql2shp cuts varchar fields Not 
> > absolutely sure, but I think its a limit in the spec.  I 
> think fields 
> > > 254 are considered to be memo fields in the dbf world and 
> so would 
> > be put in a .dbt. Its been a while since I've done any 
> DBase or Foxpro 
> > programming so my memory could be wrong.
> >
> > I've never actually seen .dbt files included with ESRI 
> shape files, so 
> > I assume ESRI discarded that side of the spec.  If its 
> allowed, then 
> > we probably should implement it.
> >
> > Hope that helps,
> > Regina
> >
> >
> > ________________________________
> > From: postgis-users-bounces at postgis.refractions.net
> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of 
> > Gustavo Ces
> > Sent: Thursday, December 18, 2008 10:53 AM
> > To: PostGIS Users Discussion
> > Subject: [postgis-users] pgsql2shp cuts varchar fields
> >
> > Hi all,
> >
> >     maybe this is an old issue... I´m trying to export to shapefile 
> > some geometries, but in the result shapefile varchar fields greater 
> > than 255 are cutted at this point. I´ve got alternatives 
> but i´d like 
> > to know : is there any method to export those fields directly with 
> > pgsql2shp or is it a shapefile-format or pgsql2shp limit?
> >     Thanks in advance,
> >
> >
> > Gus
> >
> > ________________________________
> >
> > The substance of this message, including any attachments, may be 
> > confidential, legally privileged and/or exempt from disclosure 
> > pursuant to Massachusetts law. It is intended solely for the 
> > addressee. If you received this in error, please contact the sender 
> > and delete the material from any computer.
> >
> > ________________________________
> >
> > Help make the earth a greener place. If at all possible resist 
> > printing this email and join us in saving paper.
> >
> > ________________________________
> >
> > _______________________________________________
> > postgis-users mailing list postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> > _______________________________________________
> > postgis-users mailing list postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>