Re: [gdal-dev] DXF to Postgis using ogr2ogr

2011-12-29 Thread Ralf Suhr
xf 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@lists.o

Re: [gdal-dev] DXF to Postgis using ogr2ogr

2011-12-28 Thread Bob Pawley
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@lists.osgeo.org Subject: Re: [gdal-dev] DXF to Postgis using ogr2ogr Bob, you

Re: [gdal-dev] DXF to Postgis using ogr2ogr

2011-12-28 Thread Bob Pawley
correct as neither table has, or has had, a column ogr_style. Bob From: Ralf Suhr Sent: Wednesday, December 28, 2011 1:07 AM To: Bob Pawley Cc: gdal-dev@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

Re: [gdal-dev] DXF to Postgis using ogr2ogr

2011-12-28 Thread Ralf Suhr
ord=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. > > B

Re: [gdal-dev] DXF to Postgis using ogr2ogr

2011-12-27 Thread Bob Pawley
text I get no errors. In all of the commands I`ve run, the block table remains empty. Bob From: Ralf Suhr Sent: Wednesday, December 21, 2011 1:30 AM To: Bob Pawley Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] DXF to Postgis using ogr2ogr On Import you can't use -nln option or

Re: [gdal-dev] DXF to Postgis using ogr2ogr

2011-12-20 Thread Bob Pawley
nt: Monday, December 19, 2011 8:52 AM To: Bob Pawley Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] DXF to Postgis using ogr2ogr http://www.gdal.org/ogr/drv_dxf.html Does ogrinfo print out the "blocks" layer? ogrinfo --config DXF_INLINE_BLOCKS FALSE File.dxf INFO: Open

Re: [gdal-dev] DXF to Postgis using ogr2ogr

2011-12-19 Thread Ralf Suhr
e which has been exploded before saving. > > In all of my searching, I have not come across your suggestion of > dereferencing the block. Can you point me to some documentation? > > Bob > > > From: Ralf Suhr > Sent: Monday, December 19, 2011 12:58 AM > To: gdal-dev@lis

Re: [gdal-dev] DXF to Postgis using ogr2ogr

2011-12-19 Thread Bob Pawley
: Monday, December 19, 2011 12:58 AM To: gdal-dev@lists.osgeo.org Cc: Bob Pawley Subject: Re: [gdal-dev] DXF to Postgis using ogr2ogr Hi Bob, the dxf driver writes to tables "entities" and "blocks". You have to dereference the block layer yourself. SELECT Translate(

Re: [gdal-dev] DXF to Postgis using ogr2ogr

2011-12-19 Thread Ralf Suhr
Hi Bob, the dxf driver writes to tables "entities" and "blocks". You have to dereference the block layer yourself. SELECT Translate( Scale( Rotate((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_geom

[gdal-dev] DXF to Postgis using ogr2ogr

2011-12-16 Thread Bob Pawley
I have imported a dxf file into Postgis using the following command line - set DXF_INLINE_BLOCKS=FALSE&set DXF_MERGE_BLOCK_GEOMETRIES=FALSE&set PGCLIENTENCODING=LATIN1&&ogr2ogr -f "PostgreSQL" PG:"host=localhost user=postgres dbname=dbname password=pass" W_Works.dxf -nln Import_PID -overwrite