Operace nad prostorovými daty

Operace nad prostorovými daty:

SELECT SDO_GEOM.SDO_INTERSECTION(c_a.shape, c_c.shape, 0.005)

  FROM cola_markets c_a, cola_markets c_c 
  WHERE c_a.name = 'cola_a' AND c_c.name = 'cola_b';

SELECT SDO_GEOM.RELATE(c_b.shape, 'anyinteract', c_d.shape, 0.005)

 FROM cola_markets c_b, cola_markets c_d
 WHERE c_b.name = 'cola_a' AND c_d.name = 'cola_c';

SELECT name, SDO_GEOM.SDO_AREA(shape, 0.005) FROM cola_markets;

SELECT c.name, SDO_GEOM.SDO_AREA(c.shape, 0.005) FROM cola_markets c

  WHERE c.name = 'cola_a';

SELECT SDO_GEOM.SDO_DISTANCE(c_b.shape, c_d.shape, 0.005)

  FROM cola_markets c_b, cola_markets c_d
  WHERE c_b.name = 'cola_b' AND c_d.name = 'cola_c';

SELECT c.name, SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(c.shape, 0.005)

  FROM cola_markets c WHERE c.name = 'cola_c';

Nová tabulka pro uchování výsledků:

CREATE TABLE val_results (sdo_rowid ROWID, result VARCHAR2(2000));

CALL SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT('COLA_MARKETS', 'SHAPE',

 'VAL_RESULTS', 2);

SELECT * from val_results;

Navigation menu