[postgis-users] upload a folder of raster files

[Giannis Giakoumidakis]

Anyhow, it's not so important this for me. 


The best would be something that reminds the names of the files but it's ok if it is as simple as  cc001, cc002, cc003, ... etc  or  whatever it starts from cc that is common to all the filenames and then a row of numbers.  





________________________________
 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: Thursday, September 6, 2012 5:03 PM
Subject: RE: [postgis-users] upload a folder of raster files
 
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.
> 
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120906/3e00109f/attachment.html>