Hi Peter, We've been setting this up as individual databinds as you noted using Intersects. If the parcel intersects the target layer results show, if it does not no results show. However this is indeed one by one and I think you're trying to run a single query against 56 layers and have a table output, is that so? Not sure how to do that one.
Here is some SQL from a similar databind. I'm not sure what DCP stands for - we're checking constraints like floodzones, and administrative zoning including special zoning overlay districts. base Zoning (w/ hyperlink to zoning ordinance online docs) SELECT sample_parcels_Selection.mi_key, Zoning_5_04.Name as "Code", 'http://www.portlandmaine.gov/Chapter014.pdf' as ORDLINK FROM Zoning_5_04, sample_parcels_Selection WHERE MI_Intersects(sample_parcels_Selection.obj, Zoning_5_04.obj) neighborhood name (spatial bind to neighborhood layer) SELECT sample_parcels_Selection.mi_key, NEIGHBOR.Name FROM neighbor, sample_parcels_Selection WHERE MI_Intersects(sample_parcels_Selection.obj, NEIGHBOR.obj) Will Mitchell Mitchell Geographics, Inc. 496 Congress St Portland, ME 04101 ph 207.879.7769 fx 207.253.5756 <http://www.mitchellgeo.com> www.mitchellgeo.com -----Original Message----- From: Peter Hatton [mailto:[EMAIL PROTECTED] Sent: Monday, July 04, 2005 1:59 AM To: '[email protected]' Subject: MI-L MAPINFO EXPONAIRE QUERY Hi all, can anyone help with the following ? ....... We're setting up Exponaire and would like to do the following ..... We have a total of 56 DCP related constraint layers we wish to have included in exponaire. Each layer represents a different constraint that may be applicable to a "whole" parcel polygon or part of a parcel polygon. I would like to build an Exponaire query as part of a databind to be able to search on individual parcel polygons and return a list of all constraints applicable to that parcel whether the layer polygon covers all or part of the parcel polygon. In other words find all constraint layers that "intersect " the parcel polygon.I thought that if I named all my layers with the same prefix ie. DCP then I may be able to build a query containing ............... " intersects any table like %dcp%. Can anyone point me in the right direction .......... Many thanks in advance ....... Peter Peter HATTON GIS Officer Greater Taree City Council 2 Pulteney Street TAREE 2430 phone 02 6592 5227 e-mail [EMAIL PROTECTED] gov.au This email and any files transmitted with it are intended soley for the use of the individual or entity to whom they are addressed. Greater Taree City Council is a government organisation and is subject to Freedom of Information legislation. You must assume that any material sent to Greater Taree City Council may be accessible by persons other than the intended recipient. The contents of this message may express views and opinions not necessarily shared by Greater Taree City Council. This e-mail has been scanned for viruses by MCI's Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.com --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17015
