Skip to main content
Question

I have a large POSTGIS database table with 10+ million features and I'm trying to "clip" it to another geometry that is already read into the workbench. Is there any examples of this in a tutorial or something?

  • February 16, 2022
  • 2 replies
  • 10 views

I have a large POSTGIS database table with 10+ million features and I'm trying to "clip" it to another geometry that is already read into the workbench. Is there any examples of this in a tutorial or something?

2 replies

hkingsbury
Celebrity
Forum|alt.badge.img+63
  • Celebrity
  • 1620 replies
  • February 16, 2022

Due to the volume of features you're potentially trying to clip i'd firstly look at using a FeatureReader with sptaial filtering (intersect) enabled to read in your data (use the clip geom as the initiator). This will read in all data from PostGIS that intersects the initiator geom.

 

Then pass the features you read in into the clippee port on a clipper, and pass the clip geom into the clipper port

 

http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/featurereader.htm

https://www.safe.com/transformers/clipper/


  • Author
  • 1 reply
  • February 17, 2022

Thanks @hkingsbury​ , worked like a charm!