[gdal-dev] DXF to Postgis using ogr2ogr

[Ralf Suhr]

Hi Bob,

the dxf support in ogr is not complete. I have also some dxf files with blocks 
that can not imported by ogr.

Have you checked http://trac.osgeo.org/gdal/ticket/4369 (block reference to 
another block).

On Mittwoch 28 Dezember 2011 23:18:56 Bob Pawley wrote:
> Hi Ralf
> 
> I managed to include ogr_styles by using the –sql option.
> 
> However the blocks table is still empty. There fore when I run the
> Postgresql script the result comes up empty.
> 
> Would it be possible for you to send me a dxf file that has worked for you,
> just in case the dxf I am using is structured differently. (I’m using
> engineering not geographic information.)
> 
> In email I have about a 3 meg limit.
> 
> Thanks.
> 
> Bob
> 
> From: Ralf Suhr
> Sent: Wednesday, December 28, 2011 1:07 AM
> To: Bob Pawley
> Cc: gdal-dev at lists.osgeo.org
> Subject: Re: [gdal-dev] DXF to Postgis using ogr2ogr
> 
> Bob, you need a gdal version 1.8 or higher.
> 
> On Dienstag 27 Dezember 2011 19:48:33 Bob Pawley wrote:
> > Something is still not penetrating this thick skull of mine.
> > 
> > 
> > 
> > When I run
> > 
> > 
> > 
> > ogr2ogr --config DXF_INLINE_BLOCKS FALSE --config
> > 
> > DXF_MERGE_BLOCK_GEOMETRIES FALSE -f "PostgreSQL" PG:"host=localhost
> > 
> > user=postgres dbname=db password=pass" W_Works.dxf -overwrite
> > 
> > -skipfailures -sql "SELECT
> > 
> > ST_Translate(ST_Scale(ST_Rotate((ST_Dump(b.wkb_geometry)).geom,
> > 
> > e.blockangle / 180 * PI()), e.blockscale[1], e.blockscale[2]),
> > 
> > ST_X(e.wkb_geometry), ST_Y(e.wkb_geometry)) AS wkb_geometry, CASE WHEN
> > 
> > b.ogr_style IS NOT NULL THEN b.ogr_style ELSE e.ogr_style END AS
> > 
> > ogr_style, e.layer, e.linetype, e.subclasses, b.text FROM entities e
> > INNER
> > 
> > JOIN blocks b USING (blockname)"
> > 
> > 
> > 
> > I get error - Undefined function `st_dump`used.
> 
> You can not use PostGIS functions on dxf file source.
> 
> > When I run a simplified version
> > 
> > 
> > 
> > ogr2ogr --config DXF_INLINE_BLOCKS FALSE --config
> > 
> > DXF_MERGE_BLOCK_GEOMETRIES FALSE -f "PostgreSQL" PG:"host=localhost
> > 
> > user=postgres dbname=db password=pass" W_Works.dxf -overwrite
> > 
> > -skipfailures -sql "SELECT wkb_geometry From entities"
> > 
> > 
> > 
> > I get error - unrecognized field name wkb_geometry
> > 
> > 
> > 
> > In the last, when I substitute wkb_geometry for the blocks (name, angle,
> > 
> > scale) or text I get no errors.
> > 
> > 
> > 
> > In all of the commands I`ve run, the block table remains empty.
> 
> The dxf file contains two different ogr layers.
> 
> 
> 
> ogr2ogr --config DXF_INLINE_BLOCKS FALSE --config
> DXF_MERGE_BLOCK_GEOMETRIES FALSE -f "PostgreSQL" PG:"host=localhost
> user=postgres dbname=db password=pass" W_Works.dxf entities
> 
> 
> 
> ogr2ogr --config DXF_INLINE_BLOCKS FALSE --config
> DXF_MERGE_BLOCK_GEOMETRIES FALSE -f "PostgreSQL" PG:"host=localhost
> user=postgres dbname=db password=pass" W_Works.dxf blocks
> 
> 
> 
> And finaly run the sqls inside the postgis database.
> 
> > Bob
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > From: Ralf Suhr
> > 
> > Sent: Wednesday, December 21, 2011 1:30 AM
> > 
> > To: Bob Pawley
> > 
> > Cc: gdal-dev at lists.osgeo.org
> > 
> > Subject: Re: [gdal-dev] DXF to Postgis using ogr2ogr
> > 
> > 
> > 
> > On Import you can't use -nln option or you run ogr2ogr to times. One for
> > 
> > entities layer and secound for blocks.
> > 
> > 
> > 
> > 
> > 
> > ogr2ogr -f postgresql -nln myentities PG:"..." W_Works.dxf entities
> > 
> > 
> > 
> > ogr2ogr -f postgresql -nln myblocks PG:"..." W_Works.dxf blocks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20111229/e3160c0c/attachment-0001.html