Hi,
I have a SQLite database with point and line geometries. I want to create a line between the points and the line objects. This line should be the shortest path and the sounding line (90 degres) on the existing line.
How can I manage this with a SQL Statement?
I want to use the spatial functions from SQLite
Thank you and best regards