RE: MI-L Area query in MI

[Peter Horsb�ll M�ller]

I guess you could use the Overlap() function in a SQL query to optain want
you are looking for:

Select CATCHMENT_BNDRY.CATCHMENTNAME, INDUSTRIAL_ZONES.INDUSTRIALTYPE,
                Sum(CartesianArea(Overmap(CATCHMENT_BNDRY.OBJ,
INDUSTRIAL_ZONES.OBJ), "sq m"))
        From CATCHMENT_BNDRY, INDUSTRIAL_ZONES
        Where CATCHMENT_BNDRY.OBJ Intersects INDUSTRIAL_ZONES.OBJ
        Group By CATCHMENT_BNDRY.CATCHMENTNAME,
INDUSTRIAL_ZONES.INDUSTRIALTYPE
        Order By CATCHMENT_BNDRY.CATCHMENTNAME,
INDUSTRIAL_ZONES.INDUSTRIALTYPE

I haven't tested this query so you might need to change it and run it in
parts:

Select CATCHMENT_BNDRY.CATCHMENTNAME, INDUSTRIAL_ZONES.INDUSTRIALTYPE,
                CartesianArea(Overmap(CATCHMENT_BNDRY.OBJ,
INDUSTRIAL_ZONES.OBJ), "sq m") "Area"
        From CATCHMENT_BNDRY, INDUSTRIAL_ZONES
        Where CATCHMENT_BNDRY.OBJ Intersects INDUSTRIAL_ZONES.OBJ
        Order By CATCHMENT_BNDRY.CATCHMENTNAME,
INDUSTRIAL_ZONES.INDUSTRIALTYPE
        Into ALL__OVERLAPPING__AREAS NoSelect

Select CATCHMENTNAME, INDUSTRIALTYPE, Sum(Area)
        From ALL__OVERLAPPING__AREAS
        Group By CATCHMENTNAME, INDUSTRIALTYPE
        Order By CATCHMENTNAME, INDUSTRIALTYPE  

HTH,

Peter Horsb�ll M�ller
GIS Developer
Geographical Information & IT
 
COWI A/S
Rug�rdsvej 55
DK-5000 Odense
Denmark
 
Tel     +45 6313 5013
Direct  +45 6313 5008
Mob     +45 5156 1045
Fax     +45 6313 5090
E-mail  [EMAIL PROTECTED]
http://www.cowi.dk <http://www.cowi.dk> 


> -----Original Message-----
> From: Upinder Mutti [mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ] 
> Sent: Friday, November 14, 2003 12:07 AM
> To: [EMAIL PROTECTED]
> Subject: MI-L Area query in MI
> 
> 
> Hello List
> 
> I have two tab files 'catchment_bndry' and 'indstrial_zones'. 
>  Catchment boundary contain subcatchment boundaries over a 
> given area, industrial zones (heavy industry, light 
> industry)shows land use zones that encroach over various 
> subcatchment polygons.  I want to find out the area each 
> industrial zone occupies within the subcatchments. Is there 
> an easy sql query to find this out.  I have limited 
> experience with sql, and very mininal Mapbasic skills!! (shame)
> 
> Cheers
> 
> Upinder
> 
> 
> ---------------------------------------------------------------------
> List hosting provided by Directions Magazine | 
> www.directionsmag.com <www.directionsmag.com>  | To unsubscribe, e-mail: 
> [EMAIL PROTECTED]
> For additional commands, e-mail: 
> [EMAIL PROTECTED]
> Message number: 9147
> 
>