geoc_transform_lat.sql 530 B

123456789101112131415
  1. CREATE OR REPLACE FUNCTION "public"."geoc_transform_lat"("x" numeric, "y" numeric)
  2. RETURNS "pg_catalog"."numeric" AS $BODY$
  3. DECLARE
  4. ret numeric;
  5. BEGIN
  6. ret := -100 + 2 * x + 3 * y + 0.2 * y * y + 0.1 * x * y + 0.2 * sqrt(abs(x));
  7. ret := ret + (20 * sin(6 * x * PI()) + 20 * sin(2 * x * PI())) * 2 / 3;
  8. ret := ret +(20 * sin(y * PI()) + 40 * sin(y / 3 * PI())) * 2 / 3;
  9. ret := ret +(160 * sin(y / 12 * PI()) + 320 * sin(y * PI() / 30)) * 2 / 3;
  10. return ret;
  11. END;
  12. $BODY$
  13. LANGUAGE plpgsql VOLATILE
  14. COST 100