fix(data_compression): handle duplicates correctly and throw consistent ValueError in coordinate_compression

fix(data_compression): handle duplicates correctly and throw consistent ValueError in coordinate_compression #18306