[postgis-users] pgsql2shp cuts varchar fields

[Gustavo Ces]

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