I am populating an attribute table. After adding a field i have to populate the field with different texts in a sequential order like water, air, car, school etc. i have completed inserting water using the field calculator, how do i add the others.
[GIS] Inserting text into field of attribute table in ArcGIS for Desktop
arcgis-desktopattribute-tableediting
Related Solutions
Well, if you've got a table that natively (sorted by FID or ObjectID as applicable) is NOT sorted how you want it, and you want to view the table sorted by a specific field(s) with a unique ID field in order of the sort, you don't need to mess with any scripting at all.
Just use the SORT geoprocessing tool that is included in ArcGIS (In ArcToolbox > Data Management Tools > General > Sort ). This tool should do what you're asking for because there will be a new OID/FID for the resulting dataset that is in order with the sorted values.
More info on the Sort GP tool is available at http://resources.arcgis.com/en/help/main/10.1/index.html#/Sort/001700000057000000/
"Solution" with 2 sorted fields (ascending):
mxd = arcpy.mapping.MapDocument("CURRENT")
lr=arcpy.mapping.ListLayers(mxd)[0]
tbl=arcpy.da.TableToNumPyArray(lr,("oid","A","B"))
bs=sorted(tbl, key=lambda x: (x[1], x[2]))
def sortSeq(fid,a,b):
for i,ent in enumerate(bs):
if ent[0]==fid: return i
--------------------------------------
sortSeq( !OID!, !A!, !B! )
UPDATED VERSION:
mxd = arcpy.mapping.MapDocument("CURRENT")
lr=arcpy.mapping.ListLayers(mxd)[0]
tbl=arcpy.da.TableToNumPyArray(lr,("oid","A","B"))
bs=sorted(tbl, key=lambda x: (x[1], x[2]))
aDict={}
for i,row in enumerate(bs):
aDict[row[0]]=i
def sortSeq(fid):
return aDict[fid]
-----------------------
sortSeq( !OID!)
takes 1.5 seconds to complete task on 10000 records. Original takes slightly more than 2 minutes
Best Answer
Select the rows that you want to add the text in using the
Select by Attributefrom the selection drop down, then using a query to get only those rows.Open the attribute table then use the Field Calculator to add the required text in the rows, enable editing before you use the field calculator as any changes made outside of an editing session are permanent, Repeat this for all the attributes.
If you want to change the text in the attribute table, select the text in the attribute table and press
control + for go to the attribute table drop down and select find and replace. In there select the replace tab and use it to change the text that you want, be careful that you use it onWhole Fieldand not the whole attribute table.