问题

SELECT geom from hexgrids where value > 0.5 as hexselection
SELECT * from othertable where ST_Within(geom, hexselection)

英文:

Say I have two tables, one a table of hexagons called hexgrids and another table of other features called othertable.

I'd like to select features from othertable where they intersect features in hexgrids with value > 0.5

Essentially I am trying to use the result of one query as a spatial selection on another table.

SELECT geom from hexgrids where value &gt; 0.5 as hexselection
SELECT * from other table where ST_Within( geom, hexselection)

答案1

得分: 1

你可以使用空间谓词和其他条件来加入：

SELECT * 
FROM table1
 JOIN table2 
  ON st_intersects(table1.geom, table2.geom)
WHERE table2.value > 0.5

英文:

You can join using the spatial predicate and any other conditions

SELECT * 
FROM table1
 JOIN table2 
  ON st_intersects(table1.geom, table2.geom)
WHERE table2.value &gt; 0.5

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。