Expect latlngs in column_A to match with geohashes in column_B.
expect_column_pair_values_lat_lng_matches_geohash
This expectation level is BETA
Contributors:
Tags:
geospatial
hackathon-22
multi-column expectation
Metrics:
column_pair_values.lat_lng_matches_geohash.unexpected_count
table.row_count
column_pair_values.lat_lng_matches_geohash.filtered_row_count
column_pair_values.lat_lng_matches_geohash.unexpected_values
Description
Expect latlngs in column_A to match with geohashes in column_B.
The more digits a geohash has, the smaller and more precise of an area it represents. When converting a latlng to a geohash, we are only asserting that it falls somewhere within the other geohash we're comparing it with. To verify this, we only need to make sure that they share their left-most digits. For example, dpz8 contains dpz80 (in addition to any other geohash that begins with "dpz8".
Want to make your own Expectation or an improvement to this one?
We've put together some great how to guides (including videos) on how to create your own expectations in a flash!
You can see those resources here: Contributor Resources