Anuncios

The Autodesk Community Forums has a new look. Read more about what's changed on the Community Announcements board.

Points on top of Points

bpeters33
Observer

Points on top of Points

bpeters33
Observer
Observer

Is there a tool that will prevent points from being imported on top of points?  My issue is I have data points that don't have to be imported into my dwg with great precision, but some have identical coordinates, which causes them to be brought in on top of each other, and thus, I can't tell visually how many there are.  ArcGIS has a tool called "Disperse" and I'm wondering if AutoCad has a similar tool.

0 Me gusta
Responder
Soluciones aceptadas (1)
538 Vistas
7 Respuestas
Respuestas (7)

Kent1Cooper
Consultant
Consultant

OVERKILL can remove duplicates.  EDIT:  If you don't want to do that, but only want to know how many Points there are, select a whole area of objects of any kinds, and pull down the object-type(s) list in the Properties palette:

Kent1Cooper_0-1649851037307.png

Further EDIT:  Or use SELECTSIMILAR and pick any Point, and the Properties palette will show you how many.

 

Kent Cooper, AIA
0 Me gusta

bpeters33
Observer
Observer

I don't want to remove the duplicates, I want to offset them so that I can still see them.

0 Me gusta

Kent1Cooper
Consultant
Consultant

@bpeters33 wrote:

I don't want to remove the duplicates, I want to offset them so that I can still see them.


If you want to see them only to know how many there are, see my Edit to my previous reply.

 

A routine could be made to find duplicates and move some, though I wonder about the validity of moving data points -- what does that do to the data aspect?  But in any case, there would need to be some criteria.  How far to move them?  In what direction?  Might there ever by more than two in the same place, so that some would need to be moved different distances or in different directions than others?  Etc.

 

You could also try over in the Civil3D or maybe AutoCAD Map Forum, where people who may have the same kind of need are likely to hang out.

Kent Cooper, AIA
0 Me gusta

bpeters33
Observer
Observer

Thanks.  I appreciate it.

0 Me gusta

parkr4st
Advisor
Advisor

what is the import process?  all points in one import or several imports?

maybe layers for each import, qselect by layer and change the Z value for each layer?

view from a corner of the cube would show the points separated by elevation.

data extracton would then have the Z value making the points not coincident

leeminardi
Mentor
Mentor
Solución aceptada

Here's a way to do it with Excel and AutoCAD.

1. Import the point data into Excel and then sort. This should yield duplicate points consecutively.

leeminardi_0-1650390940820.png

2.  Layout the worksheet as seen below. Cells A1 and B1 contain the desired offset for duplicate points.  The data starts on row 3.

leeminardi_1-1650391138143.png

 

3. Cell C3 = 0. while cell C4 is:

=IF(AND(A4=A3,B4=B3),C3+1,0)

Fill column C all the way down from C4 to the last row of data.

 

4. Cell D3 is:

=CHOOSE($C3+1,A3,A3+A$1,A3+2*A$1)

and E3 (fill right from C3) is:

=CHOOSE($C3+1,B3,B3+B$1,B3+2*B$1)

Fill columns D and E down to the last row of data.

 

5. Cell G3 is:

=CONCATENATE("point ",D3,",",E3)

Fill down then copy and paste this column into AutoCAD.

 

The result should look something like this.

leeminardi_2-1650391484768.png

 

 

lee.minardi

bpeters33
Observer
Observer

That's actually what I ended up doing, except I only moved the Y coordinate so that they're aligned vertically.  Thanks.

0 Me gusta