Tuesday 2 January 2018

Add a geometry column for fetching lat long using geojson in sql server

////////
ALTER TABLE TableName  ADD GeoLoc geometry

UPDATE [dbo].[TableName]

SET [GeoLoc] = geometry::STPointFromText('POINT(' + CAST([Long] AS VARCHAR(20)) + ' ' + CAST([Lat] AS VARCHAR(20)) + ')', 4326)
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...