[gdal-dev] ogr2ogr

[Chaitanya kumar CH]

Bob,
Since it is a layer *creation* option, it is only set when creating a
layer. Otherwise, they could interfere with existing data's validity. In
this case, there may be features with dim=3.

If you want to set the dimension of the created layer, there should be a
more elegant way than this. If you know the SQL command to set the
dimension, use "ogrinfo -sql <command> datasource".

On Wed, Feb 15, 2012 at 12:26 AM, Bob Pawley <rjpawley at shaw.ca> wrote:

>   I am trying to add columns to a table (which I am able to do), then add
> a trigger to that table in order to trigger an existing function.
>
> My basic problem is that the ogr2ogr switch (ie: –lco Dim=2) appear to
> only work with an -overwrite. They don’t seem to work with an -append.
>
> As -overwrite drops the existing table, as well as its trigger, I need to
> replace the trigger after the table is restored.
>
> Does this make sense?
>
> Perhaps there is another way of doing this?
>
> Bob
>
>
>
>  *From:* Chander Ganesan <chander at otg-nc.com>
> *Sent:* Tuesday, February 14, 2012 10:27 AM
> *To:* gdal-dev at lists.osgeo.org
> *Subject:* Re: [gdal-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 query.)
>
> Chander
>
> On 2/14/12 1:24 PM, Bob Pawley wrote:
>
>  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
>
>
> _______________________________________________
> gdal-dev mailing listgdal-dev at lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/gdal-dev
>
>
>
>  ------------------------------
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>



-- 
Best regards,
Chaitanya kumar CH.

+91-9494447584
17.2416N 80.1426E
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20120215/806dc791/attachment.html