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