[postgis-users] upload a folder of raster files

[Pierre Racine]

How do you want your tables names to be created from those filenames?

> -----Original Message-----
> From: Giannis Giakoumidakis [mailto:ggiakoumidakis at yahoo.com]
> Sent: Thursday, September 06, 2012 5:19 AM
> To: Pierre Racine; PostGIS Users Discussion
> Subject: Re: [postgis-users] upload a folder of raster files
> 
> 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:
> 
> http://geospatialelucubrations.blogspot.ca/2012/09/loading-many-rasters-into-
> separate.html
> 
> Pierre
> 
> > -----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.
> 
> 
>