You are here

Oracle spatial SQL remark 1

select z.geom, z.pk, z.igds_level_name as tooltip from dsrlkw_data_ds.dsr_gl_dsrline_tb z
where mdsys.sdo_filter(GEOM,
mdsys.sdo_geometry(2003,25832,NULL,
mdsys.sdo_elem_info_array(1,1003,3),
mdsys.sdo_ordinate_array( 361531.1017459362,5717128.381953186,363000.313064419 ,5717800.65743528)),'querytype=window' ) = 'TRUE'

INSERT INTO user_sdo_geom_metadata
(TABLE_NAME,
COLUMN_NAME,
DIMINFO,
SRID)
VALUES (
'dsr_gl_dsrline_tb',
'geom',
SDO_DIM_ARRAY(
SDO_DIM_ELEMENT('X', 200000, 500000,0.05),
SDO_DIM_ELEMENT('Y', 5200000, 5900000,0.05)
),
25832
);

drop index DSRLKW_DATA_DS.DSR_GL_DSRLINE_TB_SX;

CREATE INDEX DSRLKW_DATA_DS.DSR_GL_DSRLINE_TB_SX ON DSRLKW_DATA_DS.DSR_GL_DSRLINE_TB
(GEOM)
INDEXTYPE IS MDSYS.SPATIAL_INDEX;

select * from all_indexes where domidx_opstatus<>'VALID'

Blog: