[postgis-users] Mapserver connection to Postgis Raster

[Jorge Arévalo]

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