I've placed a ticket on this with a patch http://trac.osgeo.org/postgis/ticket/321
If you would try and patch and see if it creates files that are more broadly usable, that would be nice. Thanks, Paul On Fri, Nov 27, 2009 at 5:28 AM, Peter Hopfgartner <[email protected]> wrote: > Hi, > > we currently have some interoperability problems with pgsql2shp generated > shapes. Basically, if a date field is NULL, pgsql2shp writes all zeros to > the file. This file can not be opened with gvSIG and OpenOffice, whereas it > can be opened with ArcGIS and MS-Excel 2003 (showing the zeros). > > If I overwrite these zeros (from the hex editor) with spaces, all of the > above programs do open and interpret the NULL value correctly. > > I've attached a dump of the database and the generated shape file and the > version with the zeros replaced with spaces. > > I have not found any spec how dBase III should represent NULL data values > and forward this problem to the ML, but the files written in ArcGIS use > spaces, too. > > Another issue: pgsql2shp writes the integer field "ID" aligned to the left, > when written from ArcGIS it is aligned to the right. Indeed, some tools > seem to have problems in interpreting the value written. > > Regards, > > Peter > > -- > > Dott. Peter Hopfgartner > > R3 GIS Srl - GmbH > Via Johann Kravogl-Str. 2 > I-39012 Meran/Merano (BZ) > Email: [email protected] > Tel. : +39 0473 494949 > Fax : +39 0473 069902 > www : http://www.r3-gis.com > > ================================================================================ > Venite a trovarci all'ASITA, dal 1 al 4 dicembre a Bari www.asita.it > Besuchen Sie uns bei der Messe ASITA vom 1. bis 4. Dezember in Bari > www.asita.it > Visit us at ASITA, from 1st to 4th December in Bari www.asita.it > ================================================================================ > > > _______________________________________________ > 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
