Thunderstone Support Forums

Hi,

We are a Full Texis user.

Would it be possible to get access to geo2code function's underlying algorithm (coding/decoding + custom 'between' operator)?
Such knowledge would save us trouble of figuring it out ourselves & speed up development -> increase Texis usage faster -> pay you more $$$ sooner )

Thanks,
Valery.

The way a "geocode" works is simple; We use an unsigned-long field with the bits of the lon. and lat. interleaved from MSB to LSB. The LS bits that won't fit into the long are thrown out; hence, on 64 bit boxes it has 1 foot resolution, but on 32 bit boxes its something like +/- 1/8 mile.

ie: if LON = 00000000 and LAT = 11111111, then geocode= 01010101

I forgot to mention the algorithm last night;

Texis' BTREE comparison has an additional piece of code in the comparison section to eliminate items that fall "out-of-the-box" during a between operation.

While we won't provide source code to this, you could link your program with Texis and get access to it via a SQL call from a C program.