[Loadstone] point table
shawn at odyssey.cm.nu
Sat Aug 4 01:24:10 BST 2007
Adding other fields to the table will be done at some point. I'd like to
have a phone number field so there could be an option to call the number
directly. I'd also like a comments field for additional information. This
probably isn't going to happen for a while thoe since changing database
tables will break compatability with the existing databases. I want to
rewrite the entire database system at some point but that'll be a big job.
In the current system the maximum length of a point is 75 characters. If
you're hitting that limit try using abreviations if you can. For bus stops
you can use things like eb for east bound, wb for west bound, etc. Then if
you're using talks 3 you can use the dictionary to make it say the full
versions of these abreviations.
The id field is a 32 bit unsigned integer. The userid field is a 16 bit
unsigned integer. The id field is basically a unix time stamp. This means if
you're manually generating points you want to make sure the id doesn't start
using values that could overlap with the present time.
On Fri, 3 Aug 2007, Dave Mielke wrote:
> [quoted lines by Mikolaj Rotnicki on 2007/08/03 at 23:55 +0200]
>> I believe it is max. 75 characters.
> Would it be possible to add a description field to a point which would only be
> displayed on request? That way one could add additional data which a user can
> optionally request. For xample, each bus stop in my city has a phone number
> which one can call to find out when the next bus for each route that uses that
> stop will come. This is very useful information to have in the map as a blind
> person can't read it off the sign, but adding that kind of information to the
> point name often causes it to become too long for the field.
> Dave Mielke | 2213 Fox Crescent | I believe that the Bible is the
> Phone: 1-613-726-0014 | Ottawa, Ontario | Word of God. Please contact me
> EMail: dave at mielke.cc | Canada K2A 1H7 | if you're concerned about Hell.
> http://FamilyRadio.com/ | http://Mielke.cc/bible/
> Loadstone mailing list
> Loadstone at loadstone-gps.com
More information about the Loadstone