Logo

Interactive Visualizations for Dynamic and Multivariate Networks. Free, online, and open source.


Overview

Home
Try
Visualizations
Formatting Data

Learning

Getting Started
Courses new courses
Workshop
Troubleshooting
Resources

Context

Research & VistorianLab
Publications
Contribute
Team
Contact








Tutorial: Extracting Geo-coordinates

This part will show you how to deal with geographic locations in the Vistorian. The demo network (see below) is a social network based on letter correspondences. The following walks through:

See here for how to load data into the Vistorian.

Extracting geolocations

This tutorial assumes that geolocations are encoded as additional columns in a link table. In this table, every line corresponds to a link with two locations: one for each node. The table uses column names Place1 and Place2, but you can name columns in your data as you like: image

First, we tell the Vistorian which columns in our table are locations, and to which node they belong: select Location_source and Location_target from the respective dropdown menus. image

Next, scroll down the bottom of the Data View page and you realize that the Vistorian has created a new table, containing an entry of each location entry it could find in your link table. image

This table contains the following field:

Obtaining geo-coordinates

Once you have your location table, click the ‘Update location coordinates‘ button in the gray area just above the table. image

This will send your geonames to a geoservice called Nominatim and populate the location table with coordinates where it could find the corresponding entries. Note that this time, one location has not been found: image

The problem here is that Ile St Domingue is the french name, while the geoservice needs english names. If you click into the geoname-field that says Ile St Domingue, change it to Santo Domingo and click again Update location coordinates. This will find the right coordinates.

Solving ambiguous geonames

The demo data set contains some ambiguous location names such as Orléans (France, Canada) and Brest (France, Belarus). To solve ambiguity you can specify more information in the geoname column (don’t ever change the user name column as this will break your data set).

For example, for Orléans, write Orléans France, then click Update location coordinates. You will see that the coordinates have changed and that Orléans is now in France.

image

Of course, you can use the map visualization to verify all your locations, then return to the data view, fix the coordinates, and reload the map visualization.

Saving and using existing location tables

As creating clean and correct location tables can be tedious, you can export your table with the Export as CSV button at the right in the gray area.

To import an existing location table, chose Upload from the Vistorian menu, next to Data Tables (figure right). Select your csv and it will show under the Data Tables headline in the menu (e.g., userLocationTable.csv).

Next, specify the location fields in your link table (see above).

Last, chose that table in the Location Table drop down menu as shown below.

If you specify the location fields after selecting a location table, the Vistorian will create a new one. In this case, just re-select your original location table from the dropdown menu.

image