Importing areas and their Lat / Long

Modified on Mon, 02 Jan 2017 at 02:45 PM

How to import cities and counties and their geo coordinates in ElegantJ BI

I only have one question regarding use of GeoMaps. I would like to import all cities in Finland including geo coordinates into EJBI, so that I can place those to into Finnish map for data visualization. Here is example of data I’m planning to import:

 

City
County
Latitude
Longitude
Akaa
FI-08
61.169000
23.858000
Alahärmä
FI-10
63.233000
22.850000
Alajärvi
FI-08
63.000000
23.817000
Alastaro
FI-03
60.957000
22.860000

 

The manual says, that column 2 should be the ISO-code. Can you please let me know if this one above is the correct format? Also, should there be some header row in the excel. When I tried to import cities the first time without any column header line, it did not import the first row at all.

The excel file should have this format while uploading -

Latitude Longitudes coordinate are available from www.latlong.net

Import the two excel attached one by one from the admin panel (ISO is used only for States or County, where the regions are defined. You can get the region highlighted, if ISO code is provided in the County excel file.)

1) For cities, select the city in drop down



2) Similarly, while uploading the counties, select the county from the drop down


Similarly, you can do it for State or Area or Zipcode.


Once done, you can build the cube which has the data with city, county and other measure (eg sales values, cost, etc)

Make sure city name, county name in the data matches exactly as per the names in both the excel files.


Define the location hierarchies in the cube (County > City) or (Country > City) after the cube rebuild process is carried out.




Note: This article is based on ElegantJ BI Version 4.3. This may or may not be relevant to the ElegantJ BI version you may be using.

GeoMaps Geo coordinates Latitude Longitude location hierarchies import ElegantJ BI Support ElegantJ BI Knowledgebase ElegantJ BI Articles ElegantJ BI Training Business Intelligence Support Business Intelligence Articles Business Intelligence Training

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article