Hi Ralf,
Am 26.01.2012 17:20, schrieb Ralf Suhr:
Hi Verena,
can you provide more information. What software version did you use
(gdal, postgis).
PostgreSQL 9.0.4
PostGIS 1.5
GDAL 1.9dev
What kind of geometries is in the database.
psql -d mydb -c "SELECT DISTINCT GeometryType( geom_column ) FROM my_data"
POLYGON
What happend if you select only one geometrytype from database.
ogr2ogr -f "DXF" -sql "SELECT * FROM my_data WHERE GeometryType(
geom_column ) = 'POLYGON'" my_data.dxf PG:'host=localhost password=xxx
user=xxx dbname=MYDB'
Every dxf file I create only contains one single geometrytype.
Best regards,
Verena
Gr
Ralf
On Donnerstag 26 Januar 2012 16:56:48 Verena Diewald wrote:
> Hi Darren,
>
>
> I tried that option, but the error still remains.
> Does anyone have another idea?
>
>
> Greetings,
>
> Verena
>
> Am 26.01.2012 16:00, schrieb Carman, Darren:
> > Try adding -nlt POLYGON (also has POINT and LINESTRING options).
> >
> > We have this option on an older version that used the ODA libraries
> > directly, so can't guarantee it's still the same.
> >
> > Darren
> >
> > *From:*gdal-dev-boun...@lists.osgeo.org
> > [mailto:gdal-dev-boun...@lists.osgeo.org] *On Behalf Of *Verena
Diewald
> > *Sent:* 26 January 2012 14:03
> > *To:* gdal-dev@lists.osgeo.org
> > *Subject:* [gdal-dev] Creating DXF with ogr2ogr
> >
> > Hi all,
> >
> > I'm trying to create DXF files from a PostgreSQL database using
ogr2ogr:
> > |ogr2ogr -nln my_data -a_srs EPSG:25832 -s_srs EPSG:25832 -t_srs
> > |EPSG:25832 -f "DXF" my_data.dxf PG:'host=localhost password=xxx
> > |user=xxx dbname=MYDB' -sql "SELECT * FROM my_data"|
> >
> > It works fine with point data, but I get an invalid dxf file for
> > polygon data. Opening the polygon dxf file results in the following
> > error:
> >
> > The following error was encountered while reading
> > in HATCH starting at line 1546:
> > Error: expected group code 10
> > Invalid or incomplete DXF input -- drawing discarded.
> >
> >
> >
> > Do I have to pass any more options to ogr2ogr when creating a polygon
> > dxf? What did I do wrong?
> > Does anyone have an idea about that?
> >
> > Greetings,
> >
> > Verena
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Infoterra Ltd. Is part of the Astrium GEO-Information Services
> > Division and a wholly owned subsidiary of Astrium, Europe's leading
> > space systems and services specialist.
> >
> > Disclaimer. The information contained in this e-mail and its
> > attachments are confidential and intended only for the use of the
> > named addressee(s). If you are not the intended addressee, please do
> > not read, copy, use or disclose this message or its attachments. If
> > you have received this message in error, please notify the sender
> > immediately and delete or destroy all copies of this message and
> > attachments in all media. Any views or opinions expressed are solely
> > those of the author and do not necessarily represent those of
> > Infoterra Ltd and shall not form part of any binding agreement.
> >
> > Infoterra Limited a company registered in England under number 2359955
> > and having its registered office at Atlas House, 41 Wembley Road,
> > Leicester, LE3 1UT. VAT number GB 476 0468 27.
> >
> > P Before printing, think about the environment
--
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
