Geospatial Administrator & Oracle XE

Hello

I have geographic data, that are stored in Oracle XE 11g (SRID 25832).

There is no problem to query and delete features. But, when I try to create or update an feature, I get this error "Error Inserting Feature (class: TEST_BUILDING, id: 28)

Invalid geometry for table TEST.BUILDING, column SDO_GEOMETRY.54668

ORA-54668: a 2D SRID cannot be used with a 3D geometry

Irreparably invalid geometry."

The problem is that SRID’s do not match.

Is there an easy way around this problem?

Parents
  • You could probably test to update the spatial metadata and assign NULL to the SRID, I expect you to be able to post then as the error clearly suggests the issue is in the SRID. This SRID does not seem suitable for 3D data, your spatial index was also created with 3 coordinate dimensions?

    Regards
    Carlos



    Answer Verified By: Sebastien.Lefrancois 

Reply
  • You could probably test to update the spatial metadata and assign NULL to the SRID, I expect you to be able to post then as the error clearly suggests the issue is in the SRID. This SRID does not seem suitable for 3D data, your spatial index was also created with 3 coordinate dimensions?

    Regards
    Carlos



    Answer Verified By: Sebastien.Lefrancois 

Children