[postgis-users] problem with points in polygon edge

[Martin Davis]

Can you fix this by treating it as a standard non-spatial data
de-duplication problem?   I.e. use the spatial query to assign a polygon ID
to each point, and then keep only a single attribute record for each point.

Lots of examples of this out there, e.g.

https://www.sqlshack.com/different-ways-to-sql-delete-duplicate-rows-from-a-sql-table/

On Mon, Mar 14, 2022 at 6:52 AM Gustavo Martinez <gmpuljak at yahoo.com.ar>
wrote:

> Hi all,
>
> I am working with fishing vessels positions. I have millions of points,
> and when doing some analysis I need to do some intersections with polygons.
>
> All the database is on EPSG 4326 (Lat Long)
>
> I've noticed some problems when the points are on the edges of the
> polygons. When I use ST_Within I lose the points on the edges, while when
> using ST_Intersects those points get counted twice.
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220316/6e4df89f/attachment.html>