Oracle Spatial 9i常用分析语句解析

qiang

--------------------------James ** the follow is error ---------------------------------------------------
--必需要有mask
select ASIA.* from ASIA,MYINDEX where SDO_RELATE(ASIA.GEOLOC,MYINDEX.GEOLOC,'querytype=WINDOW')='TRUE';
--'true'必须大写
select ASIA.* from ASIA,MYINDEX where SDO_RELATE(ASIA.GEOLOC,MYINDEX.GEOLOC,'mask=inside querytype=WINDOW')='true';
--节点坐标对必须逆时针写出
select ASIA.* FROM ASIA WHERE SDO_RELATE(ASIA.GEOLOC,MDSYS.SDO_GEOMETRY(2003, 8307, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1), MDSYS.SDO_ORDINATE_ARRAY(57.5,12.5,57.5,57.1,139.8,57.1,139.8,12.5,57.5,12.5)),'mask=inside querytype=WINDOW')='TRUE';

--不支持矩形
select ASIA.* from ASIA where SDO_FILTER(ASIA.GEOLOC,MDSYS.SDO_GEOMETRY(2003,8307,NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(57.5,12.5,139.8,57.1)),'mask=inside querytype=WINDOW')='TRUE';

--------------------------James ** the follow is ok ------------------------------------------------------
--选择出两个图层相交部分的图元
select ASIA.* from ASIA,MYINDEX where SDO_RELATE(ASIA.GEOLOC,MYINDEX.GEOLOC,'mask=inside querytype=WINDOW')='TRUE';
select ASIA.* from ASIA,MYINDEX where SDO_RELATE(ASIA.GEOLOC,MYINDEX.GEOLOC,'mask=INSIDE querytype=WINDOW')='TRUE';
select ASIA.* from ASIA,MYINDEX where SDO_RELATE(ASIA.GEOLOC,MYINDEX.GEOLOC,'mask=INSIDE querytype=window')='TRUE';
select ASIA.* from ASIA,MYINDEX where SDO_RELATE(ASIA.GEOLOC,MYINDEX.GEOLOC,'mask=ANYINTERACT querytype=WINDOW')='TRUE';

--选择出完全包含在一个多边形中的图元
select ASIA.* FROM ASIA WHERE SDO_RELATE(ASIA.GEOLOC,MDSYS.SDO_GEOMETRY(2003, 8307, MDSYS.SDO_POINT_TYPE(108.522891, 37.74817, NULL), MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1), MDSYS.SDO_ORDINATE_ARRAY(70.3730351, 61.564954, 66.874603, 32.288922, 104.024875, 13.57145, 134.178219, 14.891274, 150.171179, 54.605882, 125.348779, 61.92489, 70.3730351, 61.564954)),'mask=inside querytype=WINDOW')='TRUE';
select ASIA.* FROM ASIA WHERE SDO_RELATE(ASIA.GEOLOC,MDSYS.SDO_GEOMETRY(2003, 8307, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1), MDSYS.SDO_ORDINATE_ARRAY(70.3730351, 61.564954, 66.874603, 32.288922, 104.024875, 13.57145, 134.178219, 14.891274, 150.171179, 54.605882, 125.348779, 61.92489, 70.3730351, 61.564954)),'mask=inside querytype=WINDOW')='TRUE';
--选择出矩形区域内的所有图元
select ASIA.* FROM ASIA WHERE SDO_RELATE(ASIA.GEOLOC,MDSYS.SDO_GEOMETRY(2003, 8307, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1), MDSYS.SDO_ORDINATE_ARRAY(57.5,12.5,139.8,12.5,139.8,57.1,57.5,57.1,57.5,12.5)),'mask=inside querytype=WINDOW')='TRUE';
select ASIA.* FROM ASIA WHERE SDO_RELATE(ASIA.GEOLOC,MDSYS.SDO_GEOMETRY(2003, 8307, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 1), MDSYS.SDO_ORDINATE_ARRAY(139.8,12.5,139.8,57.1,57.5,57.1,57.5,12.5,139.8,12.5)),'mask=inside querytype=WINDOW')='TRUE';

wwxx

进来看看 学习学习