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

[Brian Fitzgerald]

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.francois at 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-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
> ---------------------------------------
>
>
>
> _______________________________________________
> 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 --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120911/befa3b44/attachment.html>