python 式

GregorMitzlaff

<\/HEAD>

皆さん、こんにちは、<\/P>

<\/P>

写真には熱量計の属性テーブルが見えます。熱量計の番号は11250423です。熱の状態は毎月示されています。今、各月の消費量を取得する式を作りたいと思います。<\/P>

<\/P>

<\/P>

<\/P>

<\/P>

理論的には次のようにしなければなりません:<\/P>

y_(i+1)-y_(i) = 消費量<\/P>

<\/P>

月 1 (1月): y_(1+1)-y_(1) = 1月の消費量<\/P>

月 2 (2月): y_(2+1)-y_(2) = 2月の消費量<\/P>

...<\/P>

月 12 (12月): y_(12+1)-y_(12) = 12月の消費量<\/P>

<\/P>

arcgisで式を書く方法を知っている方はいらっしゃいますか？計算用に新しいフィールドを作りたいです。<\/P>

<\/P>

ご協力ありがとうございます。<\/P>

<\/P>

ドイツからのご挨拶！<\/P><\/BODY><\/HTML>

Arne_Gelfert

Gregor,

I'm sure what you're trying to accomplish can be done in field calculator. In my experience, the more massaging I have to do with data, the more I want to do it near the source. Usually that's fastest and I find it more transparent. Don't know where you're getting your data. But this would be easy to do in SQL:

<SPAN class="keyword token">SELECT</SPAN> month<SPAN class="punctuation token">(</SPAN>Datum<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> <SPAN class="punctuation token">[</SPAN>MONTH<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> year<SPAN class="punctuation token">(</SPAN>Datum<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> <SPAN class="punctuation token">[</SPAN>YEAR<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token function">SUM</SPAN><SPAN class="punctuation token">(</SPAN>Wärmemenge<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">AS</SPAN> TOTAL
<SPAN class="keyword token">FROM</SPAN> <SPAN class="operator token"><</SPAN>YOUR <SPAN class="keyword token">DATA</SPAN> SOURCE<SPAN class="operator token">></SPAN>
<SPAN class="keyword token">GROUP</SPAN> <SPAN class="keyword token">BY</SPAN> month<SPAN class="punctuation token">(</SPAN>Datum<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> year<SPAN class="punctuation token">(</SPAN>Datum<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">-- ORDER BY [MONTH], [YEAR]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

So admittedly, this may not work in in your situation but if it does and you can create a query layer or database view, I bet it would perform better.

Schöne Grüße