[postgis-users] Mapserver connection to Postgis Raster

[Virginia Maffei]

Thank you for your quick response!

I have another question: can i install postgis 2.0 in windows? where can I
download it?



Virginia


2011/6/2 Jorge Arévalo <jorge.arevalo at deimos-space.com>

> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110602/d5ca784f/attachment.html>