Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • I have overlay of features in PostGIS and another overlay consisting of boundaries of 10 electoral districts. How doI assign the feature name from each electoral district to every topograhic feature as a new attribute of that dataset?

Hi, can I have some advise on which is the best transformer to use? I have an overlay of topographic features in PostGIS. I have another overlay which consists of boundaries of 10 electoral districts. The electoral districts each have an attribute of feature name. How doI assign the feature name from each electoral district to every topograhic feature as a new attribute of that dataset?

I then want to write out the topographic overlay to individual gml files for each electoral district.

I've tried AeaOnArea and SpatialRelator but am struggling.

Thanks

Jon

I would use a PostGIS reader for the 10 districts.

Then use a FeatureReader to read the other tables, using the Spatial query option and merge the attributes.

Another option would be using SQL (if both datasets are in the same PostGIS database) in the SQLCreator transformer to select the joined features.

Hope this helps.

I would use a PostGIS reader for the 10 districts.

Then use a FeatureReader to read the other tables, using the Spatial query option and merge the attributes.

Another option would be using SQL (if both datasets are in the same PostGIS database) in the SQLCreator transformer to select the joined features.

Hope this helps.

Thanks for that. I'll give FeatureReader a try. For info the electoral district overlay is file (MapInfo .tab)

Reply


Community Stats

30,176
Posts
114,544
Replies
37,836
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.