我试图通过geoserver的WPS显示在我的geomesa-accumulo数据库中注册的每个设备的当前位置。 由于每个设备每隔X秒发送一次位置。 我使用geomesa的TrackLabel流程来获取每个设备的最后位置,WPS流程设置为:
track: device_id dtg : date_time使用我运行该过程并使用传单显示结果。 但是,我认为结果不是我所期望的,因为如果我在jupyter笔记本中运行以下查询:
spark.sql("select device_id, date_time, position from positions where device_id = 145 order by date_time desc limit 1").show()它返回的最后一个位置是2016-05-17 20:47,但TrackLabel流程表示2016-03-05 20:12 。
我的问题:如果这是正确的方法,那么我错过了什么? 或者这个问题的正确方法是什么?
I am trying to display the current position of every device registered in my geomesa-accumulo database through geoserver's WPS. Since each device sends its position every X seconds. I am using geomesa's TrackLabel process to get the last position of each device, the WPS process setup is:
track: device_id dtg : date_timeUsing I run the process and display the results using leaflet. But, I think the results are not what I expected, because if I run the following query in jupyter notebook:
spark.sql("select device_id, date_time, position from positions where device_id = 145 order by date_time desc limit 1").show()It returns that the last position was at 2016-05-17 20:47 but the TrackLabel process says 2016-03-05 20:12.
My questions: If this the correct approach, then what am I missing? Or what should be the correct approach for this problem?
最满意答案
由于您要查询整个数据集,因此可能会达到WFS结果限制。 详情请见此处
Since you're querying the entire dataset, you may be hitting the WFS result limit. See here for details
更多推荐
发布评论