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:[EMAIL PROTECTED] Sent: 08 September 2006 01:25 To: Campbell, Keith A Cc: [email protected] 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.
