I want to perform a spatial intersection of two polygon features to determine values.

I have a SQL script that does the job but it takes too long (over 20 hours). I am hoping FME can perform better. Script is below:-

 

 

select Land_No, PropNum, Property_Address,b.SCHEME_CODE, b.ZONE_CODE, p.Geometry, p.SP_Geometry,

 

ROW_NUMBER()OVER(PARTITIONby p.Land_No ORDERBY p.Land_No)AS Dup

 

INTO CI_Plan_Zone

 

from LandVic.dbo.PropParcelOwner p, [External].dbo.PS_Zone b

 

where p.SP_Geometry.STIntersects(b.Geometry_SPA.STBuffer(-0.1))=1

 

 

regards

 

Phil