ArcGIS for Desktop

  • ドキュメント
  • 価格
  • サポート

  • My Profile
  • ヘルプ
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

組織のマッピング プラットフォーム

ArcGIS for Desktop

完全なプロ仕様の GIS

ArcGIS for Server

エンタープライズ GIS

ArcGIS for Developers

位置情報利用アプリの開発ツール

ArcGIS Solutions

各種業界向けの無料のテンプレート マップおよびテンプレート アプリケーション

ArcGIS Marketplace

組織で使えるアプリとデータを取得

  • ドキュメント
  • 価格
  • サポート
Esri
  • サイン イン
user
  • マイ プロフィール
  • サイン アウト

Help

  • ホーム
  • はじめに
  • マップ
  • 解析
  • データ管理
  • ツール
  • その他...

TableView

  • サマリ
  • 説明
  • 構文
  • 特性
  • メソッドの概要
  • メソッド
  • コードのサンプル

サマリ

Provides access to basic table properties.

説明

The TableView object is essential for managing stand-alone tables that reside within a map document (.mxd). It provides access to basic table properties such as data source information and setting a table's definition query. In addition to the TableView constructor function, the ListTableViews function also provides the ability to reference a TableView object.

The TableView constructor function allows you to reference a table outside of a map document within a workspace. This provides the ability to add an external table into a map document using the AddTableView function. This function is similar to MakeTableView, but the difference is that the result from MakeTableView can't be added permanently into a map document.

The ListTableViews function returns a Python list of TableView objects. It is necessary to then iterate through each item in the list or specify an index number to reference a specific TableView object. Tables can be searched within an entire map document or within a specific data frame. Wildcards can also be used to limit the search.

A definition query will not work for all workspaces. It is important to use the correct SQL syntax when working with different workspaces. For example, file geodatabases and shapefiles have double quotes around a field name (for example, "field_name"), personal geodatabases have brackets (for example, [field_name]), and SDE connections don't have any special characters (for example, field_name). For more information on updating workspaces and data sources in a map document or layer file, please refer to the Updating and Fixing Data Sources with arcpy.mapping help topic.

Tables can be removed from a map document using the RemoveTableView function.

構文

 TableView (table_view_data_source)
パラメータ説明データ タイプ
table_view_data_source

A string that includes the full workspace path, including the name of the table.

String

特性

プロパティ説明データ タイプ
datasetName
(読み取り専用)

Returns the name of the table's dataset the way it appears in the workspace, not in the table of contents.

String
dataSource
(読み取り専用)

Returns table's data source path. It includes the workspacePath and the datasetName combined.

String
definitionQuery
(読み書き)

Provides the ability to get or set a tables's definition query.

String
name
(読み書き)

Provides the ability to set or get the name of a table the way it would appear in the ArcMap table of contents. Spaces can be included.

String
isBroken
(読み取り専用)

Returns True if a table's data source is broken.

Boolean
workspacePath
(読み取り専用)

Returns a path to the table's workspace or connection file.

String

メソッドの概要

メソッド説明
findAndReplaceWorkspacePath (find_workspace_path, replace_workspace_path, {validate})

Replaces a table's workspace with a new workspace path

getSelectionSet ()

Returns a table's selection as a Python set of Object IDs.

replaceDataSource (workspace_path, workspace_type, {dataset_name}, {validate})

Replaces a table's data source in a map document (.mxd); also provides the ability to switch workspace types (for example, replace a file geodatabase workspace with an SDE workspace).

setSelectionSet (method, oidList)

Sets a table's selection using a Python set of Object IDs.

メソッド

findAndReplaceWorkspacePath (find_workspace_path, replace_workspace_path, {validate})
パラメータ説明データ タイプ
find_workspace_path

A string that represents the workspace path or connection file you want to find. If an empty string is passed, then all workspace paths will be replaced with the replace_workspace_path parameter depending on the value of the validate parameter.

String
replace_workspace_path

A string that represents the workspace path or connection file you want to use to replace.

String
validate

If set to True, the workspace will only be updated if the replace_workspace_path value is a valid workspace. If it is not valid, the workspace will not be replaced. If set to False, the method will set the workspace to match the replace_workspace_path, regardless of a valid match. In this case, if a match does not exist, then the table's data source would be broken.

(デフォルト値は次のとおりです True)

Boolean

For more detailed discussion, parameter information, scenarios, and code samples, please refer to the Updating and fixing data sources help topic.

getSelectionSet ()

戻り値

データ タイプ説明
List

Returns a table's selection as a Python set of Object IDs.

Provides an easy way to retrieve the table's current selection.

replaceDataSource (workspace_path, workspace_type, {dataset_name}, {validate})
パラメータ説明データ タイプ
workspace_path

A string that includes the workspace path to the new data or connection file.

String
workspace_type

A string keyword that represents the workspace type of the new data.

  • ACCESS_WORKSPACE — A personal geodatabase or Access workspace
  • ARCINFO_WORKSPACE — An ArcInfo coverage workspace
  • CAD_WORKSPACE —A CAD file workspace
  • EXCEL_WORKSPACE —An Excel file workspace
  • FILEGDB_WORKSPACE —A file geodatabase workspace
  • NONE —Used to skip the parameter
  • OLEDB_WORKSPACE —An OLE database workspace
  • PCCOVERAGE_WORKSPACE —A PC ARC/INFO Coverage workspace
  • RASTER_WORKSPACE —A raster workspace
  • SDE_WORKSPACE —An SDE geodatabase workspace
  • SHAPEFILE_WORKSPACE —A shapefile workspace
  • TEXT_WORKSPACE —A text file workspace
  • TIN_WORKSPACE —A TIN workspace
  • VPF_WORKSPACE —A VPF workspace
String
dataset_name

A string that represents the name of the table the way it appears in the new workspace (not the name of the table in the table of contents). If dataset_name is not provided, the replaceDataSource method will attempt to replace the dataset by finding a table with a the same name as the layer's current dataset property.

String
validate

If set to True, a workspace will only be updated if the workspace_path value is a valid workspace. If it is not valid, the workspace will not be replaced. If set to False, the method will set the workspace to match the workspace_path, regardless of a valid match. In this case, if a match does not exist, then the data source would be broken.

(デフォルト値は次のとおりです True)

Boolean

For more detailed discussion, parameter information, scenarios, and code samples, please refer to the Updating and Fixing Data Sources help topic.

setSelectionSet (method, oidList)
パラメータ説明データ タイプ
method

A string that specifies which selection method to use.

  • NEW —Creates a new record selection from the oidList.
  • DIFFERENCE —Selects the records that are not in the current selection but are in the oidList.
  • INTERSECT —Selects the records that are in the current selection and the oidList.
  • SYMDIFFERENCE —Selects the records that are in the current selection or the oidList but not both.
  • UNION —Selects all the records in both the current selection and those in the oidList.

(デフォルト値は次のとおりです None)

String
oidList

A Python set of object IDs to use along with the appropriate selection method.

Integer

This method provides an easy way to manage a table's selection. To clear the selection, use the NEW selection method with an empty set. Python Sets or Lists can be used for the oidList, but sets get returned from the getSelectionSet method on the Table object.

コードのサンプル

TableView example 1

The following script will find a table called Customers in a data frame named Transportation and will set its definition query.

import arcpy
mxd = arcpy.mapping.MapDocument(r"C:\Project\Project.mxd")
df = arcpy.mapping.ListDataFrames(mxd, "Transportation")[0]
for table in arcpy.mapping.ListTableViews(mxd, "", df):
    if table.name.lower() == "trafficaccidents":
        table.definitionQuery = "\"age\" >= 18"
mxd.save()
del mxd
TableView example 2

The following script will reference a table in a file geodatabase and then add that table into the referenced map document.

import arcpy
mxd = arcpy.mapping.MapDocument(r"C:\Project\Project.mxd")
df = arcpy.mapping.ListDataFrames(mxd, "Transportation")[0]
accidentsTable = arcpy.mapping.TableView(r"C:\Project\Data\Transportation.gdb\Accidents")
arcpy.mapping.AddTableView(df, accidentsTable)
mxd.saveACopy(r"C:\Project\Project2.mxd")
del mxd, accidentsTable
このトピックへのフィードバック

ArcGIS for Desktop

  • ホーム
  • ドキュメント
  • 価格
  • サポート

ArcGIS プラットフォーム

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

Esri について

  • 会社概要
  • 採用情報
  • スタッフ ブログ
  • ユーザ カンファレンス
  • デベロッパ サミット
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | プライバシー | リーガル