Geocoord (geocoord)
- Juan Tomás Alonso Nieto (Deactivated)
- Former user (Deleted)
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 |
Example
Our geohash_strings column contains strings that we want to transform into geocoord data type.
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 (geocoords) containing the same geohash strings but with the geocoord data type.
How does it work in LINQ?
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.
Copy the following LINQ script and try the above example on the my.upload.geolocation.data table.
from my.upload.geolocation.data
select split(message, ";", 1) as geohash_strings
select geocoord(geohash_strings) as geocoords