postgresql中geometry格式字段怎么转换成geojson格式-Java

Java方法:如何返回给前端geojson格式
public Object convert2Geojson(int tid) throws ParseException {

        Map<String,Object> map = new HashMap<>();
 beforeTime = "2020-05-28 05:02:22";
//每辆车只返回一个最新的gps点
     String sql = "SELECT DISTINCT ON(plate_number) plate_number, gps_time,st_asgeojson(geom) as geojson,speed,mileage,direction FROM gps_info where gps_time>=? " +
                " GROUP BY plate_number, gps_time,geom,speed,mileage,direction ORDER BY plate_number, gps_time DESC";
        List<Map<String,Object>> pointList = jdbcTemplate.queryForList(sql,beforeTime);
        List<Map<String, Object>> features = new ArrayList<Map<String, Object>>();
        for (Map<String, Object> m : pointList) {
            Map<String, Object> feature = new HashMap<String, Object>();
            feature.put("type", "Feature");
            Map<String, Object> properties = new HashMap<String, Object>();

          //把非geojson全部放到属性里面
            Iterator<Map.Entry<String, Object>> it = m.entrySet().iterator();
            while (it.hasNext()) {
                Map.Entry<String, Object> en = it.next();
                if (!"geojson".equals(en.getKey())) {
                    properties.put(en.getKey(), en.getValue());
                }
            }
            feature.put("properties", properties);

            feature.put("geometry", JSON.parse(m.get("geojson").toString()));
            features.add(feature);
        }
        map.put("features", features);
        return map;
    }
  • 2
    点赞
  • 7
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值