Re: [postgis-users] please help convert raster problem
On Fri, Apr 1, 2011 at 5:18 AM, Eman Sayed eman_saye...@yahoo.com wrote: hello, i am using mapserver for windows (ms4w) ,postgres8.4,postgis2.0 and pmapper template i converted a jpg(1.45 MB) into postgis by this commands: aster2pgsql.py -r 555.jpg -t tablename -o image.sql psql -h localhost -U postgres -d template_postgis -f image.sql it is take much time to convert and create one raster table with one row but when i open the table on postgres give me that empty table or postgres backend crash and i find nothing on the map with no errors can any body help me please ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Hello, About your pgAdming screenshot, that doesn't mean the table is empty. Execute this query: select rid, ST_AsText(rast) from tablename You should see the column's rid and the WKT representation of your raster column. About the time, I don't really know. How much time did it take?, Do you have a psql log output? 1.45 MB is a small file. -- Jorge Arévalo Internet Mobilty Division, DEIMOS jorge.arev...@deimos-space.com http://es.linkedin.com/in/jorgearevalo80 http://mobility.grupodeimos.com/ http://gis4free.wordpress.com http://geohash.org/ezjqgrgzz0g ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] please help convert raster problem
pgAdmin has a confusing behavior to show a blank data cell if the number of characters is above some threshold in size. You can query the character length of a text result to see if it at leasts exists in some form: select character_length(st_astext(rast)) from tablename; hopefully you'll see a big number. -Mike On 1 April 2011 16:18, Eman Sayed eman_saye...@yahoo.com wrote: hello, i am using mapserver for windows (ms4w) ,postgres8.4,postgis2.0 and pmapper template i converted a jpg(1.45 MB) into postgis by this commands: aster2pgsql.py -r 555.jpg -t tablename -o image.sql psql -h localhost -U postgres -d template_postgis -f image.sql it is take much time to convert and create one raster table with one row but when i open the table on postgres give me that empty table or postgres backend crash and i find nothing on the map with no errors can any body help me please ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] please help convert raster problem
hello, i am using mapserver for windows (ms4w) ,postgres8.4,postgis2.0 and pmapper template i converted a jpg(1.45 MB) into postgis by this commands: aster2pgsql.py -r 555.jpg -t tablename -o image.sql psql -h localhost -U postgres -d template_postgis -f image.sql it is take much time to convert and create one raster table with one row but when i open the table on postgres give me that empty table or postgres backend crash and i find nothing on the map with no errors can any body help me pleaseattachment: imagetable.JPG___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users