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
