MiltiLinestring layer not showing well on the map

[LuisanaIG]

Hey everyone, I’m running into an issue with a layer and its attribute table when I add it to the map. Anyone know what might be causing it?

I have a MultiLineString layer stored in PostgreSQL 15.5, and I'm working with ArcGIS Pro 3.4. When I add the layer to the map, not all the geometries show up. Also, when I open the attribute table, I get an error message.

I've also checked whether the lines have at least two points to form valid geometries, confirmed that they're all MultiLineStrings, and verified that the geom column seems fine.

Additionally, I tried publishing the layer to Portal, but it still behaves strangely. The image service shows more records than actually exist, while the feature service shows the correct number of records — but still, not all geometries are drawn on the map.

Feature service:

Image service:

What’s odd is that I have other line layers that are much more complex and larger, and they don’t have this issue.

Does anyone have any idea might be causing this issue?

Thank you!!

-Lu-

[Robert_LeClair]

Are there any ShapeLengths of zero in the layer?  If so, delete those records and try the workflow again.

[LuisanaIG]

Hi Robert, thanks for your reply.

I don’t have any lines where ShapeLength is zero. The only workaround I’ve found is enabling the SDE schema/user and importing the same layer from a file geodatabase, but this might not be a viable option for the client I’m working with.

Thank you!!

[LuisanaIG · Accepted solution]

I was able to solve the problem with a SQL sentence:

UPDATE table_name geom = ST_RemoveRepeatedPoints(ST_SnapToGrid(geom, 0.001));