This is just a simple spatial intersection. Each line will intersect many contour lines producing points, you can calculate the average elevation points per line, calc min, max elev. Or save the line ID and elevation points in another table to query later. Ask the Spatialite User Group.
http://groups.google.com/group/spatialite-users Itzchak Raiskin wrote: > > Hi > I want to use SQLite in a GIS application where I create a database > containing terrain data (coordinates, height). > I would like to query this database with start and end points of a line > and > get a vector with all heights point along this line. > I can, of course create a query for each point along the line, but this > will > be very time consuming as I have hundreds of lines with hundreds of > points. > Any suggestions? > > Thanks, Itzik > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Using-SQLite-for-GIS-Application-tp25100408p25710287.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
