java+GDAL
0、环境配置
- 下载GDAL:
下载地址:GISInternals Support Site 建议使用最新版本(支持FileGDB) - 本地部署:
- 解压后将GDAL的bin文件夹下所有的dll(不包括bin目录下的文件夹)和bin/gdal/java下的dll文件拷贝到jdk安装路径的bin目录下
- 将\bin\gdal\plugins-external内的ogr_FileGDB.dll拷贝到\bin\gdal\plugins下
- 将GDAL的bin目录添加到
Path
环境变量
- \bin\gdal\plugins 目录添加到环境变量,变量名为
GDAL_DRIVER_PATH
- 将proj.db所在路径添加到环境变量,变量名为
PROJ_LIB
- 开发流程
1.在IDEA里导入本地jar包
2.编写代码
package com.lulie.gdal;
import org.gdal.gdal.gdal;
import org.gdal.ogr.ogr;
//测试案例
class GdalDemo {
//获取所有驱动的名称并打印
public void printDriver() {
gdal.AllRegister();
int count = ogr.GetDriverCount();
for (int i = 0; i < count; i++) {
String driverName = ogr.GetDriver(i).getName();
System.out.print(driverName + "\t");
}
gdal.GDALDestroyDriverManager();
}
public static void main(String[] args) {
GdalDemo demo = new GdalDemo();
demo.printDriver();
}
}
结果:
注意:
遇到 ERROR 1: Can’t load requested DLL: E:\gdal\bin\gdal\plugins\gdal_GEOR.dll 错误,可以不管。
案例1-打开shp
package com.lulie.gdal;
import org.gdal.gdal.gdal;
import org.gdal.ogr.*;
public class GdalDemo_shp {
public String opeanShp(String strVectorFile) {
//准备,注册驱动
ogr.RegisterAll();
//设置支持中文
gdal.SetConfigOption("GDAL_FILENAME_IS_UTF8","YES");
gdal.SetConfigOption("SHAPE_ENCODING","CP936");
//获取驱动
String shpDriverName = "ESRI Shapefile";
Driver shpDriver =ogr.GetDriverByName(shpDriverName);
if (shpDriver == null) {
throw new RuntimeException(shpDriverName+ " 驱动不可用!\n");
}
//获取数据源
DataSource shpDataSource = ogr.Open(strVectorFile,0);
if (shpDataSource == null)
{
throw new RuntimeException("打开文件【"+ strVectorFile + "】失败!" );
}
//获取图层0
Layer shpLayer = shpDataSource.GetLayerByIndex(0);
if (shpLayer == null)
{
throw new RuntimeException("获取shp图层失败!\n");
}
//转化为json
Feature feature = shpLayer.GetNextFeature();
Geometry geometry = feature.GetGeometryRef();
String json = geometry.ExportToJson();
shpDataSource.delete();
gdal.GDALDestroyDriverManager();
return json;
}
public static void main(String[] args) {
GdalDemo_shp shp = new GdalDemo_shp();
String strVectorFile ="D:\\新建文件夹\\4496\\天府新区.shp";
String info = shp.opeanShp(strVectorFile);
System.out.println(info);
}
}
案例2-打开gdb
public void openGdb() {
//注册所有驱动
ogr.RegisterAll();
//支持中文路径
gdal.SetConfigOption("GDAL_FILENAME_IS_UTF8", "YES");
//属性表支持中文
gdal.SetConfigOption("SHAPE_ENCODING", "CP936");
//获取GDB驱动
String gdbDriverName = "FileGDB";
org.gdal.ogr.Driver gdbDriver = ogr.GetDriverByName(gdbDriverName);
if(gdbDriver == null){
System.out.println("不支持" + gdbDriverName + "驱动");
return;
}
String gdbPath = "C:\\Users\\lulie\\Desktop\\test.gdb";
DataSource gdbDataSource = gdbDriver.Open(gdbPath, 0);
if(gdbDataSource == null){
System.out.println("GDAL打开gdb失败!");
return;
}
for (int i = 0; i < gdbDataSource.GetLayerCount(); i++) {
String layerName = gdbDataSource.GetLayer(i).GetName();
System.out.println(layerName);
}
gdbDataSource.delete();
gdal.GDALDestroyDriverManager();
}
案例3-从pg库导出/导入shp
//pg库导出shp
public static void pg2shp(){
ogr.RegisterAll();
gdal.SetConfigOption("GDAL_FILENAME_IS_UTF8","YES");
gdal.SetConfigOption("SHAPE_ENCODING","CP936");
//获取pg驱动
String pgDriverName = "PostgreSQL";
org.gdal.ogr.Driver pgDriver = ogr.GetDriverByName(pgDriverName);
if(pgDriver == null){
System.out.println("不支持" + pgDriverName + "驱动");
return;
}
//GDAL连接PostGIS
String path = "PG:dbname=test host=localhost port=5432 user=postgres password=postgres";
DataSource pgDataSource = pgDriver.Open(path, 0);
if(pgDataSource == null){
System.out.println("GDAL连接PostGIS数据库失败!");
return;
}
String strSQL = "SELECT * from province WHERE area='测试'";
//获取图层
Layer pgLayer = pgDataSource.ExecuteSQL(strSQL);
//Layer pgLayer = pgDataSource.GetLayerByName("123");
if (pgLayer == null)
{
System.out.println("获取【" + "province" + "】图层失败!");
return;
}
System.out.println(pgLayer.GetFIDColumn());
//创建矢量文件
String strVectorFile ="D:\\pg2shp.shp";
//驱动
String shpDriverName = "ESRI Shapefile";
org.gdal.ogr.Driver shpDriver =ogr.GetDriverByName(shpDriverName);
if (shpDriver == null)
{
System.out.println(shpDriverName+ " 驱动不可用!\n");
return;
}
//数据源
DataSource shpDataSource = shpDriver.CreateDataSource(strVectorFile,null);
if (shpDataSource == null)
{
System.out.println("创建矢量文件【"+ strVectorFile +"】失败!\n" );
return;
}
//图层
Layer shpLayer =shpDataSource.CreateLayer("", pgLayer.GetSpatialRef(), pgLayer.GetGeomType());
if (shpLayer == null)
{
System.out.println("图层创建失败!\n");
return;
}
//字段
FeatureDefn pgDefn =pgLayer.GetLayerDefn();
int iFieldCount =pgDefn.GetFieldCount();
for (int i = 0; i <iFieldCount; i++)
{
FieldDefn oField =pgDefn.GetFieldDefn(i);
shpLayer.CreateField(oField, 1);
}
//数据记录
Feature oFeature = null;
while ((oFeature = pgLayer.GetNextFeature()) != null)
{
System.out.println(oFeature.GetFID());
shpLayer.CreateFeature(oFeature);
}
//写入文件
shpLayer.SyncToDisk();
shpDataSource.SyncToDisk();
//删除数据源
pgDataSource.delete();
shpDataSource.delete();
gdal.GDALDestroyDriverManager();
System.out.println("shp文件创建成功!");
}
//pg库导入shp(FID会冲突,需要自己解决)
public static void shp2pg(){
ogr.RegisterAll();
gdal.SetConfigOption("GDAL_FILENAME_IS_UTF8","YES");
gdal.SetConfigOption("SHAPE_ENCODING","CP936");
String shpDriverName = "ESRI Shapefile";
org.gdal.ogr.Driver shpDriver =ogr.GetDriverByName(shpDriverName);
if (shpDriver == null)
{
System.out.println(shpDriverName+ " 驱动不可用!\n");
return;
}
String strVectorFile ="D:\\pg2shp.shp";
DataSource shpDataSource = ogr.Open(strVectorFile,0);
if (shpDataSource == null)
{
System.out.println("打开文件【"+ strVectorFile + "】失败!" );
return;
}
Layer shpLayer = shpDataSource.GetLayerByIndex(0);
if (shpLayer == null)
{
System.out.println("获取shp图层失败!\n");
return;
}
System.out.println(shpLayer.GetFIDColumn());
//获取pg驱动
String pgDriverName = "PostgreSQL";
org.gdal.ogr.Driver pgDriver = ogr.GetDriverByName(pgDriverName);
if(pgDriver == null){
System.out.println("不支持" + pgDriverName + "驱动");
return;
}
//GDAL连接PostGIS
String path = "PG:dbname=test host=localhost port=5432 user=postgres password=postgres";
DataSource pgDataSource = pgDriver.Open(path, 1);
if(pgDataSource == null){
System.out.println("GDAL连接PostGIS数据库失败!");
return;
}
//获取图层
Layer pgLayer = pgDataSource.GetLayerByName("tablename");
if (pgLayer == null)
{
System.out.println("获取【" + "tablename" + "】图层失败!");
return;
}
Feature oFeature = null;
while ((oFeature = shpLayer.GetNextFeature()) != null)
{
oFeature.SetFID(100 + oFeature.GetFID());
System.out.println(oFeature.GetFID());
pgLayer.CreateFeature(oFeature);
}
//写入文件
pgLayer.SyncToDisk();
pgDataSource.SyncToDisk();
//删除数据源
pgDataSource.delete();
shpDataSource.delete();
gdal.GDALDestroyDriverManager();
System.out.println("shp文件导入成功!");
}
案例4-读取属性
//读取属性
public void readAttribute() {
//注册所有驱动
ogr.RegisterAll();
//支持中文路径
gdal.SetConfigOption("GDAL_FILENAME_IS_UTF8", "YES");
//属性表支持中文
gdal.SetConfigOption("SHAPE_ENCODING", "CP936");
//获取GDB驱动
String gdbDriverName = "FileGDB";
org.gdal.ogr.Driver gdbDriver = ogr.GetDriverByName(gdbDriverName);
if(gdbDriver == null){
System.out.println("不支持" + gdbDriverName + "驱动");
return;
}
String gdbPath = "C:\\Users\\lulie\\Desktop\\test.gdb";
DataSource gdbDataSource = gdbDriver.Open(gdbPath, 0);
if(gdbDataSource == null){
System.out.println("GDAL连接GDB失败!");
return;
}
//获取所有的layer图层
for (int i = 0; i < gdbDataSource.GetLayerCount(); i++) {
Layer layer = gdbDataSource.GetLayer(i);
System.out.println(" layerName :" + layer.GetName());
//获取所有的字段名
List<String> fieldNames = new ArrayList<String>();
FeatureDefn featureDefn = layer.GetLayerDefn();
for (int i1 = 0; i1 < featureDefn.GetFieldCount(); i1++) {
FieldDefn fieldDefn = featureDefn.GetFieldDefn(i1);
String fields = fieldDefn.GetName();
fieldNames.add(fields);
}
System.out.println("所有字段名:" + fieldNames);
//遍历读取属性
Feature feature = null;
while ((feature = layer.GetNextFeature()) != null) {
List<String> fieldValue = new ArrayList<String>();
String geojson = feature.GetGeometryRef().ExportToJson();
System.out.println("geojson :" + geojson);
//遍历字段名读取所有属性
for (String fieldName : fieldNames) {
String field = feature.GetFieldAsString(fieldName);
fieldValue.add(field);
}
System.out.println(fieldValue);
}
}
gdbDataSource.delete();
gdal.GDALDestroyDriverManager();
}
1、连接数据源
1.1、连接之前
/*
准备工作
*/
gdal.AllRegister();
//注册所有驱动
ogr.RegisterAll();
//支持中文路径
gdal.SetConfigOption("GDAL_FILENAME_IS_UTF8", "YES");
//属性表支持中文
gdal.SetConfigOption("SHAPE_ENCODING", "CP936");
1.2、数据源驱动
/*
5种主要驱动程序的名称
*/
public class DriverName {
//String connShp = "D:\\DIST\\Code\\Project\\zhenjiang\\镇江shp\\五角星.shp";
public static final String shp = "ESRI Shapefile";
//String connGdb = "D:\\DIST\\geoData\\shpFile\\unionResult.gdb";
public static final String gdb = "FileGDB";//或者OpenFileGDB
//String connPg = "PG:dbname=dggis host=192.168.200.34 port=30013 user=sde password=sde";
public static final String postgreSQL = "PostgreSQL";
//String connStr = "OCI:sde/sde:SYS.Yjjbnt";//连接本地库可以忽略数据库实例
//String connSde = "OCI:gis_qf/Passw0rd@192.168.1.163/orcl:CHDYZT.JSFAFW";
//String connStr = "OCI:rcgtkjgh/pass@192.168.200.230:1521/orcl:RCGTKJGH.DELSH_STBHHX";
public static final String sde = "OCI";
//String connMdb = "D:\\DIST\\geoData\\shpFile\\test.mdb";
public static final String mdb = "PGeo";
}
1.3、连接数据源的基本过程
/*
连接数据源的基本过程
*/
1、根据驱动名称获取驱动
Driver driver = ogr.GetDriverByName(driverName);
2、通过驱动打开数据源
DataSource dataSource = driver.Open(FilePath, 0);//文件路径或者连接字符串,0表示不更新数据集,为只读
3、获取数据源里的图层
dataSource.GetLayer(index:)//根据id获取
dataSource.GetLayer(layerName:"")//根据名称获取
4、获取图层里的要素
//读取GDB里面的图层时,获取Feature得用GetNextFeature()方法,不能根据GetFeature(long fid)
layer.GetFeature(int:);//根据id
layer.ResetReading();//把要素读取顺序重置为从第一个开始
layer.GetNextFeature();
1.4、读取数据基本信息
读取图层数量:
int layerCount = dataSource.GetLayerCount();
图层名称
String layerName = layer.GetName();
图层要素数量
long featureCount = layer.GetFeatureCount();
图层空间参考信息
SpatialReference s = layer.GetSpatialRef();
图层的属性表结构
FeatureDefn featureDefn = layer.GetLayerDefn();
属性表字段数量
int fieldCount = featureDefn.GetFieldCount();
属性表的属性字段
FieldDefn fieldDefn = featureDefn.GetFieldDefn(i1);//根据索引获取
属性字段类型
int fieldType = fieldDefn.GetFieldType();
String fieldTypeName = fieldDefn.GetFieldTypeName(fieldType);
属性字段名称
String fieldName = fieldDefn.GetName();
获取FID
long fid = feature.GetFID();//这个是通过Feature来获取的
获取Geometry
Geometry geometry = feature.GetGeometryRef();
String geoJson = geometry.ExportToJson();
{ "type": "Polygon", "coordinates": [ [ [ 119.456586303, 32.063698523000028, 0.0 ], [ 119.468721554000012, 32.045852565000018, 0.0 ], [ 119.490850540999986, 32.040141859000016, 0.0 ], [ 119.472290745, 32.028006608, 0.0 ], [ 119.478001451999944, 32.003736104999973, 0.0 ], [ 119.457300141000019, 32.023723577999988, 0.0 ], [ 119.43659882999998, 32.002308428999982, 0.0 ], [ 119.443023375000053, 32.025865093, 0.0 ], [ 119.422322064000014, 32.034431152000025, 0.0 ], [ 119.445878728000025, 32.043711050000013, 0.0 ], [ 119.456586303, 32.063698523000028, 0.0 ] ] ] }
获取图层范围
double[] extent = layer.GetExtent();//返回4个坐标点
2、关于投影
SpatialReference spatialReference = layer.GetSpatialRef();//获取图层的空间信息
//设定空间信息
//通过EPSG
SpatialReference spatialReference = new SpatialReference();
spatialReference.ImportFromEPSG(4490);
//通过WKT字符串
String strwkt = "GEOGCS[\"GCS_North_American_1927\"," +
"DATUM[\"North_American_Datum_1927\"," +
"SPHEROID[\"Clarke_1866\",6378206.4,294.9786982]]," +
"PRIMEM[\"Greenwich\",0]," +
"UNIT[\"Degree\",0.0174532925199433]]";
SpatialReference spatialReference = new SpatialReference(strwkt);
投影信息如下(WKT字符串):
PROJCS[“CGCS2000 / 3-degree Gauss-Kruger CM 117E”, //投影名称
GEOGCS[“China Geodetic Coordinate System 2000”, //地理坐标系名称
DATUM[“China_2000”, //水平基准面
SPHEROID[“CGCS2000”,6378137,298.257222101,//椭球体、长半轴,反偏率
AUTHORITY[“EPSG”,“1024”]],
AUTHORITY[“EPSG”,“1043”]],
PRIMEM[“Greenwich”,0, //中央经线Greenwich,0度标准子午线
AUTHORITY[“EPSG”,“8901”]],
UNIT[“degree”,0.0174532925199433, //指定测量使用的单位。在地理坐标系下使用角度。
AUTHORITY[“EPSG”,“9122”]],
AUTHORITY[“EPSG”,“4490”]],
PROJECTION[“Transverse_Mercator”], //投影方式
PARAMETER[“latitude_of_origin”,0], //PARAMETER表示投影参数,0表示纬度起点为0度
PARAMETER[“central_meridian”,117], //投影带的中央经线是东经117度
PARAMETER[“scale_factor”,1], //中央经线的长度比是1
PARAMETER[“false_easting”,500000], //坐标纵轴向西移动500km
PARAMETER[“false_northing”,0], //横轴没有平移
UNIT[“metre”,1, //指定测量使用的单位,指定米为测量单位
AUTHORITY[“EPSG”,“9001”]],
AXIS[“Northing”,NORTH],
AXIS[“Easting”,EAST],
AUTHORITY[“EPSG”,“4548”]]
3、属性查询
3.1 通过图层layer查询
//查询没有发生错误则返回0,注意此时的layer只包含 满足条件的要素
int result = layer.SetAttributeFilter("YSDM='3002020100'");//属性查询时注意不能用字段别名
//参数设为null表示清空查询
layer.SetAttributeFilter(null);
3.2 通过数据源datasource查询
Layer queryLayer = dataSource.ExecuteSQL("select * from union5 where YSDM='3002020100'");
4、地理处理
/**
* 两个图层之间的地理处理操作
* @param inputLayer:输入图层
* @param queryLayer:求交图层
* @param resultLayer:返回结果图层
* @param spatialFilter:地理处理操作
*/
public static void spatialQuery(Layer inputLayer,Layer queryLayer,Layer resultLayer,int spatialFilter){
Vector v = new Vector(4);
v.add("SKIP_FAILURES=YES");//跳过处理过程中出现的错误
v.add("PROMOTE_TO_MULTI=NO");//Polygon不转为MultiPolygon,如果设为YES则会
v.add("INPUT_PREFIX=1_");//输入图层在属性表中的字段前缀
v.add("METHOD_PREFIX=2_");//求交图层的字段前缀
switch (spatialFilter){
//相交
case 0:
inputLayer.Intersection(queryLayer,resultLayer,v,null);
break;
//合并
case 1:
inputLayer.Union(queryLayer,resultLayer,v,null);
}
}
5、创建图层
/**
* 创建矢量图层
* @param driverName:驱动名称
* @param path:图层保存路径,要和驱动匹配
* @param layerName:图层名称
* @param spatialReference:图层空间参考
* @return 返回创建好的图层
*/
public static Layer createLayer(String driverName, String path, String layerName, SpatialReference spatialReference) {
Layer result = null;
Driver driver = ogr.GetDriverByName(driverName);
if (driver == null) {
log.info(driverName + "不可用");
System.out.println(driverName + "不可用");
return null;
}
DataSource dataSource = null;
//这里需要判断一下path是否已经存在,存在的话先删除再创建(如果是已存在的gdb,则直接打开)
File file = new File(path);
if (file.exists()) {
if (file.isFile()) {
file.delete();
dataSource = driver.CreateDataSource(path, null);
} else if (file.isDirectory()) {
dataSource = driver.Open(path, 1);
//GDB中存在同名图层则删除
for (int i = 0; i < dataSource.GetLayerCount(); i++) {
Layer layer = dataSource.GetLayer(i);
if (layerName.equals(layer.GetName())) {
dataSource.DeleteLayer(i);
dataSource.FlushCache();
}
}
}
} else {
dataSource = driver.CreateDataSource(path, null);
}
if (dataSource == null) {
log.info("数据源创建/打开失败");
System.out.println("数据源创建/打开失败");
return null;
}
result = dataSource.CreateLayer(layerName, spatialReference, ogr.wkbPolygon, null);
if (result == null) {
log.info(layerName + "创建失败");
System.out.println(layerName + "创建失败");
return null;
}
log.info("【"+layerName+"】" + "创建成功");
return result;
}
6、创建要素
/**
* 传入Geometry创建Feature,这里不定义属性字段
* @param layer
* @param geometry
*/
public static void createFeatureByGeometry(Layer layer, Geometry geometry) {
FeatureDefn featureDefn = layer.GetLayerDefn();
Feature feature = new Feature(featureDefn);
feature.SetGeometry(geometry);
layer.CreateFeature(feature);
}