[postgis-users] WKTRaster problems on Mac

[Pierre Racine]

You have to replace x01 with your table name... Sorry it was not clear.

Pierre

>-----Original Message-----
>From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
>bounces at postgis.refractions.net] On Behalf Of knussear
>Sent: 24 janvier 2011 12:47
>To: postgis-users at 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-bounces at postgis.refractions.net
>> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Ken
>> Nussear
>> Sent: 20 janvier 2011 12:41
>> To: postgis-users at 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 at 01CBB94E.7E398E80]
>>
>>
>> [cid:image002.png at 01CBB94E.7E398E80]
>>
>>
>>
>> [cid:image003.png at 01CBB94E.7E398E80]
>>
>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at 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 at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users