| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
Description
Returns the longitude value corresponding to a given geocoord.
How does it work in the search window?
...
from my.upload.geolocation.dataselect split(message, ";", 1) as geohash_strings
...
We want to get the longitude values corresponding to the geocoord strings in the geohash_strings column. First, we must convert the strings into geocoord data type, then use the Longitude operation to get the corresponding longitude values.
Step 1: Transform the geocoord strings into data type geocoord
...
Use the operator select... as... and add the operation syntax to create the new column. This is the syntax of the Longitude operation:
longitude(geocoord)
Example
| Note |
|---|
Note that you must have uploaded this 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.
| Code Block |
|---|
from my.upload.geolocation.data select split(message, ";", 1) as geohash_strings select geocoord(geohash_strings) as geocoords, longitude(geocoords) as longitude |