Hi Sarah It might be easier to use the buffer as a <cookie-cutter> to cut out those parts of the polys which are within the buffer. You can then get the area of the new polys.
1. Make a backup copy of your forests table first. 2. Make the forests table editable and select all polys which overlap the buffer object. 3. In the Objects menu, click Set Target. 4. Now click on the buffer object to select it, then in the Objects menu click Erase Outside. Your overlapping forest polys will now be just those areas within the buffer object and you can get the areas. regards Nigel On Mon, 24 Jan 2005 11:39:08 -0400 Sarah Chisholm <[EMAIL PROTECTED]> wrote: > 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 > > __________________________________ Nigel N James Map Room Bodleian Library Broad St Oxford OX1 3BG UK tel : +44 1865 277013 fax : +44 1865 277139 Visit the award-winning Map Room Home Page at: http://www.bodley.ox.ac.uk/guides/maps/ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 14982
