topic Re: Spatial join layer with overlapping polygons? in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/spatial-join-layer-with-overlapping-polygons/m-p/198870#M6821 <HTML><HEAD></HEAD><BODY><SPAN>Do a spatial join with parcels as the target feature and overlay districts as the join feature.&nbsp; Join one to many using the "intersects" option.&nbsp; That will give you one row for each combination of parcel and overlay district.&nbsp; Then you can do some sort of pivot table to get them to show up as columns.&nbsp; I believe this would work with overlapping polygons...</SPAN></BODY></HTML> Thu, 22 Dec 2011 17:04:04 GMT LornaMurison 2011-12-22T17:04:04Z Spatial join layer with overlapping polygons? https://community.esri.com/t5/geoprocessing-questions/spatial-join-layer-with-overlapping-polygons/m-p/198869#M6820 <HTML><HEAD></HEAD><BODY><SPAN>Hello everyone, I am trying to spatially join our city's "overlay districts" with our parcel file so that it will be displayed if a parcel is in an overlay district. However, some of the overlay districts are on top of each other. For example, a parcel can be in a C-1 zone and a historic preservation zone. I want both of these to show up in 2 different columns. Is there any way to do something like this? So the final result, the parcel would show that it is C-1 in one column and historic preservation in a second column, because the parcel overlaps both polygons.</SPAN><BR /><BR /><SPAN>Thanks in advance.</SPAN></BODY></HTML> Thu, 22 Dec 2011 16:06:02 GMT https://community.esri.com/t5/geoprocessing-questions/spatial-join-layer-with-overlapping-polygons/m-p/198869#M6820 PamelaDelaney 2011-12-22T16:06:02Z Re: Spatial join layer with overlapping polygons? https://community.esri.com/t5/geoprocessing-questions/spatial-join-layer-with-overlapping-polygons/m-p/198870#M6821 <HTML><HEAD></HEAD><BODY><SPAN>Do a spatial join with parcels as the target feature and overlay districts as the join feature.&nbsp; Join one to many using the "intersects" option.&nbsp; That will give you one row for each combination of parcel and overlay district.&nbsp; Then you can do some sort of pivot table to get them to show up as columns.&nbsp; I believe this would work with overlapping polygons...</SPAN></BODY></HTML> Thu, 22 Dec 2011 17:04:04 GMT https://community.esri.com/t5/geoprocessing-questions/spatial-join-layer-with-overlapping-polygons/m-p/198870#M6821 LornaMurison 2011-12-22T17:04:04Z Re: Spatial join layer with overlapping polygons? https://community.esri.com/t5/geoprocessing-questions/spatial-join-layer-with-overlapping-polygons/m-p/198871#M6822 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Do a spatial join with parcels as the target feature and overlay districts as the join feature.&nbsp; Join one to many using the "intersects" option.&nbsp; That will give you one row for each combination of parcel and overlay district.&nbsp; Then you can do some sort of pivot table to get them to show up as columns.&nbsp; I believe this would work with overlapping polygons...</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>For the Pivot Table operation you can use the Pivot Table tool if you have an ArcInfo license.&nbsp; If you don't, see </SPAN><A href="http://forums.arcgis.com/threads/46388-moving-columns-data-to-rows">my last post in this thread</A><SPAN> for an Excel table that uses an Excel pivot table and formulas to do the Pivot of actual table values from rows to columns.</SPAN></BODY></HTML> Fri, 23 Dec 2011 16:00:23 GMT https://community.esri.com/t5/geoprocessing-questions/spatial-join-layer-with-overlapping-polygons/m-p/198871#M6822 RichardFairhurst 2011-12-23T16:00:23Z Re: Spatial join layer with overlapping polygons? https://community.esri.com/t5/geoprocessing-questions/spatial-join-layer-with-overlapping-polygons/m-p/198872#M6823 <HTML><HEAD></HEAD><BODY><SPAN>Esri recently posted a neat approach to processing your one-to-many table (the one with dupes output from select by location):</SPAN><BR /><BR /><SPAN>Geoprocessing Blog: Concatenate Row Values</SPAN><BR /><A href="http://blogs.esri.com/Dev/blogs/geoprocessing/archive/2011/12/09/ConcatenateRowValues.aspx">http://blogs.esri.com/Dev/blogs/geoprocessing/archive/2011/12/09/ConcatenateRowValues.aspx</A></BODY></HTML> Tue, 27 Dec 2011 19:44:50 GMT https://community.esri.com/t5/geoprocessing-questions/spatial-join-layer-with-overlapping-polygons/m-p/198872#M6823 curtvprice 2011-12-27T19:44:50Z