[postgis-users] UNION

[RAVI KUMAR]

Hi,
I have prepared a course material for training in Jump for Geoscientists.
Added a minerological theme in which the final output results in prospectivity map.

I have used Post-GIS where ever complex bullion operators are needed. This was done smoothly.

But Iam now held-up in UNION and Intersection. Jump gives an OVERLAY which equals intersection. But the problem needs both
Intersected portion and
Non intersecting portion together.

Followed the advise given on this list to get the result. But the result
OPENJUMP
1.Overlay Layers A, B
2. Make union of the result (to use as a mask)
3. A-Union and B-union and combine theses two layers
4. Add Overlay to this.

This does the work but you have duplicate geometries which are filled with different attributes in different instances.
POSTGIS:
Followinf the suggestions on the Postgis list I have tried this query.
SELECT strubuf.struclass, COALESCE(geomunion(strubuf.geometry,
 geof.geometry), geof.geometry) AS geofac FROM geof INNER JOIN strubuf ON (geof.geometry && strubuf.geometry AND
 intersects(strubuf.geometry, geof.geometry));

But this doesnt result in a table geofac



This is where I am..
But for this additional exercise every thing else is ready.
However Proof of Concept for Geoscientists lies in THIS.


Cheers
Ravi Kumar
       
---------------------------------
Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070911/52db4b18/attachment.html>