Jorge, the spaces in the table name is because y paste it incorrectly in this post but in the console it`s ok. The table name is without spaces. That is not a problem.<div><br></div><div>thaks!</div><div>Virginia <br>
<br><br><div class="gmail_quote">2011/6/6 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;">
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>
<font color="#888888">Jorge<br>
</font><div><div></div><div class="h5"><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 with<br>
> the makepostgisdb.bat that de windows version brings. The only thing is that<br>
> i had to first create de DB and then in a separate .bat run the .sql load.<br>
> I installed gdal 1.8 and also have de gdal 1.8 in the mapserver (ms4w 3.0.2)<br>
> installation, but i cant connect with the data base i'm trying to run a<br>
> gdal_translate or gdal_info and it doesnt work. I created a new data base<br>
> 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<br>
> dadDeExtincion mode=2" C:\TSIG\capas\sql2\HumedadDeExtincion.tif<br>
> ERROR 1: Error browsing database for PostGIS Raster properties<br>
> GDALOpen failed - 1<br>
> Error browsing database for PostGIS Raster properties<br>
><br>
> Any way...i will post this problem in another thread because the subject is<br>
> 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<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>><br>
>> > 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>
>> >>><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<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>
</div></div></blockquote></div><br></div>