szombat 12 január 2008 21.43 dátummal [EMAIL PROTECTED] ezt írta:
> Hi all,
> I would like to ask if someone can hel me. I need to transfer
> attributes from point layer to area features. Only one point is
> situated in one polygon... There is not only "nuber" fields, which
> I need to transfer. I need to tansfer text atribute from point to
> area to. How can I do that, please?
>
> Thank You for any help.
> Stefan
If I see as well your's problem, I give an example:
UPDATE sema_name.areas_fr SET text_column=NULL;
UPDATE sema_name.areas_fr AS t SET text_column=i.text_string
FROM ( SELECT t.id, f.text_string
FROM sema_name.areas_fr t,
sema_name.point_and_text f
WHERE t.geometria && f.geometria
AND intersects( t.geometria, f.geometria )
AND f.text_type=11 ) AS i
WHERE t.id=i.id;
bye,
kjt
McAfee SCM 4.1 által ellenőrizve!
_______________________________________________
jump-users mailing list
[email protected]
http://lists.refractions.net/mailman/listinfo/jump-users
