topic Re: Remove duplicate vertices from network features? in Geodatabase Questions

Remove duplicate vertices from network features?

MartinAmeskamp — Tue, 07 Jun 2016 12:44:18 GMT

Hi, we have a geometric network where a large number (too many for interactive editing) of complex edges have duplicate vertices (these are really duplicate, i.e. two subsequent vertices have excatly the same coordinates).

How can we get rid of these duplicate vertices, preferrably without touching the geometric network?

Versions and platforms: This is ArcGIS 10.2.1 on Oracle 11.2.0.4, using ST_GEOMETRY.

Thanks very much, Martin

PS It looks like the duplicate vertices where generated by data migration; they seem occur mainly in places where a straight line segment is followed by a circular arc segment.

Re: Remove duplicate vertices from network features?

WesMiller — Thu, 09 Jun 2016 12:07:44 GMT

Repair Geometry—Help | ArcGIS for Desktop

Valid inputs are shapefiles, personal, and file geodatabase feature classes

Caution:

This tool modifies the input data. See Tools with no outputs for more information and strategies to avoid undesired data changes.

Re: Remove duplicate vertices from network features?

MartinAmeskamp — Fri, 10 Jun 2016 05:55:08 GMT

Hi Wes, thanks for pointing out this command. We had looked at it, but Repair Geometry doesn't work on SDEs, since it assumes that features are checked or repair when being inserted into the SDE - somehow the migration process bypassed that step.

We've settled on writing a little .NET addin that cycles through the affected features and calls ITopologicalOperator.Simplify for each shape. That seems to take care of the problem and doesn't hurt the geometric network.

Martin

Re: Remove duplicate vertices from network features?

MartinAmeskamp — Tue, 05 Jul 2016 06:47:52 GMT

Wrong. It does hurt the geometric network. We've contacted tech support about this...

Martin

Re: Remove duplicate vertices from network features?

WesMiller — Tue, 05 Jul 2016 12:11:40 GMT

Could you load your data into a file geodatabase run repair geometry then reload the repaired data back into server then recreate your geometric network?

Re: Remove duplicate vertices from network features?

DanPatterson_Retired — Tue, 05 Jul 2016 12:20:22 GMT

Martin... I am curious. I searched on this topic for a while and came to the conclusion that SDE is a good repository if one needs it, but trying to 'fix' something is often difficult. I wonder why they just don't suggest, fix it outside and use that result. Is this a common occurence for other simple geoprocessing issues or is it unique to this situation?

Re: Remove duplicate vertices from network features?

MartinAmeskamp — Wed, 13 Jul 2016 07:52:22 GMT

Hi, here's an update: Tech support replied on our network problems: That was fairly easy, we had done the simplify on the original shape rather than getting a clone of the shape, simplifying that and then assigning it to the feature and storing it. Switching to that second method seems to fix the network problem. Also, we find that some features are split inti multipart features by the simplify, which the network doesn't like, but we can skip and log those features and handle them by hand.

As to the other suggestions: The duplicate features are part of a geometric network in a large production geodatabase, and while extracting a large number of network features and the reloading them might be possible in theory, it's not something I'd really like to try.

And no, having this many features with duplicate vertices is not a common occurrence but rather very specific to one customer situation. We've started cheking on other databases and generally find a handful of features with "real" duplicate vertices (rather than vertices that are very close) in many databases, but these tend to be a few and can be fixed by hand, if one so desires.

Martin