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.
Comments
0 comments
Please sign in to leave a comment.