空间数据库实习三个实验

SDO_ORDINATE_ARRAY(5,1, 8,1, 8,6, 5,7, 5,1) ) );

INSERT INTO liufei VALUES( 3, 'cola_c', SDO_GEOMETRY(

2003, --two-dimensional polygon NULL, NULL,

SDO_ELEM_INFO_ARRAY(1,1003,1), --one polygon ring)

SDO_ORDINATE_ARRAY(3,3, 6,3, 6,5, 4,5, 3,3) ) );

INSERT INTO liufei VALUES( 4, 'cola_d', SDO_GEOMETRY(

2003, --two-dimensional polygon NULL, NULL,

SDO_ELEM_INFO_ARRAY(1,1003,4), --one circle SDO_ORDINATE_ARRAY(8,7, 10,9, 8,11) ) );

polygon (exterior

3．通过USER_SDO_GEOM_METADATA视图将COLA_MARKETS的空间属性列加入到空间元数据表中；

INSERT INTO USER_SDO_GEOM_METADATA VALUES ( 'liufei', 'shape',

SDO_DIM_ARRAY( --20X20 grid

SDO_DIM_ELEMENT('X', 0, 20, 0.005), SDO_DIM_ELEMENT('Y', 0, 20, 0.005) ),

NULL --SRID );

4.创建COLA_MARKETS表的空间索引COLA_SPATIAL_IDX； CREATE INDEX liufei_spatial_idx ON liufei (shape)

INDEXTYPE IS MDSYS.SPATIAL_INDEX;

5.完成下列查询：

（1）查询cola_a和cola_c相交的部分；

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

WHERE c_a.name= 'cola_a' AND c_c.name= 'cola_c';