Is it possible to calculate the file name in an attribute table?
My shapefile has a name like "cities.shp". In this shapefile I want to have a attribute "cities").
[GIS] Calculating file name with field calculator
attribute-tablefield-calculatorqgis
Related Solutions
This python code adds FILENAME field to all Featureclasses (excluding those in Datasets) and populates with featureclass name.
# Import standard library modules
import arcpy, os, sys
from arcpy import env
# Allow for file overwrite
arcpy.env.overwriteOutput = True
# Set the workspace directory
env.workspace = r"P:\geodatabase.gdb\filename"
# Get the list of the featureclasses to process
fc_tables = arcpy.ListFeatureClasses()
# Loop through each file and perform the processing
for fc in fc_tables:
print str("processing " + fc)
# Define field name and expression
field = "FILENAME"
expression = str(fc) #populates field
# Create a new field with a new name
arcpy.AddField_management(fc,field,"TEXT")
# Calculate field here
arcpy.CalculateField_management(fc, field, '"'+expression+'"', "PYTHON")
If you're committed to using the Field Calculator tool your best bet may be a very short python script within the "Pre-Logic Script Code":
def listShpName(yourShp):
desc=arcpy.Describe(yourShp)
return desc.Name
...and then your expression will be
listShpName("LayerInArcMapToC")
Where LayerInArcMapToC is the name of your layer in ArcMap
I've attached a screen capture to illustrate this. Of course, you'll have to do this on a shapefile-by-shapefile basis if you want to use field calculator. Here's a link to the ESRI documentation on describing data like I've illustrated above: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002z00000018000000
An additional link to some simple field calculator operations: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//005s0000002m000000
Best Answer
Sorry for that stupid question! I did find an very easy way to do what I aked in this thread. Just use the QGis processing tool and the SAGA "merge vector layers" tool. The merged shape file has a column (called "Layer") filled with the shape file names.