[postgis-users] pgsql2shp cuts varchar fields

[David Fawcett]

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...
>
>
> 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
>
>