
i'm a novice PostGIS user, can anybody help me do a cookie-cutter technique in PostGIS? basically, i have a polygon table of political boundary and i want to extract all the polygons that lie within the cookie cutter (which can be a single polygon, or another polygon table). it seems the intersection command works only when the operation is between two polygons but not when a collection of polygons (e.g., table) is involved. by the way, i'm assuming the intersection command is what you use for cookie-cutting?

on the same note, how do i combine two tables of the same geometry type? also can they be added together even if they don't have the same attribute columns (except for the geometry type). i'm coming from a ESRI/shapefile background so please bear with me.

any help will be appreciated. thank you.



_____________________________________________________________
Check out Atenista.Net (www.atenista.net)- new design, regular content and additional services!

