java geoTools几何关系查询

最新推荐文章于 2024-04-16 13:55:59 发布

@chenk

最新推荐文章于 2024-04-16 13:55:59 发布

阅读量609

点赞数

CC 4.0 BY-SA版权

分类专栏： arcgis 文章标签： java 数据库 sqlserver

本文链接：https://blog.csdn.net/weixin_38845058/article/details/128098189

arcgis 专栏收录该内容

3 篇文章

订阅专栏

该博客介绍了如何使用GeoTools进行数据查询，重点在于利用CQL（Common Query Language）进行空间过滤。示例代码展示了通过HashMap设置数据库连接参数，建立DataStore并获取FeatureSource，然后运用CQL过滤器筛选出与特定几何对象相交的特征。最后，遍历查询结果并打印出属性值。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 @SneakyThrows
    public static void main(String[] args) {
        try {
            HashMap<String, Object> params = new HashMap<>(8);
            params.put("dbtype", "sqlserver");
            params.put("host", "ip");
            params.put("port", 1433);
            params.put("database", "geo");
            params.put("user", "sa");
            params.put("passwd", "pwd");
            DataStore dataStore = DataStoreFinder.getDataStore(params);
            SimpleFeatureSource source = dataStore.getFeatureSource("BGPOINT");
            SimpleFeatureType schema = source.getSchema();
            dataStore.getFeatureWriter(schema.getTypeName(),new DefaultTransaction());
            //name 一般为the_geom,表示记录shp的空间信息
            String name = schema.getGeometryDescriptor().getLocalName();
            Filter filter = CQL.toFilter("INTERSECTS("+name+",LINESTRING (13362219.971500002 3362953.5067000017, 13362227.4923 3362951.6404))");
            //关键是下面的代码
            Query query = new Query(schema.getTypeName(), filter, name);
            SimpleFeatureCollection features = source.getFeatures(query);
            SimpleFeatureIterator simpleFeatureIterator = features.features();
            while (simpleFeatureIterator.hasNext()){
                SimpleFeature simpleFeature = simpleFeatureIterator.next();
                Collection<Property> properties= simpleFeature.getProperties();
                Iterator<Property> iterator= properties.iterator();
                System.out.println(simpleFeature.getID());
                while (iterator.hasNext()){
                    Property next = iterator.next();
                    System.out.println(next.getValue());
                }

            }

        } catch (IOException e) {
            e.printStackTrace();

        }


    }

GeoTools入门（六）-- 查询那点事_surpassLiang的博客-CSDN博客 CQL使用