topic Re: ArcPython work with table in Python Questions

ArcPython work with table

AlesgerMammedov2 — Mon, 22 Aug 2016 12:26:55 GMT

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 ?

Re: ArcPython work with table

JoshuaBixby — Mon, 22 Aug 2016 12:40:25 GMT

Given the ArcGIS Python API is still in beta and focused on Web GIS, I assume you are talking about ArcPy. Before offering any suggestions, it would help to know why exactly you want to select these records? Do you plan on doing some processing of these records? In the GUI or through scripting?

Re: ArcPython work with table

FC_Basson — Mon, 22 Aug 2016 13:03:40 GMT

You could split the value into 2 new fields and then do a Summarize on the "a1" column and select First record (if the records are permanently sorted on the second part). So first create 2 new fields - a text field and an integer field. Then run the split in the field calculator:

Field 1 - !Value!.split(" ")[0]

Field 2 - int( !Value!.split(" ")[1] )

Then do a permanent sort on the second split field.

Then do the summarize on the first split field

With the output table looking like this

Re: ArcPython work with table

AlesgerMammedov2 — Mon, 22 Aug 2016 13:11:36 GMT

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

Re: ArcPython work with table

FC_Basson — Mon, 22 Aug 2016 13:13:32 GMT

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

Re: ArcPython work with table

NeilAyres — Mon, 22 Aug 2016 13:26:52 GMT

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.