Skip to main content
  • EN

I have a file geodatabase that contains several feature datasets.

Here is what I need to do......The AnswerAll point feature contains over 5000 rows, however I need to "select by attributes" using Comp_Name.......this yields me 376 results each with a varying number of rows for each Comp_Name.

I then need to take the HCA Name from each of these rows and find the corresponding HCA polygon in my HCA's dataset.

Once I have the HCA Names and there associated polygons for each Comp_Name, I need to create a Bounding Box Polygon around those Polygons, and export it out with the Comp_Name, HCANames, and HCATypes

I can attach my geodatabase if anyone wants to take a crack at this!

@gina_mills_1723 if you can attach a sample of the data I'm sure someone will take a look. It's much easier to understand a workflow if you have the actual data to experiment with

So I have updated my geodatabase a little, so that all my HCA polygons are in one feature class.

Here is what I am doing in ArcGIS Pro, and trying to replicate here.

I select features by attributes from the AnswersAll data layer using the Comp_Name

I have a created a relate to relate the HCAs layer using the HCAName to the HCAName in the AnswersAll layer.

I select the features in the AnswersAll Layer and Then select the related data from the HCAs layer.

I then need to buffer the HCA data by say 10ft, dissolving the feature into one polygon.

I will need to iterate through the AnswersAll data to do this for all the Comp_Names and create Buffers for Each one with the Output being named by Comp_Name.

Of course I realize this will give me almost 376 buffer features, I could eventually combine them into one feature dataset.

Let me know if anyone can help me with this.

Sample_Database.gdb.zip

@gina_mills_1723 Thanks for including the sample data. Sorry, I'm still not sure if I've fully understood how you want to relate and dissolve your areas, but attached is a workspace that I think will give you a starting point. FME 2019.0: createcompnameareas.fmwt

Community Stats

31,951
Posts
121,337
Replies
39,563
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.