nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Intersecting address points with building footprints

ChetShuler

I'm trying to assign an address to a building footprint.

Dataset:

Buildings Prints

Address Points

In some cases I have multiple addresses within a polygon and would like to use the lowest available address.

Attachment shows a couple polygon footprints and address points.

Example.pdf

Find more posts tagged with

Accepted answers

All comments

XanderBakker

OK, this is what I came up with...

First step is to spatially join the buildings to the point. Right click on the points, select "Joins and Relates" and then "Join"::

Then specify the following:

Then run the following code, but change:

line 5, the point featureclass that resulted from the spatial join (mine points to a featureclass in a file geodatabase)
line 6, the OID field of the polygons in the in the join result. Will probably remain FID_2
line 11, the building featureclass
line 13, the field to be created where the address should be stored

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">main</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">import</SPAN> arcpy

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># join the building to the points using spatial join</SPAN>
&nbsp;&nbsp;&nbsp; fc_pnts_join <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\GeoNet\BuildAdd\data.gdb\PointsJoinBuildings'</SPAN>
&nbsp;&nbsp;&nbsp; fld_oid_pol <SPAN class="operator token">=</SPAN> <SPAN class="string token">'FID_2'</SPAN>
&nbsp;&nbsp;&nbsp; fld_lsn <SPAN class="operator token">=</SPAN> <SPAN class="string token">'LSN'</SPAN>&nbsp; <SPAN class="comment token"># TEXT 75</SPAN>
&nbsp;&nbsp;&nbsp; fld_num <SPAN class="operator token">=</SPAN> <SPAN class="string token">'ADDR_NUM'</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># polygon shapefile</SPAN>
&nbsp;&nbsp;&nbsp; fc_pol <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\GeoNet\BuildAdd\BuildingFP.shp'</SPAN>
&nbsp;&nbsp;&nbsp; fld_oid <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>fc_pol<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>OIDFieldName
&nbsp;&nbsp;&nbsp; fld_lsn_pol <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Address'</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># create dictionary of data from join</SPAN>
&nbsp;&nbsp;&nbsp; dct_join <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>
&nbsp;&nbsp;&nbsp; flds <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>fld_oid_pol<SPAN class="punctuation token">,</SPAN> fld_num<SPAN class="punctuation token">,</SPAN> fld_lsn<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc_pnts_join<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; oid_pol <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> oid_pol <SPAN class="keyword token">in</SPAN> dct_join<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data <SPAN class="operator token">=</SPAN> dct_join<SPAN class="punctuation token">[</SPAN>oid_pol<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dct_join<SPAN class="punctuation token">[</SPAN>oid_pol<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> data
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># print dct_join</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># add address field to building polygons</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>fc_pol<SPAN class="punctuation token">,</SPAN> fld_lsn_pol<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>fc_pol<SPAN class="punctuation token">,</SPAN> fld_lsn_pol<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"TEXT"</SPAN><SPAN class="punctuation token">,</SPAN> None<SPAN class="punctuation token">,</SPAN> None<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">75</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># now update the address field for the buildings</SPAN>
&nbsp;&nbsp;&nbsp; cnt <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
&nbsp;&nbsp;&nbsp; flds <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>fld_oid<SPAN class="punctuation token">,</SPAN> fld_lsn_pol<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>fc_pol<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cnt <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> cnt <SPAN class="operator token">%</SPAN> <SPAN class="number token">100</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Processing: {0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>cnt<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; oid_pol <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> oid_pol <SPAN class="keyword token">in</SPAN> dct_join<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lst <SPAN class="operator token">=</SPAN> dct_join<SPAN class="punctuation token">[</SPAN>oid_pol<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; address <SPAN class="operator token">=</SPAN> getAdressForLowestNumber<SPAN class="punctuation token">(</SPAN>lst<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> address
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; curs<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">getAdressForLowestNumber</SPAN><SPAN class="punctuation token">(</SPAN>lst<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; address <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>lst<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; address <SPAN class="operator token">=</SPAN> lst<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; min_mun <SPAN class="operator token">=</SPAN> <SPAN class="number token">999999</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> data <SPAN class="keyword token">in</SPAN> lst<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; num <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>data<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> num <SPAN class="operator token"><</SPAN> min_mun<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; min_mun <SPAN class="operator token">=</SPAN> num
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; address <SPAN class="operator token">=</SPAN> data<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> address

<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; main<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I will attach the resulting building shapefile so you can validate the result.

BuildingFP.zip

ChetShuler

After reviewing the results I have a few buildings that did not capture the lowest address number.

I may have put too much thought into creating the building footprints.. We geocoded all the addresses from legacy data. Then we dragged all the points over the building in hopes to populate the footprints with addresses. I'm not an expert writing code.. Self taught... Below is a link to show some of my work.. The Public Gallery is open to the everyone. The attachment I hope will show the problems I'm dealing with.. If floor plans or other source data were available I split the polygons into units to get a one to one match with the address points. I doubt very much that I will ever see a one to one match with every building in the city.

Link

http://cityofmiddletown.maps.arcgis.com/home/index.html

Thanks again for your interest.

BuildAdd.zip

XanderBakker

If you open the thread (not inside the inbox) when you edit a reply you see the "Use advanced editor" link in the upper right part :

When you click on it, it will open the advanced editor which has in the lower left corner a link to attach files:

ChetShuler

After reviewing the results I do have a few that did not capture the lowest address number..

I have a couple of shapefiles I zipped but do not see way to attach to my reply..

ChetShuler

Yes I can.. I have meeting in a couple minutes. I will reply back in a couple hours with some shapefiles. I really appreciate your interest..

XanderBakker

Possible yes, but it might require some scripting. I assume the address field is a text field and the number is not stored in a separate field? As suggested earlier, doing a spatial join in which you obtain the ID of the polygon in the point featureclass would be the way to start. Per building ID you would then have to run some code to determine which number (extracted from the text field) is the lowest. You may have some addresses that require some more advance extraction of the house number. Is it possible to share a part of your data?

ChetShuler

The lowest available address number..

Example would be the following address are inside the polygon.

101 Central

103 Central

105 Central

I want to make sure I capture the 101 Central for a result.

I'm reviewing the results and it appears I capture lower of the three.

I'm not sure how to handle all three addresses within apps for one polygon? Is it possible?

MitchHolley1

I understand... but, what does "lowest available address" mean? The southern-most address?

ChetShuler

I have in some cases many to one. Being many addresses to one building footprint.

MitchHolley1

I would use a spatial join. What do you mean by "lowest available address"?

ChetShuler

Sorry I haven't use the site a lot.. I believe I moved it.. Thanks.

XanderBakker

Can you move this question to the space Managing Data‌? This space is dedicated to a product called ArcGIS Monitor that will be released in January 2018.

To move content please read: https://community.esri.com/docs/DOC-2258

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.