Skip to content

Instantly share code, notes, and snippets.

@arekgotfryd

arekgotfryd/Fill Geometry::Point column with Point geometry created from coordinates which exists in the same table

Created October 11, 2018 08:04
Show Gist options
  • Save arekgotfryd/c3978216f773049731e7ada8aa5e46d2 to your computer and use it in GitHub Desktop.
Save arekgotfryd/c3978216f773049731e7ada8aa5e46d2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Fill Geometry::Point column with Point geometry created from coordinates which exists in the same table
UPDATE [YOUR_TABLE] SET [POINT_GEOM] = geometry::STPointFromText('POINT(' + CAST([X] AS VARCHAR(20)) + ' ' + CAST([Y] AS VARCHAR(20)) + ')', 4326);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment