[postgis-users] Mapserver connection to Postgis Raster

[Virginia Maffei]

Thank you!! I will try that installation

Virginia


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

> On Thu, Jun 2, 2011 at 3:25 PM, Virginia Maffei <vmaffei at gmail.com> wrote:
> > Thank you for your quick response!
> > I have another question: can i install postgis 2.0 in windows? where can
> I
> > download it?
> >
> >
> > Virginia
> >
>
> Yes, you can. Follow this post's instructions:
>
> http://gis4free.wordpress.com/2011/03/10/how-to-install-and-configure-postgis-raster-on-windows/
>
> Best regards,
> Jorge
>
>
> >
> > 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
> >
> >
> > _______________________________________________
> > 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/9e1cb86d/attachment.html>