<a href="http://mixed.dans.knaw.nl/files/TI838D.txt">http://mixed.dans.knaw.nl/files/TI838D.txt</a><br><br><br><br><div class="gmail_quote">2009/12/1 Gerald Creager <span dir="ltr"><<a href="mailto:gerry.creager@tamu.edu">gerry.creager@tamu.edu</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">My experience in the past (including some .dbf imports by several systems, including legaccy dBase IV, was that in fact, these are dB-IV .dbf's. The difference is small, as noted below, between v. III and v. IV.<br>
<br>
gerry<br>
<br>
Peter Hopfgartner wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5">
Chris Hermansen wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Peter;<br>
<br>
The canonical description of DBase files seems to be<br>
<br>
<a href="http://www.clicketyclick.dk/databases/xbase/format/" target="_blank">http://www.clicketyclick.dk/databases/xbase/format/</a><br>
<br>
<br>
</blockquote>
Well, first of all, I do not know which dBase version is targeted by ArcGIS.<br>
<br>
Second, I doubt the exact values in <a href="http://www.clicketyclick.dk/databases/xbase/format/data_types.html#DATA_TYPES" target="_blank">http://www.clicketyclick.dk/databases/xbase/format/data_types.html#DATA_TYPES</a>. <br>
<br>
From our tests, both dbase III and dBase IV can handle text fields <= 254 characters (and not < 254).<br>
Further, dBase III can handle numerics with <= 19 digits and not < 18 digits. dBase IV limits this to <= 20 digits.<br>
<br>
The above mentioned tool identifies ArcGIS generated files as dBase IV, in clear conflict on what is said in the above mentioned Wikipedia article.<br>
<br>
Cheers,<br>
<br>
Peter<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Tue, 2009-12-01 at 17:28 +0100, Peter Hopfgartner wrote:<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Mark Cave-Ayland wrote:<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Peter Hopfgartner wrote:<br>
<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Dear PostGIS devels,<br>
<br>
since we right in the middle of comparing interoperability of shape files between some FOSS programs and ArcGIS, we encoutered also the following:<br>
<br>
gvSIG chokes on the Bigint as produced by pgsql2shp. Looking at ArcGIs generated files, the max length for numbers is 19, compared to 20 for integers and 32 for floating points as in pgsql2shp. This seems to be confirmed by some Borland tools, when configured for dBase III+.<br>
<br>
Another limit seems to be that of text fields, that must be no longer then 254. This is the maximum as given by ArcGIS and by the Borland tool.<br>
<br>
Another point is Boolean: ArcGIS seems to not allow the creation of boolean fields and the Borland Tool ("Database Desktop") says that Booleans have a length of 1.<br>
<br>
Regards,<br>
<br>
Peter<br>
<br>
</blockquote>
Hi Peter,<br>
<br>
You've brought up some interesting points here. Can you actually clarify these changes with regard to parts of the official shapefile spec, or have they been found purely through experimentation?<br>
<br>
<br>
ATB,<br>
<br>
Mark.<br>
<br>
<br>
</blockquote>
Hi Mark,<br>
<br>
I do still have to figure out, if there are public specs for this. All I've found is, that attributes should be in data base files which are in dBase format (<a href="http://www.esri.com/library/whitepapers/pdfs/shapefile.pdf" target="_blank">http://www.esri.com/library/whitepapers/pdfs/shapefile.pdf</a>). From the analysis of the file (and Wikipedia: <a href="http://en.wikipedia.org/wiki/Shapefile" target="_blank">http://en.wikipedia.org/wiki/Shapefile</a>), it seems that this should be dBase III. I do not have any evidence that there is a public spec for dBase III.<br>
So all we did is basically gather some experimental data, where ArcGIS and gvSIG are our references. The first, because ESRI introduced the shape file format and gvSIG, because it is the desktop environment that we encourage our customers to use. Anyway, we have an old Borland/Inprise tool ("Database Desktop") here for managing dBase files and used it for our tests.<br>
<br>
Peter<br>
<br>
<br>
</blockquote>
<br>
<br>
<br>
</blockquote>
<br>
<br>
<br></div></div>
------------------------------------------------------------------------<br>
<br>
<br>
------------------------------------------------------------------------<br>
<br>
<br>
------------------------------------------------------------------------<div class="im"><br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</div></blockquote><div><div></div><div class="h5">
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br>