I am new to Spatialite. I have following query:
select A.* from linka as A, pointa as B where Contains(Buffer(B.Geometry, 100), A.Geometry)
A.Geometry = LINESTRING(23.2161 69.95237, 23.21581 69.95279) B.Geometry = POINT(23.21817 69.95177)
I want to create 100 meters buffer and get to know which are the link's are contained by point geometry.
I am having coordinates of WGS 84 projection system from navigation data.
The passing 100 over here, it takes as degree and creating buffer like that, but I actually want to specify the buffer distance as meters. (I don't want to pass the distance in degree value because on each earth pole degree's buffer cover not same range area. This is the big problem of geodecy)
Is there any way to satisfy my requirement in Spatialite ?