Re: [gdal-dev] unable to append data to orale spatial

2010-08-12 Thread Imran Rajjad
Hi, the orignal table is 2 dimensioned, but the features I`m appending hav 3d, though I thought the -lco DIM=2 option would take care of that, well it seems for now I have to convert 3d to 2d in Oracle 11g using the method defined at http://forums.oracle.com/forums/thread.jspa?messageID=960492󪟬 ..

Re: [gdal-dev] unable to append data to orale spatial

2010-08-12 Thread Peter J Halls
Imran, is the initial table two or three dimensioned? Most of the shapefiles I've looked at have been generated by some ESRI product or other ... In my experience, shapefiles are usually x-y-z-m, so three dimensional geometry is a sensible default. It might be worth checking the OGR

Re: [gdal-dev] unable to append data to orale spatial

2010-08-12 Thread Imran Rajjad
hi, I have appended the data but the -lco DIM=2 option does not seem to make any effect, when I`m dumping records into my table, some of them have sdo_gtype set to 3001 which is suppose to be 2001 and also an extra Z cordinate is also appearing but I`m sure I have mentioned the dimension, could th

Re: [gdal-dev] unable to append data to orale spatial

2010-08-10 Thread Imran Rajjad
Hi, yes I figured that out, for now I just drop the index added initialy and I append new data to the table, though I`m not very optimistic about not getting any more trouble when publish this table in geoserver. regards, Imran On Wed, Aug 11, 2010 at 11:25 AM, Peter J Halls wrote: > Imran, > >

Re: [gdal-dev] unable to append data to orale spatial

2010-08-10 Thread Peter J Halls
Imran, in the documentation for the OCI Driver it says clearly that the spatial extent and SDO_GEOM_METADATA entries are not updated when using append mode and that it is up to the caller to manage these. It is actually quite easy to code for this, but does require an SQLExecute to han

[gdal-dev] unable to append data to orale spatial

2010-08-10 Thread Imran Rajjad
Hi list, I inserted a shape file in oracle 11g, now I have another shape file with exactly same attributes, I`m using the -append option but it seems the new shapefile wont get appended to the table, there seems to be some problem related to the spatial index because data in both shape files does