Create kml with time visualization using postGIS

PostGIS is a great tool to work with large spatial data. We can export a query as a txt file using the function COPY TO. Moreover, Postgres have XML-functions which allow you to write and read xml documents. With this functions you can create a KML document with time visualization. This means that using TimeSpan…