Thank you for your quick response!<div><br></div><div>I have another question: can i install postgis 2.0 in windows? where can I download it? </div><div><br></div><div><br></div><div><br></div><div>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" target="_blank">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">
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>
<div><div></div><div><br>
On Thu, Jun 2, 2011 at 6:53 AM, Paragon Corporation <<a href="mailto:lr@pcorp.us" target="_blank">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 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" target="_blank">postgis-users-bounces@postgis.refractions.net</a><br>
> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Virginia<br>
> Maffei<br>
> Sent: Wednesday, June 01, 2011 8:00 PM<br>
> To: <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">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 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 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>
</div></div>> _______________________________________________<br>
> postgis-users mailing list<br>
<div>> <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
</div>> <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" target="_blank">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>
<div><a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
</div><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br></div>