gvSIG opens the generated shape file without any complaint and Excel
behaves as expected.
Thanks!
Peter
(tested with PostGIS 1.4/PostgreSQL 8.2/CentOS 5.4)
Paul Ramsey wrote:
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
--
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
