Skip to main content
Question

Spatial Relator - ESRI SDE to Access Table


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

2 replies

Forum|alt.badge.img
  • 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+17
  • 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:


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