Skip to main content
Question

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?

  • December 6, 2019
  • 2 replies
  • 6 views
J

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

erik_jan
Contributor
Forum|alt.badge.img+22
  • erik_janContributor
  • Contributor
  • 2179 replies
  • December 6, 2019

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.

J
  • jonmcdevitt
  • Author
  • 1 reply
  • December 9, 2019

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)

Community Stats

32,079
Posts
121,808
Replies
39,710
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.