Using a Custom Spatial Query | 51
Sample 1: Running a Custom Query
In this sample custom query, the user is supplying parameters to customize a
standard spatial query. The parameters simply provide the user with the
convenience of using parameters instead of having to type in, in this case,
geometry column and feature table names. This can be particularly helpful if
such names appear multiple times within a spatial query. If the values
change, the user can run the query multiple times without having to edit the
query details each time by allowing the parameters to pick up the correct
values.
Sample 1: Custom spatial query
In this sample, the following parameters are used:
■ %GEOMCOL: Comes from the Geometry Column control.
■ %FEATTABLE: Comes from the Feature Table control
This custom spatial query becomes the following after the Autodesk
MapGuide Server has updated the parameters with the appropriate values:
SELECT ID, FEATURE_GEOM FROM DUBLIN_PARCELS
Note Using parameters within a custom spatial query is optional.