JAVA 实现读取shp文件字段，自动创建pg数据库表，最后通过rest发布geoserver图层

JAVA 自动创建PG数据库表及Geoserver图层发布

原创

已于 2022-08-12 15:11:44 修改 · 3.3k 阅读

17 ·

CC 4.0 BY-SA版权

文章标签：

#java #postgresql #geoserver

于 2022-04-29 11:44:22 首次发布

本文介绍了使用JAVA读取SHP文件字段，进而自动创建POSTGRESQL数据库表，然后通过REST接口发布GEOSERVER图层的详细过程，包括引入相关依赖、关键代码实现及发布后的验证步骤。

java 实现读取shp文件字段，自动创建pg数据库表，最后通过rest发布geoserver图层

1.读取shp文件字段，创建数据库表

引入geotools依赖：

<!-- geotools主要依赖 -->
        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-metadata</artifactId>
            <version>2.7.2</version>
        </dependency>
        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-referencing</artifactId>
            <version>2.7.2</version>
        </dependency>
        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-epsg-wkt</artifactId>
            <version>2.7.2</version>
        </dependency>
        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-shapefile</artifactId>
            <version>2.7.2</version>
        </dependency>
        <dependency>
            <groupId>com.vividsolutions</groupId>
            <artifactId>jts</artifactId>
            <version>1.11</version>
        </dependency>
        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-data</artifactId>
            <version>2.7.2</version>
        </dependency>
        <dependency>
            <groupId>javax.measure</groupId>
            <artifactId>jsr-275</artifactId>
            <version>1.0.0</version>
        </dependency>
        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-api</artifactId>
            <version>2.7.2</version>
        </dependency>
        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-main</artifactId>
            <version>2.7.2</version>
        </dependency>
        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-swing</artifactId>
            <version>2.7.2</version>
        </dependency>
        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-jdbc</artifactId>
            <version>2.7.2</version>
        </dependency>
        <dependency>
            <groupId>org.geotools.jdbc</groupId>
            <artifactId>gt-jdbc-postgis</artifactId>
            <version>2.7.2</version>
        </dependency>
        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-opengis</artifactId>
            <version>2.7.2</version>
        </dependency>
        <dependency>
            <groupId>org.geotools</groupId>
            <artifactId>gt-epsg-hsql</artifactId>
            <version>2.7.2</version>
        </dependency>

功能实现代码：

@Service
public class LayerService {
   
   

	@Resource
    private GeoserverDao geoserverDao;

	@Resource
    private GeoServer geoServer;

	@Transactional
    public void addLayer(String filePath) throws Exception{
   
   
        File dir = new File(filePath);
        File[] subFiles = dir.listFiles();
        if (null!=subFiles){
   
   
            for (File subFile : subFiles){
   
   
                if (subFile.getName().endsWith(".shp")){
   
   
                    ShapefileDataStore shpDataStore = new ShapefileDataStore(subFile.toURI().toURL());
                    shpDataStore.setStringCharset(Charset.forName("GBK"));
                    // 获取地图要素
                    FeatureSource<SimpleFeatureType, SimpleFeature> featureSource = shpDataStore.getFeatureSource();