Skip to main content
deleted 6 characters in body
Source Link
PolyGeo
  • 65.4k
  • 29
  • 114
  • 345

have created database by tool osm2pgrouting. On my website can user enter start and end point.

How can I find ids of nodes? Because I have only text value of nodes which enter user, but tables generated by tool does not.
UPDATE: On the website will be 2 inputs for 2 points (start and end) user enter for example New York (as start) and Los Angeles (as end). Next I call service to my geoserver and select route, and return tiles or geoJSON. But for selecting route I use pgr_dijkstra function which requires node IDs, but I have only NY and LA in text format. How can I convert this to coordinates or osm_id?? This

This is how my table of nodes looks:   

enter image description here

This is reason why I need convert text values of user to id or coordinates. Thanks!

have created database by tool osm2pgrouting. On my website can user enter start and end point.

How can I find ids of nodes? Because I have only text value of nodes which enter user, but tables generated by tool does not.
UPDATE: On the website will be 2 inputs for 2 points (start and end) user enter for example New York (as start) and Los Angeles (as end). Next I call service to my geoserver and select route, and return tiles or geoJSON. But for selecting route I use pgr_dijkstra function which requires node IDs, but I have only NY and LA in text format. How can I convert this to coordinates or osm_id?? This is how my table of nodes looks:  enter image description here

This is reason why I need convert text values of user to id or coordinates. Thanks!

have created database by tool osm2pgrouting. On my website can user enter start and end point.

How can I find ids of nodes? Because I have only text value of nodes which enter user, but tables generated by tool does not.
UPDATE: On the website will be 2 inputs for 2 points (start and end) user enter for example New York (as start) and Los Angeles (as end). Next I call service to my geoserver and select route, and return tiles or geoJSON. But for selecting route I use pgr_dijkstra function which requires node IDs, but I have only NY and LA in text format. How can I convert this to coordinates or osm_id??

This is how my table of nodes looks: 

enter image description here

This is reason why I need convert text values of user to id or coordinates.

edited title
Link
John Powell
  • 13.7k
  • 5
  • 48
  • 62

pgrouting with pgRouting from geocoded user interactioninput

added 596 characters in body
Source Link
Aligator
  • 133
  • 1
  • 7

have created database by tool osm2pgrouting. On my website can user enter start and end point.

How can I find ids of nodes? Because I have only text value of nodes which enter user, but tables generated by tool does not. 
I am newUPDATE: On the website will be 2 inputs for 2 points (start and end) user enter for example New York (as start) and Los Angeles (as end). Next I call service to my geoserver and select route, and return tiles or geoJSON. But for selecting route I use pgr_dijkstra function which requires node IDs, but I have only NY and LA in gistext format. How can I convert this to coordinates or osm_id?? This is how my table of nodes looks: enter image description here

This is reason why I need convert text values of user to id or coordinates. Thanks!

have created database by tool osm2pgrouting. On my website can user enter start and end point.

How can I find ids of nodes? Because I have only text value of nodes which enter user, but tables generated by tool does not. I am new in gis.

have created database by tool osm2pgrouting. On my website can user enter start and end point.

How can I find ids of nodes? Because I have only text value of nodes which enter user, but tables generated by tool does not. 
UPDATE: On the website will be 2 inputs for 2 points (start and end) user enter for example New York (as start) and Los Angeles (as end). Next I call service to my geoserver and select route, and return tiles or geoJSON. But for selecting route I use pgr_dijkstra function which requires node IDs, but I have only NY and LA in text format. How can I convert this to coordinates or osm_id?? This is how my table of nodes looks: enter image description here

This is reason why I need convert text values of user to id or coordinates. Thanks!

deleted 64 characters in body
Source Link
PolyGeo
  • 65.4k
  • 29
  • 114
  • 345
Loading
Source Link
Aligator
  • 133
  • 1
  • 7
Loading