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"
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
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