Generates a geocoord from a string as long as it is a valid representation of one of the two supported coordinate systems:
- Latlon - Based on latitude and longitude and represented as sexagesimal coordinates, using degrees, minutes, seconds and position (for example: 40°24'46.3"N 3°41'43.8"W).
- Geohash - Hash representation of coordinates, called geohash (for example: ezjmguvj).
How does it work in the search window?
Select Create column in the search window toolbar, then select the Geocoord operation. You only need to specify one argument:
|Coords string (mandatory)||string|
The data type of the new column values is geocoord.
Our Geohash strings column contains strings that we want to transform into geocoord data type. Once in the new data type, the new column can be used as input for other operations like Latitude (latitude) and Longitude (longitude), for example.
Click Create column and select the Geocoord operation. Then, select Geohash strings as the Coords string argument. Click Create Column.
The result is a new column containing the same geohash strings but with the geocoord data type.
How does it work in LINQ?
Use the operator
as... and add the operation syntax to create the new column. The syntax is as follows:
Copy the following LINQ script and try the above example on the
from demo.ecommerce.data select mmlatitude(clientIpAddress) as latitude, mmlongitude(clientIpAddress) as longitude, latlon(latitude, longitude) as Geocoord, geohashstr(Geocoord) as `Geohash strings`, geocoord(`Geohash strings`) as usrcol1