Android Question MS SQL Geometry data type

Rusty

Well-Known Member
Licensed User
Does anyone know how to create (within B4a) the Geometry binary data type that Microsoft uses for its geometry definition?
In SQL, it can be created as:
B4X:
DECLARE @g geography;
SET @g = geography::STGeomFromText('POINT(-102.9035210 38.4422200 6203)', 4326);
SELECT @g.Lat;
in the above example, POINT is defining the Longitude, Latitude and Altitude of a GPS coordinate. The Geometry data type allows a lot of manipulation/plotting capabilities.
I can get the information as Longitude, Latitude and Altitude using the GPS functions within B4a/android, but would like to create one data field to contain all the information, like MS SQL does.
Any thoughts/ideas are appreciated.
Rusty
 
Top