Lumira Cloud Geodata

[Former Member]

Hi,

I want to import from an xlsx file the geodata for some cities, so I geocoded the longitude and latitude for each city in each row.

Now I got 1 column for latitude and 1 column for longitude in the format ##.#####.

For example:

City	Latitude	Longitude
Oslo	59.91387	10.75225

When I try to create a dataset Lumira imports the latitude and longitude column as numbers and not as geodata.

I already tried to fill the latitude and longitude columns with strings in the format AA.AAAAA and AA.AAAAA°N but it still wont import as geodata, so I can't use the Geo Bubble, Geo Choropleth or Geo Pie Chart.

Please tell me what I have to do and which is the right format,

thank you in advance.

[Former Member · Accepted solution]

Hi,

The format i used is,

City	Longitude	Latitude
Slater Field	-75.75379944	38.75709915
The Farm Airport	-82.77110291	32.67440033

These are dimensions and created a hierarchy based on lat and lon and used as dimension

[Former Member · Accepted solution]

Hi Iris,

Weather this format worked for you.

[Former Member · Accepted solution]

Actually it didn't work in Lumira Cloud, but when I used this format in Lumira Desktop and created a hierarchy as you described, then imported it in Lumira Cloud again, it eventually accepted it as geodata.

Thank you for your support, Pradeep!