Virginia, Looking at what you have here. I think what Leo was thinking was right. Your table is mixed case. When you put it in gdal_translate without quoting, it becomes lower case so can't find the table. It's best to just lowercase your tables in the database as he had suggestedin the prior email. It will save you a great deal of grief in the future. As you have it currently you will always have to quote "HumedadDeExtinction" Hope that helps, Regina and Leo, http://www.postgis.us
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Virginia Maffei Sent: Monday, June 06, 2011 9:06 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Mapserver connection to Postgis Raster I attached the sql. I hope this could help to find out whats happening. This is what raster_columns has: "r_table_catalog";"r_table_schema";"r_table_name";"r_column";"srid";"pixel_t ypes";"out_db";"regular_blocking";"nodata_values";"scale_x";"scale_y";"block size_x";"blocksize_y";"extent" "";"public";"HumedadDeExtincion";"rast";-1;"{64BF}";f;f;"";1000;-1000;;;"" thanks! Virginia 2011/6/6 Jorge Arévalo <[email protected]> Hi, No, the driver doesn't need an empty entry in raster_columns table. It only checks for raster_columns' existence. This is one of the things I'm going to delete from the driver's code. Virginia, raster_columns table is used in PostGIS Raster extension, to store metadata, but the driver doesn't use it. I don't think that's the problem. Could you send me the SQL code for your raster table? The code generated by raster2pgsql script. Best regards, Jorge On Mon, Jun 6, 2011 at 4:14 PM, Virginia Maffei <[email protected]> wrote: > Sorry but i didn't understand very well. In the raster_columns table i have > an entry for this table. > I dont now if i'm answering you question. > Virginia > > On Mon, Jun 6, 2011 at 10:54 AM, Pierre Racine <[email protected]> > wrote: >> >> Would it be possible that the driver needs a missing entry in the >> raster_columns table? >> >> > -----Original Message----- >> > From: [email protected] >> > [mailto:postgis-users- >> > [email protected]] On Behalf Of Jorge Arévalo >> > Sent: Monday, June 06, 2011 4:01 AM >> > To: PostGIS Users Discussion >> > Subject: Re: [postgis-users] Mapserver connection to Postgis Raster >> > >> > Hi, >> > >> > Did you test using single quotes surrounding at least the table name? >> > The blank spaces may cause problems. >> > >> > Best regards, >> > Jorge >> > >> > On Sun, Jun 5, 2011 at 11:03 PM, Virginia Maffei <[email protected]> >> > wrote: >> > > 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. >> > > 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 >> > > This is the error that it shows: >> > > C:\ms4w\tools\gdal-ogr>gdal_translate PG:"dbname=raster user=postgres >> > > table=Hume dadDeExtincion mode=2" >> > > C:\TSIG\capas\sql2\HumedadDeExtincion.tif >> > > ERROR 1: Error browsing database for PostGIS Raster properties >> > > GDALOpen failed - 1 Error browsing database for PostGIS Raster >> > > properties >> > > >> > > Any way...i will post this problem in another thread because the >> > > subject is different. >> > > regards, >> > > Virginia >> > > >> > > >> > > 2011/6/3 Jorge Arévalo <[email protected]> >> > >> >> > >> [SP] Hola Virginia. Realmente el único español, que yo sepa, soy yo, >> > >> así que si no te importa, voy a responder a tu pregunta en inglés >> > >> >> > >> [EN] Hi Virginia, AFAIK, I'm the only Spanish on the list. So, I'm >> > >> going to answer your question in english. >> > >> >> > >> Are you sure you loaded all the needed sql files? These are >> > >> postgis.sql, spatial_ref_sys.sql and rtpostgis.sql >> > >> >> > >> Best regards, >> > >> Jorge >> > >> >> > >> On Thu, Jun 2, 2011 at 11:36 PM, Virginia Maffei <[email protected]> >> > >> wrote: >> > >> > Hola! estoy intentando cargar manualmente el raster support y estoy >> > >> > ejecutando el rtpostgissql que trae el postgis2.0 Pero al >> > >> > ejecutarlo me tira que no existe la funcion box2d(raster) Alguna >> > >> > idea de que puede estar pasando? >> > >> > Gracias! >> > >> > PD: Escribí en español porque me pareció ver que son de españa y yo >> > >> > en realidad hablo en español. >> > >> > saludos! >> > >> > Virginia >> > >> > >> > >> > >> > >> > On Thu, Jun 2, 2011 at 11:16 AM, Virginia Maffei >> > >> > <[email protected]> >> > >> > wrote: >> > >> >> >> > >> >> Thank you!! I will try that installation Virginia >> > >> >> >> > >> >> >> > >> >> 2011/6/2 Jorge Arévalo <[email protected]> >> > >> >>> >> > >> >>> On Thu, Jun 2, 2011 at 3:25 PM, Virginia Maffei >> > >> >>> <[email protected]> >> > >> >>> wrote: >> > >> >>> > Thank you for your quick response! >> > >> >>> > I have another question: can i install postgis 2.0 in windows? >> > >> >>> > where >> > >> >>> > can I >> > >> >>> > download it? >> > >> >>> > >> > >> >>> > >> > >> >>> > Virginia >> > >> >>> > >> > >> >>> >> > >> >>> Yes, you can. Follow this post's instructions: >> > >> >>> >> > >> >>> >> > >> >>> http://gis4free.wordpress.com/2011/03/10/how-to-install-and- >> > configure-postgis-raster-on-windows/ >> > >> >>> >> > >> >>> Best regards, >> > >> >>> Jorge >> > >> >>> >> > >> >>> >> > >> >>> > >> > >> >>> > 2011/6/2 Jorge Arévalo <[email protected]> >> > >> >>> >> >> > >> >>> >> Hi, >> > >> >>> >> >> > >> >>> >> The mode=2 parameter is only valid with the last version of >> > >> >>> >> GDAL >> > >> >>> >> (1.8.0). So, as Regina said, you need that version to make it >> > >> >>> >> work >> > >> >>> >> properly. More accurately: >> > >> >>> >> >> > >> >>> >> - With a GDAL version down to 1.7.1, you can't make it work in >> > >> >>> >> any >> > >> >>> >> way. No driver. >> > >> >>> >> >> > >> >>> >> - With a GDAL version between 1.7.1 and 1.7.3, both included, >> > >> >>> >> you >> > >> >>> >> can >> > >> >>> >> use the old version of the driver, thought to work with the >> > >> >>> >> old >> > >> >>> >> wktraster extension, now abandoned. And it was buggy. Not >> > >> >>> >> recommended. >> > >> >>> >> Neither GDAL 1.7.x nor wktraster. >> > >> >>> >> >> > >> >>> >> - With GDAL version up to 1.8.0, you can use the last version >> > >> >>> >> of >> > >> >>> >> GDAL >> > >> >>> >> PostGIS Raster driver, and you'll need PostGIS 2.0, that >> > >> >>> >> includes >> > >> >>> >> PostGIS Raster extension. Additionally, as Regina said, those >> > >> >>> >> days >> > >> >>> >> we're working on the driver, and all the improvements will be >> > >> >>> >> included >> > >> >>> >> in GDAL 1.8.x >> > >> >>> >> >> > >> >>> >> So, summarizing: You need PostGIS 2.0 plus GDAL 1.8.0 to make >> > >> >>> >> it >> > >> >>> >> work. >> > >> >>> >> >> > >> >>> >> Further information on the driver: >> > >> >>> >> http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html >> > >> >>> >> >> > >> >>> >> Best regards, >> > >> >>> >> Jorge >> > >> >>> >> >> > >> >>> >> On Thu, Jun 2, 2011 at 6:53 AM, Paragon Corporation >> > >> >>> >> <[email protected]> >> > >> >>> >> wrote: >> > >> >>> >> > Virginia, >> > >> >>> >> > >> > >> >>> >> > I think you are missing a mode='2' in your connection. >> > >> >>> >> > That was >> > >> >>> >> > a >> > >> >>> >> > new >> > >> >>> >> > requirement that was added for GDAL 1.8+ >> > >> >>> >> > >> > >> >>> >> > Try putting that in. I think the speed on the loading still >> > >> >>> >> > needs >> > >> >>> >> > quite >> > >> >>> >> > a >> > >> >>> >> > bit of work though last I tried. The speed issues will >> > >> >>> >> > hopefully >> > >> >>> >> > be >> > >> >>> >> > resolved before 2.0 release. >> > >> >>> >> > >> > >> >>> >> > Thanks, >> > >> >>> >> > Regina >> > >> >>> >> > http://www.postgis.us >> > >> >>> >> > >> > >> >>> >> > >> > >> >>> >> > ________________________________ >> > >> >>> >> > From: [email protected] >> > >> >>> >> > [mailto:[email protected]] On >> > >> >>> >> > Behalf >> > >> >>> >> > Of >> > >> >>> >> > Virginia >> > >> >>> >> > Maffei >> > >> >>> >> > Sent: Wednesday, June 01, 2011 8:00 PM >> > >> >>> >> > To: [email protected] >> > >> >>> >> > Subject: [postgis-users] Mapserver connection to Postgis >> > >> >>> >> > Raster >> > >> >>> >> > >> > >> >>> >> > Hi, i'm new at this and i'm trying to connect to postgis >> > >> >>> >> > raster >> > >> >>> >> > in >> > >> >>> >> > the >> > >> >>> >> > mapfile. >> > >> >>> >> > I loaded a tif file into postgis raster database with the >> > >> >>> >> > raster2pgsql.py >> > >> >>> >> > script. It created a table with 2 fields: rid and rast. >> > >> >>> >> > In the mapfile i added the connection like it specifies in >> > >> >>> >> > the >> > >> >>> >> > postgis >> > >> >>> >> > raster FAQ but it doesn't displays anything. >> > >> >>> >> > This is my mapfile: >> > >> >>> >> > MAP >> > >> >>> >> > IMAGETYPE PNG24 >> > >> >>> >> > EXTENT 366582.2901411663 6127927.100382689 >> > >> >>> >> > 857582.2901411663 >> > >> >>> >> > 6670927.100382689 >> > >> >>> >> > SIZE 491 543 >> > >> >>> >> > SHAPEPATH "../data" >> > >> >>> >> > LAYER # MODIS raster layer begins here >> > >> >>> >> > NAME modis >> > >> >>> >> > TYPE RASTER >> > >> >>> >> > STATUS ON >> > >> >>> >> > DATA "PG:host=localhost port=5432 dbname='postgis' >> > >> >>> >> > user='postgres' >> > >> >>> >> > password='postgres' schema='public' >> > >> >>> >> > table='HumedadDeExtincion'" >> > >> >>> >> > PROCESSING "NODATA=0" >> > >> >>> >> > PROCESSING "SCALE=AUTO" >> > >> >>> >> > PROCESSING "SCALE_BUCKETS=201" >> > >> >>> >> > PROCESSING "BANDS=1" >> > >> >>> >> > OFFSITE 71 74 65 >> > >> >>> >> > CLASS >> > >> >>> >> > NAME "red" >> > >> >>> >> > EXPRESSION ([pixel] < 10) >> > >> >>> >> > COLOR 255 0 0 >> > >> >>> >> > END >> > >> >>> >> > CLASS >> > >> >>> >> > NAME "green" >> > >> >>> >> > EXPRESSION ([pixel] >= 10 AND [pixel] < 15000 ) >> > >> >>> >> > COLOR 0 255 0 >> > >> >>> >> > END >> > >> >>> >> > CLASS >> > >> >>> >> > NAME "blue" >> > >> >>> >> > EXPRESSION ([pixel] >= 15000 ) >> > >> >>> >> > COLOR 0 255 0 >> > >> >>> >> > END >> > >> >>> >> > END # MODIS raster layer ends here >> > >> >>> >> > >> > >> >>> >> > # End of LAYER DEFINITIONS ------------------------------- >> > >> >>> >> > END # All map files must come to an end just as all other >> > >> >>> >> > things >> > >> >>> >> > must >> > >> >>> >> > come >> > >> >>> >> > to... >> > >> >>> >> > >> > >> >>> >> > I have gdal 1.6 , postgis 1.5 and ms4w with mapserver 5.6.6 >> > >> >>> >> > We cant see the tiff file on the browser, it only appears a >> > >> >>> >> > white >> > >> >>> >> > image. >> > >> >>> >> > We did try with the tif without the database connection an >> > >> >>> >> > it >> > >> >>> >> > works. >> > >> >>> >> > Could you help us? >> > >> >>> >> > Thank you >> > >> >>> >> > >> > >> >>> >> > _______________________________________________ >> > >> >>> >> > postgis-users mailing list >> > >> >>> >> > [email protected] >> > >> >>> >> > >> > >> >>> >> > http://postgis.refractions.net/mailman/listinfo/postgis-users >> > >> >>> >> > >> > >> >>> >> > >> > >> >>> >> >> > >> >>> >> >> > >> >>> >> >> > >> >>> >> -- >> > >> >>> >> Jorge Arévalo >> > >> >>> >> Internet & Mobilty Division, DEIMOS >> > >> >>> >> [email protected] >> > >> >>> >> http://es.linkedin.com/in/jorgearevalo80 >> > >> >>> >> http://mobility.grupodeimos.com/ >> > >> >>> >> http://gis4free.wordpress.com >> > >> >>> >> http://geohash.org/ezjqgrgzz0g >> > >> >>> >> _______________________________________________ >> > >> >>> >> postgis-users mailing list >> > >> >>> >> [email protected] >> > >> >>> >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > >> >>> > >> > >> >>> > >> > >> >>> > _______________________________________________ >> > >> >>> > postgis-users mailing list >> > >> >>> > [email protected] >> > >> >>> > http://postgis.refractions.net/mailman/listinfo/postgis-users >> > >> >>> > >> > >> >>> > >> > >> >>> >> > >> >>> >> > >> >>> >> > >> >>> -- >> > >> >>> Jorge Arévalo >> > >> >>> Internet & Mobilty Division, DEIMOS >> > >> >>> [email protected] >> > >> >>> http://es.linkedin.com/in/jorgearevalo80 >> > >> >>> http://mobility.grupodeimos.com/ >> > >> >>> http://gis4free.wordpress.com >> > >> >>> http://geohash.org/ezjqgrgzz0g >> > >> >>> _______________________________________________ >> > >> >>> postgis-users mailing list >> > >> >>> [email protected] >> > >> >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > >> >> >> > >> > >> > >> > >> > >> > _______________________________________________ >> > >> > postgis-users mailing list >> > >> > [email protected] >> > >> > http://postgis.refractions.net/mailman/listinfo/postgis-users >> > >> > >> > >> > >> > >> >> > >> >> > >> >> > >> -- >> > >> Jorge Arévalo >> > >> Internet & Mobilty Division, DEIMOS >> > >> [email protected] >> > >> http://es.linkedin.com/in/jorgearevalo80 >> > >> http://mobility.grupodeimos.com/ >> > >> http://gis4free.wordpress.com >> > >> http://geohash.org/ezjqgrgzz0g >> > >> _______________________________________________ >> > >> postgis-users mailing list >> > >> [email protected] >> > >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > > >> > > >> > > _______________________________________________ >> > > postgis-users mailing list >> > > [email protected] >> > > http://postgis.refractions.net/mailman/listinfo/postgis-users >> > > >> > > >> > >> > >> > >> > -- >> > Jorge Arévalo >> > Internet & Mobilty Division, DEIMOS >> > [email protected] >> > http://es.linkedin.com/in/jorgearevalo80 >> > http://mobility.grupodeimos.com/ >> > http://gis4free.wordpress.com >> > http://geohash.org/ezjqgrgzz0g >> > _______________________________________________ >> > postgis-users mailing list >> > [email protected] >> > http://postgis.refractions.net/mailman/listinfo/postgis-users >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- Jorge Arévalo Internet & Mobilty Division, DEIMOS [email protected] http://es.linkedin.com/in/jorgearevalo80 http://mobility.grupodeimos.com/ http://gis4free.wordpress.com http://geohash.org/ezjqgrgzz0g _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
