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󪟬 .. it has worked for me , but all this is too much time on the consoles.
thanks a lot regards, Imran On Thu, Aug 12, 2010 at 12:37 PM, Peter J Halls <[email protected]> wrote: > 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/p...@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 <[email protected]> >> 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 <[email protected]> >>>> 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 > -------------------------------------------------------------------------------- > -- I.R _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
