within

  1. R

    Android Question point in polygon with spatialite

    Running this SQL in the spatialite gui application: SELECT ID FROM P_POINTS WHERE Within(GEOMETRY, polygonfromtext('POLYGON(-2.165476 52.604321, -2.167375 52.606777, -2.16444 52.606914, -2.163287 52.604595, -2.165476 52.604321)', 4326)) = 1 Geometry is the column in P_POINTS holding lat/lon...
Top