I am using PostgreSQL 9.3 and PostGIS 2.1.I imported a shapefile into my database. In that the_geom data type is "LINESTRING". Now I need a query to find the lines within a given radius for a particular latitude, longitude.
Consider I have latitude and longitude (12.4444 78.898900) for the given radius of 5000 meters I have to get the line details.
I tried a lot regarding this, I can't find a solution. Help me to solve this.