View Source

Only users with data manager role can manage GEO points and regions. See BellaDati permissions and roles for details.

BellaDati supports data visualisation on geo maps by using two options:

GEO Points
GEO Shapes

In the Data set menu screen click on the Map charts geodata to manage GEO points and regions.

Available actions on Map charts geodata screen are:

Create point-based definition
Create definition of regions
Import GeoJSON: Allow to import predefined geo regions from file using GeoJSON format.
Import points database: Allow to import predefined geo points from CSV file in structure: point name, longitude, latitude, additional names
Create default: Will create default set of regions and points (countries, world capital cities, US states). That are delivered by default as part of BellaDati installation.

BellaDati User Documentation > Managing GEO Data > 2014-04-14_170804.png

Uploading GEO Points definition

Include the GEO point definition in the regular data import mapping the longitude/latitude to the GEO Point attribute type. But if you need to use Show details for option during creating new maps in report import GEO data trough Map Charts Geo Data section as described below.

Your CSV file with GEO location points must have exact format on picture below. Please note the delimiter type and no blank spaces are accepted. Each GEO point is defined by its latitude and longitude coordinantes. You have to define associated drill-down values to match drill-down members in the report view. You can associate more drill-down values to single GEO point definition. Upper and lower case are distinguished (eg. New York, new york, NY are different values).

BellaDati User Documentation > Managing GEO Data > GEOPoints data import.jpg

This picture includes GEO POINTS for streets of Chicago city as following - Street Name, latitude, longitude

In the Map charts geodata screen click on the Import points database and import CSV file in format described in the note section
Click on the imported points data to edit data or proceed to report to create New Map

Following options are available

Add definition entry (to add new latitude and longitude definitions into the exiting definition)
Export option will export existing definition into the NameOfExistingDefinition.csv
Delete definition will delete existing definition
Back to overview will return user to overview of all available definitions

On the screen of the particular GEO points definition user can edit following parameters

Name,
Latitude
Longitude
Associated drill-down values (multiple parameters can be inserted by using , as an delimiter)

BellaDati User Documentation > Managing GEO Data > EditingGeoPoints.png

Name of the GEO point will be associated with drill-down members in your data set used to create new map in report. Using Associated with drill-down members section you can associate latitude and longitude as well with other drill-down member. Example - City of Vienna has got associated latitude and longitude in Geo Points definition. If your data set includes as well state Austria. You can define it in Associated with drill-down members section and same latitude and longitude will be associated with Austria.

GEO Regions

Each GEO region is defined by three or usually more points specified by latitude and longitude coordinantes. Standardized GeoJSON format is supported to simplify importing these definitions. You have to define associated drill-down values to match drill-down members in the report view. You can associate more drill-down values to single GEO region definition. Upper and lower case are distinguished (eg. Canada, canada, CAN are different values).

Following parameters are manageable for GEO regions:

Definition name
Region parameters: Name, GeoJSON coordinantes, Associated drill-down values

BellaDati User Documentation > Managing GEO Data > 2014-04-14_171706.png

Next Steps

Creating Geo Maps