JOIN object and WMS/WFS

[Steve Lime]

This is most likely a problem with the WMS/WFS implementations in that
they are not doing any joins before returning features via the OGJ
interfaces. Joins for normal MapServer queries are handled in the
templating code which is why it was probably missed. I can guarantee
there is no support for joins in schema production either. Supporting
one-to-one joins should not be difficult, one-to-many joins will be more
complicated. This could have implications for the underlying C APIs (and
consequently MapScript) as well if one were to generalize support for
joins a bit. I sound like a broken record, but please file a bug...

Steve


>>> "Kralidis,Tom [Burlington]" <Tom.Kralidis at EC.GC.CA> 5/17/2005
6:43:59 AM >>>
Hi,

I have a .shp/.shx/.dbf combo which I have publised as a
layer/featuretype for OGC:WMS/OGC:WFS.

I have an additional .dbf file which I'd like to join to the layer.
However when I issue a WMS GetFeatureInfo WFS DescribeFeatureType I
can't see the data from the seperate .dbf file.

Any suggestions?  Below is my mapfile layer def:

Thanks in advance

..Tom



 LAYER
  NAME "popplace_pt"
  STATUS ON
  DATA "data/popplace_pt"
  TYPE POINT
  DUMP TRUE
  HEADER "templates/popplace_pt_query_header.html"
  TEMPLATE "templates/popplace_pt_query_body.html"
  TOLERANCE 30
  JOIN
   NAME "POPNAMEJOIN"
   FROM "POPNAME"
   TO "POPNAME"
   TABLE
"/usr/local/wwwsites/apache/devgeo.cciw.ca/apps/mapserv/services/kyw/dat
a/table1.dbf"
   TYPE MULTIPLE
   TEMPLATE "templates/popplace_pt_join_query_body.html"
  END
  METADATA
   "ows_title"    "Populated Places"
   "ows_abstract"    "Populated Places"
   "ows_keywordlist" "environment,air pollution,acid
rain,climate,greenhouse effect,ecosystems,environment i
mpact assessment,emergency preparedness,pollution,biological
diversity,environmental protection,water,wildli
fe,weather,waste,environmental management,environmental
technology,recycling,climate change,environmental em
ergency,pollution prevention,sustainable development,science and
technology,environmental action,smog,ozone,
ec,cise,ogc,cgdi"
   "wms_opaque" "0"
   "ows_metadataurl_type" "FGDC"
   "wms_metadataurl_format" "text/html"
   "ows_metadataurl_href" "http://www.environmentandresources.ca/"
   "wms_dataurl_format" "text/html"
   "wms_dataurl_href" "http://www.environmentandresources.ca/"
   "wfs_metadataurl_format" "TXT"
   "gml_include_items" "all"
  END
  PROJECTION
    "init=epsg:42304"
  END
  LABELITEM "REAL_NAME"
  CLASS
   NAME "Populated Places"
   SYMBOL 'circle'
   SIZE 3
   COLOR 0 255 0
   LABEL
    ANTIALIAS TRUE
    COLOR 255 0 0
    POSITION ur
    SIZE LARGE
   END
  END
 END