[postgis-users] Mapserver connection to Postgis Raster

Jorge Arévalo jorge.arevalo at deimos-space.com
Fri Jun 3 01:01:30 PDT 2011 

[SP] Hola Virginia. Realmente el único español, que yo sepa, soy yo,
así que si no te importa, voy a responder a tu pregunta en inglés

[EN] Hi Virginia, AFAIK, I'm the only Spanish on the list. So, I'm
going to answer your question in english.

Are you sure you loaded all the needed sql files? These are
postgis.sql, spatial_ref_sys.sql and rtpostgis.sql

Best regards,
Jorge

On Thu, Jun 2, 2011 at 11:36 PM, Virginia Maffei <vmaffei at gmail.com> wrote:
> Hola! estoy intentando cargar manualmente el raster support y estoy
> ejecutando el rtpostgissql que trae el postgis2.0
> Pero al ejecutarlo me tira que no existe la funcion box2d(raster)
> Alguna idea de que puede estar pasando?
> Gracias!
> PD: Escribí en español porque me pareció ver que son de españa y yo en
> realidad hablo en español.
> saludos!
> Virginia
>
>
> On Thu, Jun 2, 2011 at 11:16 AM, Virginia Maffei <vmaffei at gmail.com> wrote:
>>
>> 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
>>
>
>
> _______________________________________________
> 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

More information about the postgis-users mailing list