Hi,
SELECT * FROM table1,table2
WHERE ST_within (table2.the_geom,table1.the_geom);

Fred.


On Mon, Oct 6, 2008 at 9:46 AM, Intengu Technologies <
[EMAIL PROTECTED]> wrote:

> I have a polygon (table1) and a point (table2) feature and would want to
> transfer attributes from the point feature to the polygon feature based on
> whether the point feature is completely enclosed by the polygon feature.
> The polygon feature can have one or more point features.
>
> How do i transfer the attributes.
>
>
> --
> Sindile Bidla
>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to