Re: [sqlite] Using SQLite for GIS Application

2009-10-01 Thread stormtrooper
-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

Re: [sqlite] Using SQLite for GIS Application

2009-08-23 Thread Kit
2009/8/23 Itzchak Raiskin itzchak.rais...@gmail.com: 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

Re: [sqlite] Using SQLite for GIS Application

2009-08-23 Thread John Machin
On 23/08/2009 3:08 PM, 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.

Re: [sqlite] Using SQLite for GIS Application

2009-08-23 Thread Rich Shepard
On Sun, 23 Aug 2009, Itzchak Raiskin wrote: 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

Re: [sqlite] Using SQLite for GIS Application

2009-08-23 Thread Derrell Lipman
On Sun, Aug 23, 2009 at 01:08, Itzchak Raiskin itzchak.rais...@gmail.comwrote: 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

Re: [sqlite] Using SQLite for GIS Application

2009-08-23 Thread P Kishor
On Sun, Aug 23, 2009 at 12:08 AM, Itzchak Raiskinitzchak.rais...@gmail.com 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

Re: [sqlite] Using SQLite for GIS Application

2009-08-23 Thread Simon Slavin
On 23 Aug 2009, at 5:00pm, P Kishor wrote: WHERE a*x - y + c = 0 Here's the problem. This works only when the equation is exact. Which under normal circumstances means that all the numbers fit neatly with some imaginary integer formula. This isn't how real life works, especially when

Re: [sqlite] Using SQLite for GIS Application

2009-08-23 Thread Stephen Woodbridge
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

Re: [sqlite] Using SQLite for GIS Application

2009-08-23 Thread P Kishor
On Sun, Aug 23, 2009 at 11:11 AM, Simon Slavinslav...@hearsay.demon.co.uk wrote: On 23 Aug 2009, at 5:00pm, P Kishor wrote: WHERE a*x - y + c = 0 Here's the problem.  This works only when the equation is exact. Indeed. We already laid out those presumptions. One, your height coverage has to

Re: [sqlite] Using SQLite for GIS Application

2009-08-23 Thread P Kishor
On Sun, Aug 23, 2009 at 11:34 AM, P Kishorpunk.k...@gmail.com wrote: On Sun, Aug 23, 2009 at 11:11 AM, Simon Slavinslav...@hearsay.demon.co.uk wrote: On 23 Aug 2009, at 5:00pm, P Kishor wrote: WHERE a*x - y + c = 0 Here's the problem.  This works only when the equation is exact. Indeed.

Re: [sqlite] Using SQLite for GIS Application

2009-08-23 Thread P Kishor
On Sun, Aug 23, 2009 at 12:08 AM, Itzchak Raiskinitzchak.rais...@gmail.com 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

Re: [sqlite] Using SQLite for GIS Application

2009-08-23 Thread Kit
2009/8/23 P Kishor punk.k...@gmail.com: If a line is expressed by (y = ax + c), you need to find all x,y that will satisfy that equation. So, SELECT x, y, z FROM terrain WHERE a*x - y + c = 0 General equation of line is a*x + b*y + c = 0. If you delete parameter b, you will have a problem

Re: [sqlite] Using SQLite for GIS Application

2009-08-23 Thread Jean-Christophe Deschamps
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

[sqlite] Using SQLite for GIS Application

2009-08-22 Thread Itzchak Raiskin
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