Model for sumarizing polygon stats near a facility

[MōnoSimeone]

Hi -

I'm new to modelbuilder and wondering how to build a model that will:

a. take an input a layer of points
b. for each point in layer, select by location or buffer 1 mile
c. select polygons with centroid in buffer
d. create summary table of specific fields from those selected polygons
e. calculate the facility ID
f. join summary table back to the point feature.

1) Not sure if my model structure makes sense
2) I can't figure out how to capture the Facility ID so the summary table can be joined back.

Are there any good examples out there? Is someone willing to share a model?

I know conceptually it can be done but I'm so lost in understanding how to setup the parameters and have the model do one facility at a time. Any articles, guides, or anything would be appreciated.

Thanks,
m.

[DuncanHornby]

I think Shapefile format does not support nullable values?

[MōnoSimeone]

I get one thing working and then another thing breaks. The model seems to be working but it's outputing a blank table now.

Update: I seem to have some consistency with one of my test models. Though, I'm completely unsure why one of my test models works and the others don't - I built them the same but they just don't react the the same. Is there any way to overwrite data? I have to expose the summary output otherwise I run into a duplication error.

Thanks for you hanging with me on this.
Cheers,
m.

[NiklasNorrthon]

For me it sounds like using an iterator is unnecessary complicated. This is how I would solve the problem:

1. Buffer on the point feature class


2. Feature to point on the polygon feature class


3. Identity between the buffers and the new points

Then I'd see what I get and if its what I need I go on from there, if not I rethink the problem. Iterators are powerful, but often there are other less complicated and more efficient way to accomplish the same thing.

Use iterators when needed, but not when there are built in tools that do the same thing.