Sorry but i didn't understand very well. In the raster_columns table i have an entry for this table.<div>I dont now if i'm answering you question.</div><div><br></div><div>Virginia<br><br><div class="gmail_quote">On Mon, Jun 6, 2011 at 10:54 AM, Pierre Racine <span dir="ltr"><<a href="mailto:Pierre.Racine@sbf.ulaval.ca">Pierre.Racine@sbf.ulaval.ca</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Would it be possible that the driver needs a missing entry in the raster_columns table?<br>
<div class="im"><br>
> -----Original Message-----<br>
> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a> [mailto:<a href="mailto:postgis-users-">postgis-users-</a><br>
</div>> <a href="mailto:bounces@postgis.refractions.net">bounces@postgis.refractions.net</a>] On Behalf Of Jorge Arévalo<br>
> Sent: Monday, June 06, 2011 4:01 AM<br>
> To: PostGIS Users Discussion<br>
> Subject: Re: [postgis-users] Mapserver connection to Postgis Raster<br>
<div><div></div><div class="h5">><br>
> Hi,<br>
><br>
> Did you test using single quotes surrounding at least the table name?<br>
> The blank spaces may cause problems.<br>
><br>
> Best regards,<br>
> Jorge<br>
><br>
> On Sun, Jun 5, 2011 at 11:03 PM, Virginia Maffei <<a href="mailto:vmaffei@gmail.com">vmaffei@gmail.com</a>> wrote:<br>
> > Hi, I installed again de postgis 2.0 and now i could load al the .sql<br>
> > with the makepostgisdb.bat that de windows version brings. The only<br>
> > thing is that i had to first create de DB and then in a separate .bat run the .sql<br>
> load.<br>
> > I installed gdal 1.8 and also have de gdal 1.8 in the mapserver (ms4w<br>
> > 3.0.2) installation, but i cant connect with the data base i'm trying<br>
> > to run a gdal_translate or gdal_info and it doesnt work. I created a<br>
> > new data base having as template the one loaded with the postgis 2.0<br>
> > This is the error that it shows:<br>
> > C:\ms4w\tools\gdal-ogr>gdal_translate PG:"dbname=raster user=postgres<br>
> > table=Hume dadDeExtincion mode=2"<br>
> > C:\TSIG\capas\sql2\HumedadDeExtincion.tif<br>
> > ERROR 1: Error browsing database for PostGIS Raster properties<br>
> > GDALOpen failed - 1 Error browsing database for PostGIS Raster<br>
> > properties<br>
> ><br>
> > Any way...i will post this problem in another thread because the<br>
> > subject is different.<br>
> > regards,<br>
> > Virginia<br>
> ><br>
> ><br>
> > 2011/6/3 Jorge Arévalo <<a href="mailto:jorge.arevalo@deimos-space.com">jorge.arevalo@deimos-space.com</a>><br>
> >><br>
> >> [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>
> >> Jorge<br>
> >><br>
> >> On Thu, Jun 2, 2011 at 11:36 PM, Virginia Maffei <<a href="mailto:vmaffei@gmail.com">vmaffei@gmail.com</a>><br>
> >> wrote:<br>
> >> > Hola! estoy intentando cargar manualmente el raster support y estoy<br>
> >> > ejecutando el rtpostgissql que trae el postgis2.0 Pero al<br>
> >> > ejecutarlo me tira que no existe la funcion box2d(raster) Alguna<br>
> >> > 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<br>
> >> > en realidad hablo en espańol.<br>
> >> > saludos!<br>
> >> > Virginia<br>
> >> ><br>
> >> ><br>
> >> > On Thu, Jun 2, 2011 at 11:16 AM, Virginia Maffei<br>
> >> > <<a href="mailto:vmaffei@gmail.com">vmaffei@gmail.com</a>><br>
> >> > wrote:<br>
> >> >><br>
> >> >> Thank you!! I will try that installation 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>
> >> >>><br>
> >> >>> <a href="http://gis4free.wordpress.com/2011/03/10/how-to-install-and-" target="_blank">http://gis4free.wordpress.com/2011/03/10/how-to-install-and-</a><br>
> configure-postgis-raster-on-windows/<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<br>
> >> >>> >> 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<br>
> >> >>> >> 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<br>
> >> >>> >> 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<br>
> >> >>> >> included<br>
> >> >>> >> in GDAL 1.8.x<br>
> >> >>> >><br>
> >> >>> >> So, summarizing: You need PostGIS 2.0 plus GDAL 1.8.0 to make it<br>
> >> >>> >> 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<br>
> >> >>> >> > 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<br>
> >> >>> >> > needs<br>
> >> >>> >> > quite<br>
> >> >>> >> > a<br>
> >> >>> >> > bit of work though last I tried. The speed issues will hopefully<br>
> >> >>> >> > 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<br>
> >> >>> >> > 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<br>
> >> >>> >> > 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'<br>
> >> >>> >> > 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<br>
> >> >>> >> > 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>
> ><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>
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>