Add and Alter and Incrementing ID Field, Assign Default to Field Tools
Add Field
How to Add Field Tool in ArcToolbox ArcMap ArcGIS??
Add Field |
Path to access the tool
:
Add
Field Tool, Fields Toolset, Data
Management Tools Toolbox
Add Field
Adds a new field to a
table or the table of a feature class, feature layer, and/or rasters with
attribute tables.
1. Input Table
The input table to which
the specified field will be added. The field will be added to the existing
input table and will not create a new output table.
Fields can be added to feature classes in geodatabases, shapefiles, stand-alone tables, rasters with attribute tables, and layers.
2. Field Name
The name of the field
that will be added to the input table.
3. Field Type
The field type of the new field.
- TEXT—Any string of characters.
- FLOAT— Fractional numbers between -3.4E38 and 1.2E38.
- DOUBLE— Fractional numbers between -2.2E308 and 1.8E308.
- SHORT— Whole numbers between -32,768 and 32,767.
- LONG— Whole numbers between -2,147,483,648 and 2,147,483,647.
- DATE—Date and/or time.
- BLOB—Long sequence of binary numbers. You need a custom loader or viewer or a third-party application to load items into a BLOB field or view the contents of a BLOB field.
- RASTER—Raster images. All ArcGIS software-supported raster dataset formats can be stored, but it is highly recommended that only small images be used.
- GUID—Globally unique identifier.
4. Field Precision (optional)
The number of digits
that can be stored in the field. All digits are counted no matter what side of
the decimal they are on.
If the input table is a
file or personal geodatabase, the field precision value will be ignored.
5. Field Scale (optional)
The number of decimal
places stored in a field. This parameter is only used in float and double data
field types.
If the input table is a
file or personal geodatabase, the field scale value will be ignored.
6. Field Length (optional)
The length of the field being
added. This sets the maximum number of allowable characters for each record of
the field. This option is only applicable on fields of type text.
7. Field Alias (optional)
The alternate name given
to the field name. This name is used to give more descriptive names to cryptic
field names. The field alias parameter only applies to geodatabases.
8. Field IsNullable (optional)
Specifies whether the field can contain null values. Null values are different from zero or empty fields and are only supported for fields in a geodatabase.
- Checked—The field will allow null values. This is the default.
- Unchecked—The field will not allow null values.
9. Field IsRequired (optional)
Specifies whether the field being created is a required field for the table and is only supported for fields in a geodatabase.
- Unchecked—The field is not a required field. This is the default.
- Checked—The field is a required field. Required fields are permanent and cannot be deleted.
10. Field Domain (optional)
Used to constrain the values allowed in any
particular attribute for a table, feature class, or subtype in a geodatabase.
You must specify the name of an existing domain for it to be applied to the
field.
Add Incrementing ID Field
How to Add Incrementing ID Field Tool in ArcToolbox ArcMap ArcGIS??
Add Incrementing ID Field |
Path to access the tool
:
Add
Incrementing ID Field Tool, Fields Toolset, Data Management Tools Toolbox
Add Incrementing ID Field
Adds a
database-maintained ID field to an existing table or feature class in a Dameng,
IBM Db2, Microsoft Azure SQL Database, Microsoft SQL Server, Oracle, or
PostgreSQL database.
A database-maintained ID field is required on all feature
classes or tables you plan to edit through a feature service.
1. Input Table
The location and name of
the table or feature class to which you want to add an ID field.
2. Field Name (optional)
The name to be used for
the ID field. If no input is provided, the name defaults to ObjectID.
Alter Field
How to Alter Field Tool in ArcToolbox ArcMap ArcGIS??
Alter Field |
Path to access the tool
:
Alter
Field Tool, Fields Toolset, Data Management
Tools Toolbox
Alter Field
Renames fields and field
aliases, or alters field properties.
1. Input Table
The input table or
feature class that contains the field to alter.
2. Field Name
The name of the field to alter. If the field is a required field (isRequired=true), only the field alias can be altered.
3. New Field Name (optional)
The new name for the
field.
4. New Field Alias (optional)
The new field alias for
the field.
5. New Field Type (optional)
Specifies the new field
type for the field. This property is only applicable if the input table is
empty (does not contain records).
- TEXT—Any string of characters.
- FLOAT— Fractional numbers between -3.4E38 and 1.2E38.
- DOUBLE— Fractional numbers between -2.2E308 and 1.8E308.
- SHORT— Whole numbers between -32,768 and 32,767.
- LONG— Whole numbers between -2,147,483,648 and 2,147,483,647.
- DATE—Date and/or time.
- BLOB—Long sequence of binary numbers. You need a custom loader or viewer or a third-party application to load items into a BLOB field or view the contents of a BLOB field.
- RASTER—Raster images. All ArcGIS software-supported raster dataset formats can be stored, but it is highly recommended that only small images be used.
- GUID—Globally unique identifier.
6. New Field Length (optional)
The new length of the
field. This sets the maximum number of allowable characters for each record of
the field. This option is only applicable to fields of type TEXT or BLOB. It is
also only applicable if the table is empty.
7. New Field IsNullable (optional)
Specifies whether the field can contain null values. Null values are only supported for fields in a geodatabase. This option is only applicable if the table is empty (does not contain records).
- Checked—The field will allow null values. This is the default.
- Unchecked—The field will not allow null values.
8. Clear Alias (optional)
Specifies whether the alias for the input field will be cleared. The field alias parameter must be empty to clear the alias of the field.
- Checked—The field alias will be cleared (set to null). The field alias parameter must be empty.
- Unchecked—The field alias will not be cleared. This is the default.
Assign Default to Field
How to Assign Default to Field Tool in ArcToolbox ArcMap ArcGIS??
Assign Default to Field |
Path to access the tool
:
Assign
Default to Field Tool, Fields Toolset, Data Management Tools Toolbox
Assign Default to Field
This tool will create a
default value for a specified field. Whenever a new row is added to the table
or feature class, the specified field will be set to this default value.
1. Input Table
The input table or
feature class that will have a default value added to one of its fields.
2. Field Name
The field to which the
default value will be added each time a new row is added to the table or
feature class.
3. Default Value (optional)
The default value to be added
to each new table or feature class. The value entered must match the data type
of the field.
4. Subtype (optional)
The subtypes that can
participate in the default value.
5. Clear Value (optional)
Specifies whether to clear the default value for either the field or the subtype. The Default Value parameter must be empty to clear the default value of the field. To clear the default value for the subtype, leave the default value parameter empty and specify the subtype to be cleared.
- Checked—The default value will be cleared (set to null). The default value parameter must be empty.
- Unchecked—The default value will not be cleared. This is the default.
Comments
Post a Comment