search

AtlasOfLivingAustralia / layers-store

API for access to spatial layers (grids and polygons)
3 stars 7 forks source link

Query of calculating outlier randomly return a string 'ID', expect 'Int' #13

Open qifeng-bai opened 2 years ago

qifeng-bai commented 2 years ago

Line 400

List<Map<String, Object>> outlierDistancesQueryResult = jdbcTemplate.queryForList( "select points.path as id, st_x(points.geom) as x, st_y(points.geom) as y," +

"Randomly" , or "caused by heavy requests", the query running with the same data, may return ID as String, but we expect int. For example: it may return

Screen Shot 2022-01-10 at 10 41 48 am

but we expect Screen Shot 2022-01-10 at 10 43 29 am