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: [email protected] > 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: [email protected] > > > > 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
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
