[ale] Decimal Degrees in MySQL

[Christopher Fowler]

I actually used a signed double(10,2)

It seems to work for now.


On Fri, 2008-03-14 at 10:05 -0400, Chris Kleeschulte wrote:
> 
> I am assuming you mean decimal degrees as it relates to GIS to express
> lat and long coordinates. Using a floats can be really really tricky
> if resolution of this magnitude is required. Computers cannot
> represent certain floats accurately just as humans have problems
> computing PI accurately. I would use a string or convert to an integer
> where there is not a chance to loose resolution.
> 
> 
> 
> 
> Chris
> 
> 
> 
> 
> On Mar 12, 2008, at 4:11 PM, Christopher Fowler wrote:
> 
> > Can someone tell me the best way to store decimal degrees in MySQL?
> > 
> > 
> > I want to create columns named ddlat and ddlon.  I'm not sure if I
> > should use a float,double, or just a string.
> > 
> > 
> > Decimal Degrees is formated like this:
> > 
> > 
> > (-)XXX.XXXXXX
> > 
> > 
> > Chris
> > 
> > 
> > 
> > 
> > _______________________________________________
> > Ale mailing list
> > Ale at ale.org
> > http://mail.ale.org/mailman/listinfo/ale
>