1

13693261870

2024-10-14 a6fe405947004d6571806edabd8f14357e144cfa

 src/main/java/com/se/simu/helper/ShpHelper.java

@@ -3,14 +3,21 @@
import cn.hutool.core.io.FileUtil;
import cn.hutool.json.JSONArray;
import cn.hutool.json.JSONObject;
import com.se.simu.domain.SeField;
import com.se.simu.domain.SeLayer;
import com.se.simu.domain.dto.GeField;
import com.se.simu.domain.dto.GeLayer;
import lombok.extern.slf4j.Slf4j;
import org.gdal.ogr.*;
import org.gdal.osr.CoordinateTransformation;
import org.gdal.osr.SpatialReference;
import org.gdal.osr.osr;

import java.math.BigDecimal;
import java.sql.Timestamp;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.List;
import java.util.Map;
import java.util.Vector;

/**
 * ShapeFile帮助类
@@ -21,7 +28,18 @@
@Slf4j
@SuppressWarnings("ALL")
public class ShpHelper {
    public static boolean createShp(String filePath, SeLayer seLayer) {
    private static Vector<String> options;

    public static Vector<String> getOptions() {
        if (null == options) {
            options = new Vector<>();
            options.add("ENCODING=UTF-8");
        }

        return options;
    }

    public static boolean createShp(String filePath, Map<String, Object> map, SpatialReference sr, Double minx, Double miny, Double maxx, Double maxy) {
        Driver driver = null;
        DataSource dataSource = null;
        Layer layer = null;
@@ -32,20 +50,127 @@
            dataSource = driver.CreateDataSource(filePath, null);
            if (null == dataSource) return false;

            int geoType = getGeometryType(seLayer.getQueryType());
            layer = dataSource.CreateLayer(FileUtil.getName(filePath), seLayer.getDb().getSpatialReference(), geoType);
            layer = dataSource.CreateLayer(FileUtil.getName(filePath), sr, ogr.wkbPolygon, getOptions());
            if (null == layer) return false;

            createLayerFields(layer, seLayer.getFields());
            if (null != map) createFields(layer, map);

            Feature f = new Feature(layer.GetLayerDefn());
            Geometry g = createPolygon(sr, minx, miny, maxx, maxy);
            f.SetGeometry(g);
            if (null != map) setValues(f, map);

            layer.CreateFeature(f);

            return true;
        } catch (Exception ex) {
            log.error(ex.getMessage(), ex);
            return false;
        } finally {
            GdalHelper.delete(layer, dataSource, driver);
        }
    }

    private static void createFields(Layer layer,Map<String, Object> map) {
        for (String key : map.keySet()) {
            Object val = map.get(key);
            switch (val.getClass().getTypeName()) {
                //case "java.math.BigDecimal":
                case "java.lang.Double":
                case "double":
                    layer.CreateField(new FieldDefn(key, ogr.OFTReal));
                    break;
                case "java.lang.Long":
                case "long":
                    layer.CreateField(new FieldDefn(key, ogr.OFTInteger64));
                    break;
                case "java.lang.Integer":
                case "int":
                    layer.CreateField(new FieldDefn(key, ogr.OFTInteger));
                    break;
                //case "java.sql.Timestamp":
                //case "java.time.LocalDate":
                //    layer.CreateField(new FieldDefn(key, ogr.OFTDateTime));
                //    break;
                default:
                    layer.CreateField(new FieldDefn(key, ogr.OFTString));
                    break;
            }
        }
    }

    private static void setValues(Feature f, Map<String, Object> map) {
        for (String key : map.keySet()) {
            Object val = map.get(key);
            switch (val.getClass().getTypeName()) {
                case "java.lang.Double":
                case "double":
                    f.SetField(key, Double.parseDouble(val.toString()));
                    break;
                case "java.lang.Long":
                case "long":
                    f.SetField(key, Long.parseLong(val.toString()));
                    break;
                case "java.lang.Integer":
                case "int":
                    f.SetField(key, Integer.parseInt(val.toString()));
                    break;
                default:
                    f.SetField(key, val.toString());
                    break;
            }
        }
    }

    private static Geometry createPolygon(SpatialReference sr, Double minx, Double miny, Double maxx, Double maxy) {
        String epsg = sr.GetAuthorityCode(null);
        if (!("4326".equals(epsg) || "4490".equals(epsg))) {
            double[] dmin = fromWgs84(sr, minx, miny);
            double[] dmax = fromWgs84(sr, maxx, maxy);
            minx = dmin[0];
            miny = dmin[1];
            maxx = dmax[0];
            maxy = dmax[1];
        }

        Geometry ring = new Geometry(ogr.wkbLinearRing);
        ring.AddPoint_2D(minx, maxy);
        ring.AddPoint_2D(maxx, maxy);
        ring.AddPoint_2D(maxx, miny);
        ring.AddPoint_2D(minx, miny);
        ring.AddPoint_2D(minx, maxy);

        Geometry poly = new Geometry(ogr.wkbPolygon);
        poly.AddGeometry(ring);

        return poly;
    }

    public static boolean createShp(String filePath, GeLayer geLayer) {
        Driver driver = null;
        DataSource dataSource = null;
        Layer layer = null;
        try {
            driver = ogr.GetDriverByName("ESRI shapefile");
            if (null == driver) return false;

            dataSource = driver.CreateDataSource(filePath, null);
            if (null == dataSource) return false;

            int geoType = getGeometryType(geLayer.getQueryType());
            layer = dataSource.CreateLayer(FileUtil.getName(filePath), geLayer.getDb().getSpatialReference(), geoType, getOptions());
            if (null == layer) return false;

            createLayerFields(layer, geLayer.getFields());

            FeatureDefn featureDefn = layer.GetLayerDefn();
            for (int i = 0, c = seLayer.getData().size(); i < c; i++) {
            for (int i = 0, c = geLayer.getData().size(); i < c; i++) {
                Feature f = new Feature(featureDefn);
                JSONObject data = seLayer.getData().getJSONObject(i).getJSONObject("properties");
                setFeatureData(f, seLayer.getFields(), data);
                JSONObject data = geLayer.getData().getJSONObject(i).getJSONObject("properties");
                setFeatureData(f, geLayer.getFields(), data);

                JSONObject geom = seLayer.getData().getJSONObject(i).getJSONObject("geometry");
                Geometry g = createGeometry(seLayer, geom);
                JSONObject geom = geLayer.getData().getJSONObject(i).getJSONObject("geometry");
                Geometry g = createGeometry(geLayer, geom);
                f.SetGeometry(g);

                layer.CreateFeature(f);
@@ -60,26 +185,26 @@
        }
    }

    private static void setFeatureData(Feature f, List<SeField> fields, JSONObject data) {
    private static void setFeatureData(Feature f, List<GeField> fields, JSONObject data) {
        for (int i = 0, c = fields.size(); i < c; i++) {
            SeField seField = fields.get(i);
            switch (seField.getType()) {
            GeField geField = fields.get(i);
            switch (geField.getType()) {
                case "int":
                    f.SetField(i, data.getInt(seField.getName()));
                    f.SetField(i, data.getInt(geField.getName()));
                    break;
                case "long":
                    f.SetField(i, data.getLong(seField.getName()));
                    f.SetField(i, data.getLong(geField.getName()));
                    break;
                case "double":
                    f.SetField(i, data.getDouble(seField.getName()));
                    f.SetField(i, data.getDouble(geField.getName()));
                    break;
                case "datetime":
                    long date = data.getLong(seField.getName());
                    long date = data.getLong(geField.getName());
                    Timestamp time = new Timestamp(date);
                    setTimestamp(f, i, time);
                    break;
                default:
                    f.SetField(i, data.getStr(seField.getName()));
                    f.SetField(i, data.getStr(geField.getName()));
                    break;
            }
        }
@@ -95,7 +220,7 @@
    /**
     * 创建Geometry对象
     */
    private static Geometry createGeometry(SeLayer seLayer, JSONObject geom) {
    private static Geometry createGeometry(GeLayer geLayer, JSONObject geom) {
        String type = geom.getStr("type");
        JSONArray cs = geom.getJSONArray("coordinates");

@@ -151,16 +276,16 @@
        }
    }

    private static void createLayerFields(Layer layer, List<SeField> fields) {
    private static void createLayerFields(Layer layer, List<GeField> fields) {
        for (int i = 0, c = fields.size(); i < c; i++) {
            SeField f = fields.get(i);
            GeField f = fields.get(i);
            FieldDefn fd = new FieldDefn(f.getName(), getFieldType(f));

            layer.CreateField(fd, i);
        }
    }

    private static Integer getFieldType(SeField f) {
    private static Integer getFieldType(GeField f) {
        switch (f.getType()) {
            case "int":
                return ogr.OFTInteger;
@@ -174,4 +299,35 @@
                return ogr.OFTString;
        }
    }

    private String getEpsg(SpatialReference sr) {
        return sr.GetAuthorityCode(null);
    }

    /**
     * 转换为WGS84坐标
     */
    public static Geometry toWgs84(SpatialReference sr, double x, double y) {
        Geometry point = new Geometry(ogr.wkbPoint);
        point.AssignSpatialReference(sr);
        point.AddPoint(x, y);

        point.TransformTo(GdalHelper.SR4326);
        //point.SwapXY();

        return point;
    }

    /**
     * WGS84转换为目标坐标
     */
    public static double[] fromWgs84(SpatialReference sr, double x, double y) {
        // https://blog.csdn.net/weixin_34910922/article/details/129208661
        CoordinateTransformation ct = new CoordinateTransformation(GdalHelper.SR4326, sr);
        if (sr.IsProjected() != 1) {
            sr.SetAxisMappingStrategy(osr.OAMS_TRADITIONAL_GIS_ORDER);
        }

        return ct.TransformPoint(x, y);
    }
}