Geo point field type

リリースバージョン: Australia

更新日 2026年03月12日

所要時間：2分

The geo point data type stores longitude and latitude coordinates.

You can store longitude and latitude coordinates by adding a geo point data type field to any table. For example, you can define a geo point field to store a longitude and latitude pair to help technicians find the location of a part in a warehouse.

Function fields provide several glidefunction operations for working with geo point fields.

Calculate the distance between geo points using distance_sphere() in a function field and use it to order records in a list based on how far away the warehouse is. For example:
```
glidefunction:distance_sphere(geopointField1, geopointField2)
```
Convert longitude and latitude columns to a geo point field using get_longitude() and get_latitude() in a function field. For example:
```
glidefunction:get_latitude(u_geo_point_field)
```
```
glidefunction:get_longitude(u_geo_point_field)
```
Convert a geo point field or any valid numeric values or columns into longitude and latitude columns or values using to_geopoint() in a function field. For example:
```
glidefunction:to_geopoint(u_long_column, u_lat_column)
```

See Function field.

Values for geo points are in longitude, latitude format where:

Both longitude and latitude are restricted to 6 decimal places of precision. For example, “80.206458”, “25.767242”.
The longitude range is [-180, 180].
The latitude range is [-90, 90].
Values entered outside the ranges for longitude or latitude are normalized to values inside their respective ranges.