101 Messages
REVIEWED-PENDING DOCUMENTATION: Collibra DQ Check for Longitude/Latitude
Question from a prospect was, can Collibra DQ automatically check the longitude and latitude values?
Answer: We have two Collibra DQ out of the box semantic rules:
LAT:
^(\\+|-)?(?:90(?:(?:\\.0{1,6})?)|(?:[0-9]|[1-8][0-9])(?:(?:\\.[0-9]{1,6})?))$
LNG:
^(\\+|-)?(?:180(?:(?:\\.0{1,6})?)|(?:[0-9]|[1-9][0-9]|1[0-7][0-9])(?:(?:\\.[0-9]{1,6})?))$
These are not editable, but they are RegEx checks to ensure a valid Latitude and Longitude exist. Beyond that we would need to help you write a custom rule.
kirkhaslbeck
41 Messages
3 years ago
Yes those examples above do check for valid LNGs and LATs. You can copy them and create your own version of LAT/LNG if you prefer different logic.
0