[postgis-users] PostGIS Raster with Map Server

[Pierre Racine]

If http://www.gdal.org/gdal_translate.html does not work fine there is not much to do with MapServer. So give it a try first.

Pierre

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