use conservation_resources

BEGIN TRANSACTION updateCliGenStations

UPDATE r2gis.cligen_stations SET point=geometry::STGeomFromText('POINT( -171.71667 -2.76667 )', 4326) WHERE ogr_fid = 60;
UPDATE r2gis.cligen_stations set point=geometry::STGeomFromText('POINT (144.81667 13.55)', 4326) WHERE ogr_fid = 61;
UPDATE r2gis.cligen_stations set point=geometry::STGeomFromText('POINT (134.46667 7.31667)', 4326) WHERE ogr_fid = 63;
UPDATE r2gis.cligen_stations set point=geometry::STGeomFromText('POINT (167.71667 8.71667)', 4326) WHERE ogr_fid = 64;
UPDATE r2gis.cligen_stations set point=geometry::STGeomFromText('POINT (171.36667 7.06667)', 4326) WHERE ogr_fid = 65;
UPDATE r2gis.cligen_stations SET point=geometry::STGeomFromText('POINT(-170.71667 -14.31667)', 4326) WHERE ogr_fid = 66;
UPDATE r2gis.cligen_stations set point=geometry::STPointFromText('POINT( 158.21667 6.95 )', 4326) WHERE ogr_fid = 67;
UPDATE r2gis.cligen_stations set point=geometry::STGeomFromText('POINT (151.85 7.45)', 4326) WHERE ogr_fid = 68;
UPDATE r2gis.cligen_stations set point=geometry::STGeomFromText('POINT (166.63333 19.26667)', 4326) WHERE ogr_fid = 69;
UPDATE r2gis.cligen_stations set point=geometry::STGeomFromText('POINT (138.11667 9.51667)', 4326) WHERE ogr_fid = 70;

COMMIT TRANSACTION updateCliGenStations