Jump to content

 
Photo

Changing fields names and such in ArcGIS 9

- - - - -

  • Please log in to reply
7 replies to this topic

#1
cmdrico7812

cmdrico7812

    Key Contributor

  • Validated Member
  • PipPipPip
  • 68 posts
  • United States

I
want to restructure the tables of my shapefiles without having to
create all brand new tables as this would take an unbelievable amount
of time. I found the PowerStructure database utility extension for
ArcView....alas...I do not have ArcView I have ArcGIS 9.1. IS there
something similar to PowerStructure that I can use to go through and
change field names and such in my tables? Or does anyone know of a good
way to do this without having to create new tables or open them all in
Excel and changing their names. Much thanks in advance.

#2
benbakelaar

benbakelaar

    Ultimate Contributor

  • Associate Admin
  • PipPipPipPipPipPip
  • 658 posts
  • Gender:Male
  • Location:North Brunswick, NJ
  • Interests:maps, information, technology, scripting, computers
  • United States

"Off the top of my head, in ArcMap 9.1....

You
can just ""Start Editing"" via the Editor toolbar, then open the
shapefile ""Attribute Table"" (think you just right-click on the layer
you want). Should let you change the field name as well as field
entries, maybe you will have to right-click on the header area and go
to Properties. "

#3
cmdrico7812

cmdrico7812

    Key Contributor

  • Validated Member
  • PipPipPip
  • 68 posts
  • United States

I tried that method and I can't edit the field names, only the data in the fields.

#4
Pete Y.

Pete Y.

    Contributor

  • Validated Member
  • PipPip
  • 23 posts
  • Location:San Bernardino, CA
  • United States

"You could always try:

1. Export all shapefiles to geodatabase feature classes
2. Changing the new feature-class field names inside MS Access.
3. Exporting all the data back to shapefiles.

Wouldn't
that work? You have much greater database-level control of things
inside Access. You can probably do a ""batch"" procedure with (1) and (3)
inside Python or ModelBuilder (or it might already exist, too lazy to
check!)

Good luck.
"

#5
benbakelaar

benbakelaar

    Ultimate Contributor

  • Associate Admin
  • PipPipPipPipPipPip
  • 658 posts
  • Gender:Male
  • Location:North Brunswick, NJ
  • Interests:maps, information, technology, scripting, computers
  • United States

"

I tried that method and I can't edit the field names, only the data in the fields.

http://


You
are correct, I just played around for a while. Only thing I have is, my
XTools Pro bar has a Table operations -> Table restructure item...
but it seems to be only for registered versions. "

#6
ELeFevre

ELeFevre

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 1,049 posts
  • Gender:Male
  • Location:Louisville, Colorado USA
  • Interests:Cartography, musical instruments, reading, hiking, craft beer
  • United States

See if this works for you:

1) Start Editing

2) Create a new field with the name you want to use.

3) Right click on the new field after it's created

4) Calculate values from the original field

5) Delete the old field





#7
frax

frax

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 2,299 posts
  • Gender:Male
  • Location:Stockholm, Sweden
  • Interests:music, hiking, friends, nature, photography, traveling. and maps!
  • Sweden

If
it is a traditional shape file, you can open the dbf file in Excel (or
equivalent) and edit it there. If it is a personal geodatabase, just
open the .mdb file in Access and edit away.
Hugo Ahlenius
Nordpil - custom maps and GIS
http://nordpil.com/
Twitter

#8
burwelbo

burwelbo

    Master Contributor

  • Validated Member
  • PipPipPipPip
  • 113 posts
  • Interests:Hockey, Hiking, Travel
  • Canada

"Try Xtools Pro. [url="http://"http://www.xtoolspro.com/"]http://www.xtoolspro.com/[/url]

There is a tool to restructure tables. Xtools also has a free evaluation period.

"




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->