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

Imran Rajjad rajjad at gmail.com
Wed Aug 11 02:32:02 EDT 2010


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 <P.Halls at york.ac.uk> wrote:
> 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 handle SDO_GEOM_METADATA.  I simply generate this on the fly, along with
> the SQL to update the spatial index.
>
> Best wishes,
>
> Peter
>
> Imran Rajjad wrote:
>>
>> 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 not come under same spatial extent, is there anyway
>> to tell gdal not to create spatial index when data is being inserted
>> and when all the data has been inserted we create the spatial index
>> manualy?
>>
>> regards,
>> Imran
>>
>>
>>
>
> --
> --------------------------------------------------------------------------------
> Peter J Halls, GIS Advisor, University of York
> Telephone: 01904 433806     Fax: 01904 433740
> Snail mail: IT Services, University of York, Heslington, York YO10 5DD
> This message has the status of a private and personal communication
> --------------------------------------------------------------------------------
>



-- 
I.R


More information about the gdal-dev mailing list