[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Possibility of connecting and writing Queries
From:       Joan <wamaithajoan () gmail ! com>
Date:       2011-11-24 14:52:45
Message-ID: CAAjRq6ju4_qWq2NBY7n7XqJ4k594QbC=vBCpVZqgq2FU_C97tA () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hi Iyke,

Check out this link.

http://www.manning-sandbox.com/thread.jspa?threadID=45833

Regards

Joan

On 24 November 2011 15:48, maduako ikechukwu <iykemadu84@gmail.com> wrote:

>
> Hi Guys,
> Is it possible to connect to my database from OpenJumP and write my
> queries of any kind and obtain results?.
> I don't mean to visualize the data that we usually do by using the
> ''ST_asBinary'' but just like accessing my database and running queries
> from the Desktop application such as OpenJumP.
> For example, I sent this query to my database:
>
> SELECT v as elevation
> FROM (SELECT ST_Value(rast,ST_Point(-106.2,38.2))as v FROM srtm
> WHERE ST_Value(rast,ST_Point(-106.2,38.2)) IS NOT NULL)foo;
>
> and OpenJumP says "-1 Array Index Out Of Bound Exception "
>
> I need suggestions guys, am trying something out.
>
>
> --
> Iyke Maduako
>
> Masters in Geospatial Technologies
>  Institute for Geoinformatics,IfGI
>  University of Muenster Germany
> Phone: +4915129048460
> Alternative Email:iykefirstclass@yahoo.com
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>

[Attachment #5 (text/html)]

<div>Hi Iyke,<br></div><div><br></div><div>Check out this \
link.</div><div><br></div><div><a \
href="http://www.manning-sandbox.com/thread.jspa?threadID=45833">http://www.manning-sandbox.com/thread.jspa?threadID=45833</a></div>
 <div><br></div><div>Regards</div><div><br></div><div>Joan</div><br><div \
class="gmail_quote">On 24 November 2011 15:48, maduako ikechukwu <span \
dir="ltr">&lt;<a href="mailto:iykemadu84@gmail.com">iykemadu84@gmail.com</a>&gt;</span> \
wrote:<br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex;"><br clear="all"><div>Hi Guys,</div><div>Is it possible \
to connect to my database from OpenJumP and write my queries of any kind and obtain \
results?.</div> <div>I don&#39;t mean to visualize the data that we usually do by \
using the &#39;&#39;ST_asBinary&#39;&#39; but just like accessing my database and \
running queries from the Desktop application such as OpenJumP.</div> <div>For \
example, I sent this query to my database:</div><div><br></div><div><div>SELECT v as \
elevation</div><div>FROM (SELECT ST_Value(rast,ST_Point(-106.2,38.2))as v FROM srtm \
</div><div>WHERE ST_Value(rast,ST_Point(-106.2,38.2)) IS NOT NULL)foo;</div>

</div><div><br></div><div>and OpenJumP says &quot;-1 Array Index Out Of Bound \
Exception &quot;</div><div><br></div><div>I need suggestions guys, am trying \
something out.</div><span class="HOEnZb"><font color="#888888"><div> \
<br></div><div><br></div>-- <br><font face="Calibri, sans-serif" size="2"><div \
style="color:rgb(0,0,0)"> <font face="Arial, sans-serif" size="2">Iyke \
Maduako<br><br></font><font style="color:rgb(0,0,0)" face="Calibri, sans-serif" \
size="2"><font face="Arial, sans-serif">Masters in Geospatial \
Technologies</font></font><br></div>

<span style="color:rgb(0,0,0)">
</span><div style="color:rgb(0,0,0)"><font face="Arial, sans-serif" \
size="2">Institute for Geoinformatics,</font><font face="Calibri, sans-serif" \
size="2"><font face="Arial, sans-serif" size="2">IfGI <br></font></font></div>

<span style="color:rgb(0,0,0)">
</span><div style="color:rgb(0,0,0)"><font face="Arial, sans-serif" \
size="2">University of Muenster Germany<br></font></div><span \
style="color:rgb(0,0,0)"> </span><div style="color:rgb(0,0,0)"><font face="Arial, \
sans-serif" size="2">Phone: <a href="tel:%2B4915129048460" value="+4915129048460" \
target="_blank">+4915129048460</a><br></font></div><font face="Arial, \
sans-serif"><span style="color:rgb(0,0,0)">Alternative <a style="color:rgb(0,0,0)" \
href="mailto:Email%3Aiykefirstclass@yahoo.com" \
target="_blank">Email:iykefirstclass@yahoo.com</a></span><br \
style="color:rgb(0,0,0)">

</font><div style="color:rgb(0,0,0)"><font face="Arial, sans-serif" size="2"> \
</font></div></font><br> \
</font></span><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></blockquote></div><br>



_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic