topic Get City for Latitude/Longitude in QlikView https://community.qlik.com/t5/QlikView/Get-City-for-Latitude-Longitude/m-p/1358843#M828128 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a table (loaded from an XLS) with the following fields: CarNumber, Latitude and Longitude.</P><P></P><P>Is there any way to get the City/Country for every Latitude and Longitude?</P><P></P><P>I'd need to do this automatically because I have like 10.000 points.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT microwin88x 2020-11-25T16:16:04Z Get City for Latitude/Longitude https://community.qlik.com/t5/QlikView/Get-City-for-Latitude-Longitude/m-p/1358843#M828128 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a table (loaded from an XLS) with the following fields: CarNumber, Latitude and Longitude.</P><P></P><P>Is there any way to get the City/Country for every Latitude and Longitude?</P><P></P><P>I'd need to do this automatically because I have like 10.000 points.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Get-City-for-Latitude-Longitude/m-p/1358843#M828128 microwin88x 2020-11-25T16:16:04Z Re: Get City for Latitude/Longitude https://community.qlik.com/t5/QlikView/Get-City-for-Latitude-Longitude/m-p/1358844#M828129 <HTML><HEAD></HEAD><BODY><P>if you have city names then you can get the lat/long for the same</P><P></P><P><A href="https://community.qlik.com/docs/DOC-9561">Google maps</A></P></BODY></HTML> Mon, 26 Jun 2017 13:01:28 GMT https://community.qlik.com/t5/QlikView/Get-City-for-Latitude-Longitude/m-p/1358844#M828129 Kushal_Chawda 2017-06-26T13:01:28Z Re: Get City for Latitude/Longitude https://community.qlik.com/t5/QlikView/Get-City-for-Latitude-Longitude/m-p/1358845#M828130 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Yes but the thing is that I don't have the City Names, only the Lat/Long...</P></BODY></HTML> Mon, 26 Jun 2017 13:04:38 GMT https://community.qlik.com/t5/QlikView/Get-City-for-Latitude-Longitude/m-p/1358845#M828130 microwin88x 2017-06-26T13:04:38Z Re: Get City for Latitude/Longitude https://community.qlik.com/t5/QlikView/Get-City-for-Latitude-Longitude/m-p/1358846#M828131 <HTML><HEAD></HEAD><BODY><P>You could try the GeoDesix plugin for Excel - <A href="http://www.calvert.ch/geodesix/" title="http://www.calvert.ch/geodesix/">GeodesiX</A></P><P></P><P>This allows you to construct Excel formulae to retrieve geo data from Google Maps. There's a limit of (I believe) 2500 requests per day though, and you may have issues with the latest version of Excel (unless he's fixed it recently).</P></BODY></HTML> Mon, 26 Jun 2017 14:33:20 GMT https://community.qlik.com/t5/QlikView/Get-City-for-Latitude-Longitude/m-p/1358846#M828131 marcus_malinow 2017-06-26T14:33:20Z