Geography and methods | Sciences, technologies and visualizations

Howto build a MySQL database from the GeoNames dumps

Another simple MySQL script to build the GeoNames database, with an efficient structure and indexes, based on the exportable dumps and on the postal codes dump. Please find the scripts and the documentation on GitHub.

Building drive time areas: cities and hinterlands accessibility in Mozambique

The objective of this article is to build a cartographic representation of drive time for freight transport companies from the 13th most important cities in Mozambique.

This model is based on an open source dataset of transport networks (OpenStreetMap, 2016) in Mozambique and the bordering countries. It is simulating, at a fine-grained level, the behaviours of truck drivers by taking in account both, barriers (one-way roads, pedestrian or cycling paths, tracks for agricultural purpose…), and common situations for drivers (border crossing time, turns and U-turns, junctions, local road crossing a regional road…). The model define six classes of roads (from local roads to highways) for more than one million kilometres of roads, with specific average traffic speed empirically deduced from a sample of transit times of a Mozambican freight transport company. This complex network of more than 1 million of road sections is analysed with ArcGIS, in order to build drive time areas (2, 4 and 6 hours), from the city centres of the major urban areas (more than 100 000 inhabitants, GeoNames, 2016). The map illustrates the interconnections of these urban areas and the problems of accessibility of their hinterlands in term of land transportation.

Read more...

Isochrones Mozambique
Isochrones Mozambique >>

The objective of this article is to build a cartographic representation of drive time for freight transport companies from the 13th most important cities in Mozambique.
[ Isochrones Mozambique ]