|
Modifying attribute tables
|
View:
New views
4 Messages
—
Rating Filter:
Alert me
|
 |
Modifying attribute tables
by Chris Hardenbrook
::
Rate this Message:
Aloha,
We have point shapefiles (ArcView/Info 9.3.1) for various permits that have been issued by our County Planning Department. The permits were numbered sequentially until an administrative change decreed they should have a new format with a dash added between the year issued and the permit number. So, instead of a simple 1, 2, 3 style we now have new permits in the form 09-1, 09-2, 09-3, etc. The field for permit numbers was established as "numeric" and so, will not accept new input containing dashes, and, since a field's properties can not be changed once established (nor, annoyingly, can you even permanently reorder the fields) I'm looking for a way to modify the existing attribute table to keep the current field order and allow a "text" type input in this field. If anyone has had any luck in this sort of modification, I'd appreciate hearing about it. I don't really want to make a whole new shapefile just to accommodate this change :( Mahalo for any hints you can toss my way! Chris Hardenbrook, GIS Analyst County of Hawai'i Planning Department 101 Pauahi Street, Ste.3 Hilo, Hawai'i 96720-3043 chardenbrook@... 808.961.8164 _______________________________________________ gislist mailing list gislist@... http://lists.geocomm.com/mailman/listinfo/gislist _________________________________ This list is brought to you by The GeoCommunity http://www.geocomm.com/ |
|
|
Re: Modifying attribute tables
by Verachtert, Jason
::
Rate this Message:
Chris,
You can do this with personal geodatabase feature classes IF you are careful. ESRI will tell you this is not supported, but I have been doing it for years. Once the data has been imported in to a .MDB file. Open the table for your feature class in Microsoft Access. Ignore all of the other tables, those are needed for the geodatabase functionality. In the designer you can move fields, rename fields and even change the field type. Then just export back to shape using ArcCatalog. Just make sure the final copy is what you need before getting rid of your original shapefiles. ___________________________________________ Jason C. Verachtert, GISP GIS Analyst Kane County GIS-Technologies 719 Batavia Ave. Geneva, Illinois (630) 208-8655 - Voice (630) 208-8659 - Fax 88º18'28" W, 41º52'44" N -----Original Message----- From: gislist-bounces+verachtertjason=co.kane.il.us@... [mailto:gislist-bounces+verachtertjason=co.kane.il.us@...] On Behalf Of Chris Hardenbrook Sent: Friday, July 24, 2009 4:34 PM To: GISlist Subject: [gislist] Modifying attribute tables Aloha, We have point shapefiles (ArcView/Info 9.3.1) for various permits that have been issued by our County Planning Department. The permits were numbered sequentially until an administrative change decreed they should have a new format with a dash added between the year issued and the permit number. So, instead of a simple 1, 2, 3 style we now have new permits in the form 09-1, 09-2, 09-3, etc. The field for permit numbers was established as "numeric" and so, will not accept new input containing dashes, and, since a field's properties can not be changed once established (nor, annoyingly, can you even permanently reorder the fields) I'm looking for a way to modify the existing attribute table to keep the current field order and allow a "text" type input in this field. If anyone has had any luck in this sort of modification, I'd appreciate hearing about it. I don't really want to make a whole new shapefile just to accommodate this change :( Mahalo for any hints you can toss my way! Chris Hardenbrook, GIS Analyst County of Hawai'i Planning Department 101 Pauahi Street, Ste.3 Hilo, Hawai'i 96720-3043 chardenbrook@... 808.961.8164 _______________________________________________ gislist mailing list gislist@... http://lists.geocomm.com/mailman/listinfo/gislist _________________________________ This list is brought to you by The GeoCommunity http://www.geocomm.com/ _______________________________________________ gislist mailing list gislist@... http://lists.geocomm.com/mailman/listinfo/gislist _________________________________ This list is brought to you by The GeoCommunity http://www.geocomm.com/ |
|
|
Re: Modifying attribute tables
by Holly Glaser
::
Rate this Message:
Hi-
In Access, a shapefile has 2 tables, attribute and spatial with the same name. I find it useful to track changes by copying and renaming both shapefile tables, and then making changes to the attribute table. Holly Glaser -----Original Message----- From: gislist-bounces+h.glaser=comcast.net@... [mailto:gislist-bounces+h.glaser=comcast.net@...] On Behalf Of Verachtert, Jason Sent: Friday, July 24, 2009 2:59 PM To: GISlist Subject: Re: [gislist] Modifying attribute tables Chris, You can do this with personal geodatabase feature classes IF you are careful. ESRI will tell you this is not supported, but I have been doing it for years. Once the data has been imported in to a .MDB file. Open the table for your feature class in Microsoft Access. Ignore all of the other tables, those are needed for the geodatabase functionality. In the designer you can move fields, rename fields and even change the field type. Then just export back to shape using ArcCatalog. Just make sure the final copy is what you need before getting rid of your original shapefiles. ___________________________________________ Jason C. Verachtert, GISP GIS Analyst Kane County GIS-Technologies 719 Batavia Ave. Geneva, Illinois (630) 208-8655 - Voice (630) 208-8659 - Fax 88º18'28" W, 41º52'44" N -----Original Message----- From: gislist-bounces+verachtertjason=co.kane.il.us@... [mailto:gislist-bounces+verachtertjason=co.kane.il.us@...] On Behalf Of Chris Hardenbrook Sent: Friday, July 24, 2009 4:34 PM To: GISlist Subject: [gislist] Modifying attribute tables Aloha, We have point shapefiles (ArcView/Info 9.3.1) for various permits that have been issued by our County Planning Department. The permits were numbered sequentially until an administrative change decreed they should have a new format with a dash added between the year issued and the permit number. So, instead of a simple 1, 2, 3 style we now have new permits in the form 09-1, 09-2, 09-3, etc. The field for permit numbers was established as "numeric" and so, will not accept new input containing dashes, and, since a field's properties can not be changed once established (nor, annoyingly, can you even permanently reorder the fields) I'm looking for a way to modify the existing attribute table to keep the current field order and allow a "text" type input in this field. If anyone has had any luck in this sort of modification, I'd appreciate hearing about it. I don't really want to make a whole new shapefile just to accommodate this change :( Mahalo for any hints you can toss my way! Chris Hardenbrook, GIS Analyst County of Hawai'i Planning Department 101 Pauahi Street, Ste.3 Hilo, Hawai'i 96720-3043 chardenbrook@... 808.961.8164 _______________________________________________ gislist mailing list gislist@... http://lists.geocomm.com/mailman/listinfo/gislist _________________________________ This list is brought to you by The GeoCommunity http://www.geocomm.com/ _______________________________________________ gislist mailing list gislist@... http://lists.geocomm.com/mailman/listinfo/gislist _________________________________ This list is brought to you by The GeoCommunity http://www.geocomm.com/ _______________________________________________ gislist mailing list gislist@... http://lists.geocomm.com/mailman/listinfo/gislist _________________________________ This list is brought to you by The GeoCommunity http://www.geocomm.com/ |
|
|
|
| Free embeddable forum powered by Nabble | Forum Help |
