You have to replace x01 with your table name... Sorry it was not clear. Pierre
>-----Original Message----- >From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- >boun...@postgis.refractions.net] On Behalf Of knussear >Sent: 24 janvier 2011 12:47 >To: postgis-users@postgis.refractions.net >Subject: Re: [postgis-users] WKTRaster problems on Mac > > > >I used QGIS to create the image. I tried Open Jump, but I can't get anything >to load at all using the commands below. > >Might be my syntax, I've never used it before > >I get the message x01 does not exist... > >Ken > > > >Pierre Racine-2 wrote: >> >> Ken, >> >> I tried the .img file you sent me and everything seems ok. >> >> What did you use to produce this image? I suspect the image is well stored >> but the renderer you are using have some problems. >> >> To display images I use OpenJump and so a query like: >> >> SELECT ST_AsBinary((gv).geom), (gv).val >> FROM (SELECT ST_DumpAsPolygons(rast) gv FROM x01) foo >> >> to the database. >> >> Pierre >> >> From: postgis-users-boun...@postgis.refractions.net >> [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Ken >> Nussear >> Sent: 20 janvier 2011 12:41 >> To: postgis-users@postgis.refractions.net >> Subject: [postgis-users] WKTRaster problems on Mac >> >> Hi all. >> >> I've been working with the gdal2wktraster.py script trying to load some >> rasters to see it things work, and I'm having some difficulty. >> The example from the tutorial using the utml.tif tile seems to work fine, >> but every other raster I've tried gives strange results. >> Some show as all one value, and others appear to have irregular patches of >> values in the block sizes imported. >> >> >> I have tried tif, png, and img files some come in as pictured below, and >> some just come in with single values (e.g. 8 for all cells). Some have >> ridiculous numbers (e.g. 2.8026e-45) >> Some examples attached. >> >> >> I'm using a mac with postgis from William Kyngesburye @ >> kyngchaos.com<http://kyngchaos.com> >> >> >> postgresql version 9.0.2-1 >> postgis version 1.5.2-2 >> WKTRaster 0.1.6d r5997 for Postgres 9.0 >> >> commands used: >> >> >> >> >> /usr/local/pgsql/bin/gdal2wktraster.py -r D2BDRK_SLP_SAAT.img -t d2bdrk >> -k 32x32 -o d2bdrk.sql -s 26911 -I -M >> >> /usr/local/pgsql/bin/psql -d brdgisR -f d2bdrk.sql -U postgres -w >> >> >> I wonder if you have any advice on what might be going wrong? >> >> >> Thanks >> >> >> Ken >> >> >> >> >> [cid:image001.png@01CBB94E.7E398E80] >> >> >> [cid:image002.png@01CBB94E.7E398E80] >> >> >> >> [cid:image003.png@01CBB94E.7E398E80] >> >> >> >> >> _______________________________________________ >> postgis-users mailing list >> postgis-users@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> > >-- >View this message in context: >http://old.nabble.com/WKTRaster-problems-on-Mac-tp30721572p30748071.html >Sent from the PostGIS - User mailing list archive at Nabble.com. > >_______________________________________________ >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
