Hi, I installed again de postgis 2.0 and now i could load al the .sql with the makepostgisdb.bat that de windows version brings. The only thing is that i had to first create de DB and then in a separate .bat run the .sql load.<div>
<br></div><div>I installed gdal 1.8 and also have de gdal 1.8 in the mapserver (ms4w 3.0.2) installation, but i cant connect with the data base i'm trying to run a gdal_translate or gdal_info and it doesnt work. I created a new data base having as template the one loaded with the postgis 2.0</div>
<div><br></div><div>This is the error that it shows:</div><div><br></div><div><div><div style="font-weight: bold; ">C:\ms4w\tools\gdal-ogr>gdal_translate PG:"dbname=raster user=postgres table=Hume<span class="Apple-style-span" style="font-weight: normal; "><b><div style="display: inline !important; ">
dadDeExtincion mode=2" C:\TSIG\capas\sql2\HumedadDeExtincion.tif</div></b></span></div><div style="font-weight: bold; "><span class="Apple-style-span" style="font-weight: normal; "><b><div style="display: inline !important; ">
<br></div></b></span></div><div>ERROR 1: Error browsing database for PostGIS Raster properties</div><div>GDALOpen failed - 1</div><div>Error browsing database for PostGIS Raster properties</div></div></div><div><br></div>
<div><br></div><div>Any way...i will post this problem in another thread because the subject is different.</div><div><br></div><div>regards,</div><div>Virginia <br>
<br><br><div class="gmail_quote">2011/6/3 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;">
[SP] Hola Virginia. Realmente el único español, que yo sepa, soy yo,<br>
así que si no te importa, voy a responder a tu pregunta en inglés<br>
<br>
[EN] Hi Virginia, AFAIK, I'm the only Spanish on the list. So, I'm<br>
going to answer your question in english.<br>
<br>
Are you sure you loaded all the needed sql files? These are<br>
postgis.sql, spatial_ref_sys.sql and rtpostgis.sql<br>
<br>
Best regards,<br>
<font color="#888888">Jorge<br>
</font><div><div></div><div class="h5"><br>
On Thu, Jun 2, 2011 at 11:36 PM, Virginia Maffei <<a href="mailto:vmaffei@gmail.com">vmaffei@gmail.com</a>> wrote:<br>
> Hola! estoy intentando cargar manualmente el raster support y estoy<br>
> ejecutando el rtpostgissql que trae el postgis2.0<br>
> Pero al ejecutarlo me tira que no existe la funcion box2d(raster)<br>
> Alguna idea de que puede estar pasando?<br>
> Gracias!<br>
> PD: Escribí en español porque me pareció ver que son de españa y yo en<br>
> realidad hablo en español.<br>
> saludos!<br>
> Virginia<br>
><br>
><br>
> On Thu, Jun 2, 2011 at 11:16 AM, Virginia Maffei <<a href="mailto:vmaffei@gmail.com">vmaffei@gmail.com</a>> wrote:<br>
>><br>
>> Thank you!! I will try that installation<br>
>> Virginia<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>
>>> On Thu, Jun 2, 2011 at 3:25 PM, Virginia Maffei <<a href="mailto:vmaffei@gmail.com">vmaffei@gmail.com</a>><br>
>>> wrote:<br>
>>> > Thank you for your quick response!<br>
>>> > I have another question: can i install postgis 2.0 in windows? where<br>
>>> > can I<br>
>>> > download it?<br>
>>> ><br>
>>> ><br>
>>> > Virginia<br>
>>> ><br>
>>><br>
>>> Yes, you can. Follow this post's instructions:<br>
>>><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>
>>> Jorge<br>
>>><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>><br>
>>> >> wrote:<br>
>>> >> > Virginia,<br>
>>> >> ><br>
>>> >> > I think you are missing a mode='2' in your connection. That was a<br>
>>> >> > 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<br>
>>> >> > 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<br>
>>> >> > 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<br>
>>> >> > 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<br>
>>> >> > 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<br>
>>> >> > 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<br>
>>> >> > 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>
>><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>