[Mapserver-users] Help with OracleSpatial Query...

[Michael Schulz]

Hi,
as far as i know, oracle layers that are connected via the native
mapserver oraclespatial connection, cannot be queried at the moment.
This is still work in progress. Probably the ogr/oraclespatial
connection type will give you more opportunities.

ttt_query.html is a dummy name for the template used to present any
query results. You will have to create a template similar to the
template you use in the web section and add to that new template some
mapserver directives that will be replaced during the query result
processing, see the documentation on the mapserver template system,
especially the part on queries.

Cheers, Michael

"Becher, Richard" schrieb:

> Hi there,
>
> I am now trying to query some simple point data in an Oracle database
> using Mapserver.
>
> It seems I am connecting to the database properly and I do not get any
> errors.
>
> However, there are no points (data) showing up on my map.
>
> My “Points” layer is the last one in the map file and I have included
> it here.You will notice that I have commented out a few things (mainly
> because I don’t know how to properly use them) – i.e. LabelItem,
> CLASSITEM, EXPRESSION, TEMPLATE.
>
> Can someone help me figure out how to properly query data in an Oracle
> database (using Windows 2000, IIS, MapServer and Oracle 8i with
> Spatial Cartridge)?
>
> Also, how are templates supposed to be used?In other layers (from
> sample data) there is a reference to ttt_query.html as a template ---
> but that file does not exist on my machine…
>
> Here is a couple of records in the referenced table:
>
> PLACE_ID529
>
> VERSION_NO1
>
> LATLONGPOINT.SDO_GTYPE1
>
> LATLONGPOINT.SDO_SRID8265
>
> LATLONGPOINT.SDO_POINT.X51
>
> LATLONGPOINT.SDO_POINT.Y-116
>
> LATLONGPOINT.SDO_POINT.Z
>
> LATLONGPOINT.SDO_ELEM_INFO<Collection>
>
> LATLONGPOINT.SDO_ORDINATES<Collection>
>
> PLACE_ID530
>
> VERSION_NO1
>
> LATLONGPOINT.SDO_GTYPE1
>
> LATLONGPOINT.SDO_SRID8265
>
> LATLONGPOINT.SDO_POINT.X48
>
> LATLONGPOINT.SDO_POINT.Y-123
>
> LATLONGPOINT.SDO_POINT.Z
>
> LATLONGPOINT.SDO_ELEM_INFO<Collection>
>
> LATLONGPOINT.SDO_ORDINATES<Collection>
>
> PLACE_ID533
>
> VERSION_NO1
>
> LATLONGPOINT.SDO_GTYPE1
>
> LATLONGPOINT.SDO_SRID8265
>
> LATLONGPOINT.SDO_POINT.X44
>
> LATLONGPOINT.SDO_POINT.Y-76
>
> LATLONGPOINT.SDO_POINT.Z
>
> LATLONGPOINT.SDO_ELEM_INFO<Collection>
>
> LATLONGPOINT.SDO_ORDINATES<Collection>
>
> And here is the layer…
>
> LAYER
>
> NAME "Historical Sites"
>
> METADATA
>
> "DESCRIPTION""Historical Sites"
>
> END
>
> CONNECTIONTYPE oraclespatial
>
> CONNECTION 'user/pw at db'
>
> DATA "LatLongPoint from (Select Place_Id, LatLongPoint from
> CRHP_SPATIAL)"
>
> TYPE POINT
>
> STATUS ON
>
> #LabelItem "Place_Id"
>
> #CLASSITEM "Place_Id"
>
> CLASS
>
> NAME "Historical Sites"
>
> #EXPRESSION /./
>
> SYMBOL 2
>
> SIZE 8
>
> COLOR 255 0 0
>
> LABEL
>
> SIZE MEDIUM
>
> COLOR 255 0 0
>
> FORCE TRUE
>
> OFFSET 10 10
>
> END
>
> #TEMPLATE "oraclequery.html"
>
> END
>
> Many thanks in advance for your help and time!
>
> Cheers,
>
> Richard Becher
>
--
-----------------------------------------------------------
Michael Schulz                                in medias res
Dipl.-Geologe                              Gesellschaft für
                                Informationstechnologie mbH
                             Sautierstr. 38, 79104 Freiburg
                                     0761 55695-95 (Fax 96)
mschulz at webgis.de                             www.webgis.de