2

Imagine I have a PostGIS database with following pieces of information

  1. OSM (OpenStreetMap) of a city,
  2. the roads/streets inside the city and
  3. the routes of public transport in that city.

I want

  1. to calculate distance from building A to building B in that city via streets/roads (for people with cars) and
  2. to estimate the amount of time it takes to get from building A to building B using available public transport (for people without a car).

Is there any ready-made (open source or commercial) software for performing such calculations in PostGIS?

rafa.pereira
  • 13,251
  • 6
  • 71
  • 109
Glory to Russia
  • 17,289
  • 56
  • 182
  • 325

2 Answers2

1

It seems that PgRouting does exactly that. Here's an intro.

Glory to Russia
  • 17,289
  • 56
  • 182
  • 325
1

For public transport planning you should check OpenTripPlanner, too. After the link, you will see various examples, not all works, but Athens does.

Plutoz
  • 694
  • 9
  • 13
  • Great! Do you know the source of data about public transport used in those demos? Perhaps you know where I can get such data for Russian cities? – Glory to Russia Nov 12 '12 at 09:27
  • 1
    As I know, every case is different, so if you want to access the data, you should get from directly the transport company. :( In some cases, these companies ensure access through GTFS (https://developers.google.com/transit/gtfs/). You could find many data source for example here: http://www.gtfs-data-exchange.com/. – Plutoz Nov 12 '12 at 12:28