I'm positive that the projection is 2273. Not sure about the errors I'm getting... it seems like I've tried every combination of -I -M -F -t -s and still can't get the second image to mosaic properly.<div>
<br></div><div>- Brian<br><br><div class="gmail_quote">On Tue, Sep 11, 2012 at 1:34 PM, Francois Hugues <span dir="ltr"><<a href="mailto:hugues.francois@irstea.fr" target="_blank">hugues.francois@irstea.fr</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I agree you Nicolas !<br>
<br>
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)<br>
<br>
Hugues.<br>
<br>
<br>
-------- Message d'origine--------<br>
De: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a> de la part de Brian Fitzgerald<br>
Date: mar. 11/09/2012 19:10<br>
À: PostGIS Users Discussion<br>
Objet : Re: [postgis-users] PostGIS 2.0 Raster Mosaic...<br>
<br>
I just tried the following (following your example) and get the following error:<br>
<br>
./raster2pgsql -d -s 2273 -t 256x256 -C -F /home/rcgeoadmin/temp/979801.tif public.testmosaic > /home/rcgeoadmin/temp/979801mosaic.sql<br>
<br>
psql -d mydb -f 979801mosaic.sql<br>
<br>
./raster2pgsql -a -s 2273 -t 256x256 -M -F /home/rcgeoadmin/temp/979903.tif public.testmosaic > /home/rcgeoadmin/temp/979903mosaic.sql<br>
<br>
psql -d mydb -f 979903mosaic.sql<br>
<br>
<br>
ERROR:<br>
<br>
postgres@minty /home/rcgeoadmin/temp $ psql -d mydb -f 979903mosaic.sql<br>
BEGIN<br>
psql:979903mosaic.sql:2: ERROR: new row for relation "testmosaic" violates check constraint "enforce_max_extent_rast"<br>
psql:979903mosaic.sql:3: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>
psql:979903mosaic.sql:4: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>
.....<br>
<br>
<br>
<br>
On Tue, Sep 11, 2012 at 12:57 PM, Markus Innerebner <<a href="mailto:markus.innerebner@inf.unibz.it">markus.innerebner@inf.unibz.it</a>> wrote:<br>
<br>
<br>
I am doing the same thing with success:<br>
<br>
use my script:<br>
<br>
cheers Markus<br>
<br>
*************<br>
param 1: name the directory in which the files are located<br>
param2: name of the table in which the files are loaded<br>
*************<br>
more raster2pgHydroalp.sh<br>
#!/bin/bash<br>
# this script imports raster ascii file into postgis<br>
#<br>
isFirst=true;<br>
cd $1;<br>
<br>
for i in $(\ls *.asc);<br>
do<br>
echo $i<br>
if $isFirst<br>
then<br>
raster2pgsql -d -s 32632 -C -F $i $2 | sudo su - postgres -c 'psql -d hydroalp';<br>
isFirst=false<br>
else<br>
raster2pgsql -a -s 32632 -M -F $i $2 | sudo su - postgres -c 'psql -d hydroalp'<br>
fi<br>
done<br>
<br>
cd ..<br>
<br>
***********<br>
<br>
<br>
<br>
--<br>
Ph D. Student Markus Innerebner<br>
<br>
DIS Research Group - Faculty of Computer Science<br>
Free University Bozen-Bolzano<br>
<br>
Dominikanerplatz 3 - Room 211<br>
I - 39100 Bozen<br>
Phone: +39-0471-016143 <tel:%2B39-0471-016143><br>
Mobile: +39-333-9392929 <tel:%2B39-333-9392929><br>
<br>
<br>
gpg --fingerprint<br>
-------------------------------------<br>
pub 1024D/588F6308 2007-01-09<br>
Key fingerprint = 6948 947E CBD2 89FD E773 E863 914F EB1B 588F 6308<br>
sub 2048g/BF4877D0 2007-01-09<br>
<br>
<br>
On Sep 11, 2012, at 6:43 PM, Brian Fitzgerald wrote:<br>
<br>
<br>
979903mosaic.sql<br>
<br>
<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
<br>
<br>
<br>
<br>
--<br>
--------------------------------------<br>
Brian Fitzgerald, PMP, GISP<br>
<a href="mailto:bkfitz@gmail.com">bkfitz@gmail.com</a><br>
<a href="tel:803.426.3469" value="+18034263469">803.426.3469</a><br>
---------------------------------------<br>
<br>
<br>
</font></span><br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><span>------------------------------</span><span>--------</span><br><span>Brian Fitzgerald, PMP, GISP</span><br><a href="mailto:bkfitz@gmail.com" target="_blank">bkfitz@gmail.com</a><br>
<span>803.426.3469</span><br><span>------------------------------</span><span>---------</span><br>
</div>