[postgis-users] how to join with contains

John Taber jtaber at johntaber.net
Tue Feb 21 08:53:21 PST 2006


I want to add attributes from a lot area that contains a building.  What 
is the right function ?  Are there any examples ?

create table bldgplus as (
select b.id, b.name, l.type
from building b
???? left join lot l on l
???? where contains(l,b)
);
thanks for any help



More information about the postgis-users mailing list