MapServer Capabilities

[Campbell, Keith A]

Thanks Steve.

Does that mean that any layer based on a SQL Server DB (an ordinary
layer without a join) would be relatively slow?

Is it possible to create feature joins as I've described with other DB
types?

Keith

-----Original Message-----
From: Stephen Woodbridge [mailto:woodbri at swoodbridge.com] 
Sent: 08 September 2006 01:25
To: Campbell, Keith A
Cc: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] MapServer Capabilities

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.


This message has been scanned for viruses by MailControl - (see
http://bluepages.wsatkins.co.uk/?4318150)


This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding.