Sunday, March 22, 2020

OpenTable app for iOS: Bad Data in the Gulf of Guinea!

iOS 13.3.1
OpenTable app for iOS (version 13.12.2)
Date: 03/22/20

Description:

Have ever been curious to know a quick way to find "bad data" in an app? Meaning, data that may have a listed address, but one that isn't recognized as valid? Have you every wanted to see if the particular map-integrated app you're using has entities which aren't geo-locating to the correct place?

Here's an easy way to do it!

The OpenTable app has a problem which is common on numerous other apps. Here's a summation of the problem: if a restaurant address is listed that is not recognized as a "valid" it is deposited at a latitude/longitude of "0.0.0.0."

This "0.0.0.0" is off the coast of Africa and is known as a mythical "Null Island" for database purposes. 


Some of the various locations you can quickly find - many of them are in Australia...
The Mexican Port Douglas
Lime Leaf Thai Restaurant 
Choo Choos Marina Port Douglas

Steps to Reproduce:

1. Download and launch the OpenTable app for iOS (version 13.12.2)
2. Sign into an account
3. Click on "Search" - search in any location
4. Click on the Map
5. Search in the Gulf of Guinea area off of West Africa
OR:
6. Run a search for restaurants in the Gulf of Guinea

Result: Searching the 0.0.0.0 area in many apps will show you locations that lack a correct address

Expected: Not sure - just a fun way to find bad data across multiple apps!



No comments:

Post a Comment