I have a list of Points in a PostGIS table. The rows can be grouped by a date
something like:
myTable
id INT
date DATE
lat NUMBER
lng NUMBER
geom GEOMETRY(POINT)
now I need a table where all points of one day are collected in a new geometry (sorted by id)
targetTable
id2 INT
date DATE
geom2 GEOMETRY(POLYGON)
how can I do this with PostGIS or GeoKettle, I cannot use any other client since this transformation has to be done in batch?