Location point

This page contains UPDATE and DELETE queries

This query changes Location point to Reference point

UPDATE geopoint
SET
pointtypeenum_guid = '{BaseData-PointType-00000000000-00001}'
WHERE
pointtypeenum_guid =  '{TestData-PointType-00000000000-00009}'

DELETE FROM imsmaenum
WHERE
imsmaenum.enumcategory =  'Point Type' AND
imsmaenum.enumvalue =  'Location Point' AND
imsmaenum.imsmaenum_guid =  '{TestData-PointType-00000000000-00009}'