Table of Contents | ||||||
---|---|---|---|---|---|---|
|
Description
Returns the latitude value corresponding to a given geocoord.
How does it work in the search window?
...
from my.upload.geolocation.data
select split(message, ";", 1) as geohash_strings
...
We want to get the latitude values corresponding to the geocoord strings in the geohash_strings column. First, we must convert the strings into geocoord data type, then use the Latitude operation to get the corresponding latitude 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 Latitude operation:
latitude(geocoord)
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, latitude(geocoords) as latitude |