[postgis-users] WKTRaster problems on Mac

Paragon Corporation lr at pcorp.us
Tue Jan 25 11:29:16 PST 2011


Ken,

If it helps -- here is a quick tutorial we wrote a while ago that shows how
to use the theming feature.  It's a bit dated, but I think still relevant.

http://www.postgresonline.com/journal/archives/72-OpenJump-for-PostGIS-Spati
al-Ad-Hoc-Queries.html

Hope that helps,
Leo and Regina
http://www.postgis.us
 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of knussear
Sent: Tuesday, January 25, 2011 2:19 PM
To: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] WKTRaster problems on Mac


I'm not an open Jump user, so I haven't explored any of these options


Paragon Corporation-2 wrote:
> 
> Ken,
> 
> Did you use the theming features of OpenJump.  That is what we usually 
> use to see the output.
> 
> Here is a snapshot from the latest revision of our raster chapter of 
> our upcoming book (due out hopefully in Mid-late February in print).
> Which is the output of this query (a raster intersected with a 100 
> meter radius buffer)  after we apply a gradient theme.
> 
> SELECT CAST((gval).val As integer) AS val,                             
>      ST_AsBinary((gval).geom) As geom                                  
> FROM (
> SELECT ST_Intersection(rast,1,buf.geom) As gval                     
> FROM ch13.kauai                                                        
>      INNER JOIN (                                                       
>      SELECT ST_Buffer(                                                  
>       ST_GeomFromText('POINT(444205 2438785)',26904),100)               
>      As geom) As buf ON                                                 
>     ST_Intersects(rast,buf.geom))      As foo
> 
> Also BTW:  Didn't see an image attached to your email.
> 
> Also I recall OJ has some issues with double precision and long int 
> which is why we cast it to an integer
> 
> Hope that helps,
> Regina and Leo
> http://www.postgis.us                      
> 
> 
> 
> 
> 
>  
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of 
> knussear
> Sent: Tuesday, January 25, 2011 7:58 AM
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] WKTRaster problems on Mac
> 
> 
>  I did finally get the Open Jump call to work, and can see the polygon 
> output. However its not entirely useful as I intend to use map algebra 
> etc on the raster......
> 
> The attachment from qgis shows the original  input raster on top of 
> what qgis shows for the raster. The qgis image of the postgis raster 
> alone is just all green (gray etc).
> 
> Ken
> 
> 
> Pierre Racine-2 wrote:
>> 
>> Actually the image in the previous post is the original. Attached is 
>> what he sees when viewing the image in QGIS after it was imported in 
>> PostGIS raster...
>> 
>>>-----Original Message-----
>>>From: postgis-users-bounces at postgis.refractions.net
>>>[mailto:postgis-users- bounces at postgis.refractions.net] On Behalf Of 
>>>Pierre Racine
>>>Sent: 24 janvier 2011 16:45
>>>To: PostGIS Users Discussion
>>>Subject: Re: [postgis-users] WKTRaster problems on Mac
>>>
>>>No but his first attempt was to open the image in QGIS. See the first
> mail. I attach the image he sent
>>>me as it was not attached in the first mail sent to users-postgis.
>>>
>>>I think this is typical of the first problem you met with the driver.
>>>
>>>Pierre
>>>
>>>>The GDAL driver is not being used in the commands I've seen. Did you 
>>>>execute the query Pierre suggested?
>>>>
>>>>SELECT ST_AsBinary((gv).geom), (gv).val FROM (SELECT
>>>>ST_DumpAsPolygons(rast) gv FROM x01) foo
>>>>
>>>>Replacing "x01" by your table's name.
>>>>
>>>>--
>>>>Jorge Arévalo
>>>>Internet & Mobilty Division, DEIMOS
>>>>jorge.arevalo at deimos-space.com
>>>>http://mobility.grupodeimos.com/
>>>>http://gis4free.wordpress.com
>>>>http://geohash.org/ezjqgrgzz0g
>>>>_______________________________________________
>>>>postgis-users mailing list
>>>>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
>> 
>> 
> 
> --
> View this message in context:
> http://old.nabble.com/WKTRaster-problems-on-Mac-tp30721572p30755095.ht
> ml 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
> 
>  
> _______________________________________________
> 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-tp30721572p30761033.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





More information about the postgis-users mailing list