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?

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

2 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • erik_janContributor
  • Contributor
  • 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
erik_jan wrote:

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


Helpful Members This Week

Community Stats

31,468
Posts
119,289
Replies
39,085
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.