Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
I have a LINESTRING made of two points start point and end point in spatialite.
UPDATE points SET road_geometry = GeomFromText('LINESTRING(24.889142 67.196188,
24.889673 67.196579)',4326) where name='name';
and Now, I want to check that if any other point is within that line string or how far the point is from the LINESTRING.
Use either ST_Distance or PtDistWithin (see documentation). With the former you can test for the distance of your points and then select based on some distance criteria.
If you are wanting to test whether a point lies exactly on your line you could try doing an Intersection or use ST_Contains. My only hesitation with these approaches is that, because a point has no area or length, normal rounding errors within floating point coordinates may give false negatives, so ST_Distance and then a selection based on some acceptable threshold may be better in this case.
