On 10/19/05, Fernando Javier Luyo Zegarra <[EMAIL PROTECTED]> wrote: > I have problems to filter the information of a layer stored in Oracle Spatial > > I have followed all the recommendations of mapfile reference but I have not > obtained satisfactory results
Fernando, Can you be more specific about what was unsatisfactory with your results? > I use connection OCI/OGR > > the syntax of mapfile is: > > *** layers departamentos*** > * > CONNECTION "OCI:system/[EMAIL PROTECTED]" > CONNECTIONTYPE OGR > DATA "scott.r_localidad"......# ¿As filter DATA for field "Tipo"? > * > *** End Layers The above looks ok to get all features (in the spatial area) from the scott.r_localidad table. Did you want to do some sort of filtering on the field Tipo? There are different ways to filter data, including using the FILTER keyword in the layer definition. If the text of the argument to the FILTER keyword starts with "WHERE" then it is assumed to be an SQL WHERE clause that should be passed on to Oracle. eg. CONNECTION "OCI:system/[EMAIL PROTECTED]" CONNECTIONTYPE OGR DATA "scott.r_localidad" FILTER "WHERE Tipo = 702" Note that there is also a "direct" oracle driver for mapserver available as opposed to going through OGR. The direct driver is likely to have better performance, but uses different configuration details. Best regards, -- ---------------------------------------+-------------------------------------- I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED] light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush | Geospatial Programmer for Rent
