|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | RE: GISList: how to create a one-to-many numeric field |
| Date: |
03/28/2003 11:35:00 AM |
| From: |
Analisa Gunnell |
|
|
Thanks to all of you who graciously attempted to answer my admittedly
confusing email, which posted the question of how to create a one-to-many
numeric field. While all of your answers were highly ingenuitive, I figured
out a way of resolving this problem (with the guidance of a team-mate), by
ditching Microsoft products, and relying on ArcView solely. I opened my
table in ArcView, and selected the name string field that needed a number
field associated with it. I then did a summarize, so I would have a new
table created with my string field being tallied with the quantity of each
being summarized in a new field. I then, created a new field called ID# in
my string table, and joined my new summarized table to my string table using
the name string field, as the join column. I finally calculated the new ID#
field to equal the FID field of the joined table. VOILA! I now have a
unique number associated with every name string on my map.
Thanks again for all your suggestions!
Analisa Noel Gunnell
GIS Technician
Ecotrust
721 NW Ninth Avenue, Suite 200
Portland, Oregon
97209
503.467.0750
analisa@ecotrust.org
www.ecotrust.org
www.inforain.org
CONSERVATION ECONOMY
ECOLOGY-ECONOMY-EQUITY
-----Original Message-----
From: Richard H Raymond [mailto:rraymond@cisunix.unh.edu]
Sent: Friday, March 28, 2003 5:41 AM
To: Analisa Gunnell
Subject: Re: GISList: how to create a one-to-many numeric field
Analisa,
You can do this in EXCEL. First create a table with two columns
containing
your numeric values and the associated label. Now go back to your main
table
and create a new column for your numeric values. Move to the first cell and
use the LOOKUP command (see EXCEL help for correct format) to place the
correct
value in this cell. COPY this cell down the length of your column and EXCEL
will fill in the values.
Ric Raymond
Center for Coastal and Ocean Mapping
University of New Hampshire
Quoting Analisa Gunnell <analisa@ecotrust.org>:
>
> Hello List,
>
> I am trying to create a numeric field with a unique number that will
> be associated with a string field in my table for the purpose of
> labeling on a map. I know that I can just use the FID field, except
> that I want a one-to-many association of the number field to my string
> field (i.e.1 = all name fields equal to "Hardy"). I'm trying to
> export my table and manipulate it in excel (I'm working in the ARC/GIS
> environment), but I have little experience in excel and seem to be
> hitting a road block. Does anyone have any suggestions?
>
> Thanks so much in advance,
>
>
> Analisa Noel Gunnell
> GIS Technician
> Ecotrust
> 721 NW Ninth Avenue, Suite 200
> Portland, Oregon
> 97209
> 503.467.0750
> analisa@ecotrust.org
> www.ecotrust.org
> www.inforain.org
> CONSERVATION ECONOMY
> ECOLOGY-ECONOMY-EQUITY
>
>
> To unsubscribe, write to gislist-unsubscribe@geocomm.com
> ______________________________________________________________________
> __
> GeoCommunity GeoBids - less than $1 per day!
> Get Access to the latest GIS & Geospatial Industry RFPs and bids
> http://www.geobids.com
>
> Online Archive of GISList (and numerous others) available at:
> http://spatialnews.geocomm.com/community/lists/
>
> Setup a GeoCommunity Account and have access to
> the GISDataDepot DRG & DOQQ Catalog
> http://www.geocomm.com/login.php
>
To unsubscribe, write to gislist-unsubscribe@geocomm.com
________________________________________________________________________
GeoCommunity GeoBids - less than $1 per day!
Get Access to the latest GIS & Geospatial Industry RFPs and bids
http://www.geobids.com
Online Archive of GISList (and numerous others) available at:
http://spatialnews.geocomm.com/community/lists/
Setup a GeoCommunity Account and have access to
the GISDataDepot DRG & DOQQ Catalog
http://www.geocomm.com/login.php
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
