Hi Bob,
Something like this:
SELECT a.id,
b.id
FROM A AS a, B AS b
WHERE ST_WITHIN(a.geom, b.geom) -- or ST_CONTAINS(b.geom, a.geom)
Cheers
2015-11-09 14:50 GMT-02:00 Bistrais, Bob <[email protected]>:
> Spatial functions such as ST_Within and ST_Boundary return a Boolean.
> Instead, I would like to be able to return the feature id’s of the features
> used in these functions. Example, instead of ST_Within(A,B) being true or
> false, I’d like to get the feature ids of A that are within B. So if A
> contains points, B contains polygons, which point features of A are within
> B. How do I do this?
>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://lists.osgeo.org/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/postgis-users
