Skip to main content
Question

Need to do a bit of complicated filtering and buffering of different datasets in a geodatabase

  • June 21, 2019
  • 3 replies
  • 15 views
gina_mills_1723
Forum|alt.badge.img

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!

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.

3 replies

M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • June 24, 2019

@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

gina_mills_1723
Forum|alt.badge.img

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

M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • June 28, 2019

@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

32,080
Posts
121,818
Replies
39,714
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.