[postgis-users] upload a folder of raster files

Giannis Giakoumidakis ggiakoumidakis at yahoo.com
Thu Sep 6 02:19:10 PDT 2012

Thank you very much! 

I need some extra help with the  table name generator (public.dem_x_!_rid:~4,2!), I can't understand how it works. 

Note that my filenames have that form: cc00h00m15s, cc00h00m30s, cc00h00m45s, cc00h01m00s, ... , cc02h00m00s (hours, minutes, seconds that rising every 15 seconds)

 From: Pierre Racine <Pierre.Racine at sbf.ulaval.ca>
To: Giannis Giakoumidakis <ggiakoumidakis at yahoo.com>; PostGIS Users Discussion <postgis-users at postgis.refractions.net> 
Sent: Wednesday, September 5, 2012 9:07 PM
Subject: RE: [postgis-users] upload a folder of raster files
Here is my answer to that:



> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Giannis Giakoumidakis
> Sent: Monday, September 03, 2012 6:12 AM
> To: PostGIS Users Discussion
> Subject: [postgis-users] upload a folder of raster files
> I want to upload to a db a big number of raster files, pe 500, inside a folder,
> named in a row (file_1 to file_500), each one to a different table. Any ideas? A
> loop or something of the basic: raster2pgsql -s 4236 -I -C -M file_1.tif -F -t
> public.demelevation | psql -d gisdb
> Note that using wildcard (*.tif) doesn't help, I tried but it uploads all files in one
> table as different rows.
> My sql knowledge is bad, so any help would be precious. Thanks.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120906/e42fbded/attachment.html>

More information about the postgis-users mailing list