Skip to main content
Became Hot Network Question
naming; removed excessive bolding for legibility
Source Link
Vince
  • 20.3k
  • 16
  • 48
  • 65

I have a setset of geometrygeometry in my postgresPostgreSQL table that consists of Points,Linestrings & PolygonsPoints, Linestrings & Polygons. From this set I need to create a subsetsubset of geometries which intersectsintersects with each other. I need a method without loopingwithout looping through each one of them as there can be more than 1000 geometries at once.

I need to fetch the geometries that are marked in red in this image

I need to fetch the geometries that are marked in red in this image

I have a set of geometry in my postgres table that consists of Points,Linestrings & Polygons. From this set I need to create a subset of geometries which intersects with each other. I need a method without looping through each one of them as there can be more than 1000 geometries at once.

I need to fetch the geometries that are marked in red in this image

I need to fetch the geometries that are marked in red in this image

I have a set of geometry in my PostgreSQL table that consists of Points, Linestrings & Polygons. From this set I need to create a subset of geometries which intersects with each other. I need a method without looping through each one of them as there can be more than 1000 geometries at once.

I need to fetch the geometries that are marked in red in this image

I need to fetch the geometries that are marked in red in this image

added 21 characters in body
Source Link
George V
  • 339
  • 1
  • 13

I have a set of geometry in my postgres table that consists of Points,Linestrings & Polygons. From this set I need to create a subset of geometries which intersects with each other. I need a method without looping through each one of them as there can be more than 1000 geometries at once.

I need to fetch the geometries that are marked in red in this image

i.e. I need to fetch the geometries that are marked in red in this image

I have a set of geometry that consists of Points,Linestrings & Polygons. From this set I need to create a subset of geometries which intersects with each other. I need a method without looping through each one of them as there can be more than 1000 geometries at once.

I need to fetch the geometries that are marked in red in this image

i.e. I need to fetch the geometries that are marked in red in this image

I have a set of geometry in my postgres table that consists of Points,Linestrings & Polygons. From this set I need to create a subset of geometries which intersects with each other. I need a method without looping through each one of them as there can be more than 1000 geometries at once.

I need to fetch the geometries that are marked in red in this image

I need to fetch the geometries that are marked in red in this image

Source Link
George V
  • 339
  • 1
  • 13

Create a subset of geometries which intersects with each other

I have a set of geometry that consists of Points,Linestrings & Polygons. From this set I need to create a subset of geometries which intersects with each other. I need a method without looping through each one of them as there can be more than 1000 geometries at once.

I need to fetch the geometries that are marked in red in this image

i.e. I need to fetch the geometries that are marked in red in this image