[postgis-users] pgsql2shp cuts varchar fields
Sufficool, Stanley
ssufficool at rov.sbcounty.gov
Thu Dec 18 09:57:08 PST 2008
> -----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
>
More information about the postgis-users
mailing list