[postgis-users] RE : PostGIS 2.0 Raster Mosaic...

[Francois Hugues]

I agree you Nicolas !

Are you sure the projection of your raster is SRID 2273 ? Regarding the first error, it seems to me you have a projection problem (but I am not really familiar with this kind of "extent" error)

Hugues.


-------- Message d'origine--------
De: postgis-users-bounces at postgis.refractions.net de la part de Brian Fitzgerald
Date: mar. 11/09/2012 19:10
À: PostGIS Users Discussion
Objet : Re: [postgis-users] PostGIS 2.0 Raster Mosaic...
 
I just tried the following (following your example) and get the following error:

./raster2pgsql -d -s 2273 -t 256x256 -C -F /home/rcgeoadmin/temp/979801.tif public.testmosaic > /home/rcgeoadmin/temp/979801mosaic.sql

psql -d mydb -f 979801mosaic.sql

./raster2pgsql -a -s 2273 -t 256x256 -M -F /home/rcgeoadmin/temp/979903.tif public.testmosaic > /home/rcgeoadmin/temp/979903mosaic.sql

psql -d mydb -f 979903mosaic.sql


ERROR:

postgres at minty /home/rcgeoadmin/temp $ psql -d mydb -f 979903mosaic.sql 
BEGIN
psql:979903mosaic.sql:2: ERROR:  new row for relation "testmosaic" violates check constraint "enforce_max_extent_rast"
psql:979903mosaic.sql:3: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:979903mosaic.sql:4: ERROR:  current transaction is aborted, commands ignored until end of transaction block
.....



On Tue, Sep 11, 2012 at 12:57 PM, Markus Innerebner <markus.innerebner at inf.unibz.it> wrote:


	I am doing the same thing with success:

	use my script:

	cheers Markus

	*************
	param 1: name the directory in which the files are located
	param2: name of the table in which the files are loaded
	*************
	more raster2pgHydroalp.sh 
	#!/bin/bash
	# this script imports raster ascii file into postgis
	# 
	isFirst=true;
	cd $1;

	for i in $(\ls *.asc); 
	  do
	  echo $i 
	  if $isFirst 
	  then 
	   raster2pgsql -d -s 32632 -C -F $i $2 | sudo su - postgres -c 'psql -d hydroalp';
	   isFirst=false
	  else 
	   raster2pgsql -a -s 32632 -M -F $i $2 | sudo su - postgres -c 'psql -d hydroalp'
	  fi
	done

	cd ..

	***********



	-- 
	Ph D. Student Markus Innerebner
	
	DIS Research Group - Faculty of Computer Science
	Free University Bozen-Bolzano
	
	Dominikanerplatz 3 - Room 211
	I - 39100 Bozen
	Phone:  +39-0471-016143 <tel:%2B39-0471-016143> 
	Mobile: +39-333-9392929 <tel:%2B39-333-9392929> 
	
	
	gpg --fingerprint
	-------------------------------------
	pub   1024D/588F6308 2007-01-09
	      Key fingerprint = 6948 947E CBD2 89FD E773  E863 914F EB1B 588F 6308
	sub   2048g/BF4877D0 2007-01-09
	

	On Sep 11, 2012, at 6:43 PM, Brian Fitzgerald wrote:


		979903mosaic.sql



	_______________________________________________
	postgis-users mailing list
	postgis-users at postgis.refractions.net
	http://postgis.refractions.net/mailman/listinfo/postgis-users
	
	




-- 
--------------------------------------
Brian Fitzgerald, PMP, GISP
bkfitz at gmail.com
803.426.3469
---------------------------------------


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