nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I show each 100th symbology out of 43000 points?

CarstAway

Hello!

I have a lot of data and want to show just every 100th data( 0, 100, 200, 300, 400 and so on till 43000) in a map. I dont want to use the Query Builder in this way: "KP_CABLE" =0 OR "KP_CABLE" =100 OR "KP_CABLE"=200..... Has anyone an good idea?

Furthermore: How can I show in my map the name to the symbology for each 100th point? For example I want to show in my map the points 0, 100, 200,... with ne name on it: KP0, KP100, KP200?

Best wishes!

Find more posts tagged with

Accepted answers

All comments

DanPatterson_Retired

Add a new field and calculate values to use for labeling and symbology.

It will return the field value if the modulus is 0, otherwise 0.

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">modu</SPAN><SPAN class="punctuation token">(</SPAN>fld<SPAN class="punctuation token">,</SPAN> divby<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">"""return the modulous and vals"""</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>fld <SPAN class="operator token">%</SPAN> divby<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; val <SPAN class="operator token">=</SPAN> fld
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; val <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">return</SPAN> val

<SPAN class="comment token"># ---- expression</SPAN>
<SPAN class="comment token">#------ modu(!YourField!, 100)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

for i in range(10): print(modu(i,3))
0
0
0
3
0
0
6
0
0
9

CarstAway

Hello,

thnaks for your answer. I never used a Field Calculator with expressions like yours.

<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;"># ---- expression</SPAN>

What is the meaning of that? Do I have to change here something?

<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">def</SPAN> <SPAN class="" style="color: #d74444; border: 0px; font-weight: inherit;">modu</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>fld<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN> divby<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"""return the modulous and vals"""</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">if</SPAN> <SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>fld <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">%</SPAN> divby<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN> <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">==</SPAN> <SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">0</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; val <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> fld
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">else</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; val <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">0</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">return</SPAN> val

<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;"># ---- expression</SPAN>
<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;">#------ modu(!YourField!, 100)</SPAN>

Using this, it leads to an error.

CarstAway

Sry, I really dont get it. I tried to copy and paste this into the Field Calculator

<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">def</SPAN> <SPAN class="" style="color: #d74444; border: 0px; font-weight: inherit;">modu</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>fld<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">,</SPAN> divby<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit;">"""return the modulous and vals"""</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">if</SPAN> <SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">(</SPAN>fld <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">%</SPAN> divby<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">)</SPAN> <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">==</SPAN> <SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">0</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; val <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> fld
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">else</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; val <SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN> <SPAN class="" style="color: #990000; border: 0px; font-weight: inherit;">0</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit;">return</SPAN> val

<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;"># ---- expression</SPAN>
<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit;">#------ modu(!YourField!, 100)</SPAN><SPAN class="" style="border-width: 0px 1px 0px 0px; border-style: initial solid initial initial; border-color: initial #999999 initial initial; font-weight: inherit;"></SPAN>

But I dont know how to work with this.

Best Wishes

DanPatterson_Retired

Calculate Field Python examples—Data Management toolbox | ArcGIS Desktop

there is a code block section where you put all the lines of the function (aka, the def)

there is an expression line... that is where you would put the expression .. modu(blah, blah) minus the #--- stuff

I don't have screen grab capabilities, but I am sure you can figure it out

CarstAway

Thanks!

XanderBakker

It is probably easier to just use a definition query like:

mod( KP_CABLE, 100) = 0

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.