I need to store the geographical location in Progress database. Please let me know as to which would be the ideal data type which can be used to store this information.
Re: What is the ideal data type to use when storing latitude/longitude (Geo Co-ordina
Depends of geo system standart.
If it is wgs-84/UTM (m from equator) it can be integer even or decimal 2.
If it is angles (latitude/longitude) - decimal with a lot of decimals.
Actually geo task is not just coordinates but also geo operation like (is point inside region or not) or what objects are inside map window. This task ordinary requires to split geo data on square regions and use integer geo index for each poligon.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.