Make Query Table Tool
أداة إنشاء جدول استعلام
ArcMap ArcGIS
How to Make Query Table Tool in ArcToolbox ArcMap ArcGIS??
كيفية استخدام أداة إنشاء جدول إستعلامArcToolbox ArcMap
ArcGIS ؟؟
Path
to access the toolمسار الوصول الى الأداة
:
Make
Query Table Tool, Layers and Table Views Toolset, Data Management Tools Toolbox
Make Query Table
This tool applies an SQL
query to a database, and the results are represented in a layer or table view.
The query can be used to join several tables or return a subset of fields or
rows from the original data in the database.
This tool accepts data
from a geodatabase or database connection.
تطبق هذه الأداة استعلام SQL على
قاعدة بيانات ، ويتم تمثيل النتائج في طريقة عرض طبقة أو جدول. يمكن استخدام
الاستعلام لربط عدة جداول أو إرجاع مجموعة فرعية من الحقول أو الصفوف من البيانات
الأصلية في قاعدة البيانات.
تقبل هذه الأداة البيانات من قاعدة بيانات جغرافية
أو اتصال قاعدة بيانات.
Input
Tables
The name of the table or tables to be used in the query. If several tables
are listed, the Expression parameter can be used to define how they are to be
joined.
The input table can be from a geodatabase or a database connection.
Fields
(optional)
The fields to include in the layer or table view. If an alias is set for a
field, this is the name that appears. If no fields are specified, all fields
from all tables are included. If a Shape field is added to the field list, the
result is a layer; otherwise it is a table view.
Expression
(optional)
An SQL expression used to select a subset of records.
Table Name
The name of the layer or table view that will be created by the tool.
Key Field
Options
Layers and table views in ArcGIS require an ObjectID field. An ObjectID
field is an integer field used to uniquely identify rows in the data being
used. In this tool, this parameter is used to indicate how an ObjectID field
will be generated (if at all) for the query. The default is Use key fields
(USE_KEY_FIELDS in Python).
· USE_KEY_FIELDS—This indicates that the fields chosen in the Key Fields
parameter can be used to uniquely identify a row in the output table. This can
be a single field or a combination of multiple fields, which, when combined,
uniquely identify a row in the output table. If there are no fields chosen in
the key fields list, the Generate a key field option (ADD VIRTUAL_KEY_FIELD in
Python) is automatically applied.
· ADD_VIRTUAL_KEY_FIELD—If no key fields have been specified, you can choose
this option to have an ObjectID generated that uniquely identifies each row in
the output table.
· NO_KEY_FIELD—This option indicates that no ObjectID field is to be
generated. Choosing this option means that selections will not be supported for
the table view.
If there is already a field of type
ObjectID in the fields list, it will be used as the ObjectID even if this
option is chosen.
Key Fields
(optional)
Specifies a field or combination of fields that can be used to uniquely
identify a row in the query. This parameter is used only when the Use Key
Fields option is set.
The Add Field button, which is used only in ModelBuilder, allows you to
add expected fields so you can complete the dialog box and continue to build
your model.
1.
Input Tables جداول الإدخال
The name of the table or
tables to be used in the query. If several tables are listed, the Expression
parameter can be used to define how they are to be joined.
The input table can be
from a geodatabase or a database connection.
اسم الجدول أو الجداول التي سيتم استخدامها في
الاستعلام. إذا تم سرد عدة جداول ، يمكن استخدام معلمة تعبير لتحديد كيفية ضمها.
يمكن أن يكون جدول الإدخال من قاعدة بيانات
جغرافية أو اتصال قاعدة بيانات.
Fields
(optional)
The fields to include in the layer or table view. If an alias is set for a
field, this is the name that appears. If no fields are specified, all fields
from all tables are included. If a Shape field is added to the field list, the result
is a layer; otherwise it is a table view.
Expression
(optional)
An SQL expression used to select a subset of records.
Table Name
The name of the layer or table view that will be created by the tool.
Key Field
Options
Layers and table views in ArcGIS require an ObjectID field. An ObjectID
field is an integer field used to uniquely identify rows in the data being
used. In this tool, this parameter is used to indicate how an ObjectID field
will be generated (if at all) for the query. The default is Use key fields
(USE_KEY_FIELDS in Python).
· USE_KEY_FIELDS—This indicates that the fields chosen in the Key Fields
parameter can be used to uniquely identify a row in the output table. This can
be a single field or a combination of multiple fields, which, when combined,
uniquely identify a row in the output table. If there are no fields chosen in
the key fields list, the Generate a key field option (ADD VIRTUAL_KEY_FIELD in
Python) is automatically applied.
· ADD_VIRTUAL_KEY_FIELD—If no key fields have been specified, you can choose
this option to have an ObjectID generated that uniquely identifies each row in
the output table.
· NO_KEY_FIELD—This option indicates that no ObjectID field is to be
generated. Choosing this option means that selections will not be supported for
the table view.
If there is already a field of type
ObjectID in the fields list, it will be used as the ObjectID even if this
option is chosen.
Key Fields
(optional)
Specifies a field or combination of fields that can be used to uniquely
identify a row in the query. This parameter is used only when the Use Key
Fields option is set.
The Add Field button, which is used only in ModelBuilder, allows you to
add expected fields so you can complete the dialog box and continue to build
your model.
2.
Fields (optional) حقول (اختياري)
The fields to include in
the layer or table view. If an alias is set for a field, this is the name that
appears. If no fields are specified, all fields from all tables are included.
If a Shape field is added to the field list, the result is a layer; otherwise
it is a table view.
الحقول المراد تضمينها في عرض الطبقة أو الجدول.
إذا تم تعيين اسم مستعار للحقل ، فسيكون هذا هو الاسم الذي يظهر. إذا لم يتم تحديد
أي حقول ، فسيتم تضمين كافة الحقول من كافة الجداول. إذا تمت إضافة حقل الشكل إلى
قائمة الحقول ، تكون النتيجة طبقة ؛ وإلا فهو عرض الجدول.
Expression
(optional)
An SQL expression used to select a subset of records.
Table Name
The name of the layer or table view that will be created by the tool.
Key Field
Options
Layers and table views in ArcGIS require an ObjectID field. An ObjectID
field is an integer field used to uniquely identify rows in the data being
used. In this tool, this parameter is used to indicate how an ObjectID field
will be generated (if at all) for the query. The default is Use key fields
(USE_KEY_FIELDS in Python).
· USE_KEY_FIELDS—This indicates that the fields chosen in the Key Fields
parameter can be used to uniquely identify a row in the output table. This can
be a single field or a combination of multiple fields, which, when combined,
uniquely identify a row in the output table. If there are no fields chosen in
the key fields list, the Generate a key field option (ADD VIRTUAL_KEY_FIELD in
Python) is automatically applied.
· ADD_VIRTUAL_KEY_FIELD—If no key fields have been specified, you can choose
this option to have an ObjectID generated that uniquely identifies each row in
the output table.
· NO_KEY_FIELD—This option indicates that no ObjectID field is to be
generated. Choosing this option means that selections will not be supported for
the table view.
If there is already a field of type
ObjectID in the fields list, it will be used as the ObjectID even if this
option is chosen.
Key Fields
(optional)
Specifies a field or combination of fields that can be used to uniquely
identify a row in the query. This parameter is used only when the Use Key
Fields option is set.
The Add Field button, which is used only in ModelBuilder, allows you to
add expected fields so you can complete the dialog box and continue to build
your model.
3.
Expression (optional) تعبير
(اختياري)
An SQL expression used
to select a subset of records.
تعبير SQL
يستخدم لتحديد مجموعة فرعية من السجلات.
Table Name
The name of the layer or table view that will be created by the tool.
Key Field
Options
Layers and table views in ArcGIS require an ObjectID field. An ObjectID
field is an integer field used to uniquely identify rows in the data being
used. In this tool, this parameter is used to indicate how an ObjectID field
will be generated (if at all) for the query. The default is Use key fields (USE_KEY_FIELDS
in Python).
· USE_KEY_FIELDS—This indicates that the fields chosen in the Key Fields
parameter can be used to uniquely identify a row in the output table. This can
be a single field or a combination of multiple fields, which, when combined,
uniquely identify a row in the output table. If there are no fields chosen in
the key fields list, the Generate a key field option (ADD VIRTUAL_KEY_FIELD in
Python) is automatically applied.
· ADD_VIRTUAL_KEY_FIELD—If no key fields have been specified, you can choose
this option to have an ObjectID generated that uniquely identifies each row in
the output table.
· NO_KEY_FIELD—This option indicates that no ObjectID field is to be
generated. Choosing this option means that selections will not be supported for
the table view.
If there is already a field of type
ObjectID in the fields list, it will be used as the ObjectID even if this
option is chosen.
Key Fields
(optional)
Specifies a field or combination of fields that can be used to uniquely
identify a row in the query. This parameter is used only when the Use Key
Fields option is set.
The Add Field button, which is used only in ModelBuilder, allows you to
add expected fields so you can complete the dialog box and continue to build
your model.
4.
Table Name اسم الجدول
The name of the layer or
table view that will be created by the tool.
اسم عرض الطبقة أو الجدول الذي سيتم إنشاؤه بواسطة
الأداة.
Key Field
Options
Layers and table views in ArcGIS require an ObjectID field. An ObjectID
field is an integer field used to uniquely identify rows in the data being
used. In this tool, this parameter is used to indicate how an ObjectID field
will be generated (if at all) for the query. The default is Use key fields
(USE_KEY_FIELDS in Python).
· USE_KEY_FIELDS—This indicates that the fields chosen in the Key Fields
parameter can be used to uniquely identify a row in the output table. This can
be a single field or a combination of multiple fields, which, when combined,
uniquely identify a row in the output table. If there are no fields chosen in
the key fields list, the Generate a key field option (ADD VIRTUAL_KEY_FIELD in
Python) is automatically applied.
· ADD_VIRTUAL_KEY_FIELD—If no key fields have been specified, you can choose
this option to have an ObjectID generated that uniquely identifies each row in
the output table.
· NO_KEY_FIELD—This option indicates that no ObjectID field is to be
generated. Choosing this option means that selections will not be supported for
the table view.
If there is already a field of type
ObjectID in the fields list, it will be used as the ObjectID even if this
option is chosen.
Key Fields
(optional)
Specifies a field or combination of fields that can be used to uniquely
identify a row in the query. This parameter is used only when the Use Key
Fields option is set.
The Add Field button, which is used only in ModelBuilder, allows you to
add expected fields so you can complete the dialog box and continue to build
your model.
5.
Key Field Options خيارات الحقول
الرئيسية
Layers and table views
in ArcGIS require an ObjectID field. An ObjectID field is an integer field used
to uniquely identify rows in the data being used. In this tool, this parameter
is used to indicate how an ObjectID field will be generated (if at all) for the
query. The default is Use key fields (USE_KEY_FIELDS in Python).
·
USE_KEY_FIELDS—This indicates that the fields chosen in the Key
Fields parameter can be used to uniquely identify a row in the output table.
This can be a single field or a combination of multiple fields, which, when
combined, uniquely identify a row in the output table. If there are no fields
chosen in the key fields list, the Generate a key field option (ADD
VIRTUAL_KEY_FIELD in Python) is automatically applied.
·
ADD_VIRTUAL_KEY_FIELD—If no key fields have been specified, you
can choose this option to have an ObjectID generated that uniquely identifies
each row in the output table.
·
NO_KEY_FIELD—This option indicates that no ObjectID field is to be
generated. Choosing this option means that selections will not be supported for
the table view.
If there is already a field of type ObjectID in the fields list,
it will be used as the ObjectID even if this option is chosen.
تتطلب عروض الطبقات والجداول في ArcGIS حقل ObjectID. حقل ObjectID هو حقل عدد صحيح يستخدم
لتعريف الصفوف في البيانات المستخدمة بشكل فريد. في هذه الأداة ، يتم استخدام هذه
المعلمة للإشارة إلى كيفية إنشاء حقل معرف الكائن (إن وجد) للاستعلام. الافتراضي
هو استخدام الحقول الرئيسية (USE_KEY_FIELDS في Python).
• USE_KEY_FIELDS - يشير هذا إلى أن الحقول المختارة في معلمة Key Fields يمكن استخدامها لتعريف صف في جدول الإخراج بشكل فريد. يمكن أن
يكون هذا حقلاً منفردًا أو مجموعة من الحقول المتعددة ، والتي عند دمجها تحدد صفًا
في جدول الإخراج بشكل فريد. إذا لم يتم اختيار حقول في قائمة الحقول الرئيسية ،
فسيتم تطبيق خيار إنشاء حقل مفتاح (إضافة VIRTUAL_KEY_FIELD في Python)
تلقائيًا.
• ADD_VIRTUAL_KEY_FIELD - إذا لم يتم تحديد حقول مفتاح ، يمكنك اختيار هذا الخيار لإنشاء
معرف كائن يحدد بشكل فريد كل صف في جدول الإخراج.
• NO_KEY_FIELD - يشير هذا الخيار إلى عدم إنشاء حقل معرف الكائن. اختيار هذا
الخيار يعني أن التحديدات لن يتم دعمها لطريقة عرض الجدول.
إذا كان هناك بالفعل حقل من النوع ObjectID في قائمة الحقول ، فسيتم استخدامه كـ ObjectID حتى إذا تم اختيار هذا الخيار.
Key Fields
(optional)
Specifies a field or combination of fields that can be used to uniquely
identify a row in the query. This parameter is used only when the Use Key
Fields option is set.
The Add Field button, which is used only in ModelBuilder, allows you to
add expected fields so you can complete the dialog box and continue to build
your model.
6.
Key Fields (optional) الحقول
الرئيسية (اختياري)
Specifies a field or
combination of fields that can be used to uniquely identify a row in the query.
This parameter is used only when the Use Key Fields option is set.
The Add Field button,
which is used only in ModelBuilder, allows you to add expected fields so you
can complete the dialog box and continue to build your model.
يحدد حقلاً أو مجموعة من الحقول التي يمكن
استخدامها لتعريف صف في الاستعلام بشكل فريد. يتم استخدام هذه المعلمة فقط عند
تعيين خيار استخدام الحقول الرئيسية.
يسمح لك الزر "إضافة حقل" ، والذي
يُستخدم فقط في ModelBuilder ، بإضافة الحقول
المتوقعة حتى تتمكن من إكمال مربع الحوار والاستمرار في بناء النموذج الخاص بك.
اليك صفحه ومجموعة على الفيس بوك لتعلم أكثر بما يخص نظم المعلومات الجغرافية (GIS) و برنامج ArcGIS Pro من خلال هذه الروابط:
مجموعة على الفيس بوك
ArcGIS Pro من
هنا.
مجموعة على الفيس بوك
GIS for WE - ArcGIS Pro من
هنا.صفحة الفيس بوك
GIS for WE من
هنا.
تعليقات
إرسال تعليق