Re: [gdal-dev] ogr2ogr

2012-02-14 Thread Bob Pawley
-dev] ogr2ogr I'm not certain what you are trying to do, but... Consider the SQL "UNION", "UNION ALL", "INTERSECT", or "INTERSECT ALL" statements perhaps? They allow you to combine the results of two queries into a single result set (as a single que

[gdal-dev] ogr2ogr

2012-02-14 Thread Bob Pawley
Is there a method of having two –sql commands in one command prompt execution. I have attempted 1. –sql “first statement ” –sql “second“ 2. –sql “first; second“ 3. sql “first “ “second“ 4. –sql “first” –overwrite –skipfailures -sql “second” (an attempt to separate the two). Bob_

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-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 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(

[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

[gdal-dev] ogr2ogr unable to open

2011-06-06 Thread Bob Pawley
Hi I hope this is the right list. I am attempting to use the FWTools to convert a .dxf file to a PostgreSQL database. I am using the following format - ogr2ogr -f "PostgreSQL" PG: "host=Remote Host user=postgres dbname=E5R password=Password p081.dxf I receive an error message - unable to o