1

I am trying to use POSTGIS to find all the outer points when I have alot of points? How would I go about doing this and and I cant seem to find a command for it. Goals

5
  • 1
    How do you define an outer point?
    – Ian Turton
    May 12 at 14:26
  • Imagine I took a Box around all my points. Than you split the Box into 8 rows and 2 columns. An outer point would be the point that are closest to the Box wall in each square/cell. May 12 at 14:41
  • I was thinking the image would explain well enough? May 12 at 15:35
  • Convex hull is what I need correct May 12 at 15:39
  • SELECT ST_ASGEOJSON((ST_DumpPoints(ST_ConvexHull(st_collect(geog::geometry)))).geom) FROM sources; made it work using May 12 at 16:14

1 Answer 1

1

Thanks for some good comments I made it work using.

SELECT ST_ASGEOJSON((ST_DumpPoints(ST_ConvexHull(st_collect(geog::geometry)))).geom) FROM sources;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.