Re: Is there a quick way to get co-ordinates (X an... - Qlik Community

jblomqvist · ‎2016-04-04

Hi all,

Is there a quick way to get co-ordinates (X and Y) of cities if you just have city names?

E.g. I have a table with a list of city names. And I would like to get the X and Y co-ordinates of those cities without having to manually look for it and populate it in some spreadsheet.

Anonymous · ‎2016-04-04

Hi John,

Yes this is possible, but you need to have geolocation service providing you with a data file that will contain the needed elements such:

City, Country, Longitude, Latitude, .....

Check on qlikmarket, google, openstreetmap, maxmind, geonames....

Best

Maurice

HirisH_V7 · ‎2016-04-04

check this,

Short Review of Geographic Mapping Options in QlikView

-Hirish

HirisH
“Aspire to Inspire before we Expire!”

simondachstr · ‎2016-04-04

X, Y? Map locations are expressed in polar rather than Cartesian coordinates

Kushal_Chawda · ‎2016-04-04

see this

Table:
LOAD
City
FROM Table;

let noRows = NoOfRows('Table')-1;

for i=0 to $(noRows)

let b = peek('City',$(i),'Table');

GeocodeResponse:
LOAD
status,
'$(b)' as CustomerCity,
([result/geometry/location/lat]) as latitude,
([result/geometry/location/lng]) as longitude
FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=$(b)&sensor=false] (XmlSimple, Table is [GeocodeResponse]);
next i;