Rusty Well-Known Member Licensed User Longtime User Apr 21, 2015 #1 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: Code: Copy 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
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: Code: Copy 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
S samperizal Active Member Licensed User Longtime User Apr 21, 2015 #2 review https://dev.mysql.com/doc/refman/5.0/en/spatial-analysis-functions.html https://dev.mysql.com/doc/refman/5.0/en/gis-property-functions.html Upvote 0
review https://dev.mysql.com/doc/refman/5.0/en/spatial-analysis-functions.html https://dev.mysql.com/doc/refman/5.0/en/gis-property-functions.html