[postgis-users] Newbie question - Transfer attributes from one feature to another

[Fred Lehodey]

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 <
sindile.bidla at gmail.com> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081006/9155deb4/attachment.html>