[Mapserver-users] RE: Oracle Spatial Support

[Jan Hartmann]

WOW, this is important! Frank, could you be a bit more specific on this 
JOIN support:

1) How do you specify the tables in the join? In your example you use a 
shapefile called "shppoly", and you use the tables "poly" and "idlink" 
for the JOIN. Where are those two tables located?

2) What are the restrictions? How much SQL do you support?

3) Has ogr2ogr some of this JOIN functionality?

Thanks,

Jan

Frank Warmerdam wrote:
> 
> 
> Note, in MapServer 3.7 the preferred OGR syntax is now:
> 
>  CONNECTION "<datasource_name>"
>  DATA "<layer_definition>"
> 
> The layer definition can be a layer name, number or an SQL query (even
> when the datastore is not an RDBMS ... though with limitations).
> 
> For instance, the test suite uses this to test OGR join support in a 
> mapfile:
> 
> 
> LAYER
>   NAME shppoly
>   TYPE polygon
>   CONNECTIONTYPE OGR
>   CONNECTION "data/shppoly.shp"
>   DATA "SELECT eas_id, idlink.Name FROM poly LEFT JOIN idlink ON 
> poly.eas_id = idlink.eas_id"
>   STATUS default
>   CLASSITEM "idlink.Name"
>   CLASS
>     NAME "selected"
>     COLOR 0 0 255
>     OUTLINECOLOR 255 0 0
>     EXPRESSION "_158_"
>   END
>   CLASS
>     NAME "normal"
>     COLOR 0 255 0
>     OUTLINECOLOR 255 0 0
>   END
> END
> 
> 
>