This is the 26th day of my participation in the August More Text Challenge

Background: Arcmap cannot draw one or more layers when importing data… The number of points is less than the required number of elements. After consulting the data for half a day, we found that it was caused by topological relationship error when making data. Now we record the treatment method in detail as follows:

1. Original data:

After importing the postgres database, the data reported an error as follows, and the data was scattered to half of the original

Reason 2.

Incorrect topology relation during data creation

3. Solutions:

3.1 Checking Errors

Open the toolbox – data management tools – elements – check geometry

Enter the problem data source, and the output table represents where the error message was output

Output the file

Indicates that there is an error in the data

3.2 repair

Open the toolbox – Data management tools – Elements – repair geometry

After the restoration, a message is displayed indicating that the restoration is successful. If a warning message is displayed, you can restore the restoration again

The restored data is shown as follows

Once fixed, we can use tools to import data into the database without error

4. Expand 4.1 Creating a Topology

You must put the data set of the database, right-click the data set to create a topology

A data can only participate in one topology, and a topology can have multiple data. Once a topology check is established, data cannot be modified or deleted

Data must be stored in the data set. If the data is not stored in the data set, the topology cannot be created

4.2 SHP File topology Check

SHP cannot perform topology check directly. You need to import or create a data set. The coordinate system must be consistent. Data must be backed up before topology check

New topology, no overlap, result

Topology modifies data. Data changes

Note: Fix geometry before topology is completed, otherwise invalid. The function is to change the outer polygon to clockwise and the inner polygon to counterclockwise