bburgemeestre

Registering a polygon table to point in a m. view using SDO_CENTROID/sdelayer error

Discussion created by bburgemeestre on Oct 28, 2013
Latest reply on Nov 5, 2013 by vangelo-esristaff
Hello,

I try to make a point materialized (point) view from a polygon table. First I make a selection on the geometry to make it a point I use  SDO_GEOM.SDO_CENTROID on the geometry so I get an extra geometry column 'GEOMETRIE2' which has the centroid of a polygon.
[ATTACH=CONFIG]28676[/ATTACH]

After the selection I do an insert on USER_SDO_GEOM_METADATA:

insert into USER_SDO_GEOM_METADATA (
    TABLE_NAME,
    COLUMN_NAME,
    DIMINFO,
    SRID)
values (
    'TABLETEST',
    'GEOMETRIE2',
    MSDYS.SDO_DIM_ARRAY (
        MDSYS.SDO_DIM_ELEMENT('X',  70000, 180000, 0.01),
        MDSYS.SDO_DIM_ELEMENT('Y', 480000, 580000, 0.01)),
    '');

I then register the table by sdelayer:

sdelayer �??o register �??l TABLETEST,GEOMETRIE2 �??e p -t SDO_GEOMETRY �??C SEQ_ID,USER �??k SDO_GEOMETRY �??P HIGH �??x 0,0,5000,0.02 �??G 28992

However this will result in the following error:

Error: Abstract Data Types not supported (-320).
Error: Cannot Create Layer.

Any ideas?

Attachments

Outcomes