下面的geojson导入postgis,shp导入postgis,postgis导出shp,postgis导出geojson已经封装好
maven里导入对应的jar(复制pom相应代码),复制PostgisUtility.java和PostgisDataStore.java文件,就可以按照app.java里的方式调用这两个类文件里封装完的四个方法。这四个方法代码如下:
validateshp,validategeojson方法为验证路径有效性,可不调用或者自己判断,否则java可能会报文件路径异常。
pom文件
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>iwuang</groupId>
<artifactId>geotools4postgis</artifactId>
<version>1.0-SNAPSHOT</version>
<name>geotools4postgis</name>
<!-- FIXME change it to the project's website -->
<url>https://github.com/yieryi/geotools4postgis</url>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.7</maven.compiler.source>
<maven.compiler.target>1.7</maven.compiler.target>
<geotools.version>21-SNAPSHOT</geotools.version>
<postgresql.version>42.1.4</postgresql.version>
</properties>
<repositories>
<repository>
<id>maven2-repository.dev.java.net</id>
<name>Java.net repository</name>
<url>http://download.java.net/maven/2</url>
</repository>
<repository>
<id>osgeo</id>
<name>Open Source Geospatial Foundation Repository</name>
<url>http://download.osgeo.org/webdav/geotools/</url>
</repository>
<repository>
<snapshots>
<enabled>true</enabled>
</snapshots>
<id>boundless</id>
<name>Boundless Maven Repository</name>
<url>http://repo.boundlessgeo.com/main</url>
</repository>
<repository>
<id>maven</id>
<name>Maven Repository Switchboard</name>
<layout>default</layout>
<url>http://repo1.maven.org/maven2</url>
<snapshots>
<enabled>false</enabled>
</snapshots>
</repository>
<repository>
<id>osgeo</id>
<name>Open Source Geospatial Foundation Repository</name>
<url>http://download.osgeo.org/webdav/geotools/</url>
</repository>
</repositories>
<dependencies>
<dependency>
<groupId>org.geotools</groupId>
<artifactId>gt-shapefile</artifactId>
<version>${geotools.version}</version>
</dependency>
<dependency>
<groupId>org.geotools</groupId>
<artifactId>gt-swing</artifactId>
<version>${geotools.version}</version>
</dependency>
<dependency>
<groupId>org.geotools</groupId>
<artifactId>gt-main</artifactId>
<version>${geotools.version}</version>
</dependency>
<dependency>
<groupId>org.geotools.jdbc</groupId>
<artifactId>gt-jdbc-postgis</artifactId>
<version>${geotools.version}</version>
</dependency>
<dependency>
<groupId>org.geotools</groupId>
<artifactId>gt-metadata</artifactId>
<version>${geotools.version}</version>
</dependency>
<dependency>
<groupId>org.geotools</groupId>
<artifactId>gt-referencing</artifactId>
<version>${geotools.version}</version>
</dependency>
<dependency>
<groupId>org.geotools</groupId>
<artifactId>gt-geojson</artifactId>
<version>${geotools.version}</version>
</dependency>
<dependency>
<groupId>org.geotools</groupId>
<artifactId>gt-epsg-hsql</artifactId>
<version>${geotools.version}</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.alibaba/fastjson -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.47</version>
</dependency>
<!--非必需,简化I/O操作-->
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.6</version>
</dependency>
<dependency>
<groupId>org.postgis</groupId>
<artifactId>postgis-driver</artifactId>
<version>1.0</version>
</dependency>
</dependencies>
</project>
PostgisDataStore类
@Data
public class PostgisDataStore {
private static DataStore postgisDataStore = null;
private static String dbtype = null;
private static String host = null;
private static String port = null;
private static String database = null;
private static String schema = null;
private static String username = null;
private static String password = null;
public PostgisDataStore() {
}
public static DataStore getInstance() {
if (postgisDataStore == null) {
Map<String, Object> params = new HashMap<String, Object>();
params.put(PostgisNGDataStoreFactory.DBTYPE.key, dbtype);
params.put(PostgisNGDataStoreFactory.HOST.key, host);
params.put(PostgisNGDataStoreFactory.PORT.key, new Integer(port));
params.put(PostgisNGDataStoreFactory.DATABASE.key, database);
params.put(PostgisNGDataStoreFactory.SCHEMA.key, schema);
params.put(PostgisNGDataStoreFactory.USER.key, username);
params.put(PostgisNGDataStoreFactory.PASSWD.key, password);
try {
postgisDataStore = DataStoreFinder.getDataStore(params);
logger.info("\nPostgisDataStore 初始化geotools中的 Datastore成功\n");
} catch (IOException e) {
logger.error("\nPostgisDataStore 初始化geotools中的 Datastore失败\n");
logger.error(e.getMessage());
}
}
return postgisDataStore;
}
}
shp文件导入到postgis数据库中
public static boolean importShp(String shppath, String tablename) throws IOException {
if (!validateShp(shppath, true)) return false;
DataStore pgDatastore = PostgisDataStore.getInstance();
ShapefileDataStore shapefileDataStore = null;
shapefileDataStore = new ShapefileDataStore(new File(shppath).toURI().toURL());
shapefileDataStore.setCharset(Charset.forName("utf-8"));
FeatureSource featureSource = shapefileDataStore.getFeatureSource();
FeatureCollection featureCollection = featureSource.getFeatures();
SimpleFeatureType shpfeaturetype = shapefileDataStore.getSchema();
SimpleFeatureTypeBuilder typeBuilder = new SimpleFeatureTypeBuilder();
typeBuilder.init(shpfeaturetype);
typeBuilder.setName(tablename);
SimpleFeatureType newtype = typeBuilder.buildFeatureType();
pgDatastore.createSchema(newtype);
logger.info("\npostgis创建数据表成功");
FeatureIterator iterator = featureCollection.features();
FeatureWriter<SimpleFeatureType, SimpleFeature> featureWriter = pgDatastore.getFeatureWriterAppend(tablename, Transaction.AUTO_COMMIT); while (iterator.hasNext()) {
Feature feature = iterator.next();
SimpleFeature simpleFeature = featureWriter.next();
Collection<Property> properties = feature.getProperties();
Iterator<Property> propertyIterator = properties.iterator();
while (propertyIterator.hasNext()) {
Property property = propertyIterator.next();
simpleFeature.setAttribute(property.getName().toString(), property.getValue());
}
featureWriter.write();
}
iterator.close();
featureWriter.close();
shapefileDataStore.dispose();
pgDatastore.dispose();
logger.info("\nshp导入postgis成功");
return true;
}
把geojson格式数据导入到postgsi,存储坐标和所有属性
public static boolean importGeojson(String geojsonpath, String tablename) throws IOException {
if (!validateGeojson(geojsonpath, true)) return false;
DataStore pgDatastore = PostgisDataStore.getInstance();
FeatureJSON featureJSON = new FeatureJSON();
FeatureCollection featureCollection = featureJSON.readFeatureCollection(new FileInputStream(geojsonpath));
SimpleFeatureType geojsontype = (SimpleFeatureType) featureCollection.getSchema();
SimpleFeatureTypeBuilder typeBuilder = new SimpleFeatureTypeBuilder();
typeBuilder.init(geojsontype);
typeBuilder.setName(tablename);
SimpleFeatureType newtype = typeBuilder.buildFeatureType();
pgDatastore.createSchema(newtype);
FeatureIterator iterator = featureCollection.features();
FeatureWriter<SimpleFeatureType, SimpleFeature> featureWriter = pgDatastore.getFeatureWriterAppend(tablename, Transaction.AUTO_COMMIT); while (iterator.hasNext()) {
Feature feature = iterator.next();
SimpleFeature simpleFeature = featureWriter.next();
Collection<Property> properties = feature.getProperties();
Iterator<Property> propertyIterator = properties.iterator();
while (propertyIterator.hasNext()) {
Property property = propertyIterator.next();
simpleFeature.setAttribute(property.getName().toString(), property.getValue());
}
featureWriter.write();
}
iterator.close();
featureWriter.close();
pgDatastore.dispose();
return true;
}
导出postgis数据库中的指定矢量表为shp文件
public static boolean exportShp(String tablename, String shpPath) throws IOException, FactoryException {
DataStore pgDatastore = PostgisDataStore.getInstance();
FeatureSource featureSource = pgDatastore.getFeatureSource(tablename);
FeatureCollection featureCollection = featureSource.getFeatures();
FeatureIterator<SimpleFeature> iterator = featureCollection.features();
SimpleFeatureType pgfeaturetype = pgDatastore.getSchema(tablename);
File file = new File(shpPath);
if (!validateShp(shpPath, false)) return false;
Map<String, Serializable> params = new HashMap<String, Serializable>();
params.put(ShapefileDataStoreFactory.URLP.key, file.toURI().toURL());
ShapefileDataStore shpDataStore = (ShapefileDataStore) new ShapefileDataStoreFactory().createNewDataStore(params);
String srid = pgfeaturetype.getGeometryDescriptor().getUserData().get("nativeSRID").toString();
SimpleFeatureTypeBuilder typeBuilder = new SimpleFeatureTypeBuilder();
typeBuilder.init(pgfeaturetype);
if (!srid.equals("0")) {
CoordinateReferenceSystem crs = CRS.decode("EPSG:" + srid, true);
typeBuilder.setCRS(crs);
}
pgfeaturetype = typeBuilder.buildFeatureType();
shpDataStore.setCharset(Charset.forName("utf-8"));
shpDataStore.createSchema(pgfeaturetype);
FeatureWriter<SimpleFeatureType, SimpleFeature> featureWriter = shpDataStore.getFeatureWriter(shpDataStore.getTypeNames()[0], AUTO_COMMIT);
while (iterator.hasNext()) {
Feature feature = iterator.next();
SimpleFeature simpleFeature = featureWriter.next();
Collection<Property> properties = feature.getProperties();
Iterator<Property> propertyIterator = properties.iterator();
while (propertyIterator.hasNext()) {
Property property = propertyIterator.next();
if (geomfield(property.getName().toString())) {
simpleFeature.setAttribute("the_geom", property.getValue());
continue;
}
simpleFeature.setAttribute(property.getName().toString(), property.getValue());
}
featureWriter.write();
}
iterator.close();
featureWriter.close();
pgDatastore.dispose();
return true;
}
导出postgis数据库中的指定矢量表为geojson文件
public static boolean exportGeojson(String tablename, String geojsonPath) throws IOException, FactoryException {
DataStore pgDatastore = PostgisDataStore.getInstance();
FeatureSource featureSource = pgDatastore.getFeatureSource(tablename);
FeatureCollection featureCollection = featureSource.getFeatures();
FeatureJSON featureJSON = new FeatureJSON();
File file = new File(geojsonPath);
if (!file.exists()) {
file.createNewFile();
}
OutputStream outputStream = new FileOutputStream(file, false);
featureJSON.writeFeatureCollection(featureCollection, outputStream);
pgDatastore.dispose();
return true;
}