[postgis-users] pgsql2shp cuts varchar fields

[Obe, Regina]

I suppose Map Info tab format or some other format is not an option for MapBook. 

Well I'm not sure about the memo field part, but I know around here MapInfo users get
frustrated when they export from MapInfo to ESRI Shape because of the .dbf 10 character field name limitation.


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net on behalf of David Fawcett
Sent: Thu 12/18/2008 12:32 PM
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...
>
>
> 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




-----------------------------------------
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081218/2b20eb1f/attachment.html>