Difference between revisions of "Operace nad prostorovými daty"

From Wikivyuka
Jump to: navigation, search
 
m
 
Line 29: Line 29:
 
    
 
    
 
SELECT * from val_results;
 
SELECT * from val_results;
 +
 +
[http://gis.vsb.cz/wikivyuka/index.php/Prostorov%C3%A9_datab%C3%A1ze Zpět na stránku PDB]

Latest revision as of 12:07, 25 April 2011

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;

Zpět na stránku PDB