Re: [sqlite] General R*Tree query

2013-12-18 Thread Brian T. Carcich
On Wed, Dec 18, 2013 at 1:53 AM, Roman Fleysher < roman.fleys...@einstein.yu.edu> wrote: > Perhaps this is a weird way for me to get deeper knowledge of R trees, and > because I vaguely remember that Tyco refers to a specific epoch in which > coordinates are defined, but would it be possible to

Re: [sqlite] General R*Tree query

2013-12-17 Thread Roman Fleysher
coordinates the metric could use some other coordinates? Roman Original message From: "Brian T. Carcich" <briantcarc...@gmail.com> Date: 12/18/2013 1:24 AM (GMT-05:00) To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite

Re: [sqlite] General R*Tree query

2013-12-17 Thread Brian T. Carcich
On Tue, Dec 17, 2013 at 3:57 PM, Roman Fleysher < roman.fleys...@einstein.yu.edu> wrote: > > Since coordinate system is spherical, how do you tell that RA=23:59 and > RA=00:01 are next to each other using usual comparisons? I don't; usual comparisons won't work so I do two comparisons: I am

Re: [sqlite] General R*Tree query

2013-12-17 Thread Brian T. Carcich
On Tue, Dec 17, 2013 at 3:51 PM, Dan Kennedy wrote: > On 12/18/2013 12:49 AM, Brian T. Carcich wrote: > >> [...] > > Points are fine. [...] > Is it working now? How many more stars do you have data for? Excellent, thanks for the info! I forgot to mention that we do

Re: [sqlite] General R*Tree query

2013-12-17 Thread Roman Fleysher
...@gmail.com] Sent: Tuesday, December 17, 2013 3:51 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] General R*Tree query On 12/18/2013 12:49 AM, Brian T. Carcich wrote: > I'm working on an SQLite solution to get at star catalogs; they are usually > searched via Right Ascension (RA), Declinatio

Re: [sqlite] General R*Tree query

2013-12-17 Thread Dan Kennedy
On 12/18/2013 12:49 AM, Brian T. Carcich wrote: I'm working on an SQLite solution to get at star catalogs; they are usually searched via Right Ascension (RA), Declination (DEC), and magnitude (mag). RA,DEC is a spherical coordinate system to specify a star position on-sky; magnitude is related

[sqlite] General R*Tree query

2013-12-17 Thread Brian T. Carcich
I'm working on an SQLite solution to get at star catalogs; they are usually searched via Right Ascension (RA), Declination (DEC), and magnitude (mag). RA,DEC is a spherical coordinate system to specify a star position on-sky; magnitude is related to star brightness. What I have so far is here: