How to intersects two dataset's geometries

Daniel Caldwell

In this example we will intersect two datasets finding all of the data in dataset_1 that intersects dataset_2

SELECT dataset_1.* from dataset_1, dataset_2 where ST_INTERSECTS( dataset_1.<geometry_field>, dataset_2.<geometry_field> )

For more information see the PostGIS documentation for ST_INTERSECTS.

0 comments

Please sign in to leave a comment.