[gdal-dev] Issues when exporting from PostGIS to shape

Peter Hopfgartner peter.hopfgartner at r3-gis.com
Wed Mar 10 07:40:14 EST 2010

This email contained a .zip file attachment. Raytheon does not allow email attachments that are considered likely to contain malicious code. For your protection this attachment has been removed.

If this email is from an unknown source, please simply delete this email.

If this email was expected, and it is from a known sender, you may follow the below suggested instructions to obtain these types of attachments.

+ Instruct the sender to enclose the file(s) in a ".zip" compressed file, and rename the ".zip" compressed file with a different extension, such as, ".rtnzip".  Password protecting the renamed ".zip" compressed file adds an additional layer of protection. When you receive the file, please rename it with the extension ".zip".

Additional instructions and options on how to receive these attachments can be found at:


Should you have any questions or difficulty with these instructions, please contact the Help Desk at 877.844.4712


Dear GDAL devs

Since I'm new to OGR, the following issues may be caused by my complete 
ignorance. Anyway, the story goes like this:

I have a PostGIS tabel, like this:
CREATE TABLE impexp_shp.points (
id serial,
name varchar(80),

which contains the following:

INSERT INTO impexp_shp.points (name, the_geom)
('così è, Straße, öäü ÖÄÜ è é ò ó ù ú ì í €', ST_GeomFromText('POINT(1 

I try to export this as a shape file:

ogr2ogr -f 'ESRI Shapefile' '/tmp/ut_table_with_geom/points' 
PG:'host=postgis user=unittest dbname=unittest password=unittestx' 

And get the attached shape file.

I have the following issues with the result:

i) The .dbf in this shape file does not contain the column "id".

ii) the resulting shape file has a language identifier set to 57 (ANSI), 
but it really is UTF-8 [1][2].

GDAL is version 1.6.3. PostGIS is version 1.4.1. platform is CentOS 5, 
64 bit.



[2] http://www.dbase.com/knowledgebase/int/db7_file_fmt.htm

Dott. Peter Hopfgartner
R3 GIS Srl - GmbH
Via Johann Kravogl-Str. 2
I-39012 Meran/Merano (BZ)
Email: peter.hopfgartner at r3-gis.com
Tel. : +39 0473 494949
Fax  : +39 0473 069902
www  : http://www.r3-gis.com

XING : http://www.xing.com/go/invita/8917535

More information about the gdal-dev mailing list