topic How to join two shapefiles by location? in Business Questions https://community.esri.com/t5/business-questions/how-to-join-two-shapefiles-by-location/m-p/298071#M55 <HTML><HEAD></HEAD><BODY><P>I have two shapefiles – the wards of a country (larger) and the land cover polygons (smaller) of the same country. At the moment the two layers are overlaid together, on the same projections, but not joined.</P><P></P><P>I want to be able to join these layers so that:</P><P>A. The polygons are all clipped to the ward they sit within.</P><P>B. If a polygon sits between two wards, the polygon will be divided along the line and created into two polygons.</P><P>C. When I open the attribute table, it says all the polygons names with a field saying which ward they sit within.</P><P></P><P>I know how to do this by taking each ward, clipping etc etc. However, I would have to do this process 500 times. I’m wondering is there a tool I don’t know about or a model someone has developed or something to make this process a lot faster?</P><P></P><P>Thanks!</P></BODY></HTML> Sat, 06 Jul 2019 22:44:40 GMT RachelStewart 2019-07-06T22:44:40Z How to join two shapefiles by location? https://community.esri.com/t5/business-questions/how-to-join-two-shapefiles-by-location/m-p/298071#M55 <HTML><HEAD></HEAD><BODY><P>I have two shapefiles – the wards of a country (larger) and the land cover polygons (smaller) of the same country. At the moment the two layers are overlaid together, on the same projections, but not joined.</P><P></P><P>I want to be able to join these layers so that:</P><P>A. The polygons are all clipped to the ward they sit within.</P><P>B. If a polygon sits between two wards, the polygon will be divided along the line and created into two polygons.</P><P>C. When I open the attribute table, it says all the polygons names with a field saying which ward they sit within.</P><P></P><P>I know how to do this by taking each ward, clipping etc etc. However, I would have to do this process 500 times. I’m wondering is there a tool I don’t know about or a model someone has developed or something to make this process a lot faster?</P><P></P><P>Thanks!</P></BODY></HTML> Sat, 06 Jul 2019 22:44:40 GMT https://community.esri.com/t5/business-questions/how-to-join-two-shapefiles-by-location/m-p/298071#M55 RachelStewart 2019-07-06T22:44:40Z Re: How to join two shapefiles by location? https://community.esri.com/t5/business-questions/how-to-join-two-shapefiles-by-location/m-p/298072#M56 <HTML><HEAD></HEAD><BODY><P>It almost sounds like you are trying to do a 'Union'</P><P><A class="link-titled" href="https://pro.arcgis.com/en/pro-app/tool-reference/analysis/union.htm" title="https://pro.arcgis.com/en/pro-app/tool-reference/analysis/union.htm">Union—Help | ArcGIS Desktop</A>&nbsp;</P></BODY></HTML> Sat, 06 Jul 2019 23:41:39 GMT https://community.esri.com/t5/business-questions/how-to-join-two-shapefiles-by-location/m-p/298072#M56 DanPatterson_Retired 2019-07-06T23:41:39Z Re: How to join two shapefiles by location? https://community.esri.com/t5/business-questions/how-to-join-two-shapefiles-by-location/m-p/298073#M57 <HTML><HEAD></HEAD><BODY><P>I have tried this tool but my outputs always end up like the attached image. The highlighted blue row shows the split between shapefiles.<IMG alt="" class="image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/452681_Capture.PNG" /></P></BODY></HTML> Tue, 09 Jul 2019 20:22:21 GMT https://community.esri.com/t5/business-questions/how-to-join-two-shapefiles-by-location/m-p/298073#M57 RachelStewart 2019-07-09T20:22:21Z Re: How to join two shapefiles by location? https://community.esri.com/t5/business-questions/how-to-join-two-shapefiles-by-location/m-p/298074#M58 <HTML><HEAD></HEAD><BODY><P>I think Intersect would do that.</P></BODY></HTML> Tue, 09 Jul 2019 21:19:23 GMT https://community.esri.com/t5/business-questions/how-to-join-two-shapefiles-by-location/m-p/298074#M58 NinaRihn 2019-07-09T21:19:23Z Re: How to join two shapefiles by location? https://community.esri.com/t5/business-questions/how-to-join-two-shapefiles-by-location/m-p/298075#M59 <HTML><HEAD></HEAD><BODY><P>Looking at Shape_Area and Shape_length, pretty well guarantees that one is a projected file and the other is in Geographic Coordinates.&nbsp; The split occurs at row 462 and 463.</P><P>The fact that the two overlay 'on-screen' is not relevant.&nbsp; You have to examine the coordinate system in the 'properties' of the layer.&nbsp; the lower polygon file is perhaps a GCS WGS84 or maybe GCS NAD83 or some variant.&nbsp; You need to use the 'Project tool' in Arctoolbox and not the 'Define Projection' tool if you did so.</P><P>Intersect will yield erroneous results as well</P></BODY></HTML> Tue, 09 Jul 2019 22:23:15 GMT https://community.esri.com/t5/business-questions/how-to-join-two-shapefiles-by-location/m-p/298075#M59 DanPatterson_Retired 2019-07-09T22:23:15Z