Table of Contents | ||||||
---|---|---|---|---|---|---|
|
Description
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:
Argument | Data type |
---|---|
Coords string mandatory | string |
The data type of the new column values is geocoord.
...
Example
The examples in this article use values in a data table generated from the following CSV file.
...
Use the operator select
... as
... and add the operation syntax to create the new column. The syntax is as follows:
geocoord(string)
Example
Note that you must have uploaded the following CSV file to your Devo domain as explained above to try out this example.
View file | ||
---|---|---|
|
Copy the following LINQ script and try the above example on the my.upload.geolocation.data
table.
Code Block |
---|
from my.upload.geolocation.data select split(message, ";", 1) as geohash_strings select geocoord(geohash_strings) as geocoords |