ArcPython work with table

Question

Good day. I have table with drill hole. Drill hole name is repeating for each drillng interval.

For example drill hole interval

a1 1
 a1 2
 a1 3
 b1 4
 b1 5
 b1 6

Now i want to select drill hole (rows) with minimal interval

for example a1 1
 b1 4

How can you help me ?

NeilAyres · Answer

If this is something to do with logging or sampling down a drillhole, the interval table is normally joined to the drillhole polyline zm using linear events.

First you need the drill trace polyline which has measures on the 3d length.

Then you can map the data table to it using the data in the table like "m_From, m_To", back to the measures.

If this is your scenario, please post some of the data here.

FC_Basson · Answer

Then just do a join on your original layer with the merged values from the output table.

AlesgerMammedov19801107 · Answer

Thank you very much, but i want to get shp file