I'd like to perform a select by location analysis in PostGIS that first selects the geometry of ONE point out of a table (of many points). Creates then a circumference around it and checks which geometries (polygons) of a second table lie within that circumference.
I came up with this but am somehow stuck..
SELECT t2.name, t2_area FROM ( SELECT geom FROM views.sites WHERE site_id LIKE 'AB_10003' ) t1, spatial.land_use t2 WHERE ST_DWithin(t1.geom, t2.geom, 1000) -- radius of 1000m
the SRID of my geometries is 31467. Any help?