What is the ideal data type to use when storing latitude/longitude (Geo Co-ordinates)

[ss_kiran]

Hello,

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.

Thanks
Kiran Shankar

 

[LarryD]

Re: What is the ideal data type to use when storing latitude/longitude (Geo Co-ordina

We use decimal with a scale of 6 decimal places. This (I believe) gives you a precision of ± 0.08 m.

Latitudes south of the equator are negative, and longitudes west of the prime meridian are negative.

 

[MaximMonin]

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.