(Note: I am trying to do as much of this as possible in PostGIS/PostgreSQL)
I have a PostgreSQL table containing location data of an aircraft in orbit around a city. Every second a new row is added with new position data.
From this table I have created a view which shows a constantly updating point of only the current position. This view therefore contains only one row.
I have created a custom polygon in a different table, which acts as a buffer around the current position point. I want to reposition/move this polygon to always be centred over the constantly updating current position coordinates. Does anyone know how to do this? I have already experimented with rotate and scale. I am happy with them. It is moving the polygon that is confusing me.
I have tried creating a view that uses ST_Translate for the polygon, however from my understanding, this function only moves coordinates by a fixed amount from the origin. It doesn’t allow me to specify exactly what lon lat coordinates I want it to move to. Does anyone know a function/how to move a polygon to new coordinates, centred on a point? Again, I am trying to achieve this from PostGIS.