修改 获取Excel模板 方法

13693261870

2023-11-28 4393d934ba300601a91084763616ea80379b550e

 src/main/java/com/moon/server/helper/GeoHelper.java

@@ -5,9 +5,14 @@
import org.apache.commons.logging.LogFactory;
import org.gdal.osr.SpatialReference;
import org.geotools.geometry.DirectPosition2D;
import org.geotools.geometry.jts.JTS;
import org.geotools.referencing.CRS;
import org.geotools.referencing.GeodeticCalculator;
import org.locationtech.jts.geom.Geometry;
import org.locationtech.jts.io.WKTReader;
import org.opengis.referencing.crs.CRSAuthorityFactory;
import org.opengis.referencing.crs.CoordinateReferenceSystem;
import org.opengis.referencing.operation.MathTransform;

import java.awt.geom.Point2D;

@@ -17,6 +22,10 @@
 * @date 2023-09-14
 */
public class GeoHelper {
    public static SpatialReference sr4326;

    public static SpatialReference sr4490;

    public static SpatialReference sr104903;

    public final static double MOON_RADIUS = 1738000;
@@ -30,6 +39,12 @@
     */
    public static void initSr() {
        try {
            sr4326 = new SpatialReference();
            sr4326.ImportFromEPSG(StaticData.I4326);

            sr4490 = new SpatialReference();
            sr4490.ImportFromEPSG(StaticData.I4490);

            sr104903 = new SpatialReference(StaticData.MOON_2000_WKT);

            crs104903 = CRS.parseWKT(StaticData.MOON_2000_WKT);
@@ -109,4 +124,24 @@

        return gc.getDestinationGeographicPoint();
    }

    /**
     * 坐标转换
     */
    public static double[] csTransform(double x, double y, int epsg) throws Exception {
        CRSAuthorityFactory factory = CRS.getAuthorityFactory(true);
        CoordinateReferenceSystem target = factory.createCoordinateReferenceSystem("EPSG:4326");

        CoordinateReferenceSystem sourceCrs = CRS.decode("EPSG:" + epsg);
        CoordinateReferenceSystem targetCrs = CRS.decode("EPSG:4326");
        MathTransform transform = CRS.findMathTransform(sourceCrs, targetCrs, true);

        WKTReader reader = new WKTReader();
        Geometry geometry = reader.read("POINT (" + x + " " + y + ")");
        geometry.setSRID(epsg);

        Geometry geo = JTS.transform(geometry, transform);

        return new double[]{geo.getCoordinate().x, geo.getCoordinate().y};
    }
}