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

[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 TRAC buglist ... I've a vague 
recollection that at some version or other there may have been an issue 
regarding appending a non-default coordinate dimension, but do not recall 
whether that was ogr2ogr - which I use rarely - or an issue when programming 
with the OGR API.

Best wishes,

Peter

Imran Rajjad wrote:
> 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 there be a problem with the syntax here?
> 
> 
> ogr2ogr -f OCI OCI:usr/pas at ip:port/db file.shp -append -skipfailure
> -lco SRID=8307 -lco DIM=2 -lco GEOMETRY_NAME=GEOM -nln ASIA_POI
> 
> 
> 
> 
> regards,
> Imran
> 
> On Wed, Aug 11, 2010 at 11:50 AM, Peter J Halls <P.Halls at york.ac.uk> wrote:
>> Imran,
>>
>> Imran Rajjad wrote:
>>> 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
>> That is sensible: drop spatial index, update table, update SDO_GEOM_METADATA
>> and recreate spatial index.  There was a related bug in ArcGIS a version or
>> two back where the workaround published by ESRI was to do this same
>> sequence!
>>
>> Best wishes,
>>
>> Peter
>>
>>> 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
>>>>
>>>> --------------------------------------------------------------------------------
>>>>
>>>
>>>
>> --
>> --------------------------------------------------------------------------------
>> 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
>> --------------------------------------------------------------------------------
>>
> 
> 
> 

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