How to define a field of type GEOGRAPHY in GeneXus. This field is from SQL Server 2012. It is with this that we calculate the distances between two geographic coordinates (Latitude and Longitude)
Can anyone tell me?
How to define a field of type GEOGRAPHY in GeneXus. This field is from SQL Server 2012. It is with this that we calculate the distances between two geographic coordinates (Latitude and Longitude)
Can anyone tell me?
GeneXus has a semantic domain called Geolocation
This domain, when linked to an attribute, does not create the GEOGRAPHY data type in SQL Server 2012, because as the tool is multi-bank, to maintain consistency, the information is stored in character format, with a comma separating the latitude and longitude, eg "-36.123, -57.235".
For the distance between coordinates, you can use the GetDistance method of the GeoLocationAPI API .
If you need more support, you can contact me by email [email protected]
I hope I have helped.
From the version GeneXus 15 begins to support the type of native Geography data from different DBMS.
Here has more information.