Import Graph From Table-Based Database with Hierarchy

[Kapucha]

This is my first post here.
First of all. The Gephi is a Fantastic, Awesome piece of software!!!

I used to work with it and with GeoLayout plugin. In my work I often create nodes that represent something on the earth. My nodes often have latitude and longitude properties.

This time I have to import about 5000 nodes from database (Mysql) that represent cities. In this database I have columns that tell me witch country this cities belong to, with province in country and with district in province. I would be lovely if Gephi can recognize those coumns (like recognice column label, id, type) and use it to create more than one level hierarchy graph so at the top level I have nodes represent countries then on the level down I have provinces in countries, on the level down I have district and on the bottom level I have nodes that represent cities.

Doing it manually is very time consuming. Can it be posiible. How to write such plugin? Is it even possible to do that?

I hope everybody understand my poor english and this idea that I described above.

[mbastian]

Hi,

Interesting use case. When you import your dataset from MYSQL it should already include the other columns. But what you want to do is use these columns to create a specific graph structure, hierarchical. This is something you could do by creating a new Import Processor in Gephi as a plugin. Processors are taking the input data (file, database import...) and create the graph structure. You could modify the default behaviour and use the additional columns to create a hierarchy.

Here is an example of a customized processor plugin
https://github.com/gephi/gephi-plugins- ... essor.java