topic Re: A simple expression... in ArcObjects SDK Questions

A simple expression...

BrianCoward — Tue, 10 May 2011 14:29:48 GMT

Alright, let me see if I can explain this clearly.
There are 3 variables:

[APN] - String
[Shp_Acerage] - Double
[APN_ac] - Double

I need records with the same [APN] to add up the [Shp_Acreage] in the [APN_ac]. The outcome of this would be...

2 or more records with the same [APN]:

[APN]                      [Shp_Acreage]        [APN_ac]
046-260-003-000       29.48                    43.67
046-260-003-000       1.53                      43.67
046-260-003-000       10.91                    43.67
046-260-003-000       1.75                      43.67

I was planning on running this through the Calculator on the [APN_ac] field but if there is a better way... I'll take it. Seems like a simple thing to do but I haven't had any luck. Appreciate the help,
Brian

Re: A simple expression...

michaelcollins1 — Tue, 10 May 2011 14:46:04 GMT

off the top of my head:

create a table with APN & APN_AC

join it to your existing table based on APN

Re: A simple expression...

BrianCoward — Tue, 10 May 2011 15:51:56 GMT

mcollinsamec,
That makes sense to me. I would assume that the new table would only have unique APN values? Could you help me with how to populate the new APN table with unique values? I've got the code below but I'm not sure how to point the sField to the feature class and field. Thanks for the help,
Brian

Static d As Object
Static i As Long
Dim iDup As Integer
Dim sField

sField = CMA_3_50ft_PARCELS[APN]

If (i = 0) Then
Set d = CreateObject("Scripting.Dictionary")
End If
If (d.Exists(CStr(sField))) Then
iDup = CMA_3_50ft_PARCELS[APN]
Else
d.Add CStr(sField), 1
iDup = 0
End If
i = i + 1

Re: A simple expression...

michaelcollins1 — Wed, 11 May 2011 14:31:09 GMT

Sorry, but coding isn't my bag.

Yes, the new table would be a relates or look-up table with unique values for APN.

Re: A simple expression...

BrianCoward — Wed, 11 May 2011 14:42:52 GMT

Oh wow... this was far easier then I was making it. All I had to do was Summarize on the [APN] field and check the Sum box in the acreage field. The resulting table is exactly what I was looking for. Mcollinsamec, thanks for the post.