select Image By
abstract suspend fun selectImageBy(latitude: Double, longitude: Double): ImageWithAdministrativeUnitNameAndGeoLocation?
Retrieves an Image object with its associated GeoLocation and AdministrativeUnitName, or null if no matching image is found.
This method uses a transaction and a custom SQL query to perform a JOIN between Image and GeoLocation tables. It searches for images where the GeoLocation.latitude and GeoLocation.longitude match the provided parameters.
Return
an Image object with its GeoLocation and AdministrativeUnitName data (can be null if no match is found).
Parameters
latitude
the latitude value to search for.
longitude
the longitude value to search for.