In my job, I am currently getting excel files with multiple polygon features in point format. Converting this to points, and then to a line feature class works absolutely fine when using the ID as the joining field. However, some of the files in receiving contain hundreds of polygons in 1 deck. when converting the line feature class to a polygon it creates all the polygons I need, however, it also creates extra polygons for any overlapping features, and on larger decks, it makes it almost impossible to manually find these extra polygons to delete.
When keeping them as lines, it makes labeling all of the features a pain as it will not create a label in the center of the feature as it is only lines.
I was wondering if anybody knew a method to convert this data to polygons without the overlap and extra polygon creation happening. From the research I've done, it seems like I would need to create a script. I am just starting a Python course so it will be a while before I understand it all enough to create my own
this is a very basic example of the type of excel file I am sent just for reference, the grids have just been dragged down to populate the field.
This is an example of what happens when converting the line features to a polygon. Do not have access to ArcMap on my home computer so cannot show images of the problem on ArcMap