目标:
计算一个点是否在弧上
建表
create table itestg1(id int,
m1 MDSYS.SDO_GEOMETRY,–存放弧线(半圆)circularstring
m2 MDSYS.SDO_GEOMETRY–存放一个点
) ;建立索引
1) 在user_sdo_geom_metadata表插入元数据,没有元数据是没法建立索引的
insert into user_sdo_geom_metadata(table_name,COLUMN_NAME, DIMINFO, SRID)
values(
‘ITESTG1’,
‘m2’,
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT(‘X’,-180,180,0.005),
MDSYS.SDO_DIM_ELEMENT(‘Y’,-90,90,0.005)
),
null
);
insert into user_sdo_geom_metadata(table_name,COLUMN_NAME, DIMINFO, SRID)
values(
‘ITESTG1’,
‘m1’,
MDSYS.SDO_DIM_ARRAY(
MDSYS.SDO_DIM_ELEMENT(‘X’,-180,180,0.005),
MDSYS.SDO_DIM_ELEMENT(‘Y’,-90,90,0.005)
),
null
)
建索引
create index index_m1 on itestg1(m1) indextype is mdsys.spatial_index;
create index index_m2 on itestg1(m2) indextype is