PostGIS: Simple query selecting nodes of polygon

[المشرف العام]

I know it's very simple but anyway: (Asked also at stackoverflow)

INPUT:

1. Regular OSM buildings .shp table
2. PostGIS Point location
3. RADIUS (around above location), lets say 500m.

RESULT:

I want to get back all corners from all buildings within this radius from location, that ("WHERE") they distance from location is less than DISTANCE (let's say 200m).

I'm struggling to get result as points accepting WHERE clause from polygons table.

EDIT:

I started something like this:

SELECT ST_AsText((ST_DumpPoints(geom)).geom)FROM buildingsWHERE ST_DWithin((ST_DumpPoints(geom).geom), ST_GeomFromText('POINT(5 45)',4326), 0.002);Thanks,



أكثر...