Relate two tables based on geom

المشرف العام

Administrator
طاقم الإدارة
I have a problem, which is, I have a table ways (like in the Workshop of pgRouting) and I also have a different table street_name, where it contains the name of the street (among other information). Both have a column geom and I want to connect a given edge of the pgr_dijkstra calculated route with the name of the nearest point in street_name. I'm already using a version of this function to convert lat/long in source/target values. Is it possible?



أكثر...
 
أعلى