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;
}