我有两个表,Table_A
:
ID | known_multipolygon | 费城 | B
---|---|
巴尔的摩 | |
夏洛特 |
您可以使用st_contains
来连接两个表:
SELECT b.ID as unknown_id,
a.ID as known_id
FROM Table_B b
JOIN Table_A a
ON st_contains(b.geometry, a.geometry);