PostgreSQL to graph-tool

graph-tool
1

I'm interested in calculating some centrality measures on a road network of
a city. The geometry of the road network, from Open Street Map, is stored
in a postgreSQL / postGIS database and can also be exported as a shapefile
or a geojson. What is the best way to import the geometry in graph-tool as
a planar graph?
Thank you,
Duccio

attachment.html (362 Bytes)

2

Hi Duccio Aiazzi,

I don't have an answer to your specific question, but I just want to call
your attention to the OSMnnx , which makes it incredibly simple to create a
road network from OpenStreetMaps data with a single line of code.
https://github.com/gboeing/osmnx

OSMnnx also allows one to save the graph as a GraphML file, which I
believe can be easily read by graph-tool as a planar graph if I'm not
mistaken.

best,

Rafael H M Pereira
urbandemographics.blogspot.com

attachment.html (2.02 KB)

3

It seems to me this is by far the easiest choice.

In addition to exporting to graphml, it is also simple to iterate over the
edges of the OSMnnx graph and add them to a graph-tool graph.

(Note that road networks need not to be planar; they may contain bridges and
tunnels.)

Best,
Tiago