Android Question MS SQL Geometry data type

Discussion in 'Android Questions' started by Rusty, Apr 21, 2015.

  1. Rusty

    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:
    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.
  2. samperizal

    samperizal Active Member Licensed User

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice