How to get point file in 5km Buffer of route generated in pgrouting

Question

I am using pgrouting to get shortest route. Now i want to get point that comes in buffer of 5km along router.Point is other shape file. route is using road shape so any one give me idea for same.

Answer 1

Pseudocode:

SELECT * 
FROM points_table pt
WHERE ST_Intersects(pt.the_geom, SELECT ST_Buffer(ST_Union(w.the_geom), 5000)
                    FROM shortest_path('
                        SELECT gid as id,
                             source::integer,
                             target::integer,
                             length::double precision as cost
                            FROM ways',
                        5700, 6733, false, false) sp
                    INNER JOIN ways w
                        ON w.gid = sp.edge_id);

• Use PostGIS ST_Union to get a LINESTRING which represents each of the line segments combined to get your route.
• ST_Buffer will buffer the linestring 5km.
• ST_Intersects retrieves all the points within the buffered zone.