Technical details
   

 
Home      IT Architecture       Software development       Open Source
 
 

 

  Java: Filter collections.
  Oracle spacial: Using geometry as selection criteria

  • SELECT id, geom FROM mytable WHERE SDO_FILTER(geom, MDSYS.SDO_GEOMETRY('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))',31468),'QUERYTYPE=WINDOW')='TRUE' AND sdo_relate(geom, MDSYS.SDO_GEOMETRY('POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))',31468),'MASK=ANYINTERACT QUERYTYPE=WINDOW') ='TRUE';
  Oracle spacial: Read textual representation (wkt) of a geometric field
  • SELECT a.geom.get_wkt() as text FROM mytable a;


 

  
   © 2014 by Angela Wiesheu •  Impressum