L

Monday, November 15th, 2021 8:06 PM

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.

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.

Loading...