Thank you!! I will try that installation<div><br clear="all">Virginia<br>
<br><br><div class="gmail_quote">2011/6/2 Jorge Arévalo <span dir="ltr"><<a href="mailto:jorge.arevalo@deimos-space.com">jorge.arevalo@deimos-space.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On Thu, Jun 2, 2011 at 3:25 PM, Virginia Maffei <<a href="mailto:vmaffei@gmail.com">vmaffei@gmail.com</a>> wrote:<br>
> Thank you for your quick response!<br>
> I have another question: can i install postgis 2.0 in windows? where can I<br>
> download it?<br>
><br>
><br>
> Virginia<br>
><br>
<br>
</div>Yes, you can. Follow this post's instructions:<br>
<a href="http://gis4free.wordpress.com/2011/03/10/how-to-install-and-configure-postgis-raster-on-windows/" target="_blank">http://gis4free.wordpress.com/2011/03/10/how-to-install-and-configure-postgis-raster-on-windows/</a><br>
<br>
Best regards,<br>
<font color="#888888">Jorge<br>
</font><div><div></div><div class="h5"><br>
<br>
><br>
> 2011/6/2 Jorge Arévalo <<a href="mailto:jorge.arevalo@deimos-space.com">jorge.arevalo@deimos-space.com</a>><br>
>><br>
>> Hi,<br>
>><br>
>> The mode=2 parameter is only valid with the last version of GDAL<br>
>> (1.8.0). So, as Regina said, you need that version to make it work<br>
>> properly. More accurately:<br>
>><br>
>> - With a GDAL version down to 1.7.1, you can't make it work in any<br>
>> way. No driver.<br>
>><br>
>> - With a GDAL version between 1.7.1 and 1.7.3, both included, you can<br>
>> use the old version of the driver, thought to work with the old<br>
>> wktraster extension, now abandoned. And it was buggy. Not recommended.<br>
>> Neither GDAL 1.7.x nor wktraster.<br>
>><br>
>> - With GDAL version up to 1.8.0, you can use the last version of GDAL<br>
>> PostGIS Raster driver, and you'll need PostGIS 2.0, that includes<br>
>> PostGIS Raster extension. Additionally, as Regina said, those days<br>
>> we're working on the driver, and all the improvements will be included<br>
>> in GDAL 1.8.x<br>
>><br>
>> So, summarizing: You need PostGIS 2.0 plus GDAL 1.8.0 to make it work.<br>
>><br>
>> Further information on the driver:<br>
>> <a href="http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html" target="_blank">http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html</a><br>
>><br>
>> Best regards,<br>
>> Jorge<br>
>><br>
>> On Thu, Jun 2, 2011 at 6:53 AM, Paragon Corporation <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> wrote:<br>
>> > Virginia,<br>
>> ><br>
>> > I think you are missing a mode='2' in your connection. That was a new<br>
>> > requirement that was added for GDAL 1.8+<br>
>> ><br>
>> > Try putting that in. I think the speed on the loading still needs quite<br>
>> > a<br>
>> > bit of work though last I tried. The speed issues will hopefully be<br>
>> > resolved before 2.0 release.<br>
>> ><br>
>> > Thanks,<br>
>> > Regina<br>
>> > <a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a><br>
>> ><br>
>> ><br>
>> > ________________________________<br>
>> > From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>
>> > [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>
>> > Virginia<br>
>> > Maffei<br>
>> > Sent: Wednesday, June 01, 2011 8:00 PM<br>
>> > To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
>> > Subject: [postgis-users] Mapserver connection to Postgis Raster<br>
>> ><br>
>> > Hi, i'm new at this and i'm trying to connect to postgis raster in the<br>
>> > mapfile.<br>
>> > I loaded a tif file into postgis raster database with the<br>
>> > raster2pgsql.py<br>
>> > script. It created a table with 2 fields: rid and rast.<br>
>> > In the mapfile i added the connection like it specifies in the postgis<br>
>> > raster FAQ but it doesn't displays anything.<br>
>> > This is my mapfile:<br>
>> > MAP<br>
>> > IMAGETYPE PNG24<br>
>> > EXTENT 366582.2901411663 6127927.100382689 857582.2901411663<br>
>> > 6670927.100382689<br>
>> > SIZE 491 543<br>
>> > SHAPEPATH "../data"<br>
>> > LAYER # MODIS raster layer begins here<br>
>> > NAME modis<br>
>> > TYPE RASTER<br>
>> > STATUS ON<br>
>> > DATA "PG:host=localhost port=5432 dbname='postgis' user='postgres'<br>
>> > password='postgres' schema='public' table='HumedadDeExtincion'"<br>
>> > PROCESSING "NODATA=0"<br>
>> > PROCESSING "SCALE=AUTO"<br>
>> > PROCESSING "SCALE_BUCKETS=201"<br>
>> > PROCESSING "BANDS=1"<br>
>> > OFFSITE 71 74 65<br>
>> > CLASS<br>
>> > NAME "red"<br>
>> > EXPRESSION ([pixel] < 10)<br>
>> > COLOR 255 0 0<br>
>> > END<br>
>> > CLASS<br>
>> > NAME "green"<br>
>> > EXPRESSION ([pixel] >= 10 AND [pixel] < 15000 )<br>
>> > COLOR 0 255 0<br>
>> > END<br>
>> > CLASS<br>
>> > NAME "blue"<br>
>> > EXPRESSION ([pixel] >= 15000 )<br>
>> > COLOR 0 255 0<br>
>> > END<br>
>> > END # MODIS raster layer ends here<br>
>> ><br>
>> > # End of LAYER DEFINITIONS -------------------------------<br>
>> > END # All map files must come to an end just as all other things must<br>
>> > come<br>
>> > to...<br>
>> ><br>
>> > I have gdal 1.6 , postgis 1.5 and ms4w with mapserver 5.6.6<br>
>> > We cant see the tiff file on the browser, it only appears a white image.<br>
>> > We did try with the tif without the database connection an it works.<br>
>> > Could you help us?<br>
>> > Thank you<br>
>> ><br>
>> > _______________________________________________<br>
>> > postgis-users mailing list<br>
>> > <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
>> > <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
>> ><br>
>> ><br>
>><br>
>><br>
>><br>
>> --<br>
>> Jorge Arévalo<br>
>> Internet & Mobilty Division, DEIMOS<br>
>> <a href="mailto:jorge.arevalo@deimos-space.com">jorge.arevalo@deimos-space.com</a><br>
>> <a href="http://es.linkedin.com/in/jorgearevalo80" target="_blank">http://es.linkedin.com/in/jorgearevalo80</a><br>
>> <a href="http://mobility.grupodeimos.com/" target="_blank">http://mobility.grupodeimos.com/</a><br>
>> <a href="http://gis4free.wordpress.com" target="_blank">http://gis4free.wordpress.com</a><br>
>> <a href="http://geohash.org/ezjqgrgzz0g" target="_blank">http://geohash.org/ezjqgrgzz0g</a><br>
>> _______________________________________________<br>
>> postgis-users mailing list<br>
>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
><br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
><br>
><br>
<br>
<br>
<br>
--<br>
Jorge Arévalo<br>
Internet & Mobilty Division, DEIMOS<br>
<a href="mailto:jorge.arevalo@deimos-space.com">jorge.arevalo@deimos-space.com</a><br>
<a href="http://es.linkedin.com/in/jorgearevalo80" target="_blank">http://es.linkedin.com/in/jorgearevalo80</a><br>
<a href="http://mobility.grupodeimos.com/" target="_blank">http://mobility.grupodeimos.com/</a><br>
<a href="http://gis4free.wordpress.com" target="_blank">http://gis4free.wordpress.com</a><br>
<a href="http://geohash.org/ezjqgrgzz0g" target="_blank">http://geohash.org/ezjqgrgzz0g</a><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br></div>