[Mapserver-users] Problems with QUERY on SPATIALORACLE
Fernando S.
simon at inf.univali.br
Fri Mar 19 09:06:25 PST 2004
This is a multi-part message in MIME format.
--------------080304040905070605020804
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Hi all mapOracleSpatial users,
About the mapOracleSpatial, we (G10-LCA), intend to release a new
version (1.9) with this function implemented in the next week (friday).
What you think about been our betatesters? We are accepting propose!
We need some cases, examples where this functions are needed.
==================================================================
Fernando Simon - simon at cttmar.univali.br <mailto:simon at cttmar.univali.br>
==================================================================
DataBase Manager, Mapserver, OracleSpatial and PostGis Developer
G10 - Laboratório de Computação Aplicada
http://g10.cttmar.univali.br
==================================================================
Gregorio Greco wrote:
>
>
>*Hi All,
>
>I have a problem with SpatialOracle and I want to do simple query for the moment like this:*
>
>*I starting work with Mapserver and SpatialOracle:*
>
>*now I am successful to display the map and to navigate, * *therefore for this aspect ** I do not have problems...*
>
>*I have problems with 'query' o 'nquery' on data fetched from the spatialoracle tables.*
>
>*I have read **that others have my same problem and I have read in a mail (21 - Jan - 2004) **that you *
>
>*are working in this function....** I would want to know * *kindly* *when this function will be available or if it exists another *
>
>*way for to do this....*
>
>*I'm sorry for my little english and I thanks in advance who me will be able to help* *in this problem !*
>
>*I take a small portion of code of the map file:*
>
>*........ others settings ..................*
>
>*_____________________________________________________________________________________________________________________________*
>
>*LAYER # States polygon layer begins here
>
> NAME province
> CONNECTIONTYPE oraclespatial
> CONNECTION "greco/9meno5=4 at test9i <mailto:greco/9meno5=4 at test9i>"
>*
>
>* DATA "GEOM FROM (SELECT P.PROVINCIA,P.CASI_TOT,P.GEOM FROM PROVINCE P)"
>*
>
> **
>
>* STATUS DEFAULT
> TYPE POLYGON
>
>**
>CLASSITEM CASI_TOT
>*
>
>* CLASS
> NAME '141767-197144'
> EXPRESSION ([CASI_TOT] >= 141767 and [CASI_TOT] <= 197144)
> TEMPLATE 'templates/query_province.htm'
> COLOR 87 170 134
> OUTLINECOLOR 255 255 255
>
> END #end class*
>
>*_______________________________________________________________________________________*
>
>*.......etc etc etc........ *
>
>**
>
>**
>
>*Best Regards*
>
>*Gregorio*
>
>
>
>_________________________________________________________
>Dr. Gregorio Greco
>CINECA - InterUniversity Computing Center - SISS
>http://www.cineca.it
>Via Magnanelli, 6/3
>40033 Casalecchio di Reno (BO) Italy
>E-mail: g.greco at cineca.it <mailto:g.greco at cineca.it>
>Phone:+39-051-6171938
>_____________________________________________________
>
--------------080304040905070605020804
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body>
Hi all mapOracleSpatial users,<br>
About the mapOracleSpatial, we (G10-LCA), intend to release a new
version (1.9) with this function implemented in the next week (friday).
<br>
What you think about been our betatesters? We are accepting
propose! We need some cases, examples where this functions are needed.<br>
<br>
<font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;">==================================================================
<br>
Fernando Simon - <a href="mailto:simon at cttmar.univali.br">simon at cttmar.univali.br</a>
<br>
================================================================== <br>
DataBase Manager, Mapserver, OracleSpatial and PostGis Developer <br>
G10 - Laboratório de Computação Aplicada <br>
<a href="http://g10.cttmar.univali.br">http://g10.cttmar.univali.br</a>
<br>
==================================================================</span></font><br>
<br>
Gregorio Greco wrote:
<blockquote cite="mid004b01c40dc4$e6e70f30$2d07ba82 at int.cineca.it"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.2800.1400" name="GENERATOR">
<style></style>
<blockquote id="0"><label id="HbSession" sessionid="3264591565"></label>
<div><!--StartFragment --> </div>
</blockquote>
<blockquote style="margin-right: 0px;" dir="ltr">
<div align="justify">
<pre><font color="#0000ff" face="Arial"><strong>Hi All,
I have a problem with SpatialOracle and I want to do simple query for the moment like this:</strong></font></pre>
<pre><font color="#0000ff" face="Arial"><strong>I starting work with Mapserver and SpatialOracle:</strong></font></pre>
<pre><font color="#0000ff" face="Arial"><strong>now I <font
color="#000000"><font color="#0000ff"> am successful to display </font></font> the map and to navigate, <!--StartFragment --></strong><font
color="#000000"> <font color="#0000ff"><strong>therefore for this aspect <!--StartFragment --></strong><strong> I do not have problems...</strong></font></font></font></pre>
</div>
<div align="justify">
<pre><strong><font color="#ff0000" face="Arial">I have problems with 'query' o 'nquery' on data fetched from the spatialoracle tables.</font></strong></pre>
</div>
<div align="justify">
<pre><font color="#ff0000"><strong><font face="Arial"><font
color="#0000ff">I have read</font> </font></strong><font
color="#0000ff"><font face="Arial"><strong>that others have my same problem and I have read in a mail (21 - Jan - 2004) </strong></font></font></font><font
color="#ff0000"><font color="#0000ff"><font face="Arial"><strong>that you <!--StartFragment --></strong><font
color="#000000"> </font></font></font></font></pre>
</div>
<font color="#ff0000"><font color="#0000ff"> </font></font>
<div align="justify">
<pre><font color="#ff0000"><font color="#0000ff"><font face="Arial"><strong>are working in this function....<!--StartFragment --></strong><strong> I would want to know <!--StartFragment --></strong> <strong>kindly</strong> <strong>when this function will be available or if it exists another </strong></font></font></font></pre>
</div>
<font color="#ff0000"><font color="#0000ff"> </font></font>
<div align="justify">
<pre><font color="#ff0000"><font color="#0000ff"><font face="Arial"><strong>way for to do this....</strong> </font></font></font></pre>
</div>
<font color="#ff0000"><font color="#0000ff"> </font></font>
<div align="justify">
<pre><font color="#ff0000"><font color="#0000ff"><font face="Arial"><strong>I'm sorry for my little english and <!--StartFragment --> I thanks in advance who me will be able to help</strong> <strong>in this problem !</strong></font></font></font></pre>
</div>
<font color="#ff0000"><font color="#0000ff"> </font></font>
<div align="justify">
<pre><font color="#ff0000"><font color="#0000ff"><strong><font
face="Arial">I take a small portion of code of the map file:</font></strong></font></font></pre>
<pre><font color="#ff0000"><font color="#0000ff"><strong><font
face="Arial">........ others settings ..................</font></strong></font></font></pre>
<pre><font color="#ff0000"><font color="#0000ff"><strong><font
face="Arial">_____________________________________________________________________________________________________________________________</font></strong></font></font></pre>
<pre><font color="#ff0000"><font color="#0000ff"><strong><font
face="Arial">LAYER # States polygon layer begins here
NAME province
CONNECTIONTYPE oraclespatial
CONNECTION "<a href="mailto:greco/9meno5=4 at test9i">greco/9meno5=4 at test9i</a>"
</font></strong></font></font></pre>
<pre><font color="#ff0000"><font color="#0000ff"><strong><font
face="Arial"> DATA "GEOM FROM (SELECT P.PROVINCIA,P.CASI_TOT,P.GEOM FROM PROVINCE P)"
</font></strong></font></font></pre>
<font color="#ff0000"><font color="#0000ff"><strong></strong></font></font>
<pre><font color="#ff0000"><font color="#0000ff"><strong><font
face="Arial"> STATUS DEFAULT
TYPE POLYGON
</font></strong><strong><font face="Arial">
CLASSITEM CASI_TOT
</font></strong></font></font></pre>
<pre><font color="#ff0000"><font color="#0000ff"><strong><font
face="Arial"> CLASS
NAME '141767-197144'
EXPRESSION ([CASI_TOT] >= 141767 and [CASI_TOT] <= 197144)
TEMPLATE 'templates/query_province.htm'
COLOR 87 170 134
OUTLINECOLOR 255 255 255
END #end class</font></strong></font></font></pre>
<pre><font color="#ff0000"><font color="#0000ff"><strong><font
face="Arial">_______________________________________________________________________________________</font></strong></font></font></pre>
<pre><font color="#ff0000"><font color="#0000ff"><strong><font
face="Arial">.......etc etc etc........ </font></strong></font></font></pre>
<pre><font color="#ff0000"><font color="#0000ff"><strong></strong> </font></font></pre>
<pre><font color="#ff0000"><font color="#0000ff"><strong></strong> </font></font></pre>
<pre><font color="#ff0000"><font color="#0000ff"><strong><font
face="Arial">Best Regards</font></strong></font></font></pre>
</div>
<font color="#ff0000"><font color="#0000ff"> </font></font>
<div align="justify">
<pre><font color="#ff0000"><font color="#0000ff"><strong><font
face="Arial">Gregorio</font></strong></font></font></pre>
</div>
</blockquote>
<blockquote>
<pre> </pre>
<pre><font size="2">_________________________________________________________
Dr. Gregorio Greco
CINECA - InterUniversity Computing Center - SISS
<a href="http://www.cineca.it">http://www.cineca.it</a>
Via Magnanelli, 6/3
40033 Casalecchio di Reno (BO) Italy
E-mail: <a href="mailto:g.greco at cineca.it">g.greco at cineca.it</a>
Phone:+39-051-6171938
_____________________________________________________</font></pre>
</blockquote>
</blockquote>
<br>
</body>
</html>
--------------080304040905070605020804--
More information about the MapServer-users
mailing list