coord 包头

create or replace package COORD is
    RANGE_LON_MAX CONSTANT NUMBER := 137.8347;
    RANGE_LON_MIN CONSTANT NUMBER := 72.004;
    RANGE_LAT_MAX CONSTANT NUMBER := 55.8271;
    RANGE_LAT_MIN CONSTANT NUMBER := 0.8293;
    jzA CONSTANT NUMBER := 6378245.0;
    jzEE CONSTANT NUMBER := 0.00669342162296594323;

  FUNCTION LAT_OFFSET_0(x NUMBER ,y NUMBER) RETURN NUMBER;
  FUNCTION LAT_OFFSET_1(x NUMBER ,y NUMBER) RETURN NUMBER;
  FUNCTION LAT_OFFSET_2(x NUMBER ,y NUMBER) RETURN NUMBER;
  FUNCTION LAT_OFFSET_3(x NUMBER ,y NUMBER) RETURN NUMBER;

  FUNCTION LON_OFFSET_0(x NUMBER ,y NUMBER) RETURN NUMBER;   
  FUNCTION LON_OFFSET_1(x NUMBER ,y NUMBER) RETURN NUMBER;
  FUNCTION LON_OFFSET_2(x NUMBER ,y NUMBER) RETURN NUMBER;
  FUNCTION LON_OFFSET_3(x NUMBER ,y NUMBER) RETURN NUMBER;
   
  FUNCTION transformLat( x NUMBER, y NUMBER) RETURN NUMBER;
  FUNCTION transformLon( X NUMBER, Y NUMBER) RETURN NUMBER;

  FUNCTION OUTOFCHINA(LAT NUMBER, LON NUMBER) RETURN BOOLEAN;
  
  FUNCTION gcj02Encrypt(ggLat NUMBER, ggLon NUMBER) RETURN MDSYS.SDO_ORDINATE_ARRAY;
  FUNCTION gcj02Decrypt(gjLat NUMBER,gjLon NUMBER) RETURN MDSYS.SDO_ORDINATE_ARRAY;
  FUNCTION bd09Decrypt(bdLat NUMBER, bdLon NUMBER) RETURN MDSYS.SDO_ORDINATE_ARRAY;
  FUNCTION bd09Encrypt(ggLat NUMBER, ggLon NUMBER) RETURN MDSYS.SDO_ORDINATE_ARRAY;

    FUNCTION wgs2gd(geom SDO_GEOMETRY) RETURN SDO_GEOMETRY;
    FUNCTION gd2wgs(geom SDO_GEOMETRY) RETURN SDO_GEOMETRY;
    FUNCTION wgs2bd(geom SDO_GEOMETRY) RETURN SDO_GEOMETRY;
    FUNCTION gd2bd(geom SDO_GEOMETRY) RETURN SDO_GEOMETRY;
    FUNCTION bd2gd(geom SDO_GEOMETRY) RETURN SDO_GEOMETRY;
    FUNCTION bd2wgs(geom SDO_GEOMETRY) RETURN SDO_GEOMETRY;

end COORD;