[postgis-users] Temporal image analysis in PostGIS

[Pierre Racine]

1) Write a little script that concatenate the date of each file to its filename. Many filename renaming software can do that (e.g. Better file rename).

2) Load the raster with raster2pgsql.py using the -F option. This will add a column with the filename in the DB.

3) Use the substring() SQL function to extract the date from the filename and then cast it to a date to UPDATE a new date_of_creation column.

Pierre

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of maduako ikechukwu
> Sent: Thursday, September 15, 2011 5:40 PM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Temporal image analysis in PostGIS
> 
> Yeah attached as an attribute of the filesystem.
> Am asking for a possible insight on how to get the time attribute into the table
> becuase i read timestamps are not allowed on raster tables.
> Thanks.
> 
> --
> 
> Iyke Maduako
> 
> Masters in Geospatial Technologies
> [Erasmus-Mundus]
> 
> IfGI - Institute for Geoinformatics
> University of Muenster Germany
> 
> Phone: +4915129048460
> 
> Alternative Email:iykefirstclass at yahoo.com
> <mailto:Email%3Aiykefirstclass at yahoo.com>
> 
>