[Mapserver-users] OGR for Joins to .dbfs

[Steve Lime]

The support for one-to-many joins is where MapServer joins come in.
Frank's stuff is very low level. MapServer doesn't even know it's
happening. There's no provision for a shapeObj to carry multiple records
of attributes. MapServer 4.0 now supports one-to-many DBF joins as part
of query output.

Steve

>>> Daniel Morissette <morissette at dmsolutions.ca> 07/31/03 11:25AM >>>
Fawcett, David wrote:
>
> I was thinking that if OGR can access shapefile data (shp, dbf,
etc.), could it be used as the data connector to execute a one-to-many
join to a .dbf file?  
> 

Actually, support for joins (independent of MapServer joins) has been 
added by Frank in OGR.  So it is possible to join a shapefile, a DGN,
or 
whatever OGR format to a DBF on the fly using OGR's SQL language.

You should be able to find some docs at 
http://gdal.velocet.ca/projects/opengis/ogrhtml/ogr_sql.html but
Frank's 
server where the docs reside is currently down.  You could also search

the list archives since I believe this has been discussed before.  BTW,

I noticed that there is one example of join in the OGR HOWTO at
http://mapserver.gis.umn.edu/doc/ogr-howto.html#examples 

Daniel
-- 
------------------------------------------------------------
  Daniel Morissette               morissette at dmsolutions.ca 
  DM Solutions Group              http://www.dmsolutions.ca/ 
------------------------------------------------------------

_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu 
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users