[OKGIS] Programming Question

Thu Feb 7 15:09:59 CST 2008

Paul,

I can think of a couple ways to get it working, but to the best of my
knowledge, there is no way to do this sort of iterative processing within
ArcMap GUI. You could go with a T-SQL cursor type solution or generate a
small .NET console application that took a few parameters and did the job.

I'd be happy to help you with it, but it's a bit beyond the scope of a
newsgroup conversation. You can contact me directly at
dlowther at coordinatesolutions.com.

David Lowther

  _____  

From: okgis-bounces at gis.gis.ou.edu [mailto:okgis-bounces at gis.gis.ou.edu] On
Behalf Of Paul Rodden
Sent: Thursday, February 07, 2008 2:55 PM
To: Oklahoma GIS Community
Subject: Re: [OKGIS] Programming Question

Yes... that is perfect.  The data is in sde, but I made a shapefile for
testing purposes that I am doing all of my work with.  Do you know of a way
to get this working?

On Feb 7, 2008 1:09 PM, David Lowther <dlowther at coordinatesolutions.com>
wrote:

Oh - and how is the layer stored (SQL, Oracle, Access, file, shapefile,
etc.)?

David Lowther

  _____  

From: okgis-bounces at gis.gis.ou.edu [mailto:okgis-bounces at gis.gis.ou.edu] On
Behalf Of Paul Rodden
Sent: Thursday, February 07, 2008 1:42 PM
To: Oklahoma GIS Community
Subject: Re: [OKGIS] Programming Question

So close... had all my data been integer, the summary would have worked.
The problem is that there is no sum function for that field, only a first
and last function.  Here is what I am actually doing.  I am trying to
populate a field that will hold the sum of text fields from a MAPSCO grid
field (the style of the data would be like 49A-C).  The MAPSCO grid is
published mapbook with a grid overlay to identify streets per grid area.
Since many of the streets carry over into different grid numbers, the values
for every street segment may be different.  I am wanting to set up a new
field that is populated by the sum of all those grid entries.  What I am
wanting is the field to read similar to "49-A49-B49A-C..." as the records
are added together.  I hope this gives a better insight as to what I am
wanting to do.  But you understand the basic premise perfectly.  Thanks for
the help.

Paul

On Feb 7, 2008 11:54 AM, David Lowther <dlowther at coordinatesolutions.com>
wrote:

Paul,

Given the following scenario, the steps below should get you where you are
going.

You have a data layer that has (or will have) the following fields: Region,
Pop, and RegionPop. You are looking for a way to calculate each state's
RegionalPop to equal the sum of the states' Pop grouped by a Region column. 

Steps:

Open the layer's attribute table.
Right-click the Region field and choose Summarize.
- the field to summarize should be Region
- expand the Pop field under step 2 and put a check next to Sum.
- say OK, and then Yes to add the table to the map.
Right-click the table that you just created and choose Open. 
- This should have your desired RegionPop values.
Right-click the original layer and choose Joins and Relates -> Join...
- 1 - Region
- 2 - the name of the table you created above.
- 3 - Region
- say OK - now you will see both the layer's fields and the table's fields.
Right-click on layername.RegionPop in the attribute table and choose Field
Calculator. Say OK to the nag screen.
- double click tablename.Sum_Pop and say OK.
Right-click the layer in the table of contents and choose Joins and Relates
-> Remove Joins -> Remove All Joins...

Hope that helps,

David Lowther 

Coordinate Solutions, Inc.

904.471.5528 (Voice)

405.210.1721 (Mobile)

904.471.5548 (Fax)

www.coordinatesolutions.com

  _____  

From: okgis-bounces at gis.gis.ou.edu [mailto:okgis-bounces at gis.gis.ou.edu] On
Behalf Of Paul Rodden
Sent: Thursday, February 07, 2008 12:24 PM
To: Oklahoma GIS Community
Subject: [OKGIS] Programming Question

To all you GIS programming guru's out there I have a question.  I want to
take multiple records in a column and add the data together in a new column.
An example of this would be, say, a feature class of the US with states and
total population of the states and wanting to set up a new column in that
feature class that would have the total population by region (Southwest,
Northwest, etc...).  I've tried EDN but to no avail.  The actual data that
I'm working with is string, but it should still work the same (as in adding
two string fields).  Does anyone have any ideas?  I would appreciate any and
all help.  Thanks.

Paul Rodden
Senior GIS Analyst
City of Mesquite

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gis.ou.edu/pipermail/okgis/attachments/20080207/c2e5af44/attachment.htm