MapServer Capabilities

[Stephen Woodbridge]

Campbell, Keith A wrote:
> 
> 
> I wish to establish the capabilities of MapServer as regards feature 
> joins. What I would like to do is create a map that has a number of 
> layers based on SHP file data. The display of the entities within the 
> SHP files needs to be themed based on attribute data held in a SQL 
> Server database. So the Feature ID of an object in the SHP file has a 
> corresponding ID in a record in the DB. Is this possible with MapServer? 
> If so, how difficult is it?

You might be able to do this with GDAL/OGR, but it will not be fast. The 
ideal way to do this is to use postGIS to store the geometry and 
attributes, then you can do this easily and it will be fast.

-Steve W.