Hot answers tagged

3 votes
Accepted

ClusterDBSCAN eps unit is meter or degrees if SRID is 4326

No. You are looking at an eps distance of 100 degrees! ST_ClusterDBSCAN currently has no signature accepting a GEOGRAPHY, so your only option is to ST_Transform your input GEOMETRYs to a suitable ...
  • 25k
1 vote
Accepted

PostGIS, create a view with a spatial join

recognition to the good folks in the comments. I finalized it on a MATERIALIZED VIEW with a automated REFRESH. SELECT aton_float.*, depth_area.drval1 AS depth_at_pos_min, depth_area.drval2 AS ...

Only top scored, non community-wiki answers of a minimum length are eligible