RE: Lat/Long storage?

2001-06-26 Thread Shankar Unni
NUMBER(8,5). You'll need around 5 digits after the decimal point. (Think GPS accuracy == 10 meters for high-grade, 100 m for dumbed-down civilian use. At the equator, that's 0.9 or 0.0009 degrees respectively. At higher latitudes, that'd be correspondingly less.) If you value accuracy, DON'T

RE: Lat/Long storage?

2001-06-25 Thread Johnny Withers
mysql> desc zipcodes; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(10) unsigned | | PRI | NULL|