[Mapserver-users] geometryfromtext in orcale spatial?

Fernando S. simon at inf.univali.br
Mon Jun 14 07:51:45 PDT 2004


This is a multi-part message in MIME format.
--------------010504080408060608090004
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: 8bit

Hi,
Well, sorry to report you only now. I believe that you need to define
the geometry column when you execute the query. I don't test this query,
but I believe that work's. I already work with this way, and run
correctly with mapserv.
So try to use:
data "the_geom from (select id, mdsys.SDO_GEOMETRY(2002, NULL, NULL,
mdsys.SDO_ELEM_INFO_ARRAY(1, 2, 1), mdsys.SDO_ORDINATE_ARRAY( *THE QUERY
THAT RETURN THE POINTS FOR LINE *)) as the_geom FROM table where id =
XXXXX)"
2002 - to define line
(1, 2, 1) - to define line

Here I used this and work correctly:
data "shape from (select mdsys.SDO_GEOMETRY(2003, 82295, NULL,
mdsys.SDO_ELEM_INFO_ARRAY(1, 1003, 4),
mdsys.SDO_ORDINATE_ARRAY(667052.077, 7092501.44, 657052.077, 7082501.44,
667052.077, 7072501.44)) as shape FROM fazendas where codigo_int =
79284237)"

I believe that this example can help you to define your query.
If you need some help you can report me.


==================================================================
Fernando Simon - simon at cttmar.univali.br
==================================================================
DataBase Manager, Mapserver, OracleSpatial Developer
G10 - Laborat¨®rio de Computac,a~o Aplicada
http://g10.cttmar.univali.br
==================================================================


Fu Chen wrote:

>Hi!
>I need to make a feature, that link gps points into line to render in mapserver.
>Vladimir Ilich Guzm¨¢n R. suggest to use geometryfromtest feature in postgis to achieve it. 
>It is something like
>
>$data="
>the_geom from (select oid,rumbo, geometryfromtext('MULTILINESTRING((' ||
>(select x(gps_geom) || ' ' || y(gps_geom) from gps_vehi ant where
>ant.gid<act.gid and ant.id_vehi=$id_vehi order by gid desc limit 1) ||
>',' || x(gps_geom) || ' ' || y(gps_geom) || '))',1) as the_geom from
>gps_vehi act where act.tiempo>='$from_time' AND act.tiempo<'$to_time'
>AND act.id_vehi=$id_vehi) as foo using unique oid using srid=1";
>$layer=$map->getLayerByName("secuencia_gps");
>$layer->set("data",$data);
>
>This method works in postgis. But this time I have to use oracle database.
>How can I achieve this feature in oracle spatial? Is there any oracle function I can use to replace geometryfromtext?
>
>Thanks!
>
>-----Original Message-----
>From: mapserver-users-admin at lists.gis.umn.edu
>[mailto:mapserver-users-admin at lists.gis.umn.edu]On Behalf Of Vladimir
>Guzm¨¢n
>Sent: Thursday, June 03, 2004 8:01 PM
>To: Fu Chen
>Cc: mapserver-users at lists.gis.umn.edu
>Subject: Re: [Mapserver-users] store and draw route
>
>
>Hello.
>We use postgis + phpmapscript, and is something like this:
>
>$data="
>the_geom from (select oid,rumbo, geometryfromtext('MULTILINESTRING((' ||
>(select x(gps_geom) || ' ' || y(gps_geom) from gps_vehi ant where
>ant.gid<act.gid and ant.id_vehi=$id_vehi order by gid desc limit 1) ||
>',' || x(gps_geom) || ' ' || y(gps_geom) || '))',1) as the_geom from
>gps_vehi act where act.tiempo>='$from_time' AND act.tiempo<'$to_time'
>AND act.id_vehi=$id_vehi) as foo using unique oid using srid=1";
>$layer=$map->getLayerByName("secuencia_gps");
>$layer->set("data",$data);
>
>Basically, what we do is a subquery to create a multilinestring from a
>point geometry.
>
>Hpe that helps,
>
>Vladimir Ilich Guzm¨¢n R.
>------------------------
>http://maintask.com 
>
>
>
>Fu Chen wrote:
>
>
>>Hi!
>>I try to use mapserver and postgis to record and render the some mobile worker's route.
>>Those routes are record by a data table like (workorID, time, position).
>>In the webgis interface, we try to draw a route map by mapserver.
>>Queried by the workor's ID, the position is sort by the time. then these points is linked with a line. We would like to draw a circle(or other symbol) on the key point if it is possible.
>>I don't know how to write map file or mapscript to get the feature.
>>Anybody can give me some suggestion?
>>Thank you!
>>
>>_______________________________________________
>>Mapserver-users mailing list
>>Mapserver-users at lists.gis.umn.edu
>>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>
>>
>> 
>>
>>
>
>_______________________________________________
>Mapserver-users mailing list
>Mapserver-users at lists.gis.umn.edu
>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
>_______________________________________________
>Mapserver-users mailing list
>Mapserver-users at lists.gis.umn.edu
>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
>


--------------010504080408060608090004
Content-Type: text/html; charset=GB2312
Content-Transfer-Encoding: 8bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=GB2312" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<font face="Helvetica, Arial, sans-serif">Hi, <br>
    Well, sorry to report you only now. I believe that you need to
define the geometry column when you execute the query. I don't test
this query, but I believe that work's. I already work with this way,
and run correctly with mapserv.<br>
    So try to use:<br>
       data "the_geom from (select id, mdsys.SDO_GEOMETRY(2002, NULL,
NULL, mdsys.SDO_ELEM_INFO_ARRAY(1, 2, 1), mdsys.SDO_ORDINATE_ARRAY( <b>THE
QUERY THAT RETURN THE POINTS FOR LINE </b>)) as the_geom FROM table
where id = XXXXX)"<br>
    2002 - to define line<br>
    (1, 2, 1) - to define line<br>
<br>
    Here I used this and work correctly:<br>
    data "shape from (select mdsys.SDO_GEOMETRY(2003, 82295, NULL,
mdsys.SDO_ELEM_INFO_ARRAY(1, 1003, 4),
mdsys.SDO_ORDINATE_ARRAY(667052.077, 7092501.44, 657052.077,
7082501.44, 667052.077, 7072501.44)) as shape FROM fazendas where
codigo_int = 79284237)"<br>
<br>
    I believe that this example can help you to define your query. <br>
    If you need some help you can report me.<br>
<br>
<br>
</font>==================================================================
<br>
Fernando Simon - <a class="moz-txt-link-abbreviated"
 href="mailto:simon at cttmar.univali.br">simon at cttmar.univali.br</a><br>
==================================================================
<br>
DataBase Manager, Mapserver, OracleSpatial Developer
<br>
G10 - Laborat¨®rio de Computação Aplicada
<br>
<a class="moz-txt-link-freetext" href="http://g10.cttmar.univali.br">http://g10.cttmar.univali.br</a>
<br>
==================================================================
<br>
<font face="Helvetica, Arial, sans-serif"><br>
<br>
Fu Chen wrote:</font>
<blockquote cite="midHLENLPCAGDEHMNMNLIDJCECGCDAA.fchen at ne.rsgs.ac.cn"
 type="cite">
  <pre wrap=""><font face="Helvetica, Arial, sans-serif">Hi!
I need to make a feature, that link gps points into line to render in mapserver.
Vladimir Ilich Guzm¨¢n R. suggest to use geometryfromtest feature in postgis to achieve it. 
It is something like

$data="
the_geom from (select oid,rumbo, geometryfromtext('MULTILINESTRING((' ||
(select x(gps_geom) || ' ' || y(gps_geom) from gps_vehi ant where
ant.gid<act.gid and ant.id_vehi=$id_vehi order by gid desc limit 1) ||
',' || x(gps_geom) || ' ' || y(gps_geom) || '))',1) as the_geom from
gps_vehi act where act.tiempo>='$from_time' AND act.tiempo<'$to_time'
AND act.id_vehi=$id_vehi) as foo using unique oid using srid=1";
$layer=$map->getLayerByName("secuencia_gps");
$layer->set("data",$data);

This method works in postgis. But this time I have to use oracle database.
How can I achieve this feature in oracle spatial? Is there any oracle function I can use to replace geometryfromtext?

Thanks!

-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:mapserver-users-admin at lists.gis.umn.edu">mapserver-users-admin at lists.gis.umn.edu</a>
[<a class="moz-txt-link-freetext" href="mailto:mapserver-users-admin at lists.gis.umn.edu">mailto:mapserver-users-admin at lists.gis.umn.edu</a>]On Behalf Of Vladimir
Guzm¨¢n
Sent: Thursday, June 03, 2004 8:01 PM
To: Fu Chen
Cc: <a class="moz-txt-link-abbreviated" href="mailto:mapserver-users at lists.gis.umn.edu">mapserver-users at lists.gis.umn.edu</a>
Subject: Re: [Mapserver-users] store and draw route


Hello.
We use postgis + phpmapscript, and is something like this:

$data="
the_geom from (select oid,rumbo, geometryfromtext('MULTILINESTRING((' ||
(select x(gps_geom) || ' ' || y(gps_geom) from gps_vehi ant where
ant.gid<act.gid and ant.id_vehi=$id_vehi order by gid desc limit 1) ||
',' || x(gps_geom) || ' ' || y(gps_geom) || '))',1) as the_geom from
gps_vehi act where act.tiempo>='$from_time' AND act.tiempo<'$to_time'
AND act.id_vehi=$id_vehi) as foo using unique oid using srid=1";
$layer=$map->getLayerByName("secuencia_gps");
$layer->set("data",$data);

Basically, what we do is a subquery to create a multilinestring from a
point geometry.

Hpe that helps,

Vladimir Ilich Guzm¨¢n R.
------------------------
<a class="moz-txt-link-freetext" href="http://maintask.com">http://maintask.com</a> 



Fu Chen wrote:

</font></pre>
  <blockquote type="cite">
    <pre wrap=""><font face="Helvetica, Arial, sans-serif">Hi!
I try to use mapserver and postgis to record and render the some mobile worker's route.
Those routes are record by a data table like (workorID, time, position).
In the webgis interface, we try to draw a route map by mapserver.
Queried by the workor's ID, the position is sort by the time. then these points is linked with a line. We would like to draw a circle(or other symbol) on the key point if it is possible.
I don't know how to write map file or mapscript to get the feature.
Anybody can give me some suggestion?
Thank you!

_______________________________________________
Mapserver-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Mapserver-users at lists.gis.umn.edu">Mapserver-users at lists.gis.umn.edu</a>
<a class="moz-txt-link-freetext" href="http://lists.gis.umn.edu/mailman/listinfo/mapserver-users">http://lists.gis.umn.edu/mailman/listinfo/mapserver-users</a>


 

</font></pre>
  </blockquote>
  <pre wrap=""><!----><font face="Helvetica, Arial, sans-serif">
_______________________________________________
Mapserver-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Mapserver-users at lists.gis.umn.edu">Mapserver-users at lists.gis.umn.edu</a>
<a class="moz-txt-link-freetext" href="http://lists.gis.umn.edu/mailman/listinfo/mapserver-users">http://lists.gis.umn.edu/mailman/listinfo/mapserver-users</a>

_______________________________________________
Mapserver-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Mapserver-users at lists.gis.umn.edu">Mapserver-users at lists.gis.umn.edu</a>
<a class="moz-txt-link-freetext" href="http://lists.gis.umn.edu/mailman/listinfo/mapserver-users">http://lists.gis.umn.edu/mailman/listinfo/mapserver-users</a>

</font></pre>
</blockquote>
<br>
</body>
</html>

--------------010504080408060608090004--



More information about the MapServer-users mailing list