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: [email protected] 
[mailto:[email protected]] 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
  [email protected]
  http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to