I want to identify a road at particular point of intrest using post gis.


Input String : 16th cross near xyz mall.

Problem I am facing

As there will be many "16th cross roads" in the map , how do I identify the "16th cross near xyz mall"

  • 1
    Welcome to GIS.SE. I think you might need to add a bit more information. Your question is not clear as it stands. – John Powell Aug 26 '15 at 6:31
  • Thanks @JohnBarça , You got my question ? – user1544198 Aug 26 '15 at 6:40

Don't know your data. A template could look like:

select st_distance(mall.geom, roads.geom) as dist 
from roads, mall
where roads.name = '16th cross' AND mall.name = 'xyz' 
order by dist
limit 1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.