Hello
Using this line gives me 0 results.
Code:
SELECT g.`country` FROM geoname g WHERE g.`latitude` LIKE 29.313757 AND g.`longitude` LIKE 48.016216
Edit: I might have had the syntax wrong. Tried this but no better:
Code:
SELECT g.`country` FROM geoname g WHERE g.`latitude` = 29.313757 AND g.`longitude` = 48.016216
Using the same coordinates as input in Google Maps gives me that this is Kuwait.
I'm using MySQL and GeoNames have worked like a charm for other queries. The same happens with other coordinates. Am I doing something wrong as I was able to get out country BZ from another pair of coordinates?
Small description: I've imported GeoNames as per guide in another post on how to do that. I've successfully queried geonames for lat/long using location names (both from MySQL query browser as well as my Java app). Now given these lat/long I also want to look up what country those lat/long belong to since not all of my lat/long data was queried from GN but available from the beginning in my source data.