Page Comparison

...

Transform a given geocoord into a string following a specific format (:type:value), where type is the geocoord type (latlon or geohash). For example:

• For geocoord 78z0, you will get :geohash:78z0

• For geocoord 36°N 20°W, you will get :latlon:36°N 20°W

...

This operation needs only one argument:

The data type of the new column is geocoord.

...

from my.upload.sample.data
select split(message, ";", 8) as geocoordStrings

...

We want to represent the strings in the geocoordStrings column in the format :type:value. First, we must transform the strings to data type geocoord.

Step 1: Transform the geocoord strings into data type geocoord

...

• reprgeo(geocoord)

• reprgeo(geocoord(string))

Example

You must have uploaded the following CSV file to your Devo domain as explained above to try out the following example.

Copy the following LINQ script and try the above example on the my.upload.geolocation.data table.