添加日期属性 (犯罪分析和安全工具)

汇总

添加包含输入日期字段中的日期或时间属性的字段，例如星期全名、日、月和年。

用法

当现有字段名称与定义的输出字段名称值相同时，将在输入表值中覆盖现有字段。
在日期字段参数值更新之后，新字段的值不会自动更新。在更新日期字段参数之后运行此工具。

参数

Dialog
Python

标注	说明	数据类型
输入表	包含待提取日期值的字段所在的图层或表。	Table View
日期字段	将从中提取数据和时间属性以填充新字段值的日期字段。	Field
日期属性	将添加到输入表的日期和时间属性以及字段。值表列： Output Time Format—The date or time property that will be added to the output field name. Day Full Name—The full name of the day of the week, for example, Wednesday. Hour—The hour value between 0 and 23. Month—The month value between 1 and 12. Day of the Month—The day of the month value between 1 and 31. Year—The year value in yyyy format, for example, 1983. Day Numeric Value—The day of the week value between 1 and 7. Output Field Name—The name of the field that will be added to the input table.	Value Table

标注

说明

数据类型

输入表

包含待提取日期值的字段所在的图层或表。

Table View

日期字段

将从中提取数据和时间属性以填充新字段值的日期字段。

Field

日期属性

将添加到输入表的日期和时间属性以及字段。

值表列：

Output Time Format—The date or time property that will be added to the output field name.
- Day Full Name—The full name of the day of the week, for example, Wednesday.
- Hour—The hour value between 0 and 23.
- Month—The month value between 1 and 12.
- Day of the Month—The day of the month value between 1 and 31.
- Year—The year value in yyyy format, for example, 1983.
- Day Numeric Value—The day of the week value between 1 and 7.
Output Field Name—The name of the field that will be added to the input table.

Value Table

派生输出

标注	说明	数据类型
更新的输入表	包含日期属性的已更新输入表。	Table View

arcpy.ca.AddDateAttributes(in_table, date_field, date_attributes)

名称说明数据类型

名称	说明	数据类型
in_table	包含待提取日期值的字段所在的图层或表。	Table View
date_field	将从中提取数据和时间属性以填充新字段值的日期字段。	Field
date_attributes [date_attributes,...]	将添加到输入表的日期和时间属性以及字段。值表列： `Output Time Format`—The date or time property that will be added to the output field name. `DAY_FULL_NAME`—The full name of the day of the week, for example, Wednesday. `HOUR`—The hour value between 0 and 23. `MONTH`—The month value between 1 and 12. `DAY_OF_MONTH`—The day of the month value between 1 and 31. `YEAR`—The year value in yyyy format, for example, 1983. `DAY_OF_WEEK`—The day of the week value between 1 and 7. `Output Field Name`—The name of the field that will be added to the input table.	Value Table

in_table

包含待提取日期值的字段所在的图层或表。

Table View

date_field

将从中提取数据和时间属性以填充新字段值的日期字段。

Field

date_attributes [date_attributes,...]

将添加到输入表的日期和时间属性以及字段。

值表列：

Output Time Format—The date or time property that will be added to the output field name.
- DAY_FULL_NAME—The full name of the day of the week, for example, Wednesday.
- HOUR—The hour value between 0 and 23.
- MONTH—The month value between 1 and 12.
- DAY_OF_MONTH—The day of the month value between 1 and 31.
- YEAR—The year value in yyyy format, for example, 1983.
- DAY_OF_WEEK—The day of the week value between 1 and 7.
Output Field Name—The name of the field that will be added to the input table.

Value Table

派生输出

名称	说明	数据类型
out_table	包含日期属性的已更新输入表。	Table View

代码示例

AddDateAttributes 示例 1（Python 窗口）

以下 Python 窗口脚本演示了如何在即时模式下使用 AddDateAttributes 函数。

import arcpy
arcpy.env.workspace = r"C:\data\city_pd.gdb"
arcpy.ca.AddDateAttributes("CallsForService", "CALLDATE")

AddDateAttributes 示例 2（独立脚本）

以下 Python 脚本演示了如何在独立脚本中使用 AddDateAttributes 函数。

# Name: AddDateAttributes.py
# Description: Add fields for hour, day full name, month, day of the month,
#              and year to the calls for service data based on the call date
#              field.

# Import system modules
import arcpy

# Set environment settings
arcpy.env.workspace = r"C:/data/city_pd.gdb"

# Set local variables
in_features = "CallsForService"
date_field = "CALLDATE"

# Customize the name of output date attribute fields
# ["Output Time Format", "Output Field Name"]
day_name_field = ["DAY_FULL_NAME", "CALL_DAYOFWEEK"]
day_week_field = ["DAY_OF_WEEK", "CALL_DAYNUM"]
hour_field = ["HOUR", "CALL_HOUR"]
month_field = ["MONTH", "CALL_MONTH"]
day_num_field = ["DAY_OF_MONTH", "CALL_DAY"]
year_field = ["YEAR", "CALL_YEAR"]

date_attributes = [day_name_field, day_week_field, hour_field, month_field, day_num_field,
                   year_field]

# Run AddDateAttributes
arcpy.ca.AddDateAttributes(in_features, date_field, date_attributes)

环境

当前工作空间, 范围

许可信息

基本: 是
标准: 是
高级: 是

添加日期属性 (犯罪分析和安全工具)

汇总

用法

参数

派生输出

环境

许可信息

相关主题