<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3462" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi Regina,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> 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! :(</FONT></DIV>
<DIV><FONT face=Arial size=2> 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...</FONT></DIV>
<DIV><FONT face=Arial size=2> </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Gus</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=robe.dnd@cityofboston.gov
href="mailto:robe.dnd@cityofboston.gov">Obe, Regina</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">PostGIS Users
Discussion</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, December 18, 2008 5:08
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [postgis-users] pgsql2shp
cuts varchar fields</DIV>
<DIV><BR></DIV>
<DIV dir=ltr align=left><SPAN class=043030316-18122008><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=043030316-18122008><FONT face=Arial
color=#0000ff size=2>Its been a while since I've done any DBase or Foxpro
programming so my memory could be wrong.</FONT></SPAN></DIV>
<DIV><SPAN class=043030316-18122008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=043030316-18122008><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=043030316-18122008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=043030316-18122008><FONT face=Arial color=#0000ff size=2>Hope
that helps,</FONT></SPAN></DIV>
<DIV><SPAN class=043030316-18122008><FONT face=Arial color=#0000ff
size=2>Regina</FONT></SPAN></DIV>
<DIV><SPAN class=043030316-18122008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=043030316-18122008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Gustavo Ces<BR><B>Sent:</B> Thursday, December 18, 2008 10:53
AM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> [postgis-users]
pgsql2shp cuts varchar fields<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial size=2>Hi all,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> 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?</FONT></DIV>
<DIV><FONT face=Arial size=2> Thanks in
advance,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Gus</FONT></DIV>
<P>
<HR SIZE=1>
<P></P>
<P><STRONG>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. </STRONG></P>
<P>
<HR SIZE=1>
<P></P>
<P><STRONG><FONT color=#339900 size=2>Help make the earth a greener place. If
at all possible resist printing this email and join us in saving paper. </P>
<P></FONT></STRONG></P>
<P>
<HR>
<P></P>_______________________________________________<BR>postgis-users
mailing
list<BR>postgis-users@postgis.refractions.net<BR>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR></BLOCKQUOTE></BODY></HTML>