Intersection of two vector tables data

[المشرف العام]

I have satellite raster data is converted in to pixels using

create table gtru_tile_pix as SELECT (ST_PixelAsPolygons(rast)).val, (ST_PixelAsPolygons(rast)).geom FROM gtru_tile_raster;

and i have vector data (polygons)in other layer to get sample pixels from the above pixels.please tell me how to get intersection of two tables



أكثر...