[pgrouting-users] Adding bike routes to database

Hi,

I have some bike routes data that I would like to insert to the ‘ways’ table in my pgrouting database.
For routing using the added routes, do I need to run assign_vertex_id again?

Also, there are existing streets where the bike routes would be added, would this be any problem?

Thanks,
Yasir

Hi Yasir,

I have some bike routes data that I would like to insert to the ‘ways’ table in my pgrouting database.
For routing using the added routes, do I need to run assign_vertex_id again?

If you can ensure that you keep a valid topology you don’t have to run it again. But probably it’s easier to do so.

Also, there are existing streets where the bike routes would be added, would this be any problem?

You might have a problem if nodes get very close to existing ones. they might “snap” if you set your “tolerance” value too high.
Also I’m not sure you want to create new roads beside existing ones. Probably you would like to try to match your bike routes with existing roads.

Best regards,
Daniel


Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

Hi Daniel,

Thanks for replying.

There is the issue of my current bike routes data not being aligned to the exiting streets (some differences are present). Also, I am not sure how ways can be assigned multiple class id’s. The Ontario.osm which was downloaded didn’t have bike data imported into the pgrouting db, unless I missed something. Ontario.osm was downloaded from: http://downloads.mapzen.mapzen.cloudmade.com/north_america/canada/ontario

To get things started, I tried adding the routes and then running the search with lower cost assigned to bike routes and higher to other road networks but this didn’t work as intended. Maybe this is the problem that you mention about nodes snapping relating to the high tolerance.

Although, I am continuing to look into this, based on above do you have any suggestions on getting things working?

Thanks,
Yasir

On 11 August 2010 15:34, Daniel Kastl <daniel.kastl@georepublic.de> wrote:

Hi Yasir,

I have some bike routes data that I would like to insert to the ‘ways’ table in my pgrouting database.
For routing using the added routes, do I need to run assign_vertex_id again?

If you can ensure that you keep a valid topology you don’t have to run it again. But probably it’s easier to do so.

Also, there are existing streets where the bike routes would be added, would this be any problem?

You might have a problem if nodes get very close to existing ones. they might “snap” if you set your “tolerance” value too high.
Also I’m not sure you want to create new roads beside existing ones. Probably you would like to try to match your bike routes with existing roads.

Best regards,
Daniel


Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de


Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Hi Yasir,

Just a question for better understanding:
Are you bike routes user generated (GPS) tracks or are they separate network data that is just not part of OSM?
If you want to match GPS tracks to an existing road network, there is a matching.sql with some functions in at least the trunk version of pgRouting.

Daniel


Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

2010/8/12 Yasir Shoaib <yasirshoa@gmail.com>

Hi Daniel,

Thanks for replying.

There is the issue of my current bike routes data not being aligned to the exiting streets (some differences are present). Also, I am not sure how ways can be assigned multiple class id’s. The Ontario.osm which was downloaded didn’t have bike data imported into the pgrouting db, unless I missed something. Ontario.osm was downloaded from: http://downloads.mapzen.mapzen.cloudmade.com/north_america/canada/ontario

To get things started, I tried adding the routes and then running the search with lower cost assigned to bike routes and higher to other road networks but this didn’t work as intended. Maybe this is the problem that you mention about nodes snapping relating to the high tolerance.

Although, I am continuing to look into this, based on above do you have any suggestions on getting things working?

Thanks,
Yasir

On 11 August 2010 15:34, Daniel Kastl <daniel.kastl@georepublic.de> wrote:

Hi Yasir,

I have some bike routes data that I would like to insert to the ‘ways’ table in my pgrouting database.
For routing using the added routes, do I need to run assign_vertex_id again?

If you can ensure that you keep a valid topology you don’t have to run it again. But probably it’s easier to do so.

Also, there are existing streets where the bike routes would be added, would this be any problem?

You might have a problem if nodes get very close to existing ones. they might “snap” if you set your “tolerance” value too high.
Also I’m not sure you want to create new roads beside existing ones. Probably you would like to try to match your bike routes with existing roads.

Best regards,
Daniel


Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de


Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users


Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Hi Daniel,

No, this is custom generated data.

Yasir

On 12 August 2010 05:18, Daniel Kastl <daniel.kastl@georepublic.de> wrote:

Hi Yasir,

Just a question for better understanding:
Are you bike routes user generated (GPS) tracks or are they separate network data that is just not part of OSM?
If you want to match GPS tracks to an existing road network, there is a matching.sql with some functions in at least the trunk version of pgRouting.

Daniel


Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

2010/8/12 Yasir Shoaib <yasirshoa@gmail.com>

Hi Daniel,

Thanks for replying.

There is the issue of my current bike routes data not being aligned to the exiting streets (some differences are present). Also, I am not sure how ways can be assigned multiple class id’s. The Ontario.osm which was downloaded didn’t have bike data imported into the pgrouting db, unless I missed something. Ontario.osm was downloaded from: http://downloads.mapzen.mapzen.cloudmade.com/north_america/canada/ontario

To get things started, I tried adding the routes and then running the search with lower cost assigned to bike routes and higher to other road networks but this didn’t work as intended. Maybe this is the problem that you mention about nodes snapping relating to the high tolerance.

Although, I am continuing to look into this, based on above do you have any suggestions on getting things working?

Thanks,
Yasir

On 11 August 2010 15:34, Daniel Kastl <daniel.kastl@georepublic.de> wrote:

Hi Yasir,

I have some bike routes data that I would like to insert to the ‘ways’ table in my pgrouting database.
For routing using the added routes, do I need to run assign_vertex_id again?

If you can ensure that you keep a valid topology you don’t have to run it again. But probably it’s easier to do so.

Also, there are existing streets where the bike routes would be added, would this be any problem?

You might have a problem if nodes get very close to existing ones. they might “snap” if you set your “tolerance” value too high.
Also I’m not sure you want to create new roads beside existing ones. Probably you would like to try to match your bike routes with existing roads.

Best regards,
Daniel


Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de


Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users


Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users


Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users