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. 
-
1How 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.– Ole DybedokkenMay 12 at 14:41
-
I was thinking the image would explain well enough?– Ole DybedokkenMay 12 at 15:35
-
Convex hull is what I need correct– Ole DybedokkenMay 12 at 15:39
-
SELECT ST_ASGEOJSON((ST_DumpPoints(ST_ConvexHull(st_collect(geog::geometry)))).geom) FROM sources; made it work using– Ole DybedokkenMay 12 at 16:14
Add a comment
|
1 Answer
Thanks for some good comments I made it work using.
SELECT ST_ASGEOJSON((ST_DumpPoints(ST_ConvexHull(st_collect(geog::geometry)))).geom) FROM sources;