I trie with following command and its working quite perfectly<br><br>gdal_translate -of PNG -co "TILED=YES" 2.tiff 2.png -outsize 2048 2048<br><br>but i am still having black lines in final output while using mapserver.<br>
<br><div class="gmail_quote">On Sun, May 13, 2012 at 5:10 PM, Pierre Racine <span dir="ltr"><<a href="mailto:Pierre.Racine@sbf.ulaval.ca" target="_blank">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">
If <a href="http://www.gdal.org/gdal_translate.html" target="_blank">http://www.gdal.org/gdal_translate.html</a> does not work fine there is not much to do with MapServer. So give it a try first.<br>
<div class="im HOEnZb"><br>
Pierre<br>
<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>
> <a href="mailto:bounces@postgis.refractions.net">bounces@postgis.refractions.net</a>] On Behalf Of abhishek bansal<br>
</div><div class="im HOEnZb">> Sent: Sunday, May 13, 2012 7:30 AM<br>
> To: PostGIS Users Discussion<br>
> Subject: Re: [postgis-users] PostGIS Raster with Map Server<br>
><br>
</div><div class="HOEnZb"><div class="h5">> no i dont know about them.. but anyhow now i am able to get that raster layer.<br>
> (I think there was some permission issue in database tables). But now I am<br>
> having artifacts in my raster image. I can see orthogonal black lines in my output<br>
> image. Are they because of tiling ..I am not able to get that.. please help !<br>
> Thank You<br>
><br>
><br>
> On Sun, May 13, 2012 at 4:53 PM, Pierre Racine <<a href="mailto:Pierre.Racine@sbf.ulaval.ca">Pierre.Racine@sbf.ulaval.ca</a>><br>
> wrote:<br>
><br>
><br>
> Did you try to do gdalinfo and/or gdal_translate with the same<br>
> parameters?<br>
><br>
> Pierre<br>
><br>
><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-">postgis-</a><br>
> users-<br>
> > <a href="mailto:bounces@postgis.refractions.net">bounces@postgis.refractions.net</a>] On Behalf Of abhishek bansal<br>
> > Sent: Saturday, May 12, 2012 1:19 AM<br>
> > To: PostGIS Users Discussion<br>
> > Subject: Re: [postgis-users] PostGIS Raster with Map Server<br>
> ><br>
> > And url I am using for mapserver is<br>
> ><br>
> > <a href="http://localhost/cgi-" target="_blank">http://localhost/cgi-</a><br>
> ><br>
> bin/mapserv.exe?map=/ms4w/Apache/htdocs/raster_wmsServerPostGIS.map&<br>
> ><br>
> SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&LAYERS=rasterLayer,point<br>
> ><br>
> s1,waterways&STYLES=&SRS=EPSG:4326&BBOX=68.820812,8.082365,96.07060<br>
> > 2,34.585531&WIDTH=800&HEIGHT=600&FORMAT=image/png<br>
> ><br>
> > I am able to see waterways and points1 whicha re my vector layers<br>
> but not<br>
> > rasterlayer.<br>
> > I am also not able to visualize this rasterlaer in QGIS.<br>
> ><br>
> > I am stuck at this point.<br>
> ><br>
> ><br>
> > On Sat, May 12, 2012 at 10:11 AM, abhishek bansal<br>
> <<a href="mailto:discover.ab@gmail.com">discover.ab@gmail.com</a>><br>
> > wrote:<br>
> ><br>
> ><br>
> > Thanks for your reply<br>
> > sorry that was a typo in the mail... that didn't help also!!<br>
> ><br>
> ><br>
> > On Sat, May 12, 2012 at 3:51 AM, <<a href="mailto:pcreso@pcreso.com">pcreso@pcreso.com</a>> wrote:<br>
> ><br>
> ><br>
> > It looks like you are missing a quote in your data statement after<br>
> "'asdf " and my<br>
> > have an extra one at the end?<br>
> ><br>
> > That might help...<br>
> ><br>
> > Brent Wood<br>
> ><br>
> > --- On Sat, 5/12/12, abhishek bansal <<a href="mailto:discover.ab@gmail.com">discover.ab@gmail.com</a>> wrote:<br>
> ><br>
> ><br>
> ><br>
> > From: abhishek bansal <<a href="mailto:discover.ab@gmail.com">discover.ab@gmail.com</a>><br>
> > Subject: [postgis-users] PostGIS Raster with Map Server<br>
> > To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> > Date: Saturday, May 12, 2012, 2:27 AM<br>
> ><br>
> ><br>
> > hello all,<br>
> ><br>
> > I am very new to all this Geo-spatial world. I am using map server<br>
> to<br>
> > display my maps in browser. I am also using Postgres and PostGIS<br>
> raster to store<br>
> > my tiff images in database. now I need to configure mapserver map<br>
> file to<br>
> > display this tiff file which is stored in database. I googled a lot and<br>
> found this<br>
> > technique which is not working for me i.e. my raster image does not<br>
> show up<br>
> > while using GetMap.<br>
> ><br>
> > I created my raster using following command<br>
> > raster2pgsql -s 4326 -I -C -M my.tif -F -t 100x100 public.asdf ><br>
> elev.sql<br>
> ><br>
> > than I imported this sql file into my PostGIS database using<br>
> postgres PG<br>
> > Admin 3.<br>
> ><br>
> > My map file layer config is as follows:<br>
> > LAYER<br>
> > METADATA<br>
> > "wms_title" "rasterlayer" ##required<br>
> > END<br>
> > NAME rasterlayer<br>
> > CONNECTIONTYPE postgis<br>
> ><br>
> > DATA "PG:host=localhost port:5432 dbname='postgis'<br>
> user='postgres'<br>
> > password='something' schema='public' table='asdf mode='2''"<br>
> > PROCESSING "NODATA=0"<br>
> > PROCESSING "SCALE=AUTO"<br>
> ><br>
> > STATUS ON<br>
> > TYPE RASTER<br>
> > PROCESSING "BANDS=1,2,3"<br>
> > OFFSITE 71 74 65<br>
> > END<br>
> ><br>
> > I found this in postGIS documentation.<br>
> > this return me a empty image in browser.<br>
> > Plz help !!<br>
> ><br>
> ><br>
> > --<br>
> > Thanks & Regards,<br>
> > Abhishek Bansal<br>
> > <a href="http://abhishekbansal.miyuri.com" target="_blank">http://abhishekbansal.miyuri.com</a><br>
> > Jaypee Institute of Information Technology, Noida<br>
> ><br>
> ><br>
> ><br>
> ><br>
> > -----Inline Attachment Follows-----<br>
> ><br>
> ><br>
> > _______________________________________________<br>
> > postgis-users mailing list<br>
><br>
> > <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> <<a href="http://mc/compose?to=postgis-" target="_blank">http://mc/compose?to=postgis-</a><br>
> > <a href="mailto:users@postgis.refractions.net">users@postgis.refractions.net</a>><br>
><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>
> > --<br>
> > Thanks & Regards,<br>
> > Abhishek Bansal<br>
> > <a href="http://abhishekbansal.miyuri.com" target="_blank">http://abhishekbansal.miyuri.com</a><br>
> > Jaypee Institute of Information Technology, Noida<br>
> ><br>
> ><br>
> ><br>
> ><br>
> ><br>
> ><br>
> ><br>
> > --<br>
> > Thanks & Regards,<br>
> > Abhishek Bansal<br>
> > <a href="http://abhishekbansal.miyuri.com" target="_blank">http://abhishekbansal.miyuri.com</a><br>
> > Jaypee Institute of Information Technology, Noida<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>
> Thanks & Regards,<br>
> Abhishek Bansal<br>
> <a href="http://abhishekbansal.miyuri.com" target="_blank">http://abhishekbansal.miyuri.com</a><br>
> Jaypee Institute of Information Technology, Noida<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>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Thanks & Regards,<br>Abhishek Bansal<br><a href="http://abhishekbansal.miyuri.com" target="_blank">http://abhishekbansal.miyuri.com</a><br>Jaypee Institute of Information Technology, Noida<br>
<br><br>