Return to Answer

non-spatial join instead of spatial intersect

Source Link

edited Nov 26, 2013 at 20:19

18.9k
5
70
114

Here is a tutorial for doing the join in QGIS.

To do this in PostGIS, you would create a query or view that does the join between the two tables based on the ST_Intersects function. There are examples of that here, one of which would read:

SELECT Select ST_Intersection(atable_a.geomcolumn, btable_b.geom)column As intersect_ab
    FROM a INNERfrom JOINtable_a b ON ST_Intersection(a,b)
join table_b   WHERE
on ST_Overlaps(atable_a.geom,MUKEY b= table_b.geomMUKEY)
    ;

(...or something very similar...)

More info here

Here is a tutorial for doing the join in QGIS.

To do this in PostGIS, you would create a query or view that does the join between the two tables based on the ST_Intersects function. There are examples of that here, one of which would read:

SELECT  ST_Intersection(a.geom, b.geom) As intersect_ab
    FROM a INNER JOIN b ON ST_Intersection(a,b)
    WHERE ST_Overlaps(a.geom, b.geom)
    ;

Here is a tutorial for doing the join in QGIS.

To do this in PostGIS, you would create a query or view that does the join between the two tables:

Select table_a.column, table_b.column  
from table_a   
join table_b   
on (table_a.MUKEY = table_b.MUKEY)

(...or something very similar...)

More info here

Source Link

created Nov 26, 2013 at 20:11

Inactivated Account

18.9k
5
70
114

Here is a tutorial for doing the join in QGIS.

To do this in PostGIS, you would create a query or view that does the join between the two tables based on the ST_Intersects function. There are examples of that here, one of which would read:

SELECT  ST_Intersection(a.geom, b.geom) As intersect_ab
    FROM a INNER JOIN b ON ST_Intersection(a,b)
    WHERE ST_Overlaps(a.geom, b.geom)
    ;