springboot中使用gdal将表中的空间数据转shapefile文件
代码：
java">// 样本导出-将样本表导出为shapefile，复制样本shp文件到临时目录下 sampleDir是文件夹pathpublic void setYbShapeFile(Yb yb, File sampleDir) {// 创建 前时项 和 后时项 文件夹File ybDir = new File(sampleDir, "样本");ybDir.mkdirs();String tableName = yb.getLabelLayerName();boolean isYbLabelName = tableName != null && !tableName.equals("");String shapefileName = new File(ybDir, tableName + ".shp").getAbsolutePath();if (isYbLabelName) {// 查询数据SqlRowSet resultSet = jdbcTemplate.queryForRowSet("SELECT objectid, ST_AsText(shape) AS shape FROM " + tableName);// 使用GDAL库将查询到的数据转换为Shapefileogr.RegisterAll();Driver driver = ogr.GetDriverByName("ESRI Shapefile");if (driver == null) {throw new RuntimeException("GDAL 驱动加载失败: ESRI Shapefile");}DataSource ds = null;Layer layer = null;try {ds = driver.CreateDataSource(shapefileName);if (ds == null) {throw new RuntimeException("无法创建 Shapefile 数据源: " + shapefileName);}// 定义坐标参考系统（以 WGS 84 为例）SpatialReference srs = new SpatialReference();srs.ImportFromEPSG(4326);// 创建图层并指定参考系统layer = ds.CreateLayer(tableName, srs, ogr.wkbUnknown);if (layer == null) {throw new RuntimeException("无法创建图层: " + tableName);}// 定义字段，根据实际数据库字段调整layer.CreateField(new FieldDefn("objectid", ogr.OFTInteger));// 遍历结果集，添加要素到图层while (resultSet.next()) {Feature feature = new Feature(layer.GetLayerDefn());feature.SetField("objectid", resultSet.getInt("objectid"));// 获取几何数据并设置String wktGeometry = resultSet.getString("shape");if (wktGeometry != null && !wktGeometry.isEmpty()) {Geometry geom = ogr.CreateGeometryFromWkt(wktGeometry);if (geom == null) {throw new RuntimeException("无效的WKT几何: " + wktGeometry);}feature.SetGeometry(geom);}// 添加Feature到图层if (layer.CreateFeature(feature) != 0) {throw new RuntimeException("无法创建要素");}feature.delete(); // 释放资源}// 同步数据到磁盘layer.SyncToDisk();} catch (Exception e) {e.printStackTrace();throw new RuntimeException("导出Shapefile时发生错误: " + e.getMessage(), e);} finally {if (ds != null) {ds.delete(); // 确保数据源关闭}if (layer != null) {layer.delete(); // 显式释放图层资源}}}}
示例表：
转为shp文件后：
