SELECT s.SEQSIT as ID, s.GEOMETRY.get_wkt() AS GEOM, c.color as color, c.linestyle as line FROM TRANPOST.SITE s, tranref.trangis_symbology_catalog c WHERE c.seqlif = s.seqlif AND s.GEOMETRY.get_wkt() IS NOT NULL AND SDO_RELATE(s.GEOMETRY, SDO_GEOMETRY (2003, 327680, NULL, SDO_ELEM_INFO_ARRAY(1,1003,3), SDO_ORDINATE_ARRAY(:LatSW,:LongSW,:LatNE,:LongNE)), 'mask=anyinteract') = 'TRUE'