Select ProportionOverlap(ZipCodes.Obj,FloodZone.Obj)�Percent�,
ZipCodes.ID_ZIP, FloodZone.ID_FloodZone [and so�.]
FROM ZipCodes,FloodZone
WHERE ZipCodes.Obj INTERSECTS FloodZone.Obj INTO tmpTable
-----Mensaje original-----
De: Jason Johannsen [mailto:[EMAIL PROTECTED]
Enviado el: Friday, February 20, 2004 1:27 PM
Para: Jorge Cordero
Asunto: RE: MI-L MapEvaluation.Mbx
Jorge, I�m not sure how to make this work. Can you roll it into a
query? For example, I want to find the % of each flood zone in each ZIP
Code. It looks like, with the tool, I have to define a radius or draw a
region. I also was getting the message �file tmp.area.dat not found�.
Best Regards,
Jason
-----Original Message-----
From: Jorge Cordero [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 1:22 PM
To: Jason Johannsen
Subject: RE: MI-L MapEvaluation.Mbx
Yes I send the mbx file and table to example I hope you recive files
-----Mensaje original-----
De: Jason Johannsen [mailto:[EMAIL PROTECTED]
Enviado el: Friday, February 20, 2004 1:07 PM
Para: Jorge Cordero
Asunto: RE: MI-L MapEvaluation.Mbx
Jorge,
Would this mbx translate between tables? For example, find the % of
area if you overlaid zip codes with flood zones? It would tell you the
% of the zip in each flood zone?
Jason Johannsen
Benfield, Inc.
-----Original Message-----
From: Jorge Cordero [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 12:32 PM
To: [EMAIL PROTECTED]
Subject: MI-L MapEvaluation.Mbx
I�m create an mbx that returns a number that indicates what percentage
of one object is covered by another object.
Jorge Eduardo Cordero Rodriguez
Desarrollador GIS
M�xico DF
