Make Query Layer Tool
أداة إنشاء طبقة استعلام
ArcMap ArcGIS
How to Make Query Layer Tool in ArcToolbox ArcMap ArcGIS??
كيفية استخدام أداة إنشاء طبقة إستعلامArcToolbox ArcMap
ArcGIS ؟؟
Path
to access the toolمسار الوصول الى الأداة
:
Make
Query Layer Tool, Layers and Table Views Toolset, Data Management Tools Toolbox
Make Query Layer
Creates a query layer
from a DBMS table based on an input SQL select statement.
ينشئ طبقة استعلام من جدول DBMS بناءً
على جملة تحديد إدخال SQL.
1.
Input Database Connection إدخال
اتصال قاعدة البيانات
The database connection
file that contains the data to be queried.
ملف اتصال قاعدة البيانات الذي يحتوي على البيانات
المطلوب الاستعلام عنها.
Output
Layer Name
The output name of the feature layer or table view to be created.
Query
The SQL statement that defines the select query to be executed in the
database.
This string must pass validation before remaining controls will be enabled.
Validation will be triggered when you click outside this input box. The
validation process executes the query in the database and verifies whether the
result of the SQL query meets the data modeling standards enforced by ArcGIS.
If the validation fails, the tool will return a warning. The only exception is
for Model Builder, in which case validation will not be triggered if the input
is derived data.
Rules for validation are as follows:
· The result of the SQL query must have only one spatial field.
· The result of the SQL query must have only one spatial reference.
· The result of the SQL query must have only one entity type, such as point,
multipoint, line, or polygon.
· The result of the SQL query cannot have any field types not supported by
ArcGIS; ArcGIS field data types describes the field types supported in ArcGIS.
Validation is especially important when working with data in spatial
databases that do not enforce the same standards as ArcGIS.
Unique
Identifier Field(s) (optional)
One or more fields from the SELECT statement SELECT list that will
generate a dynamic, unique row identifier.
Shape Type
(optional)
Specifies the shape type of the query layer. Only those records from the
result set of the query that match the specified shape type will be used in the
output query layer. Tool validation will attempt to set this property based on
the first record in the result set. This can be changed before executing the
tool if it is not the desired output shape type. This parameter is ignored if
the result set of the query does not return a geometry field.
· POINT—The output query layer will use point geometry.
· MULTIPOINT—The output query layer will use multipoint geometry.
· POLYGON—The output query layer will use polygon geometry.
· POLYLINE—The output query layer will use polyline geometry.
SRID
(optional)
The spatial reference identifier (SRID) value for queries that return
geometry. Only those records from the result set of the query that match the
specified SRID value will be used in the output query layer. Tool validation
will attempt to set this property based on the first record in the result set.
This can be changed before executing the tool if it is not the desired output
SRID value. This parameter is ignored if the result set of the query does not
return a geometry field.
Coordinate
System (optional)
The coordinate system that will be used by the output query layer. Tool
validation will attempt to set this property based on the first record in the
result set. This can be changed before executing the tool if it is not the
desired output coordinate system. This parameter is ignored if the result set
of the query does not return a geometry field.
2.
Output Layer Name اسم طبقة الإخراج
The output name of the
feature layer or table view to be created.
اسم الإخراج لطبقة المعالم أو عرض الجدول الذي
سيتم إنشاؤه.
Query
The SQL statement that defines the select query to be executed in the
database.
This string must pass validation before remaining controls will be
enabled. Validation will be triggered when you click outside this input box.
The validation process executes the query in the database and verifies whether
the result of the SQL query meets the data modeling standards enforced by
ArcGIS. If the validation fails, the tool will return a warning. The only
exception is for Model Builder, in which case validation will not be triggered
if the input is derived data.
Rules for validation are as follows:
· The result of the SQL query must have only one spatial field.
· The result of the SQL query must have only one spatial reference.
· The result of the SQL query must have only one entity type, such as point,
multipoint, line, or polygon.
· The result of the SQL query cannot have any field types not supported by
ArcGIS; ArcGIS field data types describes the field types supported in ArcGIS.
Validation is especially important when working with data in spatial
databases that do not enforce the same standards as ArcGIS.
Unique
Identifier Field(s) (optional)
One or more fields from the SELECT statement SELECT list that will
generate a dynamic, unique row identifier.
Shape Type
(optional)
Specifies the shape type of the query layer. Only those records from the
result set of the query that match the specified shape type will be used in the
output query layer. Tool validation will attempt to set this property based on
the first record in the result set. This can be changed before executing the
tool if it is not the desired output shape type. This parameter is ignored if
the result set of the query does not return a geometry field.
· POINT—The output query layer will use point geometry.
· MULTIPOINT—The output query layer will use multipoint geometry.
· POLYGON—The output query layer will use polygon geometry.
· POLYLINE—The output query layer will use polyline geometry.
SRID
(optional)
The spatial reference identifier (SRID) value for queries that return
geometry. Only those records from the result set of the query that match the
specified SRID value will be used in the output query layer. Tool validation
will attempt to set this property based on the first record in the result set.
This can be changed before executing the tool if it is not the desired output
SRID value. This parameter is ignored if the result set of the query does not
return a geometry field.
Coordinate
System (optional)
The coordinate system that will be used by the output query layer. Tool
validation will attempt to set this property based on the first record in the
result set. This can be changed before executing the tool if it is not the
desired output coordinate system. This parameter is ignored if the result set
of the query does not return a geometry field.
3.
Query استعلام
The SQL statement that defines
the select query to be executed in the database.
This string must pass
validation before remaining controls will be enabled. Validation will be
triggered when you click outside this input box. The validation process
executes the query in the database and verifies whether the result of the SQL
query meets the data modeling standards enforced by ArcGIS. If the validation
fails, the tool will return a warning. The only exception is for Model Builder,
in which case validation will not be triggered if the input is derived data.
Rules for validation are
as follows:
·
The result of the SQL query must have only one spatial field.
·
The result of the SQL query must have only one spatial reference.
·
The result of the SQL query must have only one entity type, such
as point, multipoint, line, or polygon.
·
The result of the SQL query cannot have any field types not
supported by ArcGIS; ArcGIS field data types describes the field types
supported in ArcGIS.
Validation is especially
important when working with data in spatial databases that do not enforce the
same standards as ArcGIS.
عبارة SQL التي
تحدد استعلام التحديد الذي سيتم تنفيذه في قاعدة البيانات.
يجب أن تجتاز هذه السلسلة عملية التحقق قبل تمكين
عناصر التحكم المتبقية. سيتم تشغيل التحقق من الصحة عند النقر خارج مربع الإدخال
هذا. تقوم عملية التحقق من الصحة بتنفيذ الاستعلام في قاعدة البيانات والتحقق مما
إذا كانت نتيجة استعلام SQL تفي بمعايير نمذجة
البيانات التي يتم فرضها بواسطة ArcGIS. إذا
فشل التحقق من الصحة ، ستعيد الأداة تحذيرًا. الاستثناء الوحيد هو Model Builder ، وفي هذه الحالة لن يتم تشغيل التحقق إذا كان الإدخال هو بيانات
مشتقة.
قواعد التحقق من الصحة هي كما يلي:
• يجب أن تحتوي نتيجة استعلام
SQL على حقل مكاني واحد فقط.
• يجب أن تحتوي نتيجة
استعلام SQL على مرجع مكاني واحد فقط.
• يجب أن تحتوي نتيجة
استعلام SQL على نوع كيان واحد فقط ، مثل نقطة أو متعدد النقاط أو خط أو مضلع.
• لا يمكن أن تحتوي نتيجة
استعلام SQL على أي أنواع حقول غير مدعومة بواسطة ArcGIS ؛ تصف
أنواع بيانات حقل ArcGIS أنواع الحقول المدعومة
في ArcGIS.
يعد التحقق من الصحة مهمًا بشكل خاص عند العمل مع
البيانات في قواعد البيانات المكانية التي لا تفرض نفس معايير ArcGIS.
Unique
Identifier Field(s) (optional)
One or more fields from the SELECT statement SELECT list that will
generate a dynamic, unique row identifier.
Shape Type
(optional)
Specifies the shape type of the query layer. Only those records from the
result set of the query that match the specified shape type will be used in the
output query layer. Tool validation will attempt to set this property based on
the first record in the result set. This can be changed before executing the
tool if it is not the desired output shape type. This parameter is ignored if
the result set of the query does not return a geometry field.
· POINT—The output query layer will use point geometry.
· MULTIPOINT—The output query layer will use multipoint geometry.
· POLYGON—The output query layer will use polygon geometry.
· POLYLINE—The output query layer will use polyline geometry.
SRID
(optional)
The spatial reference identifier (SRID) value for queries that return
geometry. Only those records from the result set of the query that match the
specified SRID value will be used in the output query layer. Tool validation
will attempt to set this property based on the first record in the result set.
This can be changed before executing the tool if it is not the desired output
SRID value. This parameter is ignored if the result set of the query does not
return a geometry field.
Coordinate
System (optional)
The coordinate system that will be used by the output query layer. Tool
validation will attempt to set this property based on the first record in the
result set. This can be changed before executing the tool if it is not the
desired output coordinate system. This parameter is ignored if the result set
of the query does not return a geometry field.
4.
Unique Identifier Field(s) (optional) حقل (حقول) المعرف الفريد (اختياري)
One or more fields from
the SELECT statement SELECT list that will generate a dynamic, unique row
identifier.
حقل واحد أو أكثر من قائمة SELECT عبارة
SELECT التي ستنشئ معرف صف
ديناميكيًا فريدًا.
Shape Type
(optional)
Specifies the shape type of the query layer. Only those records from the
result set of the query that match the specified shape type will be used in the
output query layer. Tool validation will attempt to set this property based on
the first record in the result set. This can be changed before executing the
tool if it is not the desired output shape type. This parameter is ignored if
the result set of the query does not return a geometry field.
· POINT—The output query layer will use point geometry.
· MULTIPOINT—The output query layer will use multipoint geometry.
· POLYGON—The output query layer will use polygon geometry.
· POLYLINE—The output query layer will use polyline geometry.
SRID
(optional)
The spatial reference identifier (SRID) value for queries that return
geometry. Only those records from the result set of the query that match the
specified SRID value will be used in the output query layer. Tool validation
will attempt to set this property based on the first record in the result set.
This can be changed before executing the tool if it is not the desired output
SRID value. This parameter is ignored if the result set of the query does not
return a geometry field.
Coordinate
System (optional)
The coordinate system that will be used by the output query layer. Tool
validation will attempt to set this property based on the first record in the
result set. This can be changed before executing the tool if it is not the
desired output coordinate system. This parameter is ignored if the result set
of the query does not return a geometry field.
5.
Shape Type (optional) نوع الشكل
(اختياري)
Specifies the shape type
of the query layer. Only those records from the result set of the query that
match the specified shape type will be used in the output query layer. Tool
validation will attempt to set this property based on the first record in the
result set. This can be changed before executing the tool if it is not the
desired output shape type. This parameter is ignored if the result set of the
query does not return a geometry field.
·
POINT—The output query layer will use point geometry.
·
MULTIPOINT—The output query layer will use multipoint geometry.
·
POLYGON—The output query layer will use polygon geometry.
·
POLYLINE—The output query layer will use polyline geometry.
يحدد نوع شكل طبقة الاستعلام. سيتم فقط استخدام
تلك السجلات من مجموعة نتائج الاستعلام التي تطابق نوع الشكل المحدد في طبقة
استعلام الإخراج. سيحاول التحقق من صحة الأداة تعيين هذه الخاصية بناءً على السجل
الأول في مجموعة النتائج. يمكن تغيير هذا قبل تنفيذ الأداة إذا لم يكن نوع شكل
الإخراج المطلوب. يتم تجاهل هذه المعلمة إذا لم تُرجع مجموعة نتائج الاستعلام حقل
هندسة.
• POINT - ستستخدم
طبقة استعلام الإخراج هندسة النقاط.
• MULTIPOINT - ستستخدم طبقة استعلام الإخراج هندسة متعددة النقاط.
• POLYGON - ستستخدم طبقة استعلام الإخراج هندسة المضلع.
• POLYLINE - ستستخدم طبقة استعلام الإخراج هندسة الخطوط المتعددة.
SRID
(optional)
The spatial reference identifier (SRID) value for queries that return
geometry. Only those records from the result set of the query that match the
specified SRID value will be used in the output query layer. Tool validation
will attempt to set this property based on the first record in the result set.
This can be changed before executing the tool if it is not the desired output
SRID value. This parameter is ignored if the result set of the query does not
return a geometry field.
Coordinate
System (optional)
The coordinate system that will be used by the output query layer. Tool
validation will attempt to set this property based on the first record in the
result set. This can be changed before executing the tool if it is not the
desired output coordinate system. This parameter is ignored if the result set
of the query does not return a geometry field.
6.
SRID (optional) اختياري
The spatial reference
identifier (SRID) value for queries that return geometry. Only those records
from the result set of the query that match the specified SRID value will be
used in the output query layer. Tool validation will attempt to set this
property based on the first record in the result set. This can be changed
before executing the tool if it is not the desired output SRID value. This parameter
is ignored if the result set of the query does not return a geometry field.
قيمة معرف المرجع المكاني (SRID)
للاستعلامات التي تُرجع الهندسة. سيتم فقط استخدام السجلات من مجموعة نتائج
الاستعلام التي تطابق قيمة SRID
المحددة في طبقة استعلام الإخراج. سيحاول التحقق من صحة الأداة تعيين هذه الخاصية
بناءً على السجل الأول في مجموعة النتائج. يمكن تغيير هذا قبل تنفيذ الأداة إذا لم
تكن قيمة SRID للإخراج المطلوبة. يتم
تجاهل هذه المعلمة إذا لم تُرجع مجموعة نتائج الاستعلام حقل هندسة.
Coordinate
System (optional)
The coordinate system that will be used by the output query layer. Tool
validation will attempt to set this property based on the first record in the
result set. This can be changed before executing the tool if it is not the
desired output coordinate system. This parameter is ignored if the result set
of the query does not return a geometry field.
7.
Coordinate System (optional) نظام
الإحداثيات (اختياري)
The coordinate system
that will be used by the output query layer. Tool validation will attempt to
set this property based on the first record in the result set. This can be
changed before executing the tool if it is not the desired output coordinate
system. This parameter is ignored if the result set of the query does not
return a geometry field.
النظام الإحداثي الذي ستستخدمه طبقة استعلام
الإخراج. سيحاول التحقق من صحة الأداة تعيين هذه الخاصية بناءً على السجل الأول في
مجموعة النتائج. يمكن تغيير هذا قبل تنفيذ الأداة إذا لم تكن هي نظام إحداثيات
الإخراج المطلوب. يتم تجاهل هذه المعلمة إذا لم تُرجع مجموعة نتائج الاستعلام حقل
هندسة.
اليك صفحه ومجموعة على الفيس بوك لتعلم أكثر بما يخص نظم المعلومات الجغرافية (GIS) و برنامج ArcGIS Pro من خلال هذه الروابط:
مجموعة على الفيس بوك
ArcGIS Pro من
هنا.
مجموعة على الفيس بوك
GIS for WE - ArcGIS Pro من
هنا.صفحة الفيس بوك
GIS for WE من
هنا.
تعليقات
إرسال تعليق