[postgis-users] RE : upload a folder of raster files

[Francois Hugues]

As explain in the documentation of raster2pgsql you have to apply raster constraints (-C option) if you want your tables to be correctly registered in the view. There is another functions to do that : http://postgis.refractions.net/docs/RT_AddRasterConstraints.html

I think here is your problem.

Hugues.


-------- Message d'origine--------
De: postgis-users-bounces at postgis.refractions.net de la part de Giannis Giakoumidakis
Date: ven. 14/09/2012 18:01
À: Pierre Racine; PostGIS Users Discussion
Objet : Re: [postgis-users] upload a folder of raster files
 
Ok I created the QueryTables and I made the select to Add contraints to each table. 


One last question: I see no differences in the "extent geometry" column of the "raster_columns" view between all the tables I created, it is exactly the same in all. It seems like it is the same raster in every table, with different name. It shouldn't have every table different geometry or it is right the way it is now?





________________________________
 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: Tuesday, September 11, 2012 8:51 PM
Subject: RE: [postgis-users] upload a folder of raster files
 
> Anyway, I need all the information missing from these
> tables, to make queries. I guess there is no way to add contraints and geometry
> to all after the split. Is there any way that the splitted tables can hold all the
> information from the main table during the split? I think no. What's your
> opinion?

You should just read all the blog post. I explain how to add the constraints on all the tables.

Pierre

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 4785 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120914/953ad39f/attachment.bin>