Skip to main content
Question

How to select a Range of Polygons based on Excel File Start/End information

N

I have two datasets: One polygon split into equal, 100m segments with a Start/End point for each polygon (Ex. 100 -200, 200-300, etc). The second is an excel file that external users fill out, supplying their needed work areas (this is based off the start/end from the polygons but can be a range - 100 to 300, etc).

 

I want to take the Excel file, take its range of data and extract just those polygons that fall into that range. Unique IDs can be used but I just do not know how to select ranges from one dataset based on an excel file.

 

Any help is most appreciated,

 

Thank you.

 

2 replies

connecter
Forum|alt.badge.img+4
  • connecter
  • March 16, 2021

Hi @Morgan Kennedy-Short​ ,

in the excelfile are coordinates or only the IDs of the polygons- or I didn't understand your quest correct.

 

Only coordinates:

You can set the right columns for x & y as coordinates in the excelreader. After that step you can use a SpatialFilter to get the polygons. Maybe you must buffer the polygons among a small distance, so the points are in the polygon.

 

Excel ID & Polygon ID

You can merge on the same ID by use the FeatureMerger or FeatureJoiner

M
Forum|alt.badge.img+2

@Morgan Kennedy-Short​ An image or, better, a small sample dataset might help us understand your question. But this might be a job for the InlineQuerier and a SQL BETWEEN

Reply


Helpful Members This Week

Community Stats

31,141
Posts
118,067
Replies
38,761
Members

Latest FME

Terms & ConditionsCookie settings

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.