Skip to main content
Question

Spatial Relator - ESRI SDE to Access Table

  • October 4, 2017
  • 2 replies
  • 36 views
S
Forum|alt.badge.img

Hello all,

Quick question. I have a Polygonal Feature (Flood Plain Boudaries) and am using Spatial Relator (its faster than Spatial Filter) and am exporting records to an Access Database.

Problem I am having is if one of the features is a line and goes over two different Flood Plain boundaries its only capturing the data from a single polygon.

I full expect the records exported to be MORE than the initial data as the line (Gas Main) may cross 3 different flood plain boundaries.

I need a record for each one of those added to a record of the original main record.

For instance if Gas Main 1234 is a single line and intersects 8 different Flood Plain Ploygons, Id want 8 different records exported to Access.

Ive built some complex workbenches but this has me puzzled.

Please help!!

Thank you,

Savas Giarenakis

Eversource Energy

Savas.Giarenakis@Eversource.com

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

S
Forum|alt.badge.img
  • sav426
  • Author
  • October 4, 2017

 

Also forgot to add, would using a Clipper be better since I simply need attributes?
erik_jan
Contributor
Forum|alt.badge.img+26
  • erik_janContributor
  • Contributor
  • October 4, 2017

I would use the PointonAreaOverlayer and the LineonAreaOverlayer to get the Flood Plain attributes on the points and Lines. If they overlap multiple Flood Plains you need to use the Attribute Accumulation options:

Community Stats

32,207
Posts
122,305
Replies
39,891
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.