[postgis-users] Mapserver connection to Postgis Raster

[Jorge Arévalo]

Hi,

The mode=2 parameter is only valid with the last version of GDAL
(1.8.0). So, as Regina said, you need that version to make it work
properly. More accurately:

- With a GDAL version down to 1.7.1, you can't make it work in any
way. No driver.

- With a GDAL version between 1.7.1 and 1.7.3, both included, you can
use the old version of the driver, thought to work with the old
wktraster extension, now abandoned. And it was buggy. Not recommended.
 Neither GDAL 1.7.x nor wktraster.

- With GDAL version up to 1.8.0, you can use the last version of GDAL
PostGIS Raster driver, and you'll need PostGIS 2.0, that includes
PostGIS Raster extension. Additionally, as Regina said, those days
we're working on the driver, and all the improvements will be included
in GDAL 1.8.x

So, summarizing: You need PostGIS 2.0 plus GDAL 1.8.0 to make it work.

Further information on the driver:
http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html

Best regards,
Jorge

On Thu, Jun 2, 2011 at 6:53 AM, Paragon Corporation <lr at pcorp.us> wrote:
> Virginia,
>
> I think you are missing a mode='2'  in your connection.  That was a new
> requirement that was added for GDAL 1.8+
>
> Try putting that in.  I think the speed on the loading still needs quite a
> bit of work though last I tried.  The speed issues will hopefully be
> resolved before 2.0 release.
>
> Thanks,
> Regina
> http://www.postgis.us
>
>
> ________________________________
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Virginia
> Maffei
> Sent: Wednesday, June 01, 2011 8:00 PM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Mapserver connection to Postgis Raster
>
> Hi, i'm new at this and i'm trying to connect to postgis raster in the
> mapfile.
> I loaded a tif file into postgis raster database with the raster2pgsql.py
> script. It created a table with 2 fields: rid and rast.
> In the mapfile i added the connection like it specifies in the postgis
> raster FAQ but it doesn't displays anything.
> This is my mapfile:
> MAP
>   IMAGETYPE      PNG24
>   EXTENT         366582.2901411663 6127927.100382689 857582.2901411663
> 6670927.100382689
>   SIZE           491 543
>   SHAPEPATH      "../data"
>   LAYER # MODIS raster layer begins here
>     NAME         modis
> TYPE         RASTER
> STATUS       ON
> DATA "PG:host=localhost port=5432 dbname='postgis' user='postgres'
> password='postgres' schema='public' table='HumedadDeExtincion'"
>     PROCESSING "NODATA=0"
> PROCESSING "SCALE=AUTO"
> PROCESSING "SCALE_BUCKETS=201"
>     PROCESSING   "BANDS=1"
>     OFFSITE      71 74 65
> CLASS
> NAME "red"
> EXPRESSION ([pixel] < 10)
> COLOR 255 0 0
> END
> CLASS
> NAME "green"
> EXPRESSION ([pixel] >= 10 AND [pixel] < 15000 )
> COLOR 0 255 0
> END
> CLASS
> NAME "blue"
> EXPRESSION ([pixel] >= 15000 )
> COLOR 0 255 0
> END
>   END # MODIS raster layer ends here
>
>   # End of LAYER DEFINITIONS -------------------------------
> END # All map files must come to an end just as all other things must come
> to...
>
> I have gdal 1.6 , postgis 1.5 and ms4w with mapserver 5.6.6
> We cant see the tiff file on the browser, it only appears a white image.
> We did try with the tif without the database connection an it works.
> Could you help us?
> Thank you
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>



-- 
Jorge Arévalo
Internet & Mobilty Division, DEIMOS
jorge.arevalo at deimos-space.com
http://es.linkedin.com/in/jorgearevalo80
http://mobility.grupodeimos.com/
http://gis4free.wordpress.com
http://geohash.org/ezjqgrgzz0g