[postgis-users] ST_Intersects

[shreyes shiv]

Dear all,

I have two shape files plots and parcels.

the attributes of the "plots" shape file are
plot_id
plot_area
owner_nm
the_geom

the attributes of the "parcels" shape file are
parcel_id
parcel_area
conversion
the_geom

when i do the ST_Intersects operation on the shape files it returns a table
that contains redundant tuples.
what i want is the area of the newly formed polygons which are formed after
the intersection as an extra column.

This image explains my problem.
[image: parcelplotresult-1.jpg]

The Plot S01BAT009 lying in Parcels P1, P2 and P3, and also occupying the
area A1, A2 and A3 in the respective parcels. The white lines are the parcel
boundaries. The black lines are the plot boundaries.
I want the areas A1, A2 and A3.

please help.



-- 
shreyes shiv
email: shivshreyes at gmail.com
phone: 9557975780
IIRS(Indian Institute of Remote Sensing)
No. 4, Kalidas Road, Dehradun-248001, Uttarakhand, India
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110505/e764ccfa/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: parcelplotresult-1.jpg
Type: image/jpeg
Size: 14784 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110505/e764ccfa/attachment.jpg>