Hi Sarah, You should try: Select Areaoverlap(bufferline.obj, forest.obj) Where bufferline.obj Intersects forest.obj into ResultTable Noselect
If you use the Mapbasic window, you can copy and paste the above expression. Maybe you should first write: Set area units "sq m" (or "sq mi") followed by <Enter> HTH S�ren Breddam -----Oprindelig meddelelse----- Fra: Sarah Chisholm [mailto:[EMAIL PROTECTED] Sendt: 24. januar 2005 16:39 Til: [email protected] Emne: MI-L Please help me with SQL select! Hi all, I'm very new to GIS and have a simple question about a SQL select query. I've created a buffer zone around a line and am trying to figure out the area of the parts of the polygons that are contained by this buffer. I can get the table to tell me the whole area of each polygon that touches the buffer (by using the Condition "bufferline.obj contains forest.obj" because 'area' is a column in the 'forest' table), but I'd like to know the area of only the small section of the polygon that is contained by the buffer. Can someone tell me how I should fit 'area' into this query? Thanks, Sarah --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14984
