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.
- Brian On Tue, Sep 11, 2012 at 1:34 PM, Francois Hugues <hugues.franc...@irstea.fr>wrote: > 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-boun...@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@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.innereb...@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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > > > -- > -------------------------------------- > Brian Fitzgerald, PMP, GISP > bkf...@gmail.com > 803.426.3469 > --------------------------------------- > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- -------------------------------------- Brian Fitzgerald, PMP, GISP bkf...@gmail.com 803.426.3469 ---------------------------------------
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
