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
--------------------------------------------------------------------------------
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
